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
- Add each client once with contact details.
- Enter every invoice with issue date, terms and amounts, then update Paid to date as money arrives.
- Sort by Days overdue and start from the Reminder message column for a polite nudge.
- 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.
Related templates
- Free Google Sheets Invoice Template
- Free Google Sheets Payment Tracker
- Free Google Docs Receipt Template
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.