Review criteria
- +Running totals for billed, paid, and outstanding amounts
- +Overdue-invoice flag via conditional formatting
- +Auto tax set-aside column at a rate you choose
- +Doubles as a year-end income summary
Freelance Invoice Tracker in Freelancing
The Freelance Invoice Tracker is a copy-ready spreadsheet that answers the two questions every freelancer needs: who hasn't paid me, and how much should I set aside for taxes? Log each invoice and it shows billed, paid, and overdue totals at a glance, with an automatic tax set-aside column, in both Google Sheets and Excel.
Last updated: August 2026
Excel workbook · opens in Google Sheets · 4 tabs · no sign-up
Try it before you download
Live preview of “Freelance Invoice Tracker”
Change any white cell; grey cells recalculate the way they will in Excel or Google Sheets. Nothing you type leaves this page.
Loading preview…
you type calculated needs attention getting close
Get this template
What’s inside “Freelance Invoice Tracker”
Tabs: How to use · Invoices · Settings · SummaryFormat: Excel (.xlsx) · opens in Google SheetsSetup: Under 10 minutesColumns: 8
Columns (grey = calculated for you)
- Invoice #
- Client
- Project
- Issued
- Due date
- Amount
- Status
- Tax set-aside
- Open the Invoices tab and replace the sample rows with your own — one row per entry. Formulas fill in automatically for new rows.
- Log invoices as you send them and mark them Paid when money lands. Due date turns red when a sent invoice is late.
- Tax set-aside shows how much of each paid invoice to move to savings, at the rate on the Settings tab.
- Using Google Sheets? Upload the file to Google Drive, then open it with Google Sheets (or File → Import in an open sheet). Formulas, dropdowns and highlights carry over.
The file opens locally on your device — nothing is uploaded, and you own the copy outright.
Freelance Invoice Tracker
About this template
It doubles as your year-end income summary, so tax season is a copy-paste instead of a scramble. There's no subscription and no account that can lock away your history — you own the file. When chasing late payments becomes the real chore, our reviews show which invoicing tool is worth paying for.
Review evidence
What to verify before choosing Freelance Invoice Tracker
Use the review criteria below to decide whether this template fits your workflow.
Often worth considering when
- +Freelancers and contractors billing a handful of clients
- +Anyone who loses track of who hasn't paid yet
Pause before choosing when
- -High-volume billing that needs automated reminders
- -Teams needing accounts-receivable workflows
About Freelancing
Why people consider this option
- +Track invoices, income, and unpaid clients without a paid invoicing app
- +Know exactly what you're owed and what to set aside for taxes
- +One sheet doubles as your year-end income summary
What to review before acting
- -No automatic payment reminders unless you add an invoicing tool
- -Manual entry per invoice if you bill high volume
Trust FAQ
Questions people ask before copying a template
How does the tax set-aside column work?
Pick a percentage, and the template automatically calculates how much of each payment to hold back for taxes — so the money is accounted for before you spend it.
Can it show me which clients haven't paid?
Yes. Mark each invoice's status and the tracker totals what's billed, paid, and overdue, with conditional formatting that flags anything past due.
Is the Freelance Invoice Tracker free?
Yes, the core template is free to copy and keep in Google Sheets or Excel. There is no paid tier — the free download includes everything described here.