US Tax - Template 37
Self Employed Tax Tracker 2026
Know your tax bill all year long, not just in April.
Microsoft Excel◆Google Sheets◆.xlsx file
Built for US freelancers, 1099 contractors and side hustlers. Log your income and expenses on a simple ledger and this spreadsheet estimates your federal tax as you go - income tax, 15.3% self-employment tax, the QBI deduction and all four quarterly 1040-ES payments, so there's never an April surprise. Every category maps to its Schedule C line, so filing is just copying the numbers across. Set for tax year 2026, with a W-2 job tab, a 72.5 cents-per-mile mileage log, a filing-status selector and a plain-English How to File guide. No formulas to write.
What's inside · 9 tabs
- Tax Dashboard - gross income, expenses, net profit, federal tax and take-home at a glance - plus a quarterly 1040-ES payment rail, a tax waterfall, deductions by Schedule C line and monthly money-in-vs-out, all automatic
- Income & Expenses - a simple ledger - every transaction categorised and mapped to its Schedule C line for you
- Schedule C - your gross receipts (line 1), expenses (line 28) and net profit (line 31), totalled into the form lines
- Tax Estimate - income tax, self-employment tax, the QBI deduction and your four quarterly payments - worked out from the 2026 federal rates
- W-2 Job - add a day job alongside the side hustle from your W-2 for a combined tax picture
- Mileage Log - 72.5 cents per business mile (the 2026 IRS rate), totalled and ready for line 9
- How to File - plain-English steps, the four 1040-ES dates and what goes where
- Settings - every 2026 rate and threshold in one place, with a Single / Married / Head of Household selector
In Motion
Your tax bill, worked out as you go.
Log income and costs and the dashboard answers - profit, federal tax and all four quarterly payments, all live.
Pairs Beautifully With
