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
Export your outstanding invoices
All unpaid customer invoices with invoice date and due date, as Excel.
How to export from TallyPrime
- Press Alt+G (Go To), type Bills Receivable, open it.
- Set the date to your as-on date.
- 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.
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.
Office doesn't allow uploading files? Ask AI for a formula instead. It never sees your data.
My Excel sheet has: A = Customer, B = Invoice No, C = Invoice date, D = Due date, E = Amount. Cell H1 has the as-on date. Write formulas for F = days overdue (H1 − D, 0 if not due) and G = bucket ("Not due", "0–30", "31–60", "61–90", "90+"). Then tell me how to make a pivot table with customers in rows, buckets in columns and the sum of amount. Use separate due-today bucket and 1–30, 31–60, 61–90, 91+; keep unknown due dates held, preserve actual due status even if invoice-age basis chosen.
Paste the two formulas, fill them down, make the pivot. Sort the pivot by the 90+ and 61–90 columns: that's your call list.
- ₹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.
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.
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?
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.