Self Employed Tax Spreadsheet 2026 All 50 States | Freelancer QBI Quarterly Tax Calculator | 1099 Expense Mileage Tracker Excel

The Self-Employed Finance Center is a 12-tab Excel spreadsheet that computes US self-employment taxes with 2026 bracket math: federal brackets, the self-employment tax, and your state's brackets. Not a flat 30% guess. It annualizes each quarter's real income into estimated payments, tracks what you owe versus what you paid, and turns lumpy income into a steady monthly paycheck.

This is for a US freelancer who needs the QBI deduction, quarterly estimates, and 1099 expense tracking in one workbook.

Freelancers don't get a steady paycheck. But the IRS still wants its money every quarter.

If you're self-employed in the US, taxes aren't a once-a-year event. They're a quarterly deadline that sneaks up four times a year. And it hurts most when your income is lumpy: a great March, a dead May, and nobody withholding a dime for you. You guess 30% aside, or you forget, and April turns into a panic.

The Self-Employed Finance Center is a 12-tab spreadsheet command center that treats your business like a business. And it covers all 50 states.

Here's the difference: most "freelancer tax spreadsheets" are one tab with a flat 30% guess. This runs real 2026 progressive bracket math. Your federal income tax with the 2026 standard deduction (Single, Married Filing Jointly, or Married Filing Separately). Your self-employment tax: Social Security up to the wage base, Medicare, and the additional 0.9%. Not a rounded estimate, the actual math. Plus your state's 2026 income-tax brackets, picked from a dropdown on the Dashboard. Live in Texas, Florida, or one of the other no-income-tax states? All nine are handled automatically.

NEW FOR 2026: the QBI deduction, done right. The One Big Beautiful Bill Act made the 20% pass-through deduction (Section 199A) permanent, and this workbook actually computes it. Answer four quick questions: your qualified business income (net profit minus the deductible half of SE tax, exactly per Form 8995), whether you're a specified service business, W-2 wages you paid, and your property basis. And it applies the real 2026 rules: the $201,750 / $403,500 income thresholds, the $75,000 / $150,000 phase-in ranges, the wage-and-property limits for high earners, and the new $400 minimum deduction. The deduction comes off before the federal brackets run, so your estimated payments reflect what you really owe. No more April surprises.

The Quarterly Tax Estimator annualizes your real income each quarter, so every estimated payment is based on your actual numbers. It tracks what you should pay vs. what you've paid, shows your true marginal rates, and flags overdue IRS payments with the real due dates.

AVOID THE UNDERPAYMENT PENALTY, without overpaying. Enter last year's total tax and AGI and the workbook computes your IRS prior-year safe harbor (100%, or 110% if your AGI topped $150,000), per quarter, next to your annualized quarter. The safe-harbor quarter alone keeps you penalty-free. Even if you still owe a balance in April; the workbook's highlighted recommendation is the higher of the two, which also covers uneven income.

Bought equipment this year? The One Big Beautiful Bill Act restored 100% bonus depreciation for qualified property, and the Section 179 limit is $2,560,000 for 2026 (inflation-adjusted per IRS Rev. Proc. 2025-32). The Preparer Packet reminds you to list every 2026 equipment purchase for your preparer, so nothing gets missed.

And the Salary Smoother is the part people love most: it turns feast-or-famine income into a steady monthly paycheck. Tax set-aside happens first, and your buffer carries you through the lean months.

Compatibility: Microsoft Excel, Google Sheets & LibreOffice. No macros, no XLOOKUP. Engine revalidated on the September 24, 2026 build: full automated test suite green in LibreOffice (137 validation checks + 191 sweep scenarios, zero formula errors), every formula verified through the LibreOffice round-trip that also clears Excel's strict-parser repair warning. Google Sheets review passed (12 tabs, live recalculation, no errors, dropdowns intact). Final Excel-for-the-web review of the shipping file PASSED September 24, 2026 (12/12 tabs render, no repair banner, headline values verified: QBI deduction $4,964.31, total estimated tax $9,253.43).

