Freelancer Invoice + Client Tracker

Who it's for

Freelancers don't have an invoicing problem — they have a remembering problem. Who owes what, which invoice is overdue, what you actually earned this year: it all lives in your head until a client ghosts an invoice. This Freelancer Invoice + Client Tracker turns invoicing chaos into one calm spreadsheet.

Built for freelancers, 1099 contractors, coaches, and service providers who'd rather be doing the work than chasing the money. Add a client once and they flow into your invoice dropdowns, payments, and dashboard automatically.

What's inside

• Dashboard: outstanding (unpaid), overdue right now, paid this year, active clients, per-client revenue, and monthly income — all live.
• Invoices tab: invoice numbers, client dropdowns, issue and due dates, auto totals (Amount × (1 + Tax %)), status dropdowns (Draft → Sent → Paid), and automatic Days Overdue math. Overdue invoices flag themselves in red.
• Clients tab: contact details, rates, and payment terms, with per-client Total Billed, Total Paid, and Balance Due — all formula-driven.
• Payments Log: handles partial payments and updates every balance instantly. Recurring tab: retainers and subscriptions with next-due dates and annual value.

How it works

1. Download the .xlsx file instantly after checkout.
2. Open in Excel or import into Google Sheets (File → Import → Upload).
3. Add your clients, create invoices, log payments — the dashboard does the rest.

Frequently asked questions

You may also like

Wedding Budget Spreadsheet — $24.99Bookkeeping Spreadsheet for Etsy Sellers — $19.99ADHD Daily Focus Planner — $14.99