Create advanced Works with: Any AI

Rolling 13-Week Cash Forecast

Table output Has example

Plan cash week by week.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Create a 13-week cash flow forecast. Opening cash balance: [OPENING_CASH]. Expected receipts by week or customer: [RECEIPTS]. Known payments (payroll, rent, suppliers, loans, taxes): [PAYMENTS]. Uncertain items: [UNCERTAIN_ITEMS]. Minimum cash I want to hold: [MINIMUM_CASH].

Return a table with weeks as columns and rows for: opening cash; receipts by source; payments by category; net cash flow; closing cash; and the gap versus the minimum. Show the arithmetic for each week. Apply timing realism: customers pay later than terms (use my history if given: [PAYMENT_HISTORY]), and mark the share of receipts that are confirmed versus hoped.

Add: the weeks where cash falls below the minimum and the options (delay a purchase, ask for deposits, invoice earlier, short-term financing to discuss with my bank); a downside case with receipts 20 percent lower; a weekly update routine (replace forecast with actuals and roll forward one week); and a list of items to confirm. Do not fill in numbers I did not supply. Not financial advice.

Keep every conclusion tentative: it should rest only on the inputs I have given and nothing else. It is planning support only, and not accounting, tax, legal or investment advice. Do not act on this until an accountant or financial adviser experienced in [JURISDICTION] has reviewed it.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Opening cash 14,000; minimum 5,000.
Week 1: receipts 6,500 (confirmed 4,000, hoped 2,500); payments 7,900 (payroll 5,200, rent 1,800, suppliers 900). Net -1,400; closing 12,600.
Week 2: receipts 3,200; payments 2,100; net +1,100; closing 13,700.
Week 3: receipts 2,800; payments 9,400 (VAT or sales tax 3,600 included); net -6,600; closing 7,100.
Week 4: receipts 8,900 (late payers expected, history says 15 days late, so only 5,900 counted); payments 2,300; closing 10,700.
Weeks below the 5,000 minimum so far: none, but week 3 is 2,100 above it.
Downside, receipts 20 percent lower in weeks 1 to 4: receipts fall by 18,400 x 0.20 = 3,680, so closing week 4 = 10,700 - 3,680 = 7,020, still above the minimum. Action: ask two customers for deposits.

• cash-forecast