How to Track Outstanding Receivables in the UK

To track outstanding receivables in the UK, start by creating a clear, up-to-date record of all unpaid invoices. Include customer names, invoice numbers, issue dates, amounts owed, and due dates. This helps you follow up on late payments and manage your cash flow effectively.

Why this comes up / what goes wrong

Small business owners often struggle with tracking outstanding receivables because sales are made on credit but follow-up is inconsistent or disorganised. Without a proper system, invoices can be forgotten, payments delayed, and cash flow disrupted. Many UK businesses rely on spreadsheets, emails, or WhatsApp messages, which can lead to missed payments or disputes over amounts and due dates.

Step-by-step

1. Gather all invoice data: Collect every invoice issued that has not been paid yet. Include invoice number, customer name, invoice date, amount, and payment terms.

1. Create or update your receivables ledger: Use a spreadsheet, accounting software, or a CRM to list these invoices. Each entry should have columns for invoice number, customer, issue date, due date, amount, and status (e.g., unpaid, partially paid).

1. Calculate due dates: Based on your payment terms (e.g., 30 days), calculate the due date for each invoice. Confirm these dates against your contracts or sales agreements.

1. Sort by due date and amount: Organise the list so the oldest or largest outstanding invoices appear first. This prioritises follow-up actions.

1. Monitor ageing of receivables: Track how long each invoice has been outstanding (e.g., 0-30 days, 31-60 days, over 60 days). This helps identify overdue payments.

1. Follow up systematically: Contact customers ahead of due dates with polite reminders. After the due date, escalate follow-ups with calls or emails. Document all communications.

1. Update statuses regularly: Mark invoices as paid, partially paid, disputed, or written off as appropriate.

1. Review regularly: Weekly or monthly, review your receivables ledger to spot trends or problem accounts.

1. Reconcile with your accounting records: Ensure your receivables ledger matches your accounting system to avoid errors.

1. Use CRM tools if possible: A CRM with integrated communication (like WhatsApp and SMS) and task reminders can improve follow-up efficiency and record keeping. See WhatsApp and SMS CRM and the built-in CRM dialer for options.

Example (fictional figures)

A kitchen-fitting company in Leeds issued three invoices:

• Invoice 101 to Customer A on 01/04/2024 for £3,500, payment terms 30 days
• Invoice 102 to Customer B on 15/03/2024 for £4,200, payment terms 30 days
• Invoice 103 to Customer C on 20/02/2024 for £2,800, payment terms 45 days

Calculate due dates:

• Invoice 101: 01/04/2024 + 30 days = 01/05/2024
• Invoice 102: 15/03/2024 + 30 days = 14/04/2024
• Invoice 103: 20/02/2024 + 45 days = 06/04/2024

Today is 10/04/2024. Status check:

• Invoice 101: Due in 21 days (01/05/2024) – Not yet due
• Invoice 102: Due 10/04/2024, today – Due today
• Invoice 103: Due 06/04/2024, overdue by 4 days

Outstanding amounts sorted by due date:

1. Invoice 103: £2,800 (overdue)
2. Invoice 102: £4,200 (due today)
3. Invoice 101: £3,500 (due in 21 days)

Follow-up priority:

• Contact Customer C immediately about Invoice 103
• Remind Customer B about Invoice 102
• Schedule reminder for Customer A closer to due date

Common mistakes

• Not updating the receivables list regularly: Prevent by scheduling weekly updates.
• Ignoring payment terms or due dates: Always calculate and record due dates accurately.
• Failing to follow up promptly: Set reminders and use systematic communication.
• Mixing personal and business communications: Use a dedicated CRM or system to keep track, not just WhatsApp or email threads.
• Not reconciling with accounting records: Regularly cross-check your receivables ledger to avoid errors.
• Overlooking disputed invoices: Document disputes clearly and follow up to resolve them.

Frequently asked questions

How often should I update my outstanding receivables list? Update your receivables ledger at least once a week to keep track of new invoices, payments received, and overdue amounts. Regular updates help you spot issues early.

Can I track receivables using WhatsApp or email? You can, but it is easy to lose track or miss follow-ups. Using a CRM that integrates WhatsApp and email communications can centralise your records and automate reminders. Learn more about WhatsApp and SMS CRM.

What is the best way to prioritise follow-ups? Sort outstanding invoices by due date and amount owed. Prioritise contacting customers with the oldest and largest unpaid invoices first.

How do I handle disputed invoices? Record the dispute details in your receivables list and communicate clearly with the customer to resolve the issue. Keep notes of all correspondence.

Should I reconcile my receivables with my accounting software? Yes, regular reconciliation ensures your records match your financial reports and helps prevent errors or fraud. Consider using tools with built-in reconciliation features.

Can a CRM help with tracking receivables? A CRM with integrated communication and task management can improve your tracking and follow-up efficiency. See features like the built-in CRM dialer for calling customers directly from your system.

Key takeaways

• Create and update a detailed receivables ledger with invoice and customer details.
• Calculate and track invoice due dates based on payment terms.
• Prioritise follow-ups by due date and amount owed.
• Use systematic reminders and document all communications.
• Reconcile your receivables with accounting records regularly.
• Consider CRM tools to centralise communication and task management.

Tracking outstanding receivables is essential for maintaining healthy cash flow and business stability. To get started today, consider using a CRM system that supports your communication and follow-up needs. You can Start on the Free Forever plan (200 leads, no credit card) to organise your leads and sales pipeline efficiently.

For UK businesses, tools like HelloGrowthCRM for the United Kingdom offer integrated WhatsApp and SMS communication to help you stay on top of your receivables and customer follow-ups.