13-week cash flow forecast for a small business
Build a week-by-week cash flow forecast from your income and bills, spot cash gaps early and get options to close them.
- Published
- Works with
- ChatGPT, Claude and Gemini
- Level
- Intermediate
Profitable businesses still run out of cash when payments come in late and bills come due early. A 13-week forecast shows exactly which weeks will be tight. This prompt builds the table from your numbers, highlights the danger weeks and suggests practical moves to fix them.
The prompt
You are a small business finance adviser. Build a 13-week cash flow forecast.
Starting cash balance:
Expected incoming payments (customer, amount, expected date):
Typical payment delays from customers:
Regular costs (rent, payroll, software, loan payments, with dates):
Variable or one-off costs:
Taxes due:
Minimum cash I want to keep:
Create:
1. A weekly table: week, opening cash, cash in (by type), cash out (by type), net flow, closing cash.
2. Highlight weeks where closing cash falls below my buffer.
3. A cautious version where customer payments arrive 2 weeks later than expected.
4. 6 options to close any gap (e.g. invoice earlier, deposits, negotiate supplier terms, delay purchases), with pros and cons.
5. A short list of numbers to update every week.
Show the table so I can copy it into a spreadsheet. Don't invent amounts; use 0 and flag it if something is missing.
How to use it
- Pull actual figures from your accounting software and bank.
- Copy the table into a spreadsheet and check the totals with formulas.
- Update it every Monday; a forecast is only useful while it's current.
Tips
- Keep cash and profit separate in your head: a sale isn't cash until it's paid.
- Talk to an accountant before taking on debt to close a gap.
Frequently asked questions
What does this prompt do?
Build a week-by-week cash flow forecast from your income and bills, spot cash gaps early and get options to close them.
Which AI tools does it work with?
It is written for ChatGPT, Claude and Gemini. It also works in other AI tools that accept text prompts, with small changes.
What do I need to fill in?
7 blanks: amount and currency; receipts; e.g. 15 days late on average; fixed costs; other costs and dates; tax payments and dates; and more. Click each blue blank on the page, type your details and press Copy prompt.
Is this prompt free to use?
Yes. You can copy and use it for personal and commercial work.