Freelance invoice reminder schedule in Excel

A reminder schedule is a simple Excel calendar for unpaid invoices — Day 0 send, Day 1–3 polite check, Day 7 firm reminder, Day 14 escalate, Day 30 pause work — so you never wonder “should I nudge them today?” Yellowcell’s free invoice sample gives you a clean sendable invoice; the paid invoice kit adds expense and mileage companions when you want the full set.

What a reminder log should capture

Invoice # — unique id you quote in every follow-up
Client — who pays (one row per open invoice)
Due date — Net 15 / Net 30 / custom
Last touch — date of last email, call, or portal note
Next reminder date — when the schedule says to act again
Status — sent, polite check, firm, escalated, paused, paid

If a row cannot answer “what do I send next, and on which day?”, it is not a reminder row yet.

Day-by-day schedule freelancers actually use

Day 0 — send the invoice (PDF + payment link); log send date
Day 1–3 — polite check-in if no open/read signal; re-attach PDF once
Day 7 — firm reminder: invoice #, amount due, original due date
Day 14 — escalate to AP contact / PO owner; note contract terms
Day 30 — pause new work (if the contract allows); decide payment plan or next step

Count days from due date for overdue nudges, or from send date for soft “did you get this?” checks before due — pick one rule and stick to it on every row.

Simple Excel layout (yellow in, gray helpers)

Column	Example
Yellow — invoice #	YC-1042
Yellow — client	Acme Studio
Yellow — due date	2026-08-14
Yellow — last touch	2026-08-21 (Day 7 reminder)
Yellow — next reminder date	2026-08-28
Yellow — status	Firm reminder sent
Gray — days past due	=TODAY()-due date (when open)
Gray — schedule stage	Day 0 / 1–3 / 7 / 14 / 30

Filter Open and sort by Next reminder date ascending so today’s nudges sit at the top of a 10-minute morning pass.

Weekly 10-minute collections ritual

Filter rows where Next reminder date ≤ today
Send one message per overdue client (not five to the same inbox)
Update Last touch and bump Next reminder date to the next stage
When payment clears, flip status to Paid and archive

Common mistakes

Nudging every day — burns goodwill and gets filtered as spam
Reminder emails with no invoice #, amount, or due date
Skipping Day 14 escalation and jumping straight to angry Day 30 notes
Leaving paid rows in the open view until the schedule feels noisy

Free invoice sample Invoice kit $19 All free downloads

Pair with billing tools

Invoice aging guide — bucket open balances by how late they are
Late-fee / billable hours guides — structure the next send so reminders stay rare
Money Kit ($29) — invoice, budget, and debt sheets when you want the paid set

Educational templates for record-keeping only — not tax, legal, or accounting advice.