DEV Community

Gorky Smith
Gorky Smith

Posted on

How I track overdue freelance invoices in a spreadsheet (UK-friendly chase cadence)

How I track overdue freelance invoices in a spreadsheet (UK-friendly chase cadence)

Disclosure: I built and sell a £7 Google Sheets / Excel workbook with these tabs pre-built (Invoice & Chase Tracker). This post is the free method — organisational tips only, not tax or legal advice.

Two-tab setup

Invoices: client, invoice #, issued/due dates, amount, status (Draft/Sent/Part-paid/Paid/Overdue), last/next chase, notes.

Chase log: date, invoice #, channel, outcome, next chase.

Filter Overdue + sort by next chase — that is the daily list.

Simple cadence

  1. Due date: polite reminder with payment details.
  2. +7 days: ask what is blocking payment.
  3. +14 days: firmer note; pause new work if that is your policy.
  4. +21–30 days: final written chase, then your own escalation / GOV.UK late payment guidance.

Free snippets + paid workbook

Organisational template only. Not tax, legal, or debt-recovery advice.

Top comments (0)