How to run a monthly aged debtors review as a small business owner

Running a small business in the UK means wearing many hats. You’re the CEO, the head of sales, the marketing department, and often, the credit controller. While chasing invoices might feel like a distraction from your "real" work, it's the lifeblood of your business. This is where a monthly aged debtors review becomes one of the most powerful 30-minute habits you can build for managing your cash flow and ensuring your hard work actually turns into money in the bank.

This guide will walk you through exactly how to conduct an effective monthly aged debtors review. We’ll cover what the report is, how to analyse it, and most importantly, how to decide which actions will get you paid faster. This isn't about complex accounting theory; it's a practical process for business owners who need to keep cash flowing.

What is an Aged Debtors Report?

An aged debtors report (sometimes called an aged receivables report) is a simple but critical document. It lists all the sales invoices you've issued that haven't been paid yet, and groups them by how long they have been outstanding. It's essentially a snapshot of all the money your customers owe you.

Most modern accounting software like Xero, QuickBooks, FreeAgent, or Sage can generate this report in a few clicks. Typically, it will have columns for:

• Customer Name: Who owes you the money.
• Invoice Number: The unique reference for the bill.
• Invoice Date: When you issued the invoice.
• Due Date: The date payment was expected by.
• Amount Outstanding: The total value of the unpaid invoice.
• Ageing Buckets: This is the key part. The report sorts the outstanding amount into columns based on how long the invoice has been overdue.

The buckets usually look something like this:

• Current: Invoices that have been issued but are not yet due.
• 1-30 Days: Invoices that are between 1 and 30 days past their due date.
• 31-60 Days: Invoices overdue by one to two months.
• 61-90 Days: Invoices overdue by two to three months.
• 90+ Days: Invoices that are seriously late.

The simple truth of credit control is that the older a debt gets, the harder it is to collect. A monthly review of this report is your early warning system, allowing you to spot problems before they escalate into critical cash flow issues.

The Monthly Review Process: A Step-by-Step Guide

Set aside 30-60 minutes at the same time each month—for example, the first Tuesday morning—to perform this review. Consistency is key. Open your accounting software and run the aged debtors report for today's date. Now, work through it systematically.

Step 1: Look at the Total Figure

Before diving into the details, look at the grand total at the bottom of the report. This is the total amount of money owed to your business right now.

