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

  1. Open the provided template and rename the sheet if desired.
  2. Enter your client, invoice number, dates, amount, and status for each invoice.
  3. The Days Overdue column uses a formula to count days past the due date.
  4. The Amount Due column shows 0 for paid invoices and the invoice amount for pending ones.
  5. 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 Status column 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.