Invoice & Client Tracker - Invoice Template Spreadsheet (Excel & Google Sheets)

An invoice spreadsheet for freelancers and small businesses. Pick an invoice number and a finished, printable invoice appears. Enter payments as they arrive and the tracker shows who has paid, who is late and how much you are owed.

What's inside (7 tabs):

- Invoice: a clean printable invoice with your business details, bill-to, line items, discount, tax, payments and balance due. Print it or save as PDF

- Invoices: one row per invoice. Due date comes from the client's payment terms. Status shows Paid, Partial, Sent or "Overdue N days"

- Items: line items with quantity and rate. Pick a service and its default rate fills in, or type your own rate

- Clients: contact details, payment terms, and invoiced, paid and owed totals per client

- Dashboard: invoiced and collected this year, outstanding, overdue, aging buckets (1-30, 31-60, 61-90, 90+ days), average days to get paid, oldest overdue invoices, top clients and a monthly chart

- Setup: business name, address, tax rate, default terms, payment instructions and your service list

Holds 100 clients, 600 invoices and 3,000 line items. Works in Excel (2016+, Microsoft 365, Mac or Windows) and Google Sheets. No macros. Ships with sample data so you can see it working; clear the yellow cells to start.

Bookkeeping tool, not tax or legal advice. Instant download (.xlsx + quick-start guide).