Sage overdue invoice reporting what it shows and what it misses

Sage is a cornerstone of UK business accounting, providing a robust system for tracking income and expenses. Its reporting features are powerful for giving you a snapshot of your financial health, especially when it comes to who owes you money. But while Sage is excellent at telling you who is late to pay, it stops there, leaving the crucial—and time-consuming—work of actually chasing those debts entirely up to you.

This article explores exactly what Sage's overdue invoice reporting shows you and, more importantly, what it misses. We'll walk through the standard manual chasing process that Sage reports leave you with and highlight the gaps in a system that reports on problems but doesn't help you solve them. For the thousands of small business owners who spend hours every month manually chasing payments, understanding these limitations is the first step to reclaiming that lost time.

What Sage Reporting Shows You: The Aged Debtors List

The primary tool within Sage for identifying late payers is the Aged Debtors Report. Whether you use Sage Business Cloud Accounting or Sage 50, this report is your main source of truth for outstanding invoices.

Its main purpose is to present a clear, time-based breakdown of all the money owed to your business by your customers. When you run the report, you get a list of every customer with an outstanding balance, categorised by how long the debt has been overdue.

Key Information in the Aged Debtors Report

A typical Aged Debtors report will show you several columns of vital information:

• Customer Name: The name of the client who owes you money.
• Total Owed: The total outstanding balance for that customer.
• Aging Brackets: This is the most important part. The total owed is broken down into columns that typically look something like this:
  • Current: Invoices that have been issued but are not yet past their due date.
  • 0-30 Days: Invoices that are up to 30 days overdue.
  • 31-60 Days: Invoices between 31 and 60 days overdue.
  • 61-90 Days: Invoices between 61 and 90 days overdue.
  • 90+ Days: Invoices that are more than 90 days overdue.

This aging summary is incredibly useful for prioritisation. At a glance, you can see who your oldest debtors are and who owes you the most money. This allows you to decide where to focus your chasing efforts first—do you chase the largest single debt, or the oldest debts that pose the biggest risk of going unpaid?

Sage also provides other related reports, like a Customer Statement, which lists every invoice, credit note, and payment for a single client over a period. This is useful for sending a complete history to a customer who might be confused about their balance.

The key takeaway is that Sage gives you an excellent, accurate list of what is owed and by whom. It’s a diagnostic tool. It tells you the scale of your late payment problem. However, it provides no tools to help you fix it.

What Sage Reporting Misses: The Credit Control Workflow

The problem isn't what the Aged Debtors report shows; it's what it doesn't show and what it can't do. A static report is just a list. It's not a workflow, it's not a communication tool, and it's not a credit control system. Here are the critical gaps.

1. It Doesn’t Automate the Chasing

This is the single biggest limitation. The report tells you an invoice is 7 days overdue, but it doesn't send the first friendly reminder. It tells you an invoice is now 30 days overdue, but it doesn't send the firmer follow-up. It tells you a debt is 60 days old, but it doesn't help you draft a final notice or letter before action.

Every single action that follows from the information in the report must be performed manually by you or your team. Sage identifies the problem; you are left to do all the work.

2. There’s No Communication History

Your Aged Debtors report doesn't know if you've already chased an invoice. It has no record of the emails you've sent, the phone calls you've made, or the promises a customer gave you last Tuesday.

This means you need a second system to track your chasing activity. For many small businesses, this is:

• Your email outbox: Trying to remember who you've emailed by searching for their name.
• A spreadsheet: Manually updating a separate sheet with dates and notes every time you contact a client.
• Sticky notes: A chaotic but common method of jotting down "Chase Bob re: INV-123".
• Your memory: The least reliable system of all.

This separation of data (the what in Sage, the when and how in your head or a spreadsheet) is inefficient and prone to errors. It's easy to forget to chase someone, or to chase a customer who has already replied to say they've paid.

3. No Context on Disputes or Promises to Pay

