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
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.
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.
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.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
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.
Keep your actual accounting records in Excel. Ask AI for the method using only column headings and approved rules.
Movements A:E ref, week, type, amount, certainty; opening ₹[Opening available cash], weeks [Weeks]. Build week table with SUMIFS inflows/outflows, rolling opening and closing, and conservative rolling balances excluding uncertain inflows. Add negative closing flag and unique movement check; reconcile final totals. Tell me exactly where to paste the formulas or how to set up the local steps. Use made-up examples only; do not ask for actual company data.
Run the checks in your own workbook; reconcile to the source export and have accounts approve any correction before posting.
- 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.
Then send this: Recalculate each weekly opening and closing; reconcile final base and conservative balances to opening plus/minus all movements.
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?
If your whole team does this, we'll set it up for all of them in one session.