Read customer by customer, your aged debtor report shows how each one pays: who owes a large share of the total, who's late every month and who was late once, who pays slowly but reliably and who's drifting, and whose older invoices never quite get cleared. Each pattern points to a different change, from moving due dates or asking for a deposit to putting a customer on direct debit, sending statements or pausing further work.
In this article
The short version
- Read your aged debtor report customer by customer to see how each one pays.
- If one customer owes a large share, learn their payment process and take deposits on big jobs.
- Customers late every month often miss their own payment run, so move due dates or switch them to direct debit.
- A customer whose time to pay keeps lengthening is drifting and worth acting on early.
- Old invoices left open are usually disputed, part paid or forgotten, and a statement helps with the last.
Who owes you the most
Start with each customer's total, not the oldest column. If one customer accounts for a large share of everything you're owed, their payment habits are a big part of your cash flow. That's fine while they pay on time. If they slip by a few weeks, or run into trouble, it can hurt more than all your small late payers put together.
You don't fix this by turning away good work. It's a reason to know that customer's payment process well: who approves invoices, when their payment run is, and whether a purchase order number has to be on every invoice. On larger jobs it's also a reason to agree a deposit or stage payments, so you're never carrying the full value of a project at once.
Late every month or late once
Put this month's report next to the last two or three. A customer who appears in the overdue columns once, for one invoice, has usually had a one-off problem: a lost email, a query, someone on holiday. A quick call tends to clear it, and there's no reason to change anything about how you work with them.
A customer who shows up every month is telling you how they pay. Often it comes down to their payment run. If they pay on the last Friday of the month and your terms are 14 days, plenty of your invoices will miss it whatever you do. Moving your due dates to suit their run, or invoicing earlier, can make a habitual late payer an on-time one without any extra chasing.
Where timing isn't the issue, the payment method often is. A customer paying by bank transfer has to remember, log in and type your details each time. Moving a regular customer onto direct debit means each invoice is collected on the date you set unless they cancel, and for irregular work a card kept on file can do a similar job. For customers who stay on invoices, Adfin's collection agents can adjust the timing and channel of reminders to how each customer tends to respond, within rules you approve.
Slow but steady or drifting
Two customers can each owe you the same amount, 45 days past due, and mean very different things. One has paid at around 45 days for two years. The other used to pay in 20 days, then 30, and is now at 45 with a balance that keeps growing.
You can plan around the steady payer, or try to shorten the gap with clearer terms. With the drifting customer, it's worth acting early, because a lengthening time to pay can be the first sign that a customer is short of cash. Ask what's changed. Consider asking for payment upfront on the next piece of work, and think carefully before extending more credit until the balance comes down. If it keeps growing, pausing further work may be the only lever left, and on business debts you can also claim statutory interest and fixed compensation.
A single report makes drift hard to see, because it's a snapshot. A measure of how long each customer takes to pay, tracked over a few months, shows it much sooner. In Adfin you can add DSO and days overdue columns to your dashboard. Customer-level DSO averages the time across that customer's payments, and days overdue shows their oldest unpaid invoice.
Old invoices that never get cleared
Open the detail report and look for customers whose recent invoices are paid while an older one stays open. It usually means one of three things.
Sometimes the older invoice is disputed. The customer pays what they're happy with and leaves the rest, often without saying so. Find out what the query is and settle it, since it won't resolve itself by sitting in the over 90 column.
Sometimes it was part paid, and a small remainder keeps ageing from the original due date. These often come from a deduction the customer thought was agreed. A short note to agree the difference, or a credit note to clear it, stops a small balance ageing for months on a good customer's account.
And sometimes the customer has simply lost track. Paying invoice by invoice, they pay whatever's in front of them, and the older one drops off their list. A statement showing everything they owe helps here. Adfin can send customer statements on a schedule you choose, with rules so they only go to customers above a set balance or number of days overdue, and customers can pay several invoices in one payment straight from the statement.
Common questions
How do I spot a customer who's getting into financial trouble? Watch for a customer whose time to pay keeps lengthening and whose balance keeps growing. Part payments and slower replies alongside that are worth a conversation sooner, not later.
Is it risky for one customer to owe most of my debtors? It can be, because a delay from them affects your cash far more than anyone else's. Knowing their payment process and taking deposits on large jobs reduces the exposure.
Should I stop working for a customer who always pays late? Not necessarily. If they always pay in the end, changing their due dates or moving them to direct debit may solve it, so stopping work is usually kept for customers whose balance keeps growing.
Why does a customer pay new invoices but leave an old one? Usually because the old one is disputed, was part paid, or has dropped off their list. A call or a statement tends to find out which.
Can I see customer payment patterns in Xero or QuickBooks? Both have aged receivables summary and detail reports, which you can compare month to month. Tracking each customer's average time to pay usually means building it yourself or using a tool that shows it.
Do statements help get older invoices paid? They often do, because they show a customer every open invoice in one place. That makes it easier to spot an invoice they've missed and pay everything together.
Sources
- QuickBooks Learn & Support - Run an accounts receivable ageing report (accurate as of October 2026) https://quickbooks.intuit.com/learn-support/en-global/help-article/accounts-receivable-reports/run-accounts-receivable-ageing-report/L4N7PC2hg_ROW_en
- GOV.UK - Late commercial payments: charging interest on commercial debt (accurate as of October 2026) https://www.gov.uk/late-commercial-payments-interest-debt-recovery/charging-interest-commercial-debt
- Adfin - Changelog (accurate as of October 2026) https://adfin.com/resources/changelog
- Adfin - Credit control (accurate as of October 2026) https://www.adfin.com/credit-control
