Prompt Library for Small Businessby Small Business Control Center · free
Money and pricingMake a plan or a schedule Check the numbersAbout 15 minutes

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).

  1. 1Copy the prompt
  2. 2Replace what’s in [brackets] with your details
  3. 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

  1. Make a table with 13 columns (one per week) and start with today’s bank balance.
  2. Add expected incoming payments in the week you really expect to receive them, not the invoice week.
  3. Add outgoing payments: payroll, rent, suppliers, taxes, loans, subscriptions.
  4. Calculate each week’s closing balance (opening + money in - money out) and highlight the weeks below your minimum.
  5. 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.

The prompt

Act as a practical financial advisor for small businesses. Write in English. My business is in [COUNTRY, e.g. the US, the UK or Australia]: if something depends on the rules there and you’re not sure, tell me. I want a simple 13-week cash forecast in a spreadsheet. Don’t give me made-up figures: help me design the structure and fill it in. My business: [TYPE OF BUSINESS, e.g. hair salon with 3 employees] Bank balance today (approximate): [BALANCE TODAY] Payments I expect to receive and when: [EXPECTED PAYMENTS IN] Fixed payments (rent, payroll, insurance, accountant, subscriptions): [FIXED PAYMENTS] Variable payments (suppliers, materials): [VARIABLE PAYMENTS] Periodic taxes I know are coming (sales tax or VAT, payroll taxes, estimated payments): [EXPECTED TAXES] Minimum cushion I want to keep: [MINIMUM CUSHION] Give me: 1. The columns and rows of the sheet (weeks in columns, money in and out in rows). 2. The formulas for the weekly balance and the lowest balance (for Excel and Google Sheets). 3. A list of the questions you still need answered to complete it. 4. How to highlight in red the weeks below my cushion. Don’t do the sums yourself: give me the formulas. Don’t give tax advice: for tax dates and amounts, tell me what to ask my accountant.
Fill in the gaps on this page
Example of what to write: TYPE OF BUSINESS: hair salon with 3 employees | BALANCE TODAY: about $8,500 | FIXED PAYMENTS: rent $900, payroll $5,400, insurance and accountant $300 | MINIMUM CUSHION: $4,000.

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

Recommended tools

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.

Affiliate linkEmail and teamworkGoogle Workspace

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.

What’s new

New and reviewed prompts every week

See more updates →

Help us improve the library

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.

We’ll only use them to reply about this request. No newsletter unless you ask for it.

Free newsletter · 1 email a week

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.