Freelance Invoice Tracker Spreadsheet: Know Who Owes You

Late or forgotten invoices are one of the easiest money leaks to fix. You do not need invoicing software to stay on top of them, just a consistent log.

The columns that matter

Invoice number and date sent
Client and project
Amount and due date (Net 15, Net 30)
Status: sent, partially paid, paid, overdue
Days outstanding

A simple follow-up rhythm

Send a friendly reminder a few days before the due date, another on the due date, and a firmer note at 7 and 14 days overdue. A tracker that calculates days outstanding makes this a two-minute weekly check.

Watch your concentration

If one client is more than half your income, a single late payment can wreck your month. Seeing revenue by client in one dashboard helps you notice that early.

The Freelancer Client & Invoice Tracker ($12) has tabs for clients, projects, invoices, and payments plus a dashboard of what is outstanding and overdue.

Free download: Freelancer Salary Calculator (Excel). No signup. Paid kits are $12 each or $27 for all three at the store.

General information only, not tax, legal, or financial advice. Check current rules with the IRS or a tax professional.