Design your 13-week cash forecast
A clear structure to see what comes in and goes out each week and spot crunches in time.
Useful for: most businesses (8 of 8 types).
- 1Copy the prompt
- 2Replace what’s in [brackets] with your details
- 3Paste it into ChatGPT, Claude, Gemini or Copilot
Quick answer
How do you make a cash flow forecast?
Start from the money in the bank today, list week by week what you expect to collect and what you have to pay, and calculate the balance at the end of each week. With 13 weeks (a quarter) you spot the gaps early and can act before you run out of cash.
Step by step
- Make a table with 13 columns (one per week) and start with today’s bank balance.
- Add expected incoming payments in the week you really expect to receive them, not the invoice week.
- Add outgoing payments: payroll, rent, suppliers, taxes, loans, subscriptions.
- Calculate each week’s closing balance (opening + money in - money out) and highlight the weeks below your minimum.
- Update it every Monday in 10 minutes with what actually happened.
Watch out: Be cautious: push doubtful payments later and don’t count sales you haven’t closed. Always include taxes.
To adapt this to your exact situation, copy the prompt below, fill in your details and paste it into your AI assistant.
Did it work for you?
One click is enough. Your answer tells us which prompts need work, and it helps the next person who uses it.
Reviewed with: Claude (Nov 2026). Last updated: 2026-11-21. AI answers can contain mistakes. Check what matters.
More like this
Tools we recommend for your business
We picked them because they suit small businesses. Some links are affiliate links: if you sign up through them we get a commission, at no extra cost to you. How we choose them and all the tools.
Email on your own domain, shared documents, calendar and video calls.
Works with Small Business Control Center: the workbook runs in Google Sheets, which comes with Google Workspace.
New and reviewed prompts every week
- - Review Quick answers in 50 prompts
The pages that answer the most-searched small business questions now open with a direct, step-by-step answer. The prompt is still below, so you can adapt the answer to your situation. How we review
What would you like AI to take off your plate?
Tell us the task that eats up your week. We read every request and the most repeated ones become new prompts.
Get practical tools to run your business better
A selection of prompts, guides and tips to put AI to work and improve how you run your business. We only ask for your email; unsubscribe whenever you like.