← All prebuilt solutions
Bookkeeping & Compliance

Credit Control Tracker

Get paid on time – know who owes what, who to chase and what to say

£20

Secure checkout. Your download link is sent as soon as payment clears.

Credit Control Tracker

Overview

Late payment is one of the biggest causes of cash flow problems for small businesses. This workbook brings everything about the money you're owed into one place: customers with credit limits and terms, every invoice and payment, an aged debtors report, a chase log, a daily action list with the recommended next step for every overdue invoice, statutory late payment interest, printable statements and chase letters, and a dashboard showing debtor days and the cash you can expect.

Price
£20
Who it’s for
Bookkeeping & Compliance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Invoices

Every invoice with its due date, payments, balance, ageing, status, last chase and recommended next step. What you do: enter the yellow columns.

Invoices
Payments

Step 2

Payments

Money received, matched to invoices. What you do: add a row for each payment.

Step 3

Chase Log

Every reminder, call, statement and letter, with the outcome and next action date. What you do: add a row each time you chase.

Chase Log
Aged Debtors

Step 4

Aged Debtors

Each customer's debt by age, largest first, with limit, risk, last payment, last contact and next step. What you do: nothing to enter.

Who it is for

Made for people like you

  • Example – text
  • Service businesses invoicing monthly – A clear view of who is late and a consistent, polite-then-firm chasing process.
  • Credit controllers and bookkeepers – A daily action list, a full chase history and letters that fill themselves in.
  • Owners and managers – One dashboard: total owed, overdue %, debtor days, cash expected and the top debtors.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business details (they print on statements and letters), bank details, default credit terms and the report date. Check the late payment rates, chasing steps and letter wording.
  2. Customers – Add each customer with a credit limit, payment terms (blank = your default), a risk rating and whether they're a business (statutory interest applies) or a consumer.
  3. Invoices – Enter every unpaid invoice – and ideally the last few months of paid ones too, so the payment history means something. Amounts include VAT.
  4. Payments – Record each payment against the invoice number it pays. Money you can't match yet goes in as 'on account' against the customer.
  5. Work the Action List – Each morning, open the Action List: anything not marked 'Wait' or 'Promised' needs doing today. Record what you did on the Chase Log.
  6. Send statements and letters – Pick a customer on the Statement or Letters sheet and print – everything fills in automatically.

Key features

  • Customers with credit limits, terms and risk ratings; invoices and payments (including part payments and money on account) with balances, ageing and status.
  • Aged debtors by customer (Current, 1–30, 31–60, 61–90, 90+), credit limit checks and a daily action list with the recommended next step for every overdue invoice.
  • Chase log of reminders, calls, statements and letters; statutory late payment interest and compensation under the Late Payment of Commercial Debts Act.
  • Printable customer statements and chase letters (polite reminder, firm reminder, final demand) from your own wording, plus a dashboard with debtor days and cash expected.

What’s included

  • Dashboard – Debt at a glance
  • Settings – Your details, rules and letter wording
  • Customers – Limits, terms and payment record
  • Invoices – Every invoice and its status
  • Payments – Money received
  • Chase Log – Every chase and its outcome
  • Aged Debtors – Who owes what, by age
  • Action List – What to do today
  • Interest – Late payment interest calculator
  • Statement – Printable customer statement
  • Letters – Printable chase letters
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions