Invoice Google Sheet Template: Free Tracker & Setup Guide (2026)

Most freelancers manage invoices through their email inbox: sent items for proof it was sent, flagged emails for reminders, and memory for everything in between. That system breaks the moment you have more than five outstanding invoices simultaneously — and it provides zero visibility into total outstanding balance, days overdue per client, or who last heard from you. Google Sheets solves all of this for free.

Compared to Excel, Google Sheets has three meaningful advantages for invoice tracking: it's cloud-synced (always current on every device), shareable with your bookkeeper or business partner via a single link, and requires no file management. The TODAY() function that powers the overdue calculation updates automatically every morning — your overdue flags refresh without you touching anything.

Important distinction upfront: this guide builds an invoice tracker — a log where you record all invoices and monitor payment status. This is not an invoice template (the document you send to clients). For the invoice document itself, see our invoice format guide and standard invoice format.

Your invoice tracker needs these columns to be functional. In Row 1, create these headers:

The Last Follow-Up column is the most skipped and the most important. It tells you whether an overdue invoice has been chased recently or is being silently ignored. Update it every time you send a reminder. Without it, you lose track of where you are with each client.

1. Create a new Google Sheet. Name it "Invoice Tracker [Year]". Add the 11 column headers from the table above in Row 1. Freeze Row 1 (View > Freeze > 1 row) so it stays visible when you scroll.
2. Format the date columns. Select columns D, E, and I. Format > Number > Date. This ensures date formulas work correctly.
3. Format the amount column. Select column F. Format > Number > Currency. Choose your currency.
4. Add a status dropdown. Select the cells in column G (e.g. G2:G200). Data > Data validation > Add a rule > Dropdown. Add options: Unpaid, Reminded, Overdue, Paid, Disputed, Written Off.
5. Add the Days Overdue formula. In H2, enter the formula (see the Formulas section below) and drag it down to H200. This auto-calculates overdue days without manual input.
6. Add conditional formatting for overdue rows. Select all data rows (A2:K200). Format > Conditional formatting. Add a rule: "Custom formula is" → =AND($H2>0, $G2<>"Paid"). Set the fill colour to red or pink. Now overdue unpaid rows highlight automatically.
7. Add a summary at the top. Above your headers, add summary cells: Total Unpaid, Total Overdue, Count Overdue. These formulas give you a dashboard view at a glance (see Formulas section).

These are the most useful formulas for an invoice tracker in Google Sheets:

Days Overdue (Column H)

Shows how many days past the due date — only for unpaid invoices. Returns 0 if not yet overdue or already paid.

Where G2 = Status, E2 = Due Date. Drag down to apply to all rows.

Total Outstanding Amount

Sum of all invoices not marked as "Paid".

Total Overdue Amount

Sum of invoices where Days Overdue is greater than 0 and status is not Paid.

Count of Overdue Invoices

Expected Due Date (from Invoice Date + Net Days)

If your payment terms are Net 30, auto-calculate the due date from the invoice date.

Replace 30 with your payment terms (7, 14, 45, 60, etc.)

The Status column is the heart of your tracker. Use these statuses:

• Unpaid — sent, within payment terms, not yet due
• Reminded — you've sent at least one follow-up
• Overdue — manually flagged as needing immediate attention
• Paid — payment confirmed received
• Disputed — client has raised an objection
• Written Off — decided not to pursue further

Recommended colour scheme for conditional formatting (apply to the whole row based on Status):

• Overdue — red/pink highlight
• Reminded — yellow/amber highlight
• Paid — green highlight (or grey out the row)
• Unpaid — no colour (default)

Google Sheets is free and flexible, but it has real limitations you'll hit as your business grows:

• Manual updates required. You have to remember to update the status every time you send a reminder or receive a payment. Miss an update and your data becomes unreliable.
• No automatic reminders. Sheets won't send an email when an invoice is overdue. You have to check the sheet manually and act on what you see.
• No chase history per invoice. You can't see a timeline of every reminder you sent for a specific invoice — just the date of the last one.
• Scales poorly. Once you have 50+ invoices and multiple clients in various stages, a flat spreadsheet becomes hard to navigate quickly.
• No client-facing features. You can't share invoice status with clients, accept online payments, or generate client statements from a spreadsheet.

For a full comparison, see our guide on invoice tracking spreadsheet vs software and our list of common Excel invoice tracking problems (which apply equally to Google Sheets).

Signs it's time to move from a Google Sheet to a dedicated invoice tracking tool:

• You have more than 15–20 active invoices at a time
• You're forgetting to send reminders because you're not checking the sheet consistently
• You have multiple clients with multiple outstanding invoices and need to consolidate follow-ups
• You've had an invoice slip to 60+ days overdue because you lost track of it
• You want chase history per invoice, not just a "last follow-up" date

InvoiceGrid is built specifically for this step up from spreadsheets. It's not accounting software — it's a focused tool for tracking invoices and getting paid, with a visual board, chase history, aging overview, and reminder generation. The free spreadsheet tool lets you export your current data easily when you're ready to switch.

For more on what to look for when upgrading, see our guide on best invoice tracking software for small business and our invoice management software comparison.