How to Track Freelance Invoices and Outstanding Payments in a Spreadsheet

The freelance cash-flow problem is not always low income — it is money you earned that sits in someone else’s account. A free freelance invoice tracker spreadsheet answers two questions every month: who hasn’t paid, and how much of what arrived should stay untouched for taxes.

Log every invoice, not every bank deposit

One row per invoice:

1. Client
2. Invoice number and date
3. Amount billed
4. Due date
5. Status — sent, paid, overdue
6. Amount received — when payment lands

The sheet totals billed, paid, and outstanding automatically. Conditional formatting flags overdue rows so you chase the right client on Monday morning, not after you’ve forgotten who owes what.

Set aside tax when payment arrives

Add a tax set-aside column at the percentage you choose — commonly 25–30% as a starting reserve. Move that slice to savings when the invoice is marked paid, not when you spend the rest. Pair with the freelance income and expense tracker if you also log costs by client.

The weekly invoice hygiene habit

• Friday: mark paid invoices, highlight overdue, send one polite reminder batch.
• Month-end: export billed vs. paid totals — your year-end summary is already built.

When to upgrade to invoicing software

Spreadsheets win until volume makes manual reminders painful — dozens of recurring invoices, payment links, or a bookkeeper who needs AR aging reports. Until then, a disciplined tracker plus email templates covers most solo freelancers and small studios.

These templates are operational tools, not tax advice. Verify payment terms and tax obligations with your advisor.