Shop / Business

Freelancer Income & Tax Tracker

See what you billed, collected and set aside — in one view.

7 Excel sheetsInvoice ageingQuarterly reserveBlank version included
Freelancer Income & Tax Tracker cover

Dashboard

Five live KPIs, income by client and a monthly trend, with two native charts.

Invoices

One row per invoice, ageing in days, reserve and net-after-reserve calculated for you.

Expenses

Purchase log with a deductible flag, receipt check and a running total.

Mileage

Trip log; amount = miles × the rate you choose on Settings.

Quarterly check

Reserve target versus what you actually set aside. The gap turns red when you fall behind.

Two versions

A sample version to see the maths, and an identical blank one for real records.

What is in the download

  • Freelancer-Income-Tax-Tracker.xlsx (7 sheets, sample data)
  • Freelancer-Income-Tax-Tracker-BLANK.xlsx (7 sheets, blank)
  • README-START-HERE.txt (setup and compatibility)

How it works

Open either file in Excel, WPS Office, LibreOffice Calc, Numbers or Google Sheets. Set four assumptions on the Settings sheet — your year, the share you want to set aside, your own per-mile rate and an as-of date — then type your invoices, purchases and trips into the blue cells. Grey cells are formulas. The dashboard, ageing, quarterly target and charts update on their own. Nothing to install, no macros, no subscription, works offline.

What this is not

This workbook is a record-keeping and arithmetic tool. It is not tax, legal, accounting or financial advice. It does not compute any tax liability and does not decide what is deductible. Every rate in Settings is an assumption you choose, not an official rate. Rules vary by country and change over time — ask a qualified professional about your own situation.

Compatibility

Native formulas only: SUM, SUMIF, SUMIFS, COUNTIF, IF, OR, ROUND and DATE. To use Google Sheets, upload the .xlsx and choose File > Save as Google Sheets, then check the drop-down lists because Sheets may convert them. There are no external links and no volatile functions, so a snapshot stays reproducible.

Licence

Personal use licence. You may adapt the sheets and formulas for your own work. You may not resell or redistribute the workbook as a competing template product. If a file is broken, contact us within 30 days for a replacement or a full refund.

Want the whole library — and 22% off this shop?

Patreon members get 22% off everything in this shop. Supporters ($3/month) get every public post and priority Q&A; Insiders ($9/month) also gets every template pack in the shop. Cancel anytime.

Join on Patreon →