An owner MIS with the key numbers
The owner reads only the last line. You spent 6 hours on the other 40.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Export the approved summary
Use metric, current and previous totals, with the currency in the box. Take P&L, cash, debtor and creditor totals from the same period and accounting basis.
Check the totals
Reconcile the exported summary to source reports before sending.
Privacy Use summary amounts, not individual transactions or personal identifiers. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching monthly summary totals for [Report month], currency [Currency]. Profit basis: [Profit basis]. A. Table of current and prior values, difference (current minus prior) when both values numeric, and percentage change if both numeric and prior nonzero. Missing values stay unknown. Show supplied revenue minus expense as profit; reconcile to reported profit if present. B. Cash, debtors and creditors summary; flag missing values or inconsistency. Do not add balance sheet and P&L metrics together. Label any figure that depends on an item an earlier step or my data marks as held, pending or unadjusted as provisional, and say which item. C. Five-line owner note: facts from the numbers and separately labelled suggested questions. No invented causes or forecasts. 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.
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.
Excel A:C metric, current, prior; basis [Profit basis]. Write formulas for difference only when both values numeric, percentage when both numeric and prior nonzero, missing-value flag, and separate calculated profit from revenue less expense; compare reported profit if present. Show balance metrics separately; no invented causes. 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.
- Revenue₹10 L vs ₹9 L. Up ₹1 L; no cause supplied.
- Profit₹2.5 L reported. ₹10 L minus ₹8 L = ₹2 L; gap ₹50,000.
- CashPrior missing. Current ₹3 L; no period-on-period cash comparison until prior confirmed.
Then send this: Recalculate profit and changes, show reported vs calculated gap, and confirm each balance matches input.
It invents reasons
Reply: "Only facts; label questions separately."
It adds unrelated balances
Reply: "Keep P&L and balance metrics separate."
It uses a different period
Reply: "Use the same month and prior column."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. 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.
If your whole team does this, we'll set it up for all of them in one session.