An aged debtor report usually looks wrong because the payments behind it haven't been recorded properly: money received but not matched, matched to the wrong invoice, or credit notes and overpayments left unallocated. The rest is mostly settings and timing, such as ageing from the invoice date, the date you ran it, or direct debits still on their way. Each has a straightforward fix in Xero or QuickBooks, and most stop recurring once payments match themselves.
In this article
The short version
- Most wrong aged debtor reports come from payments not recorded against the right invoice.
- Check the ageing basis and run date first, as they take seconds to fix.
- Unallocated credit notes, overpayments and duplicate customers make balances look wrong.
- Direct debits in transit and disputed invoices can sit in the overdue columns without being late.
- Payments that match themselves stop most of these problems recurring.
Check the settings first
Before you start reallocating anything, rule out the two causes that take seconds to check.
The ageing basis
If the report ages from the invoice date, an invoice on 30-day terms appears overdue a month before it is. Check the report's settings and, where you can, age from the due date.
The run date
The report measures each balance against the date you run it, or the date you type in. A report dated last month, or run on the 1st when customers pay on the 5th, can show debts that have since cleared. Rerun it for today and compare like with like.
Payments not recorded against the right invoice
Most wrong reports come from here. The cash is in your bank, but the accounting system doesn't know which invoice it paid.
A payment received but not matched
The money arrived, but the bank line hasn't been reconciled to the invoice, so the invoice keeps ageing. Usually the customer left off the reference or used a different one. Find the bank line, match it to the open invoice and reconcile. If you can't tell what it's for, hold it as unallocated and ask the customer.
A payment matched to the wrong invoice or customer
One invoice shows as paid and another stays overdue, or one customer looks in credit while another looks in arrears. Remove the match on the bank line and reallocate it to the right invoice. A customer who's paid "the March invoice" when you had two that month is a common source.
Duplicate customer records
The same customer set up twice, perhaps as "Smith Ltd" and "Smith Limited", splits their balance across two rows: payments land on one and invoices sit on the other. Merge the records so everything sits under one customer. Most accounting software has a way to combine duplicate contacts.
Credit notes and overpayments left unallocated
A credit note or an overpayment that hasn't been applied shows the customer as owing in one column and in credit in another. Apply the credit note to the invoice it relates to, and allocate the overpayment to the next open invoice or refund it.
Part payments
If a customer pays £900 of a £1,000 invoice, the £100 left keeps ageing from the original due date. That's correct, but it can look like an old debt the customer has ignored. Check whether the shortfall was deliberate, such as a disputed line or a deduction, and either chase it, credit it or write it off.
Invoices that shouldn't be in the overdue columns
Some invoices are accurately recorded but don't belong with the debts you need to chase.
Direct debits still being collected
A direct debit is collected on or after the due date and takes a few working days to reach your bank, so for a short spell the invoice can show as overdue when nothing has gone wrong. Give mandate invoices a few working days before you treat them as late.
Disputed or on-hold invoices
An invoice the customer is querying sits in the same columns as one they've forgotten, which makes the total look worse and leads to chasing that irritates the customer. Keep a note of each dispute with an owner and a date, and pause chasing on that invoice while it's being resolved.
Voided or duplicate invoices never cleared
An invoice raised twice, or replaced by a corrected one, stays on the report until someone voids or credits the original. Void the duplicate, or raise a credit note if it was already sent, so the customer's balance matches what they owe.
How to stop it happening again
Most of these problems start with a payment that didn't arrive with enough information to match itself. Fixing them by hand works, but it comes back every month.
When customers pay through Adfin, by card, pay by bank or direct debit, the invoice is marked paid in Xero or QuickBooks automatically. Bank transfers go to unique bank details for each customer, so a payment is identified by where it lands. Adfin's aged debtors view then shows what each customer owes as it stands, broken down by age, and you can give disputed debts an owner, add the next action and pause chasing for a customer while a query is sorted. Its collection agents carry on chasing what's genuinely overdue, within the rules you set.
Common questions
Why does my aged debtor report show an invoice the customer has paid? The payment probably hasn't been matched to the invoice in your accounting system. Find the bank line, match it to the invoice and reconcile it.
Why does a customer show as owing and in credit at the same time? Usually a credit note or overpayment hasn't been applied to their open invoices. Allocate it and the two balances net off.
Why do small balances keep appearing in the oldest column? They're often the remainder of part payments, which keep ageing from the original due date. Check whether each was a deliberate deduction, then chase, credit or write it off.
Should disputed invoices stay on the aged debtor report? Yes, because the money is still owed, but mark them clearly and pause chasing so you don't treat a query like a late payment.
Why do direct debit invoices show as overdue? A direct debit takes a few working days to reach your bank after collection, so the invoice can look late for a short time when it's on track.
How do I fix duplicate customers in Xero or QuickBooks? Merge the two records so all invoices and payments sit under one customer. Both have a way to combine duplicate contacts, so check the help pages for yours.
Sources
- QuickBooks - 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
- 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
