Today's cash position in one note
Owner asks 'cash kitna hai?' Three bank portals and one cash box have the answer.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get morning balances
Use account codes or cash box names, available balance and today's known receipts/payments. Take balances at the same time.
Confirm available funds
Exclude restricted funds from available balance and mark any missing balance or unconfirmed movement.
Privacy Use account codes and aggregate amounts, not statement identifiers or personal payment details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
Whenever I send morning balances for [As on date], prepare cash position. Rule: [Forecast rule]. A. Per unique account code validate numeric opening, confirmed receipts and planned payments. Missing or nonnumeric values are not zero; negative movements need clarification. Flag negative opening as possible overdraft. Calculate projected close only for complete valid rows and flag each negative projected balance; do not net it away against another account without confirmed transfer. B. Sum known opening, receipts, payments and projected close for complete rows; label partial if any missing. Show held accounts separately. C. Owner note in up to 6 lines: current known cash, projected balance, account shortfalls and suggested checks. No transfers or payments. 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. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Set it up once. Save the morning position format and 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 the new date and masked balances.
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 the actual records in your own Excel workbook; share only headings and rules.
Excel A:D account code, available opening, confirmed receipts, planned payments. Rule [Forecast rule]. Give formulas for projected close only when all values numeric, negative closing and incomplete flags; use SUMIFS complete-row totals for opening, receipts, payments and close, with a held-row count. Tell me where to paste formulas or how to set up the local steps; use fictional examples only, no actual records. Require all three numeric values, hold missing or negative movements, flag duplicate accounts and negative opening/closing; sum complete rows only.
Run locally, verify flagged rows against your source and have the responsible person approve any action.
- Bank B−₹5,000 close. ₹20,000 opening minus ₹25,000 planned; ask accounts.
- Bank DBalance missing. Exclude from complete totals; verify current balance.
- Cash₹10,000 close. ₹15,000 opening minus ₹5,000 planned.
Then send this: Recheck every input, unique account code, complete-row totals and individual negative balance; hold missing/non-numeric movements or opening, and flag overdraft separately.
It assumes missing balance zero
Reply: "Hold unknown balance; label partial."
It moves cash between accounts
Reply: "Flag shortfall only."
It adds expected receipts
Reply: "Only confirmed receipts in my rule."
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.