How do I read an accounts receivable ageing report?
An ageing report lists what customers owe, grouped by how long each invoice has been unpaid. Read it from the oldest column inward: look at the largest old amounts, the customers behind them and whether the old buckets grew since last month. Then decide who to call this week.
Who asks this: An owner or finance head of a small Indian business who has an ageing report from the books but is not sure what it is saying, which customers matter and what to do after reading it.
The steps
1. Check that the report is current
Look at the date at the top and confirm that it is today or the last working day. An ageing report built on last month's data hides this week's problem. Also check that recent receipts are posted; otherwise customers who have paid will look overdue and the report will send you to chase the wrong people.
2. Understand the columns
First see which date the report counts days from: the due date or the invoice date. The heading or the report settings say. Most reports group unpaid invoices into current, up to thirty days, thirty-one to sixty, sixty-one to ninety and over ninety days. These buckets are a convention, not a rule, so use the ones your accountant prefers. If the report counts from the due date, current means not yet due and every column after it means late, and the further right, the harder collection becomes. If it counts from the invoice date, a column alone does not say an invoice is late: an invoice forty days old on sixty-day terms is not yet due, so compare each invoice with its credit terms first.
3. Read the total, then the old columns
Note the total owed, then the share that sits in the two oldest columns. A rising share of old money is the clearest warning the report gives. Compare it with last month's report in a single line: total, share over sixty days, and the number of customers in it.
4. Find the customers behind the numbers
Sort by amount in the old columns and list the top five customers. A handful of customers often hold most of the old money, so check whether that is true for you. Write beside each one the reason for delay, if known: dispute, cash trouble, approval pending or simple neglect.
5. Check for disputes and unapplied credits
Some old invoices are not unpaid at all: the customer paid but the receipt was never matched, or a credit note was never applied. Ask the accounts person to check these first. Clearing them shrinks the report honestly and stops you chasing someone who has already paid.
6. Decide one action per bucket
For a report counted from the due date: Current: send a reminder before the due date. Up to thirty days: a call. Thirty-one to sixty: a statement to the decision maker. Over sixty: the owner speaks to the customer and you review credit terms. Write the action and the person next to each customer, and review again next week.
7. Let your accountant judge doubtful dues
For invoices that look unlikely to be paid, talk to your accountant about how to treat them in the books. That is a judgement for them. Your part is to bring the history: what was promised, what was paid and what you have tried.
A worked example
illustrative
A hardware distributor in Nagpur has dues of twenty-four lakh rupees. The report counts days from the due date and shows fourteen lakh current, five lakh within thirty days late, two lakh in thirty-one to sixty days and three lakh over sixty. The old money is an eighth of the total, up from a twelfth last month. Two contractors hold two and a half lakh of the old amount. The accounts person finds that one of them paid by transfer two weeks earlier and the receipt was never posted, which removes sixty thousand rupees from the old column. The owner calls the other contractor and agrees a dated plan.
What goes wrong
- The report is stale, so the call list is wrong from the start.
- Unmatched receipts make paying customers look overdue, and the team chases someone who already paid.
- The report is read as one total, and the growing old buckets are missed.
- Nobody writes down the reason beside the big names, so the same discussion repeats.
- A single large customer is treated like a small one, and no one with authority calls.
- The report is looked at only at month end, when the old money is already old.
How Demystify OS helps
Hand the CA the month-end reportsAvailable
Shows receivable and payable ageing coming out of the same books as the other month-end reports, so the ageing and the ledger agree.
See who is overdue before you bookEarly access
Shows outstanding by retailer and a credit warning at order time, so old money is visible before a new order adds to it.
See what travellers still oweAvailable
Shows the idea for a travel business: the outstanding list for balances still due from travellers and agents, ready to work from.
Mysty WorkersEarly access
Mysty Workers can be set up with you to read the ageing list you share, pick out the customers in the old columns and draft the follow-up for your approval. An ageing-review routine is not yet a standard catalogue entry.
What it does not do. Demystify OS does not decide whether a due is recoverable or how it is treated in your books; it reads the list you share and prepares the follow-up, and your accountant and you decide the rest.
Questions people ask
What does ageing mean in an ageing report?
It means the number of days an invoice has been unpaid, counted either from the invoice date or from the due date. Counting from the due date is more useful, because it shows how late a customer is rather than how long ago you sold.
How often should I look at the receivables ageing?
Weekly for a business with many customers, and at least twice a month for a smaller one. A weekly look lets you act on money that is a few days late, which is far easier to collect than money that is three months late.
What is a healthy share of old dues?
There is no universal number. Compare your own report month by month, and ask your accountant what is normal for your trade. A stable, small old column is healthy, while a growing one is a sign to act whatever its size.
Should I stop supplying a customer in the old bucket?
Often yes, until a dated payment plan is agreed, but decide by customer. A large long-term customer with a dispute is handled by the owner, while a small repeat late payer can be put on advance payment. Tell the customer calmly and apply the rule evenly.
Can I keep the ageing in a spreadsheet?
Yes. A sheet with customer, invoice, date, due date, amount and days late is enough for a small business, as long as receipts are posted the same day. If that is hard to keep true, your books can produce the report for you.
Apply for the beta.
Demystify OS is invite only, and a person reads every application.
Apply for the beta