Template · Google Sheets + Excel
Invoice & Payment Tracker
Every invoice in one place, with a status that updates itself: Paid, Partial, Open, Due soon or Overdue.
One-time payment. Checkout and receipt by Polar. You receive the files straight after checkout.
- Example edition and blank edition
- One-time payment, no subscription
- Google Sheets and Excel 2016+
Tour
See it in 15 seconds
A silent 15-second walkthrough, recorded from the real file with sample data.
Features
What it does
One row per invoice
Client, amount, tax rate and due date. Dropdowns keep entries tidy.
Status that updates itself
Paid, Partial, Open, Due soon or Overdue, worked out from today's date.
Days overdue
A counter shows whom to nudge first.
Client list
Total invoiced and outstanding per client.
Dashboard
Invoiced vs collected by month, outstanding and overdue totals, and a chart.
Invoice View
Pick an invoice number and get a clean one-page invoice to print or save as PDF.
What is included
Two editions, one set of tabs
You get two .xlsx files with identical formulas, charts and layout. Open the example edition to explore, or the blank edition to start clean.
Example edition
Filled with sample data (rows marked EX-) so you can see every dashboard and flag working. Delete the EX- rows or switch to the blank edition when you are ready.
Blank edition
The same file, empty and ready for your own data. Capacity: 500 invoices and 200 clients. Copy the last row down if you need more.
| Tab | What it is for |
|---|---|
| Start Here | 5-minute guide and colour key |
| Dashboard | KPIs, monthly table and chart |
| Settings | Business name, currency, terms |
| Clients | Contacts and per-client terms |
| Invoices | One row per invoice; status is automatic |
| Invoice View | Pick a number, print or save as PDF |
| Reminders Bonus | 3 polite payment emails, filled in |
It flags what is overdue; it does not email your clients or process payments.
Compatibility
Works where you already work
| App | Support |
|---|---|
| Google Sheets | Yes. Upload the .xlsx to Google Drive, then right-click and choose Open with Google Sheets. A free Google account is enough. |
| Microsoft Excel | Excel 2016 or later opens the .xlsx directly. |
| Macros and add-ons | None. Plain formulas, dropdowns and charts. |
| Other apps | Numbers, LibreOffice and similar apps are not officially supported. |
FAQ
Questions about Invoice & Payment Tracker
Does it email my clients?
No. It flags what is overdue; you send the reminder yourself.
Can I use my own currency?
Yes. Type a currency label in Settings; amounts are plain numbers.
Excel or Google Sheets?
Both. Excel 2016+, or upload the .xlsx to Google Drive and open with Google Sheets.
How many invoices fit?
500 invoices and 200 clients. Copy the last row down for more.
Can I edit the formulas?
Yes. Excel: formulas locked, no password. Google Sheets: add protection via Data › Protect ranges.
Is there a subscription?
No. It is a one-time payment, with free updates for this version.
Can I use it for my clients' work?
Yes. Use it to run your own business, including work you do for clients. Please do not resell or share the files.
How do payment, receipts and refunds work?
Checkout is handled by Polar, our merchant of record, which also issues your receipt. For refunds, Polar's terms apply. If a file does not work, we will fix it or refund you.
Get the Invoice & Payment Tracker.
One-time payment, instant download. A tracking tool, not accounting, tax, legal or financial advice.


