DEV Community: Gorky Smith

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

Gorky Smith — Sat, 19 Sep 2026 17:43:30 +0000

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

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

Free snippets + paid workbook

Free chase snippets: https://gajames.gumroad.com/l/tjrcyk
Soft landing: https://brewpage.app/public/ETRt1BQO0q
Full workbook £7: https://gajames.gumroad.com/l/euvsdf (I built/sell this — Gary James / gajames).

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

How freelancers handle scope creep politely (email cadence + boundaries)

Gorky Smith — Sat, 19 Sep 2026 17:00:34 +0000

Scope creep rarely arrives as a formal change request. It arrives as a Slack ping, a “quick thought”, or a late stakeholder who “just wants one more version”.

Left alone, those moments become unpaid evenings. Handled well, they become either a clear yes with a fee — or a polite no that keeps the relationship intact.

This is a how-to for organisation and communication. It is not legal, contractual, tax, or accounting advice. Your proposal and statement of work still govern what you can insist on. The aim here is a calm, repeatable process so you are not inventing wording under pressure.

Disclosure: I built and sell a small Scope Creep Reply Pack (£6) with fifteen copy-paste UK-tone emails (Gumroad). Below is the free method first — cadence, boundaries, and sample wording — so you can use it without buying anything. Soft links sit near the end.

What counts as scope creep

Treat something as a change when it moves any of these:

Deliverable — a new format, platform, page, or asset not in the agreed list
Effort — another revision round after the included ones are used
Timeline — same fee, tighter deadline
People — new reviewers whose feedback restarts the work
Access — post-handoff “tiny tweaks” after you closed the project

Clarifying a requirement inside what you already priced is normal. The line is when the ask adds real work you did not include.

A useful test: Would I have quoted differently if this had been in the brief? If yes, treat it as a change.

Spot it early — before the free work starts

Most freelancers lose money in the gap between “sure, I’ll have a look” and “Ive already done three hours.”

Habit that helps:

Acknowledge within one working day (warm, not defensive)
Name it as a possible change — not a favour you owe
Quote or decline before you schedule the work
Do not keep building extras while you wait for a yes on the quote

Log it simply: date, ask in one sentence, what you sent, outcome. You are not being difficult; you are being organised.

A polite email cadence (four beats)

Adjust to the relationship. A pattern that stays courteous without absorbing free work:

Beat	When	Purpose
1. Soft acknowledge	Same day or next working day	Confirm you heard them; keep in-scope work moving
2. Change quote	Within 1–2 working days	Fee, effort, timeline impact, includes / excludes
3. Pause (if needed)	If they want work started before agreeing	Protect your calendar until they decide
4. Close the loop	After yes / no / silence	Schedule, invoice, or politely park the extra

A tiny clarification may end at beat 1. A redesign of the deliverable needs 2 and sometimes 3.

Beat 1 acknowledge without promising free labour

Subject: Re: [Project] — happy to look at this as a change

Hi [Name], Thanks for sending this through — I can see why you’d want [short ask]. To keep [Project] on track with what we agreed, I’ll treat this as a change request and send a short note on fee and timeline so you can decide before I start that work. Everything already in scope continues as planned.

Warm. Clear. No apology for having a scope.

Beat 2 — the change quote

Subject: Change quote for [short ask] — [Project]

Hi [Name], Happy to take this on. Quote before I start: ask [one sentence]; effort — [hours]; fee — £amount; timeline [e.g. +3 working days]; includes / does not include [one line each]. Reply “agreed” and I’ll schedule it. Until then I’ll keep focus on the agreed deliverables.

Commercial language is not rude. Vague “we’ll sort something later” is how freelancers donate weekends.

Beat 3 — pause until agreed

Subject: Pausing the extra work on [Project] until we confirm

Hi [Name], I’m keen to help with [ask]. To avoid muddling the current delivery, I’ll hold the extra work until the change quote is agreed. Happy to jump on it as soon as you confirm — original scope stays on the timeline we set.

You are not refusing help. You are refusing unpaid ambiguity.

Beat 4 — fee pushback

Stay factual. Offer options: smaller scope, later phase, or decline if it does not fit capacity. Only discount on purpose — and write it down so it does not become a habit.

