Skip to the content.

Free Google Sheets Invoice Tracker

For businesses that send invoices from anywhere, paper, PDF or accounting software, and need one list of who owes what and for how long.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Invoices and Clients, no typing needed.
Invoices Columns Invoice number, Client ID, Job or description, Issue date, Terms, Due date override (optional), Subtotal, Discount, Tax rate and 5 more.
Clients Columns Client ID, Company or customer, Contact first name, Email, Phone and Billing address.
Settings Your own dropdown lists (term and calendar days), so the choices match how you work.

How to fill it in

  1. Add each client once with contact details.
  2. Enter every invoice with issue date, terms and amounts, then update Paid to date as money arrives.
  3. Sort by Days overdue and start from the Reminder message column for a polite nudge.
  4. Check the aging columns on Clients to see who is drifting past 30, 60 and 90 days.

A tip from the field

Set your terms once on Settings, such as Net 15 or Net 30. Due dates and overdue days then work out by themselves.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle sends invoices with a pay link, marks them paid when the customer pays and can remind late payers for you. See how it works on smarfle.com.

All free templates