If a customer emails you to say, "Sorry, we're disputing this charge, please hold," your Sage Aged Debtors report will continue to flag that invoice as overdue. There is no simple way within the report to mark an invoice as 'Disputed' or 'Promised to Pay on Friday' to pause reminders.

This lack of context means you risk chasing disputed invoices, which can damage client relationships. You might spend time drafting a firm reminder for a client who has already promised payment for a specific date, making your credit control process seem disorganised.

4. No Calculation of Late Payment Charges

Under the Late Payment of Commercial Debts (Interest) Act 1998, UK businesses are legally entitled to charge interest and fixed compensation on overdue B2B invoices. The interest is set at 8% plus the Bank of England's base rate.

Sage does not calculate this for you. If you decide to enforce your statutory right, you have to:

1. Look up the current Bank of England base rate.
2. Calculate the daily interest amount for the overdue invoice.
3. Multiply it by the number of days the invoice is late.
4. Add the correct fixed compensation sum (£40, £70, or £100 depending on the debt value).
5. Create a new invoice or update the existing one with these charges.

This is a manual, multi-step calculation that Sage's reporting doesn't assist with, yet it's a powerful tool in a credit controller's arsenal.

The Manual Chasing Routine Sage Leaves You With

If you use Sage for your accounting, this step-by-step routine will probably feel very familiar. It’s the weekly or monthly ritual of turning your Aged Debtors report into action.

Step 1: Generate the Report. You log in to Sage and run the Aged Debtors report as of today's date.

Step 2: Analyse and Prioritise. You scan the list, looking at the 30, 60, and 90+ day columns. You decide who to chase first based on the size and age of the debt.

Step 3: Open Your Email. You open Outlook, Gmail, or whatever email client you use. You now have two windows open: Sage and your email.

Step 4: Find the Contact. You look at the first customer on your list, then search your email contacts or CRM for their accounts payable address.

Step 5: Write the First Email. You start typing. "Hi Jane, Hope you're well. Just a friendly reminder that invoice INV-101 for £1,200 was due last week..." You try to strike the right tone—polite but clear.

Step 6: Attach the Invoice. You realise the client will probably ask for a copy of the invoice. You go back into Sage, find the specific invoice, download it as a PDF, and attach it to your email.

Step 7: Send and Record (Maybe). You hit send. Then, you either try to remember you've chased them or, if you're organised, you switch to your chasing spreadsheet and log the date, invoice number, and that you've sent 'Reminder 1'.

Step 8: Repeat. You move to the next name on your Aged Debtors list and repeat steps 4 through 7. And again. And again. For ten, twenty, or even fifty overdue invoices.

Step 9: Escalate Next Week. A week later, you run the report again. For everyone who still hasn't paid, you repeat the entire process, but this time you write a slightly firmer email ("Following up on my previous email...").

This process is a significant administrative burden. It’s repetitive, boring, and takes you away from running and growing your business.

The Problem in a Nutshell: Manual vs. Automated

The core issue is the gap between knowing there's a problem and doing something about it. A simple table illustrates the difference between the manual process Sage leaves you with and a dedicated, automated approach.

Task	Manual Chasing with Sage Reports	Automated Chasing
Identifying Debts	Run Aged Debtors report weekly/monthly.	System automatically checks Sage data daily.
Sending Reminders	Manually type and send individual emails.	Pre-written, scheduled emails are sent automatically.
Escalating Tone	Manually write a firmer email for the 2nd/3rd chase.	Automatically uses a different, firmer template for later reminders.
Attaching Invoices	Manually find and attach PDF of invoice to each email.	PDF invoice is automatically attached from Sage.
Tracking History	Relies on memory, email outbox, or a separate spreadsheet.	A full, time-stamped log of every reminder is kept automatically.
Pausing Chasing	Manually remove from your chase list; risk of error.	Can pause chasing for a specific invoice or client with one click.
Time Investment	Hours per week/month.	Minutes to set up, then runs in the background.

