What Is an Aged Debtor Report and Why Do Providers Want It?
An aged debtor report lists every customer, what they owe, and how overdue the debt is (usually bucketed as current, 1-30 days, 31-60, 61-90, 90+). Providers use it to assess ledger quality, dilution risk, and concentration. Clean ledgers (90%+ current) unlock the best rates.
Why This Matters
An aged debtor report is the single most scrutinised document in any invoice finance application. It's a snapshot of your sales ledger, showing every customer, what they owe, and crucially, how late those payments are running. UK invoice finance providers use it to determine two things: how much cash you can actually access (your advance rate), and what price you'll pay.
A ledger showing £500,000 of invoices sounds healthy until the report reveals £200,000 is 90+ days overdue. That's a red flag. Providers know that debts aged beyond 90 days have sharply declining recovery rates, especially if your customers include construction subcontractors or hospitality businesses.
The report also reveals concentration risk. If 60% of your ledger is owed by a single customer, you're vulnerable. Providers will cap advances or decline altogether. For UK SMEs chasing faster cash flow, understanding what your aged debtor report says before you apply can mean the difference between an 85% advance at 2.5% and a 60% advance at 4%, or no facility at all.
Key Points
- The report categorises debts by age: current (not yet due), 1-30 days overdue, 31-60, 61-90, and 90+ days. Providers typically want 85-90%+ of the ledger value in 'current' or under 30 days for competitive terms.
- Concentration risk is immediately visible. If one debtor represents over 25-30% of total ledger value, most providers will apply sub-limits or reject the application outright to protect against single-customer default.
- Dilution is calculated from the report. Credits, disputes, or returned goods create 'dilution'. If your report shows £100,000 invoiced but £15,000 in credit notes, that's 15% dilution, well above the 5-8% threshold most providers accept.
- Providers cross-reference the report against your management accounts and VAT returns. Material discrepancies (e.g. £600,000 on the aged debtor report vs. £400,000 trade debtors in your balance sheet) trigger deeper due diligence or withdrawal.
- Sector norms matter. Construction or recruitment agencies often see 60-day payment as standard, so a 'clean' report in those sectors looks different to a retailer supplying Tesco. Providers adjust expectations accordingly.
- The report must be dated within 7-14 days of submission. Stale reports are rejected. Providers want real-time visibility, especially if they're advancing 80-90% of invoice value within 24 hours.
- Bad debt write-offs visible in historic reports affect pricing. If your previous year's report showed £50,000 written off from a £1m ledger (5% bad debt ratio), expect higher discount fees or lower advance rates.
Illustrative Example
Hypothetical: a Birmingham IT services company with £800,000 annual turnover applies to an invoice finance provider for invoice discounting. Their aged debtor report shows £120,000 outstanding: £70,000 current, £30,000 at 1-30 days, £15,000 at 61-90 days, and £5,000 at 90+ days. One customer (a local NHS trust) owes £40,000 of the total.
The provider identifies 33% concentration (NHS trust) and 17% of the ledger aged over 60 days. They offer a facility but cap advances against the NHS trust at £25,000 until payment history improves, and quote a higher fee than it would for a cleaner ledger. The business accepts but focuses on chasing the overdue £15,000 to clean the ledger for renegotiation in six months.
Common Pitfalls
- Submitting a report that doesn't reconcile to your bookkeeping software. Providers will spot mismatches between Xero/QuickBooks debtor balances and your spreadsheet, causing immediate credibility damage.
- Hiding problem debts by writing them off just before application. Providers request 6-12 months of historic reports during due diligence and will see the pattern, treating it as dishonesty rather than housekeeping.
- Assuming all invoice finance providers accept the same ledger profile. Some larger funders may fund a ledger with 20% aged over 60 days if debtors are blue-chip, while a smaller funder might walk away at a much lower percentage.
- Not understanding that intercompany invoices are usually excluded. If £60,000 of your £200,000 ledger is invoices to your sister company, the fundable ledger is only £140,000, slashing available cash.
- Failing to separate factoring-eligible invoices from ineligible ones (e.g. consumer debts, overseas invoices outside approved territories). The report should clearly flag what's in-scope for funding.
What to Do Next
- Run an aged debtor report from your accounting software today, even if you're not applying yet (or build one in our free aged debtors template). Identify any invoices over 60 days and start formal chasing or consider write-offs to clean the ledger before approaching providers.
- Calculate your concentration ratio: divide your largest single debtor balance by total ledger value. If it's over 25%, diversify your customer base or prepare to accept sub-limits and higher pricing.
- Compare your report against sector benchmarks. Contact 2-3 providers from the allowlist (e.g. Ultimate Finance, Skipton Business Finance, Sonovate) and ask what aged debtor profile they consider 'clean' for your industry before formal application.
Related Questions
What aged debtor profile do most UK providers consider fundable?
Typically 85-90% of ledger value current or under 30 days overdue, under 10% at 31-60 days, and under 5% beyond 60 days. Anything over 15% aged beyond 60 days usually triggers either rejection or materially higher fees. Sector matters: construction or recruitment may see more tolerance for 60-day ages, while retail or distribution expect tighter profiles.
Can I exclude very old debts from the aged debtor report I submit?
No. Providers require a complete ledger snapshot. Selectively omitting debts is grounds for rejection and potential fraud allegations. If debts are genuinely unrecoverable, write them off formally in your accounts before applying, and be prepared to explain the write-off during due diligence with supporting documentation.
How often will the provider want updated aged debtor reports once the facility is live?
Weekly or even daily, depending on the product. Invoice discounting usually requires weekly uploads to the provider's portal. Many providers take daily automated feeds from your accounting software to monitor ledger quality in real time and adjust advance rates immediately if aging deteriorates.
Founder & Managing Director, Muswell Rose, founder and PSC of Best Business Loans Ltd
Adam is the founder and managing director of Muswell Rose and a founder of Best Business Loans Ltd, the company behind Market Invoice. He spent over three years as managing director of Penny, a UK invoice finance business, and his career runs through insurance, mortgages, commercial finance and fintech lending. He writes the Market Invoice library.
Published · Updated