Freelancer Invoice Tracker Spreadsheet | Client, Expense, Tax Set-Aside (Excel, Google Sheets)

Know who owes you what. One spreadsheet for your clients, invoices, expenses and tax set-aside, with three printable invoice designs built in. Works in Excel and Google Sheets.

WORKS WITH: Microsoft Excel 2016 or newer and Google Sheets (File > Import). DOES NOT: send invoices by email, connect to your bank or payment apps, or calculate your real tax bill (the tax set-aside is a percentage you choose). No macros: print or export the invoice sheet to PDF yourself.

INPUTS (blue cells, everything else is formulas)
• Start Here: your business name and address, currency symbol, tax rate charged on invoices, income-tax set-aside rate, first day of your year (fiscal years welcome), default payment terms, editable expense categories
• Clients: name, contact, address, default rate, payment terms in days, notes
• Invoices: invoice number, client (dropdown), issue date, description, qty/hours, rate, status (Draft / Sent / Paid), paid date
• Expenses: date, category (dropdown), vendor, amount, deductible yes/no

WHAT YOU GET
• Invoices sheet that thinks for you: due date from the client's terms, tax, total, LIVE STATUS that flips to Overdue by itself when a Sent invoice passes its due date, days late, days to pay. Status colours: green paid, red overdue, amber sent, grey draft.
• Monthly Summary: 12 months of invoiced, collected, still outstanding, expenses, net, tax set-aside and net after set-aside, with totals.
• Client Summary: per client invoices, invoiced, paid, outstanding, overdue right now, average days to pay, rank.
• Dashboard: year-to-date income, expenses, deductible, net and set-aside; outstanding and overdue right now; top 5 clients; income-by-month chart and expenses-by-category chart.
• Invoice A, B, C: three printable one-page invoice layouts (classic, modern band, minimal). Pick an invoice number in the blue cell and every field fills in: your details, bill-to, line, tax, total, balance due, payment instructions. File > Print.
• Room for 30 clients, 200 invoices, 200 expenses. Sample data (Sample Co., Jordan Rivera...) shows how it works; delete it and start.
• 1-page PDF guide: 30-second start, what each sheet does, Google Sheets import, FAQ.

WORKS IN
Excel 2016+, Excel 365, LibreOffice and Google Sheets (upload, then File > Save as Google Sheets). Only SUM / SUMIF / SUMIFS / COUNTIF / COUNTIFS / IF / IFERROR / MAX / ROUND / INDEX / MATCH / EOMONTH / TODAY are used. No macros, no add-ins, nothing locked. All 1,893 formulas independently checked cell by cell (0 mismatches).

NOT
Accounting software, and not tax advice. A tidy, honest place for your numbers so nothing slips through. Not for resale or redistribution.

Delivery: instant download (ZIP with the .xlsx and the PDF guide). Etsy does not send .xlsx directly, so unzip first. Created with AI assistance (disclosed per Etsy policy).