Invoice Template with Payment Tracker

**One clean invoice you can send today — plus a log that tells you who still owes you money.**

Most invoice templates stop at the invoice. This one keeps going, because the hard part is not writing the invoice, it is remembering who never paid it.

**INSIDE THE FILE — 5 TABS**

- Invoice — print-ready, 14 lines, tax optional, your bank details at the bottom

- Invoice log — 120 invoices, each one marked Paid, Unpaid or Overdue

- Dashboard — total outstanding, total overdue, average days your customers take to pay, and totals per customer

- Your details — fill in once, used on every invoice

- Start here — plain-English instructions

**WHY THIS ONE**

- Overdue is worked out from the due date and today's date, so the list is always current without you touching it

- Tax is a single rate you set, so it works for VAT, GST, sales tax, or nothing at all

- Tells you the average days to payment — worth knowing before you agree to 30-day terms

- Per-customer totals, so you can see who is always late

- Print it or save it as a PDF straight from the Invoice tab

**HOW YOU USE IT**

1. Put your business name, address and bank details in once.

2. Type the invoice number, the customer and the lines. Totals and tax work themselves out.

3. Save as PDF and send it.

4. Add a row to the log. Fill in the date paid when the money lands, and the status changes itself.

**WHAT YOU GET**

- 1 x XLSX file (opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc)

- A "Start here" tab written in plain English

- Every cell pre-filled with a worked example, so you can see how it behaves before you touch it

**HOW IT WORKS**

Cream cells are the ones you type in. Grey cells work themselves out. That is the whole rule.

No macros. No pivot tables. No add-ons. Everything is built from ordinary formulas and dropdowns, which is why it behaves the same way in Excel and in Google Sheets. Nothing to enable, nothing to trust, nothing that breaks on the other side.

**TO USE IT IN GOOGLE SHEETS**

Google Drive > New > File upload > right-click the file > Open with > Google Sheets. That is it. No add-on, no permissions request.

**DELIVERY**

Instant download. Etsy emails you the file the moment payment clears. Nothing is posted to you.

**LICENCE**

Use it in your own business as much as you like, on as many devices as you like. Please do not resell, redistribute or share the file itself.

**A NOTE ON THE EXAMPLE DATA**

The file arrives filled in with example numbers so nothing looks empty and you can see every formula working. Type straight over them with your own.

Questions before you buy? Message me — I answer the same day.