Finance
Aged receivables report: how to read it and collect
What the age columns tell you, and a weekly routine that turns overdue invoices into cash.
An aged receivables report lists every invoice customers have not paid yet, grouped by how many days have passed since it fell due. The usual columns are not yet due, 1 to 30 days, 31 to 60, 61 to 90 and over 90 days. Read it every week and chase the largest amounts in the oldest columns first, because the older an invoice gets, the less likely it is to be paid.
What is an aged receivables report?
Receivables are what customers owe you for goods or services sold on credit. The report puts each customer on a row, each age band in a column, and a total at the end of each row.
It matters to any business that sells on credit: a roastery supplying cafés, a wholesaler selling to hotels and offices, or a service company that bills monthly. A café paid at the till needs it only for its corporate and catering accounts.
Check two things before you read it:
- Is age counted from the due date or the invoice date? From the due date shows real lateness. From the invoice date, an invoice on 30-day terms looks late on its first day.
- Are all payments and credit notes applied? A payment that is not matched to its invoices leaves them open on the report, and you end up chasing a customer who has paid.
How do you read an aged receivables report?
Here is an invented example: a wholesale roastery on 30-day terms, on 30/11/2026. Figures are in AED:
| Customer | Not yet due | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| Café group | 12,000 | 21,400 | 0 | 0 | 0 | 33,400 |
| Hotel | 6,500 | 0 | 14,300 | 0 | 0 | 20,800 |
| Office caterer | 0 | 0 | 0 | 4,200 | 6,300 | 10,500 |
| Independent café | 9,800 | 0 | 0 | 0 | 0 | 9,800 |
| Total | 28,300 | 21,400 | 14,300 | 4,200 | 6,300 | 74,500 |
Here is what it says:
- 46,200 of the 74,500 is overdue, which is 62%. That is high for a business on 30-day terms.
- The largest overdue amount is the café group's 21,400, but it is in the newest column. One call will often settle it.
- The riskiest row is the office caterer. All of its 10,500 is over 60 days late, and it has bought nothing new. That is the usual pattern before a bad debt.
- The hotel keeps buying while one old invoice of 14,300 sits unpaid. Those two together usually mean the customer disputes that invoice.
Which invoices should you chase first?
Rank by amount and age together. A small old invoice can wait a day. A large old one cannot.
- Balances over 60 days, largest first.
- Customers who keep buying while an old invoice stays open. Ask about that invoice by number.
- Balances of 31 to 60 days, before they move into the next column.
- Anything newly overdue, with a short message or a statement, usually without a call.
How do you collect an overdue invoice, step by step?
Being consistent matters more than being firm. A customer who knows you follow up on fixed days pays you before others. Here is a simple schedule to adapt to your terms:
- Three days before the due date: a friendly message with the invoice number, amount, due date and a copy.
- Day 7 overdue: a statement with every open invoice, and one question: is anything holding up payment?
- Day 30: a call to the person who approves payments at the customer, ending with a date and an amount you write in the follow-up log.
- Day 60: stop new credit orders until the balance is settled, and accept payment on delivery or a post-dated cheque for an agreed date.
- Day 90: a decision by the owner: a written payment plan, a formal claim, or a provision for a doubtful debt agreed with your accountant.
When a customer says an invoice is wrong, fix it the same day with a credit note or a corrected copy. A disputed invoice does not get paid, however often you chase it.
What is DSO, and what is a good number?
DSO, days sales outstanding, is the average number of days it takes to collect a credit sale. Divide receivables by credit sales for a period, then multiply by the days in that period.
In the example, credit sales for the last 90 days were 186,250. So 74,500 ÷ 186,250 × 90 = 36 days, six days past the 30-day terms.
A good number sits close to your terms. On 30-day terms, 36 is fine. At 50, you are funding your customers with your own cash. Watch the trend month to month more than any single month.
Why doesn't the report match what the customer says?
When a customer says they have paid, or their balance is different, the cause is usually one of these:
- A payment reached the bank but was not matched to its invoices. The bank reconciliation finds it.
- A credit note for a return or a discount that was promised but never recorded.
- A post-dated cheque received but not yet banked, so the balance stays open until it clears.
- A part payment put against the wrong invoice, so an old one stays open and a newer one shows as paid.
Send the customer a statement, ask for theirs in return, and match them line by line. Make this check for your largest customers part of the month-end close, after the bank reconciliation.
What is the next step?
Pick one day each week to read the report, for example Sunday. For every balance over 30 days, write down who owns the follow-up and the date the customer promised. Next week, start with the promises that were not kept.
In Seyaqi, Receivables shows who owes you and which invoices each payment covers, and the AI Advisor tells you each morning which customers are late. See accounting in Seyaqi.
Common questions
What is an aged receivables report?
It lists the invoices customers have not paid yet, grouped by how long they are overdue: not yet due, 1 to 30, 31 to 60, 61 to 90 and over 90 days.
Should invoices be aged from the invoice date or the due date?
Use the due date to see real lateness. Aging from the invoice date makes an invoice on 30-day terms look late on its first day.
How do you calculate DSO?
Divide receivables by credit sales for a period and multiply by the days in it. For example, 74,500 ÷ 186,250 × 90 is 36 days.
How often should I review aged receivables?
Once a week on a fixed day, and again at month-end. Weekly is often enough to catch an invoice before it reaches 60 days.
Every number in your business, in context.
Seyaqi runs stock, production, purchasing, sales, people and the books in one system, with an AI Advisor that reads it all every night and tells you what needs you.
Read next
- Finance Prime cost for a restaurant or café: formula and target The formula, the UAE labour costs most guides leave out, and a worked example from one branch. 4 min read
- Finance Petty cash procedure for a small business, step by step A fixed float, one holder, a receipt for everything and a count every week, with a worked example and the VAT rule for receipts. 5 min read
- Finance Month-end close checklist for a small business in the UAE Eight steps in order, who does each one, and why the close only drags when the books fall behind during the month. 6 min read