• Invoice & Payment Tracker for Google Sheets and Excel, dashboard shown on a tablet
  • How it works: enter data, statuses update, read the dashboard
  • Feature: Overdue invoices flag themselves
  • Feature: Invoiced vs collected by month
  • Feature: Print a clean invoice
  • What is included: sheet list, example edition and blank edition
  • Settings, colour key and printing
  • Start Here guide opens the file
  • Frequently asked questions
  • Part of a set of five Hornbeam trackers

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.

$9one-time

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.

TabWhat it is for
Start Here5-minute guide and colour key
DashboardKPIs, monthly table and chart
SettingsBusiness name, currency, terms
ClientsContacts and per-client terms
InvoicesOne row per invoice; status is automatic
Invoice ViewPick a number, print or save as PDF
Reminders Bonus3 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

AppSupport
Google SheetsYes. Upload the .xlsx to Google Drive, then right-click and choose Open with Google Sheets. A free Google account is enough.
Microsoft ExcelExcel 2016 or later opens the .xlsx directly.
Macros and add-onsNone. Plain formulas, dropdowns and charts.
Other appsNumbers, 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 as described, message us and we will help fix it.

Get the Invoice & Payment Tracker.

One-time payment, instant download. A tracking tool, not accounting, tax, legal or financial advice.

$9Buy now