Map Seasonal Cash-Flow Curves

Business Value

Converts the seasonal cash flow problem into a standing, strategic instruction. If two strong months fund the rest of your year, the most common pitfall is overspending during the peak. December feels like abundance, and February arrives with a strained credit line. This prompt maps your true monthly rhythm, identifies exactly where your balance has historically dropped below your safety buffer, and produces a single, actionable number: exactly how much cash to sweep into your money market savings account during peak months so the lean months fund themselves. By automatically calculating your seasonal highs and lows, this prompt gives you a precise savings strategy to protect your liquidity and avoid unnecessary debt year-round.

Verified Prompt

You are acting as my financial analyst.

Pull all transactions from my [ACCOUNT NAME] account for the past [NUMBER, e.g., 12] months.

Calculate total incoming deposits, total outgoing expenses, and net cash flow for each calendar month. Present this as a table: Month | Inflows | Outflows | Net.
Using that table, identify my seasonal pattern: which months are reliably my peaks and which are my troughs, citing the actual figures.
My target operating cash buffer is $[CUSHION AMOUNT, e.g., 50,000]. Identify the months where my history shows I risk dipping below that buffer, using actual balance figures where available.
Propose a reserve accumulation plan: given my peak months of [PEAK MONTHS] and low months of [LOW MONTHS], calculate how much surplus I should sweep into my Money Market Savings account during each peak month so that the combined historical deficit of my low months is covered without touching credit. Show the arithmetic: (total low-month deficit + buffer shortfall) ÷ number of peak months.

OUTPUT: Produce exactly these four sections, in this order, with these exact headings:

Monthly Cash Flow. Exactly 12 monthly rows plus one TOTAL row: | Month | Inflows | Outflows | Net | |---|---|---|---| | 2025-07 (EXAMPLE) | $80,974.00 | -$94,800.00 | -$13,826.00 | | TOTAL | ... | ... | ... |
Seasonal Pattern | Type | Months | Evidence (net figures) | |---|---|---| | PEAK | ... | ... | | TROUGH | ... | ... |
Buffer Breaches | Period | Lowest Balance | Date | Amount Below $50,000 Buffer | |---|---|---|---| If none: write exactly "NO BUFFER BREACHES FOUND".
Sweep Plan. Show the formula filled in with your numbers on one line: Sweep per peak month = (combined low-month deficit [$...] + buffer shortfall [$...]) ÷ 2 peak months = $... Then a maximum of three sentences on how to operationalize it.

RULES: Build every figure from the transactions you actually pulled — show monthly totals so I can spot-check them. If fewer than 12 full months are available, tell me and note that the seasonal read is weaker. This is a planning framework based on my past cash flows, not a guarantee of future performance; sweep amounts are starting points for me to adjust. If any portion of the prompt is incomplete, please flag it immediately and prompt me back to ensure all portions of the prompt are filled out

DATA SOURCE: If you're connected to my Grasshopper account(s) via the MCP connector, pull my transaction history directly.

Why it’s structured this way

This prompt is engineered as a verifiable calculation chain that anchors the AI to your actual transaction records, ensuring that every seasonal trend and savings target is mathematically traceable back to your ledger.

Auditable Foundation First: Begins with a complete month-by-month table of inflows, outflows, and net position, including a total row, so you can spot-check the base figures before trusting anything built on top of them.
Evidence-Cited Seasonality: Peaks and troughs must be identified with their actual net figures rather than asserted narratively, so the seasonal read is something you can verify against your own memory of the year.
Your Buffer, Your Seasons: The target cash cushion and the peak and low months are your inputs. You remain the author of your business’s seasonal story; the data confirms or challenges it rather than inventing one.
A Single Reproducible Formula: The sweep calculation is stated in the prompt itself and must be shown with your numbers filled in. Two runs on the same data land on the same figure, and you can recompute it yourself as the year progresses.
Data Grounding & Stability: Connects directly to your live account data via our MCP-based AI Connector, allowing the AI to securely extract your long-term transaction history to map accurate seasonal curves without the risk of manual spreadsheet errors.

Unlock the Full Power of This Prompt

To get the most accurate and actionable results, this prompt is designed to run on your real-time banking data. By activating the Grasshopper AI Connector, you establish a secure link between your bank account and your AI workspace, eliminating manual data entry and messy spreadsheets while ensuring your analysis is always grounded in the reality of your accounts.

Set Up In Online Banking

The content provided on this page is intended for educational and informational purposes only. It is not intended to be, and should not be construed as, financial, investment, tax, or legal advice. We strongly recommend consulting with a qualified financial advisor, tax professional, or legal counsel regarding your specific circumstances before making any financial or tax-related decisions.