Accounts Receivable Ageing Report: Build and Read It
What an AR ageing report shows, ageing from due date vs invoice date, how auditors use it for provisioning, and the action each bucket calls for.
Editorial disclosure: Pyalm publishes and maintains the products and free tools discussed on this site. Regulatory statements are linked to primary sources where applicable. No independent professional review is claimed unless a reviewer is explicitly named.
A receivables ageing report groups unpaid invoices by how long they've been outstanding. It is the quickest way to see which customers are slow, how much cash is stuck, and where an allowance for doubtful debts may be needed.
The standard buckets
| Bucket | Meaning | Typical action |
|---|---|---|
| Current | Not yet due | Nothing — confirm invoices were received |
| 1–30 days | Slightly late | Friendly reminder |
| 31–60 days | Late | Call; confirm no dispute |
| 61–90 days | Seriously late | Escalate; consider stopping credit |
| Over 90 days | At risk | Formal demand, payment plan, provision |
Due date or invoice date?
- From due date: shows how late customers are. Best for collections.
- From invoice date: shows how old the debt is regardless of terms. Some auditors prefer it for provisioning.
Pick one and use it consistently. If your export has no due dates, calculate them as invoice date plus payment terms.
How to build it
- Export open invoices with customer, invoice number, invoice date, due date and outstanding amount.
- Include unapplied receipts and credit notes as negative lines, or the report overstates what customers owe.
- Choose a report date (usually period end).
- Calculate days past due and assign each invoice to a bucket; total by customer.
- Agree the total to the receivables control account in the ledger. If it doesn't tie, find out why before presenting.
The free Receivables Ageing Report does steps 3–4 from a pasted or uploaded CSV: buckets by customer, percentage by age, weighted average days overdue, and CSV exports for summary and invoice detail.
How auditors use it
- Existence and valuation: older balances are more likely to be disputed or uncollectible. Large old balances attract confirmation requests under ISA 505.
- Provisioning: under IFRS 9, many businesses use a provision matrix — a loss rate per ageing bucket based on history, adjusted for current conditions.
- Cut-off and credit notes: a pile of credit notes just after year-end suggests revenue that should not have been recognised.
Reading it well
- Look at the percentage over 60 or 90 days, not just the total.
- Look for concentration — one customer making up 40% of the balance.
- Compare with DSO (days sales outstanding) over time. Use the DSO Calculator and reduce DSO and collect faster.
- Watch for partial payments that leave small old balances nobody chases.
Acting on it
Send a statement to every customer with a past-due balance; the Statement of Account Generator makes that quick. For persistently late payers, note any contractual interest with the Late Payment Interest Calculator and review credit limits.
Ageing is far easier when invoices, receipts and credit notes are in one system. Pyalm Books tracks overdue invoices through the sales cycle and shows receivables position directly, free during beta.
Standards, rates and deadlines change. Confirm the current position with the relevant authority or a qualified adviser before you rely on it.