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

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

Example for: a two-location bakery with $30,000 starting cash, a $15,000 buffer, biweekly payroll and a planned $11,000 oven replacement.

13-Week Cash Flow Forecast

WeekWeek startingOpening cashCash inCash outNet changeClosing cashBelow buffer?
1Jun 2$30,000$17,500$28,100-$10,600$19,400N
2Jun 9$19,400$17,000$7,800+$9,200$28,600N
3Jun 16$28,600$17,700$23,700-$6,000$22,600N
4Jun 23$22,600$17,300$7,800+$9,500$32,100N
5Jun 30$32,100$16,400$28,100-$11,700$20,400N
6Jul 7$20,400$16,000$18,800-$2,800$17,600N
7Jul 14$17,600$15,700$23,700-$8,000$9,600Y
8Jul 21$9,600$16,100$15,200+$900$10,500Y
9Jul 28$10,500$16,500$28,100-$11,600-$1,100Y
10Aug 4-$1,100$16,900$7,800+$9,100$8,000Y
11Aug 11$8,000$17,300$23,700-$6,400$1,600Y
12Aug 18$1,600$17,500$7,800+$9,700$11,300Y
13Aug 25$11,300$18,000$21,600-$3,600$7,700Y

Danger week

Week 7 (Jul 14) is the first week below your buffer, closing at $9,600, a $5,400 shortfall. Week 9 is the low point at -$1,100, which is $16,100 under the buffer and would mean an overdraft.

Levers

  1. Finance the oven instead of paying cash. Impact: +$11,000 from Week 6, less about $650 a month from Week 10. Downside: interest cost of roughly $1,200 over three years.
  2. Ask your flour and dairy supplier to move from 7-day to 21-day terms. Impact: one-time release of about $15,600 (two weeks of supplies) from Week 4. Downside: you may lose a 2% early-payment discount.
  3. Shorten café wholesale terms from 30 to 14 days. Impact: about $4,500 pulled forward into Week 6. Downside: one or two accounts may push back or order less.

Levers 1 and 2 together lift Week 9 to about $25,500, above the buffer.

Assumptions

  • Retail takings dip in July as you described, then recover from Week 9.
  • Rent ($6,500) leaves on the 1st business day: Weeks 1, 5 and 9.
  • Loan payments ($2,100) fall in Weeks 3, 7 and 11.
  • Quarterly sales tax of $7,400 is paid in Week 8.
  • Payroll ($13,800) runs every other week starting Week 1.

Biggest risk: a wet July cutting retail takings by 10% would push Week 9 to about -$9,000; you did not include card processor holds or owner draws.

Written by AI from this prompt. Your results will vary.

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 in Business