• Ask yourself: How does this total compare to last month? Is it trending up or down?
• If it’s increasing significantly: This could be a good sign (you're making more sales) or a bad one (your collection process is slowing down). You need to dig deeper.
• If it's decreasing: Great! Your chasing efforts are likely paying off.

This top-level view gives you vital context before you start analysing individual invoices.

Step 2: Scan the 'Current' Column

These invoices aren't late yet, so no chasing is needed. However, this column is invaluable for short-term cash flow forecasting.

• Identify large invoices: Are there any particularly large amounts due to be paid in the coming weeks? Knowing this helps you plan your own expenditure.
• Proactive reminders: For a new customer or a very large invoice, it can be worth sending a polite, "no-chase" email a few days before the due date. Something like, "Hi [Client Name], just a quick and friendly reminder that invoice #123 for £X is due for payment on [Date]. We've attached a copy for your convenience." This confirms they have the invoice and puts it on their radar.

Step 3: Focus on the '1-30 Days' and '31-60 Days' Columns

This is your primary action zone. These are recently overdue debts and are the most likely to be paid with a simple, professional nudge.

For each invoice in these columns, ask:

• Has it been chased yet? Check your sent items or the notes in your accounting software. If not, it needs chasing today.
• Is there a known dispute? If a customer has raised an issue with the work or the invoice, a standard reminder email won't help. This needs a phone call to resolve the underlying problem. Make a note to deal with this separately.
• Is it a small, forgotten amount? Sometimes a client pays the main part of a bill but forgets a small disbursement or final charge. A quick, friendly email is usually all that's needed.
• Is this a regular late payer? If you see the same client name appearing in these columns month after month, it’s a pattern. Standard chasing might not be enough. It’s time to consider a different approach for them (more on this below).

Step 4: Scrutinise the '61-90 Days' and '90+' Columns

These are the red flags. Debts this old represent a significant risk to your cash flow. The chance of non-payment increases dramatically after 90 days. Your approach here needs to be firmer and more direct.

For each of these very late invoices:

• Review the entire history: What's the story here? How many times have you chased? Have they made any promises to pay? Have they been responsive? All your notes are crucial here.
• Pick up the phone: If you've only been using email, it's not working. A phone call is harder to ignore and allows you to understand the real reason for non-payment. Is their business in trouble? Did they genuinely lose the invoice? Is there a deep-seated dispute?
• Stop any further work: Do not provide any more goods or services to a client with a debt this old until it is settled. You must protect your business from further losses.
• Decide on escalation: These debts require a decision. Are you going to initiate formal debt recovery action, or is the amount small enough that it's time to consider writing it off?

Deciding What Action to Take: A Triage System for Your Debts

Once you’ve reviewed the report, you need to turn your analysis into action. Don't just close the report and forget about it. Group your outstanding invoices into three categories and assign a clear next step for each.

Category 1: Routine Chasing (1-60 days overdue)

These are your standard, run-of-the-mill late payments. The client is likely just busy, disorganised, or has a slightly slow payment run.

• Action: Send the next communication in your chasing sequence. This should be a pre-planned escalation process, for example:
  • 7 days overdue: A polite, friendly reminder email.
  • 14 days overdue: A slightly firmer email, stating the invoice is now overdue.
  • 30 days overdue: A firm email, attaching a statement of account, and mentioning that you may need to call them if you don't hear back.
• Automation: This is the most repetitive and time-consuming part of credit control. This is exactly the kind of process that can be automated. Tools like InvoiceReminder connect to your accounting software and send these scheduled email sequences for you, using rules you define. This ensures every overdue invoice is chased consistently and professionally, freeing you up to focus on the problem accounts.

Category 2: Problem Accounts (Repeat offenders, disputed invoices)

These are accounts that require your personal attention. They might be good clients who are just chronically disorganised, or there might be an unresolved issue preventing payment.

• Action: Stop emailing and pick up the phone. Your goal is to understand the "why" behind the late payment.
  • For the disorganised client: "Hi John, just calling about a couple of overdue invoices. Is everything okay on your end?"
  • For the disputed invoice: "Hi Sarah, I wanted to follow up on the issue you raised with invoice #456. I want to get this sorted for you – when is a good time to talk it through?"
• Future Strategy: For repeat late payers, consider changing their payment terms. You might move them to 7-day terms or even request payment upfront (pro-forma) for all future work.

Category 3: High-Risk Debts (90+ days overdue, unresponsive clients)

These debts require a serious, formal approach. The goal has shifted from "reminding" to "recovering."

• Action: Legislate and Escalate. For business-to-business debts in the UK, you have a statutory right to claim interest and compensation under the Late Payment of Commercial Debts (Interest) Act 1998.
  • Interest: You can charge interest at 8% plus the Bank of England's base rate. You should check the current base rate on the Bank of England website when calculating this.
  • Fixed Compensation: You can also add a one-off compensation charge. The amount is set by law.

Debt Value (per invoice)	Fixed Compensation You Can Add
Up to £999.99	£40
£1,000 to £9,999.99	£70
£10,000 or more	£100

• Next Steps:
  1. Final Demand / Letter Before Action: Send a formal letter (by post, ideally recorded) stating the full amount now due including statutory interest and compensation. State that if payment is not received within 7 or 14 days, you will begin legal proceedings without further notice.
  2. Small Claims Court: If they still don't pay, you can use the UK Government's Money Claim Online service to start a small claims court action. It's designed to be used without a solicitor for debts up to £10,000.
  3. Consider Writing It Off: Be pragmatic. If the debt is small (e.g., £150) and the client is a sole trader who has vanished, the time and court fees involved in chasing it may be more than the debt is worth. Sometimes, the best commercial decision is to write it off, claim any applicable tax relief, and move on. This is a business decision, not a defeat.

Spotting Deeper Problems in Your Aged Debtors Report

Your monthly review isn't just about chasing individual invoices. It's a health check for your entire sales and finance process. Look for these patterns:

• Concentration Risk: Is a single client responsible for 40% or more of your total outstanding debt? This is a huge risk. If they have financial trouble, it could seriously damage your business. Your review should prompt you to think about diversifying your client base.
• Systemic Payment Delays: Are a large number of your clients slipping into the 31-60 day column? This might not be their fault. Perhaps your payment terms are unclear on your invoices, you don't offer easy payment methods (like a 'Pay Now' button), or your initial reminders are too soft or sent too late.
• Dispute Patterns: Do you see lots of small credit notes or notes about disputes? This could indicate a problem in your service delivery, product quality, or even your quoting process. The aged debtors report can be the first sign that something is wrong operationally.

Automate the Manual Work to Focus on What Matters

The purpose of a monthly aged debtors review is to apply your judgement where it's needed most: on the complex, high-risk, or relationship-driven accounts. The repetitive task of sending the first, second, and third reminder emails for routine late payments is a perfect candidate for automation.

This is where a tool like InvoiceReminder comes in. It connects directly to accounting platforms like Xero, QuickBooks, FreeAgent, and Sage to automatically send out your chasing emails according to a schedule you set. This means the 'Routine Chasing' category is handled for you, ensuring no invoice is ever forgotten. Your monthly review then becomes much faster and more strategic, as you can immediately focus your energy on the 'Problem Accounts' and 'High-Risk Debts' that truly require your human touch. The platform is built by the team behind WeCovr, a UK company authorised and regulated by the Financial Conduct Authority for its insurance activities, bringing a culture of reliability and trust to its software products.

Frequently asked questions

How often should I run an aged debtors report?

For most small businesses, a dedicated review once a month is the perfect cadence. It’s frequent enough to catch problems early without becoming an overwhelming administrative burden. If your business has very tight cash flow or a high volume of transactions, a weekly review might be more appropriate.

What's the difference between an aged debtors and aged creditors report?

They are two sides of the same coin. An aged debtors report shows who owes you money (your accounts receivable). An aged creditors report shows who you owe money to (your accounts payable). Reviewing both is key to managing your overall cash flow.

At what point should I consider a debt uncollectable?

There is no single rule, as it's a commercial decision. Generally, you should consider it if the client has gone into liquidation or administration, or if the cost and time of further chasing (e.g., court fees) are likely to be more than the debt itself. For a debt over 90-120 days old where the client is completely unresponsive despite formal demands, you should seriously evaluate whether to continue chasing or to write it off.

Can I charge interest on all overdue invoices in the UK?

For business-to-business (B2B) transactions, you generally have a statutory right to claim interest and compensation under the Late Payment of Commercial Debts (Interest) Act 1998, unless your contract specifically excludes it. For business-to-consumer (B2C) sales, the rules are different and more complex; you typically can't add these statutory charges unless it was a specific term in your contract that the consumer explicitly agreed to.

My customer says they never received the invoice. What should I do?

Don't get into an argument about whether they did or didn't. It's unproductive. The fastest path to payment is to be helpful. Immediately say, "No problem at all, I'm resending it to you right now. Can you please confirm when you've got it?" Resend the invoice from your accounting system while you're on the phone or in the email. This resets the clock on their payment excuses and gets the process moving again.

What is a good "Days Sales Outstanding" (DSO) figure?

DSO measures the average number of days it takes for your customers to pay you. A good DSO varies by industry and your standard payment terms. A common rule of thumb is to aim for a DSO that is no more than 1.5 times your standard terms (e.g., if you offer 30-day terms, a DSO of 45 days or less is a good target). The most important thing is to track your own DSO over time and work to bring it down.