Accounts Receivable Aging: How to Read It and Get Paid Faster

Unpaid invoices are the most common reason profitable small businesses run short of cash. An accounts receivable aging report, usually just called an aging report, shows exactly which customers owe you money and how late each payment is. Reading it weekly, and acting on it, is one of the simplest ways to get paid faster.

What an aging report is

It lists every unpaid invoice and sorts the amounts into time buckets based on how overdue they are:

The older the bucket, the less likely the money is to arrive without action.

Where the numbers come from

In double-entry bookkeeping, every posted invoice adds to accounts receivable, and every payment reduces it. The aging report breaks that one balance down by customer and due date. Part payments reduce an invoice's outstanding amount rather than removing it. If this is new to you, see how to create an invoice and double-entry bookkeeping explained.

How to read it

1. Start with the oldest buckets. Money over 60 days overdue needs action today.
2. Look for patterns by customer. One customer always in 31–60 days might need shorter terms or a deposit.
3. Watch the total trend. Receivables growing faster than sales means you're funding your customers.
4. Check "not yet due" too. A big upcoming balance from one customer is a concentration risk.

A follow-up routine that works

A consistent, polite routine beats occasional frantic chasing:

Keep every message short and specific: invoice number, amount, due date, how to pay.

Six ways to shorten the time to payment

1. Invoice the day the work is delivered.
2. Use shorter terms, such as 14 days instead of 30, where you can.
3. Take deposits on larger projects.
4. Include PO numbers and the right contact for larger customers.
5. Make paying easy, with a payment link next to bank details.
6. Know your rights. In the UK, businesses can claim statutory interest and compensation on late commercial payments under late-payment legislation; GOV.UK explains how.

When to write off a debt

Some invoices won't be paid. When chasing has failed, record a write-off so your receivables, and your balance sheet, reflect reality. Ask your accountant how bad debts are treated for tax.

Don't forget the other side

Accounts payable aging does the same for bills you owe suppliers. Use it to schedule payments, avoid late fees and keep supplier relationships healthy.

Aging reports in Zelvorm Books

Zelvorm Books shows aging for both what's owed to you and what you owe, built from your posted invoices and bills, with part payments counted correctly and void invoices left out. It's free double-entry bookkeeping for small businesses.

Three reminder emails you can copy

Short, polite and specific works best. Adapt these to your voice.

Before the due date

Subject: Invoice INV-0042 due on 20 November

Hi Sam, a quick reminder that invoice INV-0042 for £1,440.00 is due on 20 November. You can pay by bank transfer or with this link: [payment link]. Thanks!

A week overdue

Subject: INV-0042 is now overdue

Hi Sam, invoice INV-0042 for £1,440.00 was due on 20 November and is now a week overdue. Could you let me know when we can expect payment, or if anything is holding it up? Payment link: [payment link].

A month overdue

Subject: Overdue invoice INV-0042: action needed

Hi Sam, invoice INV-0042 for £1,440.00 is now 30 days overdue. Under our payment terms, late-payment charges may apply from this point. Please arrange payment this week, or call me on [number] to agree a plan.

How fast do you get paid? Days sales outstanding

Days sales outstanding (DSO) = (accounts receivable ÷ credit sales for the period) × days in the period.

If you have £6,000 of receivables and invoiced £12,000 last month (30 days), your DSO is (6,000 ÷ 12,000) × 30 = 15 days. Compare that with your payment terms: if your terms are 14 days and DSO is 15, customers pay roughly on time. If DSO is 40 on 14-day terms, you're funding your customers for nearly a month.

Track DSO monthly. A rising number is an early warning, well before cash runs short.

A credit control policy in five lines

Write it down, share it with your team and stick to it:

1. Our standard terms are 14 days from the invoice date.
2. New customers pay a deposit on work over £[amount].
3. We send reminders 3 days before, on, and 7 days after the due date.
4. At 30 days overdue we pause new work and call.
5. At 60 days overdue we offer a payment plan or start formal recovery.

Consistency matters more than the exact numbers: customers learn which suppliers get paid first.

Payment plans for customers who are struggling

Sometimes a good customer genuinely can't pay in full. A written payment plan, such as three monthly instalments, can recover the money and keep the relationship. Record each instalment against the original invoice so the balance stays accurate, and pause new work until the plan is complete.

What a healthy aging report looks like

• Most of the total is in not yet due.
• Little or nothing is over 60 days.
• No single customer makes up a large share of overdue money.
• The total grows in line with sales, not faster.

If yours doesn't look like this, start with the oldest invoices and work forwards. For the basics of what to put on each invoice, see how to create an invoice.

The short version

An aging report sorts unpaid invoices by how overdue they are. Review it weekly, act on the oldest buckets first, follow a consistent reminder routine and tighten terms for customers who are always late.