WHAT'S INSIDE (12 connected tabs):
- Start Here: plain-English setup, five minutes to working
- Dashboard: pick your state; net profit, estimated tax, state tax, set-aside target, next-payment countdown, monthly charts
- Income Log: every dollar in, tagged by client for 1099 matching
- Invoice Tracker: open and overdue alerts with day counts
- Expense Log: Schedule C categories with 50% meals handling
- Mileage Log: 2026 IRS rates (Jan-Jun / Jul-Dec split) with monthly rollups
- Salary Smoother: lumpy income in, steady monthly paycheck out
- Quarterly Tax Estimator: progressive federal + state + self-employment tax math, annualized per quarter, required vs. paid tracking, marginal rates, the full Section 199A QBI worksheet, and the prior-year safe-harbor calculator
- Cash-Flow Buffer: how many months your cash covers
- 1099 Checklist: expected vs. logged slip amounts, mismatch flags before filing (updated for the 2026 $2,000 1099-NEC reporting threshold)
- Preparer Packet: one clean summary page for your accountant, with your state tax and QBI deduction broken out. Built to make your tax preparer's day
- Settings: every 2026 bracket, deduction, wage base, QBI threshold, and mileage rate is editable

HOW IT WORKS:
1. Log income, expenses, mileage, invoices. Cream cells are yours.
2. Watch the Dashboard, Smoother, and tax estimates update live.
3. Set aside what the quarterly engine tells you, when it tells you.
4. Hand the Preparer Packet to your accountant at tax time.

YOU GET:
- 1 spreadsheet (.xlsx), US edition
- Branded Quick-Start Guide (PDF)
- Sample data included so you can see it working (replace it in minutes)
- Free lifetime updates. The 2027 tax tables are included free when published

PLEASE NOTE:
- This is a digital download. No physical item will be shipped.
- Because of the nature of digital products, refunds aren't available. But if something doesn't work, message me and I'll make it right.
- Planning estimates only. Not tax advice. Confirm your real liability with a tax professional.

Built by the Kollaz studio. Smart financial tools for modern money.

Try the live demo (view-only sample): https://docs.google.com/spreadsheets/d/16FHOzjaHo8o4cxrYUfZfucpnOAAX7zsq9cx9A73Qtis/edit?usp=sharing

How much should I set aside for quarterly estimated taxes in 2026?
The Quarterly Tax Estimator annualizes your real income each quarter, so every estimated payment is based on your actual numbers. It tracks what you should pay versus what you've paid, shows your true marginal rates, and flags overdue IRS payments with the real due dates.

How does the 20% QBI deduction work for 2026?
The One Big Beautiful Bill Act made the 20% pass-through deduction (Section 199A) permanent, and this workbook computes it: four questions, the real 2026 rules. $201,750 / $403,500 thresholds, $75,000 / $150,000 phase-in ranges, wage-and-property limits, and the new $400 minimum deduction.

How do I avoid the underpayment penalty?
Enter last year's total tax and AGI and the workbook computes your IRS prior-year safe harbor (100%, or 110% if AGI topped $150,000) per quarter, next to your annualized quarter. The safe-harbor quarter alone keeps you penalty-free.

What about no-income-tax states?
Texas, Florida, and the other seven no-income-tax states are handled automatically. Pick your state on the Dashboard and the math adjusts.

Does it handle equipment purchases?
The workbook reminds you to list every 2026 equipment purchase for your preparer. 100% bonus depreciation is restored, and the 2026 Section 179 limit is $2,560,000.

Is this tax advice?
No. It gives planning estimates built on real 2026 US tax figures. Your CPA has the last word on every number.

Format: Excel .xlsx workbook, 12 connected tabs (Start Here, Dashboard, Income Log, Invoice Tracker, Expense Log, Mileage Log, Salary Smoother, Quarterly Tax Estimator, Cash-Flow Buffer, T4A Checklist (CA) / 1099 tracking (US), Preparer Packet, Settings)
Tax coverage: all 50 US states, 2026 federal brackets (Single, MFJ, MFS), real self-employment tax math, 2026 QBI deduction engine, IRS prior-year safe harbor
Works in: Microsoft Excel, Google Sheets, LibreOffice. No macros, no XLOOKUP
You get: workbook (.xlsx) + branded Quick-Start Guide (PDF) + pre-loaded sample data
Also available: Canadian edition (listing 4581934685) with the 2026 CRA tax engine for all provinces and territories
Maker: Kollaz: Smart financial tools for modern money
Delivery: Instant digital download