Spreadsheet Templates
•
Published on Nov 20, 2026
•
By SheetVault Editorial Team
•
Free .XLSX
Free Freelance Invoice Tracker Template for Excel & Google Sheets (Download)
=IF(F2="Paid",0,E2)
What Is a Freelance Invoice Tracker?
A simple spreadsheet that records every invoice you send, tracks payment status, and automatically calculates overdue days and outstanding amounts.
Key Benefits
- Instant visibility of unpaid invoices
- Automatic overdue alerts
- Quick totals for revenue and receivables
- Works in both Excel and Google Sheets
Step‑by‑Step Setup
- Open the provided template and rename the sheet if desired.
- Enter your client, invoice number, dates, amount, and status for each invoice.
- The Days Overdue column uses a formula to count days past the due date.
- The Amount Due column shows 0 for paid invoices and the invoice amount for pending ones.
- Review the total rows at the bottom for overall revenue and outstanding balances.
Core Formulas Explained
Days Overdue (Column G)
=IF(TODAY()>D2, TODAY()-D2, 0) – Returns the number of days past the due date; returns 0 if not overdue.
Amount Due (Column H)
=IF(F2="Paid",0,E2) – Shows 0 when the status is "Paid"; otherwise displays the invoice amount.
Pro Tips
- Use conditional formatting to highlight rows where
G(Days Overdue) > 0. - Filter the
Statuscolumn to see only pending invoices. - Copy the total row formulas down as you add more invoices.
Download Ready-to-Use Spreadsheet
Instant .xlsx file download with pre-loaded formulas, formatted totals, and clean design.
Download Template (.xlsx)Frequently Asked Questions
How do I mark an invoice as paid?
Change the value in the "Status" column to "Paid". The Amount Due column will automatically update to 0.
Can I use this template in Google Sheets?
Yes. All formulas are compatible with Google Sheets; just upload the .xlsx file or copy the data into a new Google Sheet.