Boundaries that reduce friction

Organisational habits, not legal rules:

Write exclusions once — “Does not include…” in the proposal beats arguing later.
Name a feedback owner — one consolidated note beats six stakeholders in a thread.
Cap revision rounds — then price the next round.
Protect discovery — “quick calls” that redesign the brief get summarised as a change afterwards.
Close handoff cleanly — post-delivery tweaks are a mini-quote or retainer, not infinite free polish.
Bundle small extras — five “tiny” asks become one change quote.

Avoid long apologies for having a fee, silent free work, and threats you will not follow through on. Everyday creep usually responds better to calm structure than heat.

Free method first — then optional tools

You can run this cadence with a notes app and your sent folder. Templates only remove the blank-page moment.

Freebie (Brewpage): UK-tone freelance ops snippets and a soft landing for the toolkit:

→ https://brewpage.app/public/ETRt1BQO0q

Guides hub:

→ https://brewpage.app/public/WWAqpLKhQJ/

Paid (£6) — Scope Creep Reply Pack: fifteen situation-matched emails (extra revisions, late stakeholders, tighter deadlines, retainer overflow, post-handoff tweaks, firm decline, and more) in Markdown, Word, and plain text:

→ https://gajames.gumroad.com/l/xmrnt

Week-1 ops bundle (£19): several freelancer ops starters together:

→ https://gajames.gumroad.com/l/week-1-ops-starter-bundle

Coupon: Through 26 Sep (Europe/London), code WEEK1 takes 20% off the tracker and the Week-1 bundle. Ignore paid links if your own wording already works.

Ownership disclosure: I am the seller (Gary James / these Gumroad and Brewpage listings). Organisational / communication templates only — same limits as this article. No guarantees about client behaviour or income.

Honest ask

When a client asks for “just one more thing”, which part trips you up most — naming it as a change, quoting the fee, or pausing until they agree? I read replies and tighten the pack from real friction.

Communication and organisational templates only. Not legal, tax, accounting, or financial advice. Not a substitute for your proposal, SOW, or professional advice. You remain responsible for what you send, agree, and invoice.

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

Gorky Smith — Sat, 19 Sep 2026 14:39:40 +0000

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

Late invoices are rarely dramatic on day one. They become painful when you cannot answer three simple questions:

Who still owes me?
When did I last chase them?
What is the next polite step?

You do not need accounting software for that. A plain spreadsheet - Excel or Google Sheets - is enough if the columns are deliberate and you actually log every follow-up.

This is a how-to for organisation. It is not tax, VAT, CIS, bookkeeping, or legal advice. Check GOV.UK and a qualified professional for your own compliance. Late-payment rights depend on your contracts and the law that applies to you.

Disclosure: I built and sell a small GBP7 Invoice & Chase Tracker workbook based on this setup (Gumroad listing). Below I explain the free method first so you can copy it yourself. There is also a free chase-email freebie (Gumroad freebie) at the end.

The minimum viable invoice log

Create a sheet called Invoices with one row per invoice. Keep status values consistent so formulas work.

Column	Why it matters
Invoice number	Your reference in every chase email
Client	Who to contact
Project / description	Context in one glance
Issued date	When the clock started
Due date	When a chase is on time vs late
Amount (GBP)	Outstanding maths
Status	`Draft` / `Sent` / `Due` / `Overdue` / `Paid`
Paid date	Optional; helps average days to pay later
Notes	PO numbers, accounts-email, quirks

Status discipline: do not invent spellings (over due, paid). Pick five words and stick to them. Dashboard counts with COUNTIF / SUMIF depend on exact matches.

A tiny Dashboard that earns its keep

On a Dashboard sheet, surface only what changes behaviour:

Total outstanding (SUMIF where status is not Paid)
Overdue count (COUNTIF status = Overdue)
Paid this month (optional SUMIFS on paid date)
Breakdown by status

If a metric does not change what you do on Monday morning, skip it.

The chase log (the part most freelancers skip)

Create a second sheet: Chase Log.

Column	Example
Date	2026-09-19
Invoice number	INV-1042
Channel	Email / Call / LinkedIn
Outcome	No reply / Promised Friday / Sent to accounts
Next chase date	2026-09-24
Notes	Asked if PO was raised