While Sage is an indispensable accounting platform, it was never designed to be a fully-fledged credit control solution. That’s why tools like InvoiceReminder exist. They connect directly to your Sage account, pull the data from your Aged Debtors list, and execute the entire chasing workflow for you, turning a static report into an automated action plan.

How to Bridge the Gaps Yourself

If you’re not ready for an automated tool, you can still improve your manual process.

1. Create Email Templates: Instead of re-writing reminders every time, create a set of templates for each stage of the chase: a friendly first reminder, a firmer follow-up, and a final notice threatening late payment charges.
2. Use a Tracking Spreadsheet: It's extra work, but a simple spreadsheet is better than nothing. Create columns for Customer Name, Invoice Number, Invoice Amount, Due Date, Date Chased 1, Date Chased 2, and Notes. Be disciplined about updating it.
3. Time Block Your Chasing: Dedicate a specific time slot to credit control each week (e.g., 9 AM every Tuesday). This consistency prevents overdue invoices from slipping through the cracks for weeks on end.
4. Reference the Law: When you get to the final reminder stage, don't be afraid to reference The Late Payment of Commercial Debts (Interest) Act 1998. Stating that you reserve the right to add statutory interest and compensation can often be enough to prompt immediate payment.

These manual improvements will make your process more robust, but they don't solve the core problem: it's still your time being spent on low-value, repetitive administrative work.

Take Control of Your Overdue Invoices

Sage provides the essential data you need to understand your debtors. But data alone doesn't get you paid. The reporting is the starting pistol, not the race itself. The real work—the chasing, the follow-ups, the escalations—is a manual, time-draining process that Sage's reports leave entirely in your hands. By recognising this gap, you can begin to implement better processes, whether manually or through automation, to finally get paid on time without spending hours doing it.

For businesses tired of this manual routine, services built to automate the process can be transformative. InvoiceReminder connects directly to Sage (as well as Xero, QuickBooks, and FreeAgent) to automate the entire invoice chasing sequence. It uses your Sage data to send scheduled reminders based on rules you define, from a gentle nudge to a final demand. The platform is built for UK small businesses and accountants who want to stop chasing invoices by hand. The Free plan currently includes unlimited email reminders at no cost. InvoiceReminder is built by the team behind WeCovr, a UK company authorised and regulated by the Financial Conduct Authority for its insurance activities.

Frequently asked questions

What is the best report in Sage for seeing who owes me money?

The best and most commonly used report is the Aged Debtors Report (sometimes called an Aged Receivables report). It provides a summary of every customer with an outstanding balance, broken down into time brackets like 30, 60, and 90+ days overdue, so you can easily prioritise who to chase.

Can Sage automatically send overdue invoice reminders?

No, Sage Business Cloud Accounting and Sage 50 do not have a built-in feature to automatically send chasing emails for overdue invoices. The platform's reports identify which invoices are late, but the entire process of contacting the customer, sending reminders, and following up must be done manually.

How do I calculate statutory late payment interest for a Sage invoice?

You must calculate it manually. The formula for UK B2B invoices is the overdue amount multiplied by the statutory interest rate (currently 8% + the Bank of England base rate), divided by 365, and then multiplied by the number of days the payment is late. You must also add the relevant fixed compensation sum (£40, £70, or £100). Sage does not perform this calculation for you.

Does Sage show me if a client has opened my chase email?

No. Because you send chase emails manually from your own email client (like Outlook or Gmail), Sage has no visibility into whether they have been sent, delivered, or opened. This tracking is a feature offered by dedicated invoice reminder software.

How often should I run my Aged Debtors report in Sage?

For effective credit control, you should run your Aged Debtors report at least once a week. This allows you to stay on top of newly overdue invoices and promptly follow up with customers who haven't paid after your previous reminders. Running it less frequently, such as monthly, allows debts to become older and harder to collect.

Can I customise the aging periods in my Sage Aged Debtors report?

Yes, in most versions of Sage, you can customise the aging brackets. While the default is often 30, 60, and 90 days, you can typically adjust these periods to better match your business's standard payment terms (e.g., 14, 28, and 42 days) in the report settings.