PROMPT BRO
Accounts desk

Old debt review with evidence and questions

The oldest balance has survived two financial years and three collection spreadsheets.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By hand2–3 hrs
With AI30 min
Per quarter · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get overdue account summary

Use customer code, outstanding, oldest overdue days, last confirmed follow-up and status. Use only verified notes.

First time? Try it on fake data first:

Confirm review threshold

Get the owner's review rule. This is not a write-off or provision calculation.

Privacy Use customer codes, business balances and verified notes; remove personal contact 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)
old-debts.xlsx

I'm attaching old debt summaries as on [Review date]. Review over [Age for review] days; rule: [Review basis]. A. Table of balance, age, status, evidence note and review flag. Separate dispute from unpaid and unknown; do not infer collectability or blame. B. Sum total balance and flagged balance; rank flagged by outstanding amount, noting missing follow-up evidence. C. List suggested owner questions and next checks; no provision, write-off or recovery promise. 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)
₹3.5 Ltotal dues
₹2.5 Lreview value
3review accounts
  • C1₹1.2 L, 120 days. No recent follow-up noted; ask for update.
  • C2₹80,000 disputed. Review regardless of age.
  • C4₹50,000, 105 days. Customer promised payment; verify status.
Before you trust it

Then send this: Recount flagged rows and sum balances; check notes are quoted only from source and no collectability judgment invented.

If it goes wrong
It gives write-off %

Reply: "No provision recommendation; evidence only."

It says customer won't pay

Reply: "State known status, not prediction."

It ignores disputes

Reply: "Flag disputed balance regardless of age."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?