Invoice Tracker Excel Template | Freelance Client & Payment Status Log, Business Bookkeeping, Expense Spreadsheet

Bill clients. Track payments. Know exactly who owes you — at a glance.

The Freelance Invoice +Client Tracker is a complete invoicing system for freelancers, consultants, and solo service providers. No more juggling spreadsheets, sticky notes, or mental math. Log one row per

invoice — the rest runs itself.

Your invoice number generates itself, your balance due and days-overdue calculate automatically, and your dashboard updates live — no formulas to touch, no manual totals.

**✦ WHAT'S INCLUDED (6 connected tabs + printable quick-start guide)**

◆ Read Me First — quick-start guide + color legend

◆ Setup — enter your business info once; it flows into every invoice

◆ Dashboard — live totals: invoiced, collected, outstanding, overdue, plus outstanding-by-client

◆ Client List — your client database (contact info, default rate, notes)

◆ Invoice Tracker — the master log with auto-numbering and color-coded payment status

◆ Invoice Template — a clean, print-ready invoice that pulls client + amount automatically

◆ Bonus: 4-page PDF Quick Start Guide — walk through every tab and send your first invoice in under 5 minutes

**✦ KEY FEATURES**

◆ Invoice numbers auto-generate the moment you enter a client name

◆ Dropdown payment status (Draft, Sent, Paid, Partially Paid, Overdue)

◆ Rows color-code automatically — green for paid, red for overdue, yellow for outstanding

◆ Days Overdue and Balance Due calculate themselves

◆ Live dashboard totals — invoiced, collected, outstanding, overdue

◆ Print-ready invoice template, auto-filled from your tracker

◆ 100 rows ready to go — add more anytime, formulas copy down automatically

**✦ COMPATIBILITY**

Works in Microsoft Excel (Windows & Mac) and Google Sheets (File > Import > Replace spreadsheet). No plug-ins, no subscriptions, no macros.

**✦ PERFECT FOR**

Designers & brand studios · copywriters & consultants · photographers & creatives · coaches & virtual assistants · any solo service provider who bills clients directly.

**✦ HOW IT WORKS**

1. Fill in your business info on the Setup tab.

2. Add your clients to the Client List.

3. Log each invoice on the Invoice Tracker — the invoice number fills in automatically.

4. Set the status from the dropdown; the row color-codes itself.

5. Open the Invoice Template, pick the invoice number, and print or save as PDF.

6. Check the Dashboard anytime for a live snapshot of what's paid, owed, and overdue.

**✦ GOOD TO KNOW**

This is a digital product — no physical item will be shipped. Because it's an instant download, all sales are final, but if anything isn't working the way you expect, message me and I'll help you get it sorted within 48 hours.

Questions before you buy? Send a message — happy to help.

---

Tip for buyers: this template does not include tax calculation or multi-currency conversion. Currency symbol can be changed via Format Cells > Number in Excel or Google Sheets.