Aged Debt Reports in the UK: How to Monitor and Act on Overdues

Every month, your aged debt report is a financial snapshot that categorizes unpaid invoices by how long they have been outstanding. For UK business owners, this document is not just a spreadsheet; it is a vital health check for your cash flow. If you ignore the buckets where money sits for 30, 60, or 90 days, you are essentially lending to customers without interest. This guide breaks down exactly how to read these reports, identify risky patterns, and take action before small delays turn into write-offs.

What an Aged Debt Report Actually Shows

An aged debt report groups your outstanding receivables into time-based buckets. Typically, you will see columns for 1-30 days, 31-60 days, 61-90 days, and over 90 days. The total at the top represents your total Accounts Receivable (AR). However, the value lies in the distribution. If 80% of your AR is in the 1-30 day bucket, your credit control is working. If a large chunk has slipped into the 60+ day range, you have a problem that requires immediate attention. This tool helps you distinguish between normal payment cycles and genuine delinquency.

It is crucial to understand that "overdue" does not always mean "bad." Some clients pay slowly but reliably. Others pay fast but rarely. The report gives you the data to separate these behaviors. You need to look at the aging trend over several months, not just a single snapshot. A sudden spike in the 90-day bucket might indicate a specific client’s financial trouble, while a gradual increase across all buckets could signal a systemic issue with your invoicing process or credit terms.

Setting Up Your Buckets and Thresholds

Before you can act, you must define what "late" means for your business. Standard practice in the UK often follows the statutory late payment rules, which allow interest charges after 30 days unless agreed otherwise. However, your internal thresholds should align with your cash flow needs. Many businesses set their first warning trigger at 15 days past due. This early intervention prevents small issues from becoming large ones. You should configure your accounting software, such as Xero, QuickBooks, or Sage, to automatically generate these reports monthly. Do not rely on manual spreadsheets if you can avoid them; automated reporting reduces human error and saves hours of administrative time.

Consider customizing your buckets based on your industry. Construction firms, for example, often face longer payment cycles due to project milestones, so their "normal" 30-day bucket might be 45 days. Retailers with net-14 terms will flag anything over 15 days as urgent. Tailoring these thresholds ensures your team focuses on the right risks. If your software allows it, add color-coding: green for current, yellow for 1-30 days, orange for 31-60 days, and red for 60+ days. Visual cues help non-financial staff understand urgency at a glance.

Identifying Risky Patterns and Bad Debts

Once your report is generated, scan for outliers. Look for individual customers who consistently appear in the 60+ day column. These are your high-risk accounts. Check if there is a pattern: do they only pay when chased? Are their payments smaller than the invoice amount? These are red flags. In the UK, bad debt write-offs are tax-deductible, but preventing them is far better than claiming the loss later. Use the report to calculate your Days Sales Outstanding (DSO). This metric tells you the average number of days it takes to collect payment. If your DSO is rising month over month, your collection efforts are slowing down. A healthy DSO for most SMEs ranges between 30 and 45 days. Anything above 60 days suggests you are funding your customers' operations rather than your own.

Also, watch for partial payments. If a client pays half an invoice and ignores the rest, it is often a sign of cash flow stress. This is the moment to engage. Do not wait for the next invoice. Contact the client immediately to discuss the balance. Early conversation preserves the relationship and increases the likelihood of full recovery. Conversely, if a client disappears entirely, move them to the "at risk" category and consider stricter terms for future orders, such as prepayment or bank transfer only.

Action Plans for Different Aging Stages

Not all overdue accounts require the same response. A structured approach ensures consistency and fairness. Here is a practical framework for acting on different stages of aging:

• 1-30 Days (Friendly Reminder): Send a polite email confirming the invoice was received and noting the due date. Assume it was an oversight. Keep the tone helpful, not accusatory. Attach the original invoice for convenience.
• 31-60 Days (Formal Chase): Send a formal letter or email stating the account is overdue. Mention any contractual late payment fees or interest under the Late Payment of Commercial Debts (Interest) Act 1998. Request a specific payment date.
• 61-90 Days (Escalation): Make phone calls. Emails get ignored; voices get attention. Speak to the person responsible for payments, not just the general inbox. If no answer, send a final notice before legal action.
• 90+ Days (Recovery Phase): Consider engaging a debt collection agency or sending a Letter Before Action (LBA). At this stage, the goal shifts from maintaining the relationship to recovering cash. Evaluate if continuing to trade with this client is worth the risk.

Document every interaction. If you eventually need to go to court, a paper trail of chases strengthens your case. Use your CRM or accounting software to log calls and emails against the specific invoice. This data also helps you refine your customer credit policies over time.

Optimizing Credit Terms and Prevention

The best way to manage aged debts is to prevent them. Review your credit terms annually. Are you offering Net-60 when Net-30 would suffice? Longer terms increase your exposure to default. For new customers, start with conservative limits. Offer Net-30 terms and monitor their behavior for three to six months. If they pay on time, you can gradually increase their credit limit. For existing customers who have a history of late payments, tighten their terms. Move them to Cash on Delivery (COD) or require a deposit for large orders. This shift may upset some clients, but the cost of chasing unpaid invoices is higher than the cost of slightly stricter terms.

Automate your reminders. Most modern accounting platforms allow you to schedule automatic emails at 7, 14, and 30 days post-due date. This removes the emotional labor of chasing and ensures no invoice falls through the cracks. Combine automation with manual follow-up for high-value accounts. For smaller balances, let the system handle the initial nudges. Reserve your personal time for the big tickets that significantly impact your cash flow.

Tools and Technology for Monitoring

You do not need expensive enterprise software to manage this effectively. Tools like Xero, QuickBooks Online, and FreeAgent offer robust AR modules with built-in aging reports. These platforms integrate with bank feeds, reducing reconciliation errors. If you use Excel, ensure your formulas are dynamic and linked to your general ledger. Static spreadsheets become outdated quickly and lead to poor decisions. Look for features that allow you to export data for deeper analysis. Some advanced tools offer predictive analytics, flagging customers likely to pay late based on historical data. While not essential for small businesses, these insights can save significant time as you scale.

Regular reviews are key. Schedule a monthly 30-minute session to review the aged debt report. Bring your sales team along if necessary. Sometimes, sales promises unrealistic delivery dates that lead to payment disputes. Aligning sales and finance ensures everyone understands the impact of credit terms on cash flow. This cross-functional dialogue prevents silos and creates a unified approach to revenue collection.