Freelancer Income & Tax Tracker
See what you billed, collected and set aside — in one view.
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.