Logging chases does two useful things:

Stops you from remembering you chased when you only thought about it.
Gives you a calm paper trail if you later need to escalate under your contract.

You are not being aggressive by writing things down. You are being organised.

A UK-friendly chase cadence (polite, factual)

Adjust to your contract and relationship. A pattern that works for many solo freelancers:

When	Action	Tone
Same day as delivery	Send the invoice	Clear amount, due date, how to pay
On the due date	Gentle nudge	Just checking it arrived / anything else needed?
+3-5 working days	Second follow-up	Ask for an expected payment date
+3-5 working days	Third follow-up	Still courteous; confirm it is in a payment run
After a clear trail	Final reminder before next steps	Factual; invite them to raise any query

Stay polite. Escalate only after a documented trail. Do not threaten what you are not prepared to do. This article does not advise on statutory interest, Late Payment legislation, or debt recovery - get proper advice if a dispute continues.

Email wording that does not sound like a threat

Keep subject lines boring and searchable: include the invoice number.

Friendly first nudge

Subject: Quick follow-up on my invoice

Hi [Name], I hope youre well. I just wanted to gently follow up on invoice [number] for [project], which was due on [date]. Please let me know if you need me to resend it or if there is anything else you need from me.

Checking it reached accounts

Subject: Invoice [number] - received safely?

Hi [Name], Im checking that invoice [number] for [amount] reached you and the right person in your accounts team. It was due on [date]. Would you mind confirming when you have a moment?

Clear payment-date request

Subject: Payment date for invoice [number]

Hi [Name], A quick follow-up on invoice [number] for [amount], now [n] days overdue. Could you please let me know the expected payment date? Im happy to answer any questions about the work or paperwork.

Copy these into a Rates & Terms tab in your workbook so you are not rewriting from scratch every time.

Spreadsheet hygiene tips

Invoice the same day you deliver - fewer gaps.
Freeze the header row - you will scroll.
Mark sample rows EXAMPLE - so an empty-looking file is not confusing if you share a template.
One chase row per touch - never overwrite the previous note.
Review outstanding every Monday - ten minutes beats end-of-month panic.

Excel vs Google Sheets

Excel / LibreOffice: open the .xlsx directly.
Google Sheets: File -> Import -> Upload, or upload via Drive then open with Sheets. Re-check data validation on the Status column after import.

No macros required for the core setup.

What this system deliberately does not do

Calculate your VAT return or CIS
Replace your accountant
Guarantee faster payment
Act as a legally binding debt process

It only makes unpaid work visible and your follow-ups consistent.

Freebie + paid workbook (ownership disclosed)

Free: Five UK-tone chase email snippets you can copy:

https://gajames.gumroad.com/l/tjrcyk

The in-article wording above is enough to start; the freebie pack is the same tone in one download.

Paid (GBP7): If you would rather not build the sheets from scratch, I sell Invoice & Chase Tracker - an Excel workbook that also imports to Google Sheets, with Dashboard, Invoices, Chase Log, Rates & Terms, and setup README:

https://gajames.gumroad.com/l/euvsdf

For a quick overview of the approach, see the landing page.

Ownership disclosure: I am the seller (Gary James / these Gumroad listings). Both the freebie and the GBP7 workbook are organisational templates only - same limits as everything above. No income claims, no get paid faster guaranteed promises.

If you already have a system that works, ignore the product link and keep your process.

Honest ask

If you chase late invoices: what column or workflow step is still missing for you day-to-day? I read replies and improve the workbook from real friction - not from marketing adjectives.

Templates and trackers for personal organisation only. Not accounting, tax, legal, or financial advice. You remain responsible for your own invoices, contracts, and compliance.

More guides: https://brewpage.app/public/WWAqpLKhQJ

For a broader first-week workflow, see the Week-1 Ops Starter Bundle (£19): https://gajames.gumroad.com/l/week-1-ops-starter-bundle/

Week 1 offer: Use code WEEK1 for 20% off the £7 Invoice & Chase Tracker or £19 Week-1 Ops Starter Bundle, through 26 September.