Freelancer Invoice & Payment Tracker

What it is

A single spreadsheet that tracks every invoice you send — and tells you which ones are late, without you checking anything.

Inside the file (4 tabs)

• Dashboard — total invoiced, total paid, total outstanding and total overdue at a glance, plus a month-by-month bar chart of what you billed and what actually landed.

• Invoices — invoice number, client, issue date, due date, amount and status (Draft / Sent / Paid), with an automatic OVERDUE flag the moment the due date passes on an unpaid invoice.

• Clients — client name, email, hourly rate and a running total pulled straight from the Invoices tab, so you can see who your biggest client really is.

• How to use — a one-page guide to copying the file into your own Drive in about 30 seconds.

How to use it

1. Open the file in Google Sheets (File → Make a copy) or in Excel.

2. Replace the sample rows on the Clients and Invoices tabs with your own.

3. The Dashboard recalculates itself — there are no formulas to edit.

Works in Google Sheets, Excel and Apple Numbers. One-time purchase, instant download, free updates whenever the template changes.