PROMPT BRO
Accounts desk

Turn your debtor list into an ageing report and call list

₹4.97 lakh outstanding. 'Sir, payment next week pakka.' Since July.

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

By hand1–2 hrs
With AI15 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Export your outstanding invoices

All unpaid customer invoices with invoice date and due date, as Excel.

First time? Try it on fake data first:
How to export from TallyPrime
  1. Press Alt+G (Go To), type Bills Receivable, open it.
  2. Set the date to your as-on date.
  3. Press Alt+E (Export), then Current, set the format to Excel and export.

Menus can differ in Tally ERP 9 and Busy. Due dates show only if you enter a credit period on your invoices.

Delete extra columns

Phone numbers, emails, PAN, if they come through. Keep customer, invoice, dates and amount.

Privacy Use customer codes or approved business names, invoice refs and amounts. Remove names, phone numbers, email IDs, account details and PAN.

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

I'm attaching unpaid invoices: customer code, unique invoice ref, invoice date, due date and outstanding amount. As on [As on date], requested ageing basis: [Count days from]. A. Validate refs, nonnegative numeric balances and unambiguous dates. Calculate actual days past due from confirmed due date; future due = Not due, due date today = Due today. For due-date ageing use mutually exclusive buckets Not due, Due today, 1–30, 31–60, 61–90, 91+ days; show missing/invalid dates separately. If requested basis is invoice date, show invoice-age buckets separately from actual overdue status, and never chase a not-yet-due invoice on invoice age alone. B. Call list: customers with valid overdue invoices >90 days first, then by total amount overdue >30 days; show oldest actual overdue invoice and amount. 1–30 days reminder only; due today/not due separate. Do not send or invent a promise. C. Per-customer ageing table and grand totals, separate held rows, and invoice-level working so the complete known balance reconciles. List missing/duplicate refs, dates and any unclear due status. A person checks before contacting. Use only supplied values, no tax or interest assumptions. Keep identifying details local.

Which model? This task is about dates and totals, so use your tool's strongest model with thinking (or extended reasoning) 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.96 Loverdue
₹1.65 Lover 60 days
4to call
  • ₹18,900Om Sai Traders, 104 days. Top of the call list: the only invoice over 90 days.
  • ₹2,34,500Deshmukh Builders. Two invoices, 67 and 43 days. The biggest amount overdue.
  • ₹1,01,480Not due yet. Shah Hardware and Mehta & Co bills not due yet. Don't chase these.
Before you trust it

Then send this: Recompute date difference for every invoice, especially 0, 30, 60, 90 and 91-day boundaries. Reconcile mutually exclusive bucket totals plus held amounts to source; check no not-due invoice appears on call list.

If it goes wrong
Days overdue look wrong

Your dates may be read as month-day. Add to the message: "All dates are DD-MM-YYYY."

My export has no due date

Change "Count days from" to invoice date, or add to the message: "Due date is invoice date + 30 days" with your real credit period.

The answer stops halfway

Type "continue". For a long list, ask for the summary and call list first, and the invoice table after.

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?