Freelancer Income & Invoice Tracker — Invoices, Clients & Tax Dashboard (Excel + Google Sheets)
Know exactly who owes you, and never get surprised by taxes again.Chasing unpaid invoices from memory and guessing what to save for quarterly taxes is how freelancers lose money. This tracker gives you a live picture of your entire freelance income — no invoicing app, no subscription, no bank linking.What's inside:📊 Dashboard — YTD collected, YTD invoiced, outstanding, overdue, average invoice, and your top 5 clients by billed amount. All automatic.🧾 Invoice log — one row per invoice with client and status dropdowns. Days overdue calculates itself the moment a due date passes. 300 rows ready to go.👤 Clients — name, default rate, email, and YTD billed per client, totaled automatically from your invoices.📅 Monthly income — invoiced vs collected for every month of the year, with a simple in-cell bar chart so slow months jump out.💰 Tax set-aside — set your rate once (25% default) and see exactly how much to put away each quarter, based on what you actually collected.Works with: Microsoft Excel (2016+) Google Sheets (File → Import → Upload) LibreOffice / Numbers Instant download. Lifetime use. Free updates.No spreadsheet skills needed — sample invoices and clients show you exactly how it works. Delete the samples, add your numbers, done.Questions? Message me here on Gumroad — happy to help you set it up.
Get it → lu7er.gumroad.com