● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Taxes & VAT›Self Employed Tax Tracker
Self-Employed Tax Tracker hero image showing the tax tracker spreadsheet
TAXES & VAT

Self Employed Tax Tracker

Most freelancers meet their tax bill the expensive way, rebuilding a year from bank statements the night before a deadline. This self employed tax tracker keeps income, sales tax, deductions and mileage organised as you go, a few minutes at a time, so filing season feels boring in the best possible way.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Tax season, handled a few minutes at a time

The design idea is simple: log things when they happen, in the tab where they belong, and let the file do the organising. Income by Client records every payment by who paid you, with any sales tax you collected sitting in its own column, apart from your income where it belongs. The Sales Tax Log then lines up what you collected each month against what you have sent in, so the balance you are holding for the tax office is never a mystery.

Expenses get the same calm treatment. Every business cost goes on the Expense and Deductions tab with its category and deductible share, and client meals count at half automatically, the way the rules treat them. The Mileage Log turns business trips into a deduction at your rate per mile as you take them. And the 1099 Tracker lists every client who owes you a form, totals pulled from your income log, ready to tick off as each one arrives.

Two tabs turn all that logging into decisions. Quarterly Estimates shows your profit by quarter, what to send at your own tax rate, and the usual due dates, so estimated payments stop being guesses. The Dashboard gathers the headline numbers on one screen: total income, deductible expenses, net profit, estimated tax and sales tax still owed. When the year closes, the Year-End Summary puts it all on one page with a closing checklist, ready for you or your accountant.

Inside the workbook: 9 tabs

What you receive

  • Google Sheets Access PDF with a one-click copy link, click it and the workbook is yours
  • BLANK Excel workbook, your clean fresh start
  • EXAMPLE Excel workbook filled with realistic sample data to explore first
  • Quick Start Guide PDF with the setup steps on one page
  • Four separate files by instant download, no ZIP to unpack

Good to know

  • Runs in Excel 2021 or Microsoft 365, and in Google Sheets free
  • Any currency works, because amounts are plain numbers
  • Works on your computer, tablet and phone
  • It organises numbers and estimates, it is not tax advice
  • Stuck on anything? Message us through Etsy for help

Questions about this template

The things buyers ask us most.

I am a freelancer, not an LLC. Is this built for me?

Yes. It was made for freelancers, sole traders and single-member LLCs who keep their own books. You do not need an accounting background: if you can type a date and an amount, you can run it. The tabs follow how freelance money actually arrives, in pieces across the year, rather than assuming a tidy monthly salary.

Does it file my taxes or send payments for me?

No, and it does not pretend to. The tracker organises your numbers and works out quarterly estimates from the tax rate you set, quarter by quarter. You, or your accountant, still do the actual filing and sending. Think of it as arriving at tax season already sorted, with the figures ready instead of rebuilt in a panic.

How does the sales tax part work?

When a payment includes sales tax, you log that tax in its own column next to the payment, so it never mixes into your income. The Sales Tax Log gathers your monthly collected totals and tracks what you have remitted, which means the balance you are still holding for the tax office is always in front of you.

Can I change the categories and rates?

Yes. Expense categories, your estimated tax rate, the mileage rate and the amounts you have paid are all yours to edit. The formulas read from the cells you type in, so the Dashboard, quarterly estimates and summaries keep up on their own. Set it up once with your real numbers and the tracker follows your business, not a template's idea of one.

More in Taxes & VAT

All templates in this category →

Three more workbooks from the same shelf.

Receipt Tracker Spreadsheet

Every receipt logged once, missing ones listed, and a tax page ready for your accountant.

$7.50 $3.00
View on Etsy
Tax Deduction Tracker Spreadsheet

Log deductions, file receipts under matching codes, and end the year with a tax-ready summary.

$7.50 $3.00
View on Etsy
VAT Tracker Spreadsheet

Sales, purchases and the nine box VAT return, worked out as you log each line.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00