PROMPT BRO
Accounts desk

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

By hand20–30 min
With AI5 min
Per day · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get morning balances

Use account codes or cash box names, available balance and today's known receipts/payments. Take balances at the same time.

First time? Try it on fake data first:

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.

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

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.

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.

What you'll get back (example, from the practice files)
₹1.5 Lknown opening
₹1.2 Lprojected close
2account flags
  • 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.
Before you trust it

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.

If it goes wrong
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?