Debtors ageing report in Excel, and an AI agent that also drafts the reminders

Short answer: A debtors ageing report lists each unpaid invoice by how long it is overdue, grouped into buckets such as not due, 1 to 30, 31 to 60, 61 to 90 and over 90 days. Adjust unapplied receipts and credit notes first, or customers look more overdue than they are. An AI agent can build the ageing and draft the reminders.

The ageing report is easy to build and easy to get wrong. The formulas work; the data underneath is the problem: receipts not set off against bills, credit notes not adjusted and advances that look like payments.

Here is the method from a recent Excel tutorial, then an agent doing the month's ageing and the reminders.

The tutorial this is based on

Create an Automatic Aging Report in Excel | Perfect for Accountants by PowerEx by Jitendra, published 1 November 2026 (in Hindi). A short build with the classic formulas and a PivotTable.

How do you make a debtors ageing report in Excel?

  1. Put the invoices in an Excel Table: customer, invoice number, invoice date, due date, amount and amount received.
  2. Outstanding = amount minus received. If it is zero or less, mark the invoice as paid.
  3. Mark each unpaid invoice as overdue if the due date is before the report date, and work out the days overdue.
  4. Give each invoice a bucket (not due, 1-30, 31-60, 61-90, over 90) with an approximate-match lookup against a small bucket table.
  5. Highlight overdue rows with conditional formatting.
  6. Build a PivotTable with customers in rows, buckets in columns and outstanding amounts in values. Refresh it when new invoices come in.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent three files for a made-up electrical distributor, Rudra Electricals: sales invoices from April to October, unadjusted receipts and credit notes, and customer credit terms with contacts. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackRudra Electricals: make the debtors ageing as on 31 October from these three files. Adjust receipts and credit notes properly, show me the customers overdue more than 60 days, and draft reminder emails for them. Don't send anything.
Slack request for a debtors ageing report with three Excel files attached, and the agent's adjustments for an on-account receipt, a credit note and an advance
The request, and how the agent set off the receipt, the credit note and the advance.

What the agent did

  1. Worked out the due date of every invoice from each customer's credit days.
  2. Aged every unpaid invoice into buckets as on 31 October.
  3. Went through the unadjusted receipts and credit notes and decided how each one should be treated.
  4. Asked only for the undisputed bills in the reminder to the customer with a disputed invoice, and proposed checking the GRN and issuing a credit note for any verified shortage.
  5. Drafted reminder emails for the three customers more than 60 days overdue, and did not send them.
  6. Saved the ageing as an Excel workbook.
The agent's breakdown of the three customers more than 60 days overdue, invoice by invoice, with a disputed bill noted
The customers more than 60 days overdue, invoice by invoice.

What it found

What the agent adjusted before ageing
ItemCustomerAmount (₹)Treatment
Receipt on account not set offVinayak Infra Projects1,50,000.00Applied to the oldest bills first
Credit note not adjustedGodavari Builders23,600.00Set off against the oldest open bill
Advance for a future orderTrimbak Hotels LLP40,000.00Keep as an advance, not a payment
Disputed invoice (short supply)Panchavati Malls2,20,220.00Not asked for; check the GRN first
Overdue more than 60 daysThree customers15,54,710.00Reminders drafted, not sent
The agent's draft reminder to a customer, asking for payment of the undisputed bills and proposing a GRN check for the disputed one
A draft reminder that asks only for the undisputed bills and proposes a GRN check for the disputed one. Nothing is sent until you approve it.

What you still check

Questions accountants ask

Should ageing be by invoice date or due date?

By due date, if you want to know who is late. Ageing by invoice date is useful for spotting slow payers, but it makes customers with long credit terms look overdue.

Can the agent send the reminders?

Only after you approve them. It drafts each email and asks before it sends anything. It can also send them from Slack or WhatsApp once you say yes.

Can it run every week?

Yes. Agents can run on a schedule, so the ageing and the drafts can be waiting for you every Monday morning.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo