Use the Aged Debtors report in Sage Accounting UK

Run Aged Debtors as of the date you need, then open the detailed report to see what makes up each balance. Check unallocated receipts and credit notes before treating a balance as the amount to chase.
Upload a case

Key facts

Example. An invoice that was open on 31 October can appear on a report dated 31 October even if you received and allocated payment in November.

Run the report at the right cutoff

From Reports, open Aged Debtors. Enter the date you want the report to cover. For a collections review, sorting by outstanding amount brings the largest balances to the top. Select Calculate and switch to the detailed view.

Check transactions behind each balance

Identify the invoices, credits and unallocated sales transactions behind the total. When the report differs from the customer record, start by comparing the report date with the dates of the entries and allocations. Keep a historical report and a current report separately labelled.

Decide who to contact first

Use the detail export to record invoice references, current open amounts and dispute or payment holds. Confirm payments posted since the cutoff before assigning the next follow-up.

Sources and related guidance. Sage’s Aged Debtors guide · Sage’s guidance on balance differences · Debitura's accounts receivable guide.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.