How to Track Customer Debts: A Complete Guide

Forgotten customer debts are one of the quietest ways a growing business loses money. They almost never show up as a single bad day — they leak out over months: a £40 unpaid here, a £120 unpaid there, three customers you cannot quite remember. By the end of a year, it can easily add up to thousands.

This guide shows you how to track customer debts properly: why they get forgotten, what to record, when to chase, how to chase politely, and which tools actually help. If you would rather skip the homework, Tallyn includes a built-in debt tracker that does most of this automatically.

Why customer debts get forgotten

• The sale and the payment are separate events. You remember selling. You forget that the payment never arrived.
• Reminders live in WhatsApp. WhatsApp is great for messaging and terrible for tracking. Conversations scroll out of view and the unpaid sale goes with them.
• You trust the customer. Most customers do mean to pay. Most of those forget unless reminded.
• The amount feels too small to chase. Small amounts add up. £40 forgotten 25 times a year is £1,000.

The fix is not better memory. It is a system that remembers for you.

What to record for every credit sale

A working debt ledger needs five pieces of information for every unpaid or partially paid sale:

1. Who owes — customer name and a contact (phone or email).
2. How much — total owed, in your currency.
3. What it is for — the products or services sold.
4. When the sale happened — so you can age the debt.
5. Agreed payment terms— “by Friday”, “next month”, “on payday”.

Most growing businesses capture #1 and #2 in their head and miss the rest. That is exactly why debts pile up — without #4 you cannot sort by oldest, and without #5 you have no honest way to chase.

Building a simple debt ledger

At its simplest, a debt ledger is a list of unpaid sales. The question is where to keep it. There are three options.

Notebook

Cheap and immediate. Awful at sorting and ageing. Easy to lose. Use only as a temporary backup, never as the source of truth.

Spreadsheet

Better. A simple sheet with columns for customer, sale date, amount, due date, status and last reminder date can carry you for a while. The catch: every entry is manual, and the sheet has to be kept in sync with your actual sales — which most people do not do.

A sales tracker with a built-in debt ledger

The cleanest option. The moment you record an unpaid sale, the debt appears against the customer automatically. No copy-paste, no separate sheet. Tallyn’s debt ledger sorts customers from biggest debt to smallest and shows how long each one has been outstanding, so the worst offenders surface first.

When to chase

A reasonable cadence for most growing businesses:

• Day 0:Confirm the unpaid sale at point of sale, out loud — “just to confirm, that is £85.50 to settle by Friday.” Customers honour what they have heard themselves say.
• Day 7: Friendly reminder. WhatsApp or email is fine. Lead with the balance, not the lateness.
• Day 14: Firmer reminder. Restate the original terms.
• Day 30: Phone call. Always works better than a text.
• Day 60+: Pause future credit until the balance is settled. This is not punishment — it is policy.

How to chase politely (with templates)

The goal is the customer settling, not feeling guilty. Three rules:

• Lead with the balance. Make the number impossible to miss.
• Make paying easy. Include a payment option in the message.
• Stay short. Long messages feel like accusations.

Day 7 (friendly)

Hi Sarah, just a friendly reminder you have an outstanding balance of £85.50. You can settle by bank transfer to the usual account. Thanks!

Day 14 (firmer)

Hi Sarah, your balance of £85.50 is now two weeks old. Could you settle by Friday? Happy to take a partial payment if that is easier.

Day 30 (phone, no script)

Calls beat texts at 30 days. Keep it human. Reference the original agreement, ask how they would like to settle, and pick a date together.

Bulk reminders save real time

If you sell on credit at any volume, sending reminders one by one is the bottleneck. The fix is a tool that lets you send them in bulk. Tallyn lets you say “remind everyone who owes over 100” and writes individual messages for each customer with their balance — sent on WhatsApp or email.

Prevention beats collection

Debt collection is mostly hygiene. The biggest wins come from preventing bad debt in the first place:

• Set a credit limit per customer. Stop selling on credit once the limit is hit until something is paid.
• Move large credit customers to part-payment up front.
• Confirm the next pay date out loud at the time of sale.
• Review the debt ledger weekly, not yearly. Old debt is lost debt.

The customers who pay late are usually the same customers, every time. Once you have a real debt ledger, the pattern becomes obvious — and so do the policy changes that fix it.

In short

Forgotten debts are a system problem, not a memory problem. Build a debt ledger, record every unpaid sale, sort by age, chase politely on a fixed cadence, and use bulk reminders once you have more than a handful of credit customers. If you want all of that in one tool that updates the moment you make a sale, try Tallyn free.

Related reading: how to track sales, how to send professional invoices.

Frequently asked questions