PROMPT BRO
Accounts desk

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

By hand4–6 hrs
With AI1 hr
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

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.

First time? Try it on fake data first:

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.

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

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.

What you'll get back (example, from the practice files)
₹2 Lcalc profit
₹50,000profit gap
₹3 Lcash
  • 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.
Before you trust it

Then send this: Recalculate profit and changes, show reported vs calculated gap, and confirm each balance matches input.

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