Freelancer Income and Expense Tracker Spreadsheet, Self Employed Tax Estimator, 1099 Quarterly Tax and Mileage Log for Google Sheets

For freelancers, contractors and side hustlers: track every invoice, expense and business mile, and know what to set aside for quarterly taxes.

Log invoices (cash basis: they count when marked Paid), business expenses by category, and mileage. The Summary works out profit by month, totals by category, and an estimated quarterly tax set-aside using rates you control.

FEATURES
- Income: client, invoice number, amount, Paid or Unpaid status, with unpaid invoices totaled
- Expenses: 17 editable categories, receipt reminder, and deductible amounts (business meals at 50%)
- Mileage: trip log with deduction from the mileage rate you set
- Summary: income, expenses, mileage and net profit by month, category totals, and a chart
- Quarterly estimated tax: profit so far, estimated tax (self-employment, federal and state/local rates you enter), what you paid, and what to pay by each due date

Estimates only, not tax advice. Tax rules differ by situation; check with a tax professional or irs.gov.

HOW YOU GET IT
This is a digital download. Nothing is shipped. After purchase, download the files from your Etsy Purchases page (or the email Etsy sends you).

WHAT'S IN THE DOWNLOAD
- The template in 3 color themes (Sage, Blush, Slate)
- Each theme with example data, so you can see it working, and a blank version to start fresh
- A Start Here PDF with setup steps for Google Sheets and Excel

WORKS WITH
- Google Sheets (free, any computer, phone or tablet app)
- Microsoft Excel 2016, 2019, 2021 and Microsoft 365
- Not tested in Apple Numbers

GOOD TO KNOW
- No macros, no add-ons, no account to make with us.
- Personal use. Please do not share or resell the files.
- Designed by Tallyhouse with the help of AI tools. Every formula is tested against worked examples before it ships.
- Questions? Message us here on Etsy. We usually reply within a day.