Accounts receivable aging: how to read the report that shows who owes you money

Accounts receivable aging is the report that turns "customers owe us money" into something you can actually act on. Instead of one big outstanding balance, it sorts every unpaid invoice by how long it has been overdue — current, 1–30 days past due, 31–60, 61–90, and over 90 days. If you only look at total receivables, a healthy-looking number can hide a handful of invoices that will never be paid. The aging report shows you exactly where the risk sits.

Accounts receivable aging: how the buckets work

Every open invoice lands in a bucket based on its due date, not its invoice date.

The standard buckets are:

• Current — not yet due. This is normal trading, not a problem.
• 1–30 days past due — usually an oversight, a lost invoice, or a slow approval on the customer's side. A polite reminder normally clears it.
• 31–60 days past due — now a pattern. Something is stuck: a dispute, a missing document, or a customer managing cash by paying late.
• 61–90 days past due — serious. The longer an invoice sits here, the less likely it is to be paid in full.
• Over 90 days past due — at this point you should assume collection will take real effort, and consider whether part of the balance needs a provision for doubtful debts.

The buckets are not just labels. They drive what you do next, and doing the same thing for every bucket — sending the same reminder to everyone — wastes effort on customers who would have paid anyway and under-reacts to the ones who won't.

Accounts receivable aging: what to do with each bucket

Work the report from the oldest bucket backwards, not the other way round. The over-90-day invoices are where money is actually at risk; the current bucket mostly takes care of itself.

Current and 1–30 days: send a friendly reminder a few days before the due date and again shortly after it passes. Most late payment at this stage is administrative — the invoice went to the wrong inbox, or the approver was on leave. Make it easy to pay: the invoice, the amount, and the payment details in one message, with no need to reply asking for any of them.

31–60 days: pick up the phone. Email reminders have already failed twice by now, and a call tells you something an email never will — whether there is a dispute, a missing delivery note, or a genuine cash problem. Log what the customer says and the date they promise to pay. A promise with no date is not a promise.

61–90 days: escalate in writing. Restate the amount, the original due date, and the agreed payment date from your last call. Decide now whether you will keep supplying this customer on credit, and put any new orders on hold or on payment in advance until the balance clears. Continuing to extend credit to a customer who is 75 days behind is how a small problem becomes a large one.

Over 90 days: treat this as a collection decision, not a reminder task. Options include a formal demand letter, a payment plan with dated instalments, handing the account to a collection agency, or, where the amount justifies it, legal action. At the same time, review whether the balance should be provided against in your accounts — recognising that some of it may not arrive is honest bookkeeping, not pessimism.

The weekly routine that makes accounts receivable aging work

A report you run once a quarter is a history lesson. A report you run every week is a management tool. The routine that works for most small businesses is short:

1. Run the aging report every Monday. It takes minutes once your invoicing is up to date, and it sets the week's collection priorities.
2. Chase the oldest bucket first. One focused hour on the 60-plus-day invoices beats a morning of polite emails to customers who pay on time anyway.
3. Record every promise. Who promised what, by when. Next week's report should show whether they kept it.
4. Review credit terms monthly. If the same customer keeps landing in the 61–90 day bucket, their terms are wrong — shorten them, ask for a deposit, or move them to payment in advance.
5. Reconcile the report to the ledger. The aging total must match the receivables balance in your accounts. If it doesn't, an invoice, a payment, or a credit note has been recorded in one place and not the other, and you need to find it before month-end.

One more discipline matters: never let a new invoice go out to a customer with a large over-90-day balance without a conscious decision. "Just this once" is how the balance doubles.

The mistake that costs small businesses most

The most expensive mistake is not a bad debt — it is the slow drift. A customer who pays at 45 days instead of 30 does not feel like a problem, so nobody acts. Six months later they are paying at 90 days, and the business has effectively been lending them money interest-free while its own suppliers demand payment in 30. Accounts receivable aging catches that drift early, while a conversation can still fix it, instead of late, when only a collection letter can.

None of this requires complicated software. A spreadsheet and a weekly hour will do it. What matters is the habit: look at the buckets, work the oldest first, and act on what you see.

---

Point, the accounting software we are building at Tetra M Labs, is designed around this kind of routine — clear receivables, honest numbers, and no clutter. It is currently in private beta, and you can join the waitlist at tetramlabs.com.