PROMPT BRO
Accounts desk

A weekly cash forecast and shortfalls

Cash flow says there is money next week. The supplier wants it today.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By hand2 hrs
With AI20 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make a cash movement list

Put week, type (in/out), amount and certainty in Excel. Use expected collections and planned payments from your own records.

First time? Try it on fake data first:

Confirm opening cash

Take available cash/bank balances as on the start date, excluding restricted funds.

Privacy Use aggregate expected amounts; remove banking and personal identifiers. Delete bank account numbers; replace customer UPI IDs and phone numbers.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
cash-movements.xlsx

Whenever I send a movement sheet, make a weekly forecast from [Forecast starts] for [Weeks] weeks, opening ₹[Opening available cash]. A. Weekly opening, expected inflows, outflows and closing (opening + in minus out). Use week numbers in file, include uncertain inflows in base forecast and show separate conservative closing excluding them throughout. B. Flag negative closing and uncertain receipts by week. C. Show total inflows, outflows, final balances and suggested follow-up questions. No borrowing or payment decision. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.

Set it up once. Save the forecast format and certainty rules. Pick your tool at the top to see how.

After that, each time: send updated opening and weekly movements.

First time? Try it in a normal chat: paste and send.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
₹10,000base closing
−₹20kcautious close
1base shortfall
  • Week 1₹40,000 closing. ₹50,000 + ₹20,000 − ₹30,000.
  • Week 2−₹10,000 base. ₹40,000 + ₹30,000 − ₹80,000; collection uncertain.
  • Week 3₹10,000 base. ₹40,000 receipts and ₹20,000 payments; cautious closing −₹20,000.
Before you trust it

Then send this: Recalculate each weekly opening and closing; reconcile final base and conservative balances to opening plus/minus all movements.

If it goes wrong
It counts uncertain as certain

Reply: "Show separate conservative forecast."

It assumes new loan

Reply: "No new funding unless supplied."

It double counts invoices

Reply: "Use unique movement IDs and reconcile totals."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?