How to File an Aged Debtor Report for Invoice Finance: A Complete Guide for UK SMEs

An aged debtor report lists every outstanding invoice by customer and by how long it has been unpaid. Invoice finance providers use it to recalculate your available funding, spot slow payers, and confirm your sales ledger matches what they are financing. Filing it accurately and on time keeps drawdowns flowing without delay.

What an aged debtor report is and why your funder needs it

An aged debtor report, sometimes called an aged debt or sales ledger ageing report, is a snapshot of every invoice you have raised that has not yet been paid, grouped by how long each one has been outstanding. Typical bands are current, 30 days, 60 days, 90 days and 90 days plus.

Your invoice finance provider is not lending against your business in the abstract; it is lending against specific invoices on your sales ledger. The aged debtor report is how they check that the ledger you are drawing funds against still exists, still matches your accounting records, and is not deteriorating. It feeds directly into the calculation of your available funding, so it is one of the most important documents you send them.

What the report needs to contain

A funder-ready aged debtor report should show, for each customer: the debtor name, individual invoice numbers, invoice dates, due dates, invoice values, and the outstanding balance split across the standard ageing bands. Totals should be shown per debtor and for the ledger as a whole.

Most providers want the report to reconcile exactly to your sales ledger control account in your accounting system. If the totals do not match, expect the funder to query it before releasing further drawdowns. Some also ask for a separate note of any credit notes, contra balances, or invoices under dispute, since these are usually excluded from the funding calculation.

How often to file and typical deadlines

Most invoice finance facilities require the aged debtor report weekly, though some smaller or lower-risk facilities move to monthly reporting once a track record is established. Confidential invoice discounting facilities with strong controls sometimes report monthly from day one; disclosed factoring facilities are more likely to stay on a weekly cycle because the funder is managing collections directly.

Deadlines are usually set in the facility agreement, for example by close of business each Monday for the previous week. Missing a deadline does not just create admin friction; many funders pause new drawdowns until an up-to-date report is received, which can leave you short of working capital exactly when you need it.

Common mistakes that trigger holds or audit flags

The most frequent issue is a mismatch between the aged debtor report and the sales ledger, often caused by invoices being raised in the accounting system but not yet uploaded to the funder's portal, or vice versa. A close second is failing to flag disputed or credit-noted invoices, which the funder then discovers during a periodic audit and treats as a control weakness.

Concentration is another trap. If one customer makes up a large share of your ledger and their invoices start ageing past 90 days, funders will typically reduce or suspend funding against that debtor specifically, which can materially cut your overall availability even if the rest of the ledger is healthy. Reviewing concentration before you file, not after the funder flags it, avoids surprises.

Preparing the report from Xero, Sage or QuickBooks

All three mainstream UK accounting platforms have a built-in aged receivables or aged debtor report under their standard reporting menu, and each lets you export to CSV or Excel with custom ageing periods set to match your funder's bands. Before exporting, run through your sales ledger and clear down anything that should not be there: cancelled invoices, duplicate entries, or invoices already paid but not yet marked as such.

Some funders integrate directly with your accounting software via API, which removes the manual export step and reduces reconciliation errors. If that option is available on your facility, it is worth setting up early, since it also tends to speed up drawdown processing.

What happens after you submit it

Once received, the funder's operations team reconciles the report against your existing drawn balance, applies any ineligibility rules (concentration caps, debtor age limits, disputed invoice exclusions), and recalculates your available funding, known as your borrowing base. If availability has increased, you can typically drawdown the difference the same or next working day. If it has fallen, further drawdowns are capped until the ledger recovers or new invoices are added.

Periodically, usually every three to twelve months depending on facility size, the funder will also carry out a fuller sales ledger audit, phoning a sample of your debtors to confirm invoices are genuine and undisputed. A clean, consistent history of aged debtor reporting makes these audits faster and less likely to raise concerns.

Checklist

• ☐Reconcile the aged debtor report total to your sales ledger control account before submitting
• ☐Flag all credit notes, part-payments and disputed invoices separately, not netted off silently
• ☐Check no single debtor exceeds your facility's concentration limit before it becomes a funding problem
• ☐Set a recurring calendar reminder that matches your funder's exact filing deadline, not just the day
• ☐Use your accounting software's built-in ageing report rather than building one manually where possible
• ☐Review invoices sitting in the 90 days plus band and chase them before the funder does

FAQs