Build a 13-Week Cash Flow Forecast From Your Own Numbers
Turns your pasted cash figures into a week-by-week 13-week table, flags the first week cash falls below your buffer, and gives three priced fixes.
You getTable, danger week and levers
Prompt
Act as a small-business finance manager who builds 13-week cash flow forecasts.
I will paste my numbers after this prompt: starting cash, expected receipts, regular costs, one-off payments and my minimum cash buffer. If the starting balance, the buffer or the timing of a large item is missing, ask me up to 3 numbered questions in one message and wait for my answers.
Rules:
1. Use only my figures. Label any split or spread you make as an assumption.
2. Put each item in the week it hits the bank, not the week it is invoiced.
3. Name the first week closing cash drops below my buffer, and the dollar shortfall.
4. Give exactly three levers to close the gap, each with a dollar impact, start week and one downside.
5. Each week's opening cash must equal the prior week's closing cash.
Output format:
- Table: Week | Week starting | Opening cash | Cash in | Cash out | Net change | Closing cash | Below buffer?
- Danger week: two sentences
- Levers: numbered list
- Assumptions: bullet list
End with one line on the biggest risk to this forecast and any missing data. This is a planning aid, not financial advice; talk to an accountant or your bank before borrowing or if the gap exceeds a month of costs.Example output
Tips and common edits
Why this works
- Forcing timing to bank dates, not invoice dates, shows the real crunch week instead of a smoothed-out monthly view.
- The opening-equals-closing check catches arithmetic slips that AI models often make in long tables.
- Requiring a dollar impact, start week and downside for each lever turns vague advice into choices you can compare.
Use before a slow season, a big purchase or a payroll crunch. Have your bank balance, expected receipts, payroll dates, rent, loan payments and a buffer figure ready to paste into ChatGPT, Claude or Gemini.
Common edits
- Change 13 weeks to 6 weeks for a quick payroll check, or ask for a monthly view for a lender.
- Ask for a best-case and worst-case column with receipts 10% higher and lower.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Prepare for a Small Business Loan Meeting with a Bank or Lender
You get a lender document checklist with status, your key loan numbers with the math, drafted answers to likely lender questions, and a ranked list of gaps to fix first.
Calculate Restaurant Food Cost Per Plate and Set Menu Prices
Turns your pasted recipe and supplier prices into a costed ingredient table, a cost per plate, and three menu price options with every calculation shown.
Organize Business Receipts and Records into a Bookkeeping-Ready Filing System
You get a folder tree, a file naming rule with examples, a records retention table and a timed 15-minute weekly routine built around your own tools and expenses.
Turn Your Staff Rules into Clear Policies for Breaks, Swaps, Call-Outs and Phones
You get a one-page staff policy table covering breaks, shift swaps, call-outs and phone use, with one-sentence rules, a consequence for each, and flags to fix.
Turn Your Terms of Service into a Plain-English Customer Summary
Paste your terms of service and get a plain-English summary table tied to the original section numbers, plus flags for unclear clauses.
Run a One-Page SWOT Analysis That Ends in Three Prioritized Actions
Get a tight SWOT table built only from your own facts, plus three ranked actions that each tie a strength or opportunity to a weakness or threat.