Morning cash position and today's payment gaps
Cash position arrives just after the owner asks for it.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get morning account summary
Use account codes, available opening, confirmed receipts and planned payments. Keep account numbers local.
Privacy Remove personal names where not needed, phone numbers, email IDs, personal records and bank details. Use role, employee code or aggregate business facts.
Whenever I send the next details, use this format. As on: [As on] Rule: [Rule] I'm attaching morning-cash.xlsx. A. Validate unique account codes and numeric opening, confirmed receipts and planned payments; missing/non-numeric amounts are not zero, and missing or negative movement amounts need clarification. A negative opening may be an actual overdraft; flag it. Calculate projected cash only for complete, valid rows, flag every negative projected balance and any missing movement. Do not net a short account against another without a confirmed transfer. B. Sum complete-row opening and projected cash, label partial if held. C. One-line owner position and questions; no transfer or payment decision. Use only supplied facts and numbers. Separate facts from suggestions and label suggestions clearly. No invented reasons, commitments or figures. A person checks before sending, paying or deciding.
Set it up once. Save the approved report format and decision rules, not private records. 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 approved facts and current rules; review before acting.
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 actual business records in your own workbook; ask AI for the method using column headings and rules only.
Excel A:D account code, opening available, confirmed receipts, planned payments. Rule [Rule]. Give formulas for projected close and negative/missing flags, sum complete-row opening and projected balances with held count. No account numbers, transfers or payments. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records. Require all three amounts to be numeric, hold missing/non-numeric or negative movement inputs, flag negative opening/projected balances and duplicate account codes; sum complete rows only.
Run locally, verify every result against source records, and have the responsible person or professional approve before acting.
- Bank B−₹5,000. Shortfall before planned payment.
- Bank DOpening missing. Exclude from complete total.
- Cash₹10,000. ₹15,000 less ₹5,000.
Then send this: Recheck all inputs, unique accounts, individual projected balances and complete-row totals. Treat missing receipts/payments or opening as unknown, not zero; flag each short account separately even if aggregate cash is positive.
Moves money
Reply: "Flag only."
Missing zero
Reply: "Hold unknown."
Includes uncertain receipt
Reply: "Confirmed only."
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.