AP & AR
Aged receivables report
A monthly accounts receivable ageing report for your UK company breaks outstanding customer balances into current, 30, 60 and 90-plus day buckets, reconciled to invoices and payments in Xero, QuickBooks Online or Sage, so collection risk is visible before it turns into a cash shortfall.
Aged receivables
Illustrative client · August 2026
GBP
| Customer | Current | 1-30 | 61+ | |
|---|---|---|---|---|
| Customer A | 18,400 | - | - | - |
| Customer B | 9,250 | 4,100 | - | - |
| Customer C | - | 6,780 | 2,200 | - |
| Customer D | 12,600 | - | - | - |
| Customer E | - | - | - | 1,450 |
| Total | 40,250 | 10,880 | 2,200 | 1,450 |
Illustrative. An example of the document, not a client's figures.
Seeing risk before it hits the bank
An ageing report is prepared each month as part of close, splitting every open customer balance into current, 30, 60 and 90-plus day buckets. Balances are reconciled to invoices and payments recorded in Xero, QuickBooks Online or Sage, so the figures match what the ledger actually shows rather than a rough estimate.
Any invoice under dispute or on a payment plan is noted separately, so it does not distort the ageing picture for a customer who is genuinely current on the terms you agreed. Accounts moving into a higher-risk bucket month over month are called out, giving you time to act while there is still a working relationship to protect.
For a company approaching the VAT registration threshold or already VAT-registered, ageing figures are kept clean of VAT distortion, so the net position a director or lender looks at reflects the actual trading exposure, not a figure inflated by VAT sitting in transit.
Write-offs stay your call
Bad-debt candidates are flagged for your review, with the history behind each one. Deciding whether to write off a balance, and how that interacts with your VAT bad debt relief position, sits with you and your adviser, not with our bookkeeping team. The report itself is kept in the same format month over month, so a director or a lender reviewing three months side by side sees a genuine trend rather than three reports built on different assumptions.
Why this report matters to lenders and financiers
Many UK companies fund working capital through invoice discounting or factoring, and the facility provider checks the ageing schedule against the sales ledger before releasing funds against it. A clean, consistently formatted ageing report is what keeps a drawdown moving rather than stalled on a query from the lender's monitoring team. The same report also feeds the bad debt provision a director signs off in the statutory accounts, and FRS 102's amended revenue recognition rules, effective for periods beginning on or after 1 January 2026, change how some UK companies time revenue and the receivable that sits against it. We flag where that shift touches your ageing figures so your accountant is not reconciling a surprise at year end.
Questions
Frequently asked questions: Aged receivables report
How often is the UK ageing report updated?
Monthly as part of close, with an updated view available on request if you need to check a specific customer's balance sooner.
Does the ageing report account for VAT bad debt relief?
We flag candidate balances and the history behind them. Applying VAT bad debt relief on a written-off invoice is a decision for you and your adviser.
Can the report be broken down by customer or by business unit?
Yes. Buckets are shown by customer as standard, and we can split by business unit or entity on request during onboarding.
What do the ageing buckets actually flag for us?
Current, 30, 60 and 90-plus day buckets show which customers are drifting from prompt payers into slow payers before it becomes a cash-flow problem. A customer sliding from current into the 30-day bucket month after month is a clearer early signal than a single missed invoice.
Can the ageing report feed into a cash flow forecast?
Yes, the same ageing data that shows who owes what and how late feeds directly into a 13-week cash flow forecast if you use that service, so expected collections are based on real payment patterns rather than an assumption that every invoice lands on time.
How often is the aged receivables report updated?
Monthly as part of close, with an updated view available on request if you need to check a specific customer sooner.
Do you decide when to write off a bad debt?
No. We flag the candidates and the history behind them. Writing off a balance is a decision you or your tax preparer make.
Who reviews the work before it reaches us?
Every deliverable under aged receivables report is reviewed by a senior reviewer before it reaches you. You keep access to the underlying file at every stage, so nothing about the work happens somewhere you cannot see it.
What is included in aged receivables report?
Aged receivables report covers monthly aged receivables report broken into current, 30, 60 and 90-plus day buckets and customer balances reconciled to invoices and payments received. The exact scope is agreed and set out in writing before work starts, so you know precisely what is and is not covered before the first deliverable arrives.
Related services
- AP & ARCollectionsOverdue invoices are followed up on a set cadence, with reminders sent and calls logged, so slow-paying customers get consistent attention without you having to chase them yourself.
- AP & ARCash applicationIncoming customer payments are matched to the right invoice and posted to the correct account, so accounts receivable reflects what is actually still owed.
Next step
Talk to the team that would run your books
A short call covers your setup, your software and what a first month would look like. You get a written scope and price after it.