How do I read an accounts receivable aging report?
For owners, accountants · By the Petro team · Last reviewed
The short answer
An aging report lists what each customer owes and sorts it into columns by how old it is, usually current, 1 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days. Read it from the right: the older the money, the less likely it is to be paid, so the oldest columns are where to act first. Before you act, make sure payments received have been matched to invoices, or the report will show customers as owing money they have already paid.
What do the columns mean?
Each row is a customer, or an invoice within a customer. The total outstanding is everything they owe. It is then split into buckets by age:
- Current (or not yet due): invoices still within the agreed payment terms. Nothing is wrong here.
- 1 to 30 days: just overdue. Usually a reminder or a slow approval at the customer's end.
- 31 to 60 days: needs a call and a promised date.
- 61 to 90 days and older: a problem account. Credit should usually be paused until it is cleared.
Many reports also show unallocated payments: money the customer has paid that has not yet been matched to any invoice. A large figure there means the buckets are overstated.
Should I age by invoice date or by due date?
Aging by invoice date (or posting date) shows how long ago the sale was made. Aging by due date shows how late the payment is. For chasing, use the due date: a monthly bill on 30-day terms is not late on day 25, even though the fuel was taken weeks ago. For judging how long your cash is tied up in credit, the invoice date is more useful. Whichever you choose, use the same basis every time so one week can be compared with the next.
What does a healthy credit book look like?
Most of the total should sit in current and 1 to 30 days, and very little should be older than 60 days. What matters most is the trend: the share in the older buckets should not grow from month to month.
What warning signs should I look for?
- A customer moving from current into the later buckets month after month, even by small amounts.
- A customer whose total is above their credit limit.
- A customer paying the newest invoices but leaving an old one untouched, often a disputed bill nobody has dealt with.
- Old balances that never change, which may be opening balances from an old system or debts nobody is chasing.
- A growing total in the over-90-days bucket, which is where bad debts come from.
Why might the aging report be wrong?
- Payments not matched to invoices. A payment recorded on account but not allocated leaves the old invoice looking unpaid, while the payment sits separately as a credit.
- One payment for many invoices allocated to the wrong ones, so a new invoice shows paid and an old one shows overdue.
- Returned cheques where the payment was not reversed, so the customer looks paid when they are not.
- Fuel taken but not yet billed. Credit fills recorded as deliveries do not appear in an invoice-based aging until they are billed, so the customer can owe more than the report shows.
- Wrong payment terms on a customer, so due dates, and therefore the buckets, are wrong.
Before chasing anyone, match outstanding payments to invoices and confirm unusual balances with the customer's statement.
Frequently asked questions
- How often should I look at the aging report?
- Weekly for the manager or accountant who chases payments, and monthly for the owner, comparing the share in each bucket with the month before.
- What is the difference between an aging report and a customer ledger?
- A ledger shows every invoice and payment for one customer in date order, with a running balance. An aging report shows every customer at once, with what they owe sorted by age. Use the aging report to decide who to chase, and the ledger to settle the detail with that customer.
- Should a customer with a credit balance appear on the report?
- Yes. A credit balance means they have paid more than they owe, or a payment has not been matched. Match it to their invoices, or agree with the customer to use it against the next bill or refund it.
How Petro handles this
Petro's Account Receivable report shows who owes you invoice by invoice with the age of each debt, aged by posting or due date, and the Accounts Receivable Summary gives one line per customer with its aging buckets. Payment Reconciliation matches payments to invoices so the aging stays accurate, and the Petro Owner app shows an invoice aging chart of current, 1 to 30, 31 to 60 and over 60 days past due.
See receivables reports in PetroThis guide is general information for Sri Lankan fuel stations, written by the Petro team. Figures in examples are made up. For a decision about your own tax or legal position, check with your accountant or the authority named in the sources.
