How to Build an Invoice Tracking Spreadsheet That Actually Gets Used

The most common mistake when building this spreadsheet: adding too many columns on day one. A Status column, a VAT column, a Retainer Type column, a Client Category column — and within two weeks you're spending more time maintaining the spreadsheet than chasing invoices. Start with the minimum viable set and add columns only when you feel the gap. Google Sheets is the most practical free choice for this — accessible from any device, shareable, and supports all the formulas below.

Essential columns (include from day one):

Optional columns (add when needed):

• PO Number — required by many corporate clients
• Payment Method — bank transfer / card / PayPal
• Invoice Type — retainer / project / hourly
• AP Contact — who to email for payment queries
• Last Chased — date of most recent reminder
• Amount Paid — for partial payments

Without these, you have a static list of invoices — useful for reference, useless for action. These three formulas are what make the spreadsheet update itself daily so you can open it Monday morning and immediately see what needs chasing, without doing any manual calculations.

Conditional formatting is the difference between “spreadsheet you open, scan, and act on” and “spreadsheet you open, feel overwhelmed by, and close.” Without it, you read every row individually. With it, the red and amber rows pull your attention directly to the problems. Set up three rules — in this exact order, since Excel and Google Sheets apply them top-down:

Rule 1 — Overdue (any)

Fill: light orange / amber. Applies to any unpaid invoice past its due date.

Rule 2 — Seriously overdue (30+ days)

Fill: red. High priority — needs immediate action.

Rule 3 — Due within 3 days

Fill: yellow. Pre-due reminder opportunity — send a heads-up before it goes overdue.

In Excel: Home → Conditional Formatting → New Rule → Use a formula. In Google Sheets: Format → Conditional Formatting → Custom formula. Apply rules to the entire row by using mixed references (e.g. $D2 instead of D2) for the date column but relative references for the row.

A Notes column starts out looking fine: “Chased 12 Feb.” Then a second follow-up: “Chased 12 Feb. Chased 19 Feb — no reply.” Then a third. Then a fourth. Within six weeks you have a sprawling wall of text in a single cell and no idea what you actually said in each message or what the client's response was. The fix: a second tab called “Chase Log” with one row per contact attempt.

Each time you send a reminder or make contact, add a row. This gives you a complete timeline per invoice — essential when following up multiple times, and critical evidence if you ever need to escalate to formal action. See: unpaid invoice small claims court.

The spreadsheet isn't broken — it just wasn't designed for active AR management. Here are the specific pain points that reliably appear once you have more than 10–15 open invoices at a time:

• No automatic alerts. The spreadsheet doesn't know you exist until you open it. An invoice that went overdue on a busy Tuesday gets spotted the following Monday, now 7 days cold. One week of silence is often enough for a client to deprioritise payment entirely.
• No today-view. You can't open the spreadsheet and immediately see “here are the three invoices that need action right now.” You see 40 rows and have to reconstruct the picture yourself every time.
• Chase log disconnected from invoices. Even with a well-built Chase Log tab, you have to manually look up which log entries belong to which invoice before every follow-up. You're doing relational database work by hand.
• No reminder drafting. Every follow-up email starts from scratch, or from a vague template you saved somewhere else. The 10-minute friction of writing a good reminder is why invoices go chased once and then forgotten.
• Multi-person access problems. A shared spreadsheet means two people can overwrite each other's chase notes simultaneously. Version history exists but rarely gets checked.

In practice, the spreadsheet works reliably for solo freelancers with 3–5 active clients. It starts creating problems for anyone managing 15+ open invoices across 8+ clients. For a full breakdown: Excel invoice tracking problems — where it breaks down.

The spreadsheet doesn't fail dramatically — it fails gradually. You stop updating it as diligently. You forget to add a new invoice. You miss a follow-up. An invoice goes 45 days overdue because you were busy and the spreadsheet didn't remind you. Watch for these specific signals:

• You've discovered an invoice was overdue by weeks — not because you checked, but because the client mentioned it or you happened to scan the spreadsheet
• You regularly have 15+ open invoices and genuinely can't tell which ones need action today without filtering and sorting
• You're writing follow-up emails from scratch because you can't quickly pull up what you wrote last time or what the client said
• Updating the spreadsheet has started taking longer than the actual chasing — adding rows, updating statuses, cross-referencing the chase log
• Someone else in your business needs visibility into invoice status and your solution is a shared sheet with frequent version confusion

The cost of a dedicated tracker ($12–15/month) is recovered in the first invoice it catches that would have otherwise slipped past 45 days — the point at which collection rates drop sharply. Best Way to Track Invoices in 2026 covers all the options. For the InvoiceGrid tracker specifically, see the pricing page.