How to Track Unpaid Invoices: A Simple Follow-Up System
Most unpaid invoices aren't disputes — they're disorganization. Yours or the client's. A simple tracking system plus a fixed follow-up schedule recovers the vast majority of late payments without awkwardness or aggression. Here's the complete setup, from spreadsheet to escalation.
Step 1: Build your invoice tracker
You don't need software to start. A spreadsheet with these columns handles everything:
- Invoice number and client name
- Amount and currency
- Issue date and due date
- Status: Sent / Viewed / Paid / Overdue / Disputed / Written off
- Days overdue (formula: today minus due date)
- Last follow-up date and next follow-up date
- Notes (e.g., "client asked to split into two payments")
Review it every Monday morning. Ten minutes, same time, every week — that's the entire discipline. Invoices you don't look at don't get paid.
Step 2: Follow the escalation schedule
Same sequence, every invoice, every client. Consistency removes the emotional weight:
- 3 days before due date — courtesy heads-up. "Hi [Name], just a quick note that invoice INV-0042 ($2,300) is due on Friday. Payment details are attached. Let me know if you need anything!" This single email prevents a huge share of late payments.
- Day 1 overdue — friendly nudge. "Hi [Name], checking in — invoice INV-0042 was due yesterday. It may have just slipped through; here's the payment link again."
- Day 7 overdue — direct. Restate the amount, original due date, and payment details. Ask directly: "Is there an issue with this invoice I should know about?" This question matters — it surfaces real problems (wrong approver, missing PO) versus simple delay.
- Day 14 overdue — formal. Reference your payment terms and late-fee clause. Set a specific deadline: "Please arrange payment by [date]. Per our agreed terms, a 1.5% monthly late fee applies to overdue balances."
- Day 30 overdue — final notice. State plainly that you'll pause further work and consider next steps (collections, small claims) if unpaid by [date]. Keep it professional — this letter may be read by a judge someday.
Send every follow-up as a new email with the invoice re-attached, not a reply buried in an old thread. Make paying effortless at every touchpoint.
Step 3: Handle the tricky cases
- "We never received it": resend immediately with read receipt if possible, and confirm the correct billing contact. Then note the correct contact in your tracker so it never happens again.
- "It's with accounting": ask for the accounting contact's name and email, then follow up with them directly. "With accounting" without a name is often a polite stall.
- Partial payment offered: accept it in writing, document the remaining balance and a date for the rest. A partial payment is a good sign, not a resolution — keep the schedule running on the balance.
- Genuine dispute: pause the escalation clock, address the substance fast, and issue a credit note if you owe an adjustment. Disputes resolved quickly preserve relationships; disputed invoices left to rot destroy them.
- Client gone silent: after the day-30 notice, a phone call beats a fifth email. If that fails, weigh the amount against collection costs — sometimes a formal demand letter from a lawyer (often a few hundred dollars) recovers thousands.
Step 4: Measure what matters
Once a month, compute three numbers from your tracker:
- Average days to payment: from issue date to paid date. Trending down means your system works.
- Overdue rate: percentage of invoices that go past due. Above 30% means your terms or client screening need work.
- Aging buckets: how much money sits in 1–30, 31–60, and 60+ days overdue. Money in the 60+ bucket needs personal attention, not another template email.
These numbers also tell you which clients deserve better terms (always on time) and which need deposits upfront (always in the 60+ bucket). See our small business invoicing guide for adjusting terms per client.
Preventing late payment beats chasing it
The best follow-up system is one you rarely need:
- Invoice within 24 hours of delivery — the payment clock starts at receipt.
- Always include a due date and crystal-clear payment instructions.
- Offer multiple payment methods; friction delays payment more than unwillingness.
- Require deposits from new clients (see invoicing for deposits).
- Send the pre-due-date heads-up — it's the highest-ROI email you'll ever write.
Key takeaways
- Track every invoice in a simple spreadsheet; review it weekly without fail.
- Follow a fixed escalation: pre-due reminder, day 1, day 7, day 14, day 30.
- Re-attach the invoice with every follow-up and keep payment one click away.
- Distinguish disputes from delays — pause the clock for real problems, not excuses.
- Measure days-to-payment and overdue rates monthly; adjust terms per client.