wowprompt

13-week cash flow forecast for a small business

Builds a week-by-week cash forecast for the next quarter from opening balance, expected receipts and payments, and flags the weeks where cash runs short. Use it when money is tight, before a big purchase, or ahead of festive stock buying and year-end bonus payments.

A 13-week table of opening cash, receipts, payments and closing cash, with low-cash weeks flagged, a list of assumptions and actions to close any gap
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Business and currency: [e.g. wholesale garment trader, INR]
  • Opening cash balance and start date: [amount, date of week 1]
  • Minimum cash to keep: [the buffer you never want to go below]
  • Expected receipts: [customer payments with amount and expected week, typical delay in collecting from customers, other income]
  • Expected payments: [salaries, rent, supplier payments with due dates, loan EMIs, tax payments, bonuses, one-time purchases]
  • Credit available: [overdraft or credit line limit, or none]

Task

Build a 13-week cash flow forecast and show where the business will run short.

Output format

  1. | Week | Week starting | Opening cash | Receipts | Payments | Net flow | Closing cash | Below minimum? |
  2. Weeks below the minimum or negative, with the main cause for each.
  3. Assumptions list: every timing and amount that was estimated rather than given.
  4. Actions to close each gap, such as chasing a named receivable, moving a payment date, or drawing on credit, with the cash effect of each.
  5. A CSV version of the table in a code block for pasting into a spreadsheet.

Rules

  • Closing cash of one week is the opening cash of the next; check that the chain is unbroken.
  • Use only amounts and dates from the inputs; mark any estimate clearly.
  • Receipts land when cash is expected in the bank, not when the invoice is raised.
  • Do not give tax or legal advice; list tax payments only as provided.

Example

Week 6 | 9 Nov | 3,10,000 | 1,20,000 | 4,85,000 | -3,65,000 | -55,000 | Yes, Diwali bonus and supplier payment fall in the same week

cash flow forecast13 week cash flowsmall business cash planningworking capitalcash shortfallweekly cash forecast

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity