Freelancer Tax Spreadsheet | Self Employed 1099 Quarterly Tax Calculator | Schedule C Expense Tracker (Excel)

Freelancer Quarterly Tax Estimator — 1099 income log, Schedule C expense dropdowns, quarterly federal and state estimator, and set-aside calculator. No April surprise.

INSTANT DOWNLOAD
Opens in Excel, Google Sheets, or Apple Numbers.

WHY THIS MATTERS

W-2 employees have taxes withheld automatically. Freelancers and 1099 earners don't, and underpaying triggers underpayment penalties. This spreadsheet calculates exactly how much to set aside from every invoice, schedules your 4 quarterly payments, and tracks deductible expenses in Schedule C categories so your CPA's job takes 1 hour instead of 8.

WHAT'S INSIDE

- Income log with per-client tracking plus invoice dates
- Auto set-aside calculator (25 to 30 percent default, adjustable for your bracket)
- Schedule C expense dropdowns (15 IRS categories)
- Mileage log with standard mileage rate auto-applied
- Home office deduction calculator (regular plus simplified methods)
- Quarterly tax estimator (federal plus state) for 50 states
- Estimated quarterly payments calendar (April, June, Sept, Jan)
- Self-employment tax breakdown (SE tax plus income tax, separated)
- Year-end summary sheet ready to hand to a CPA
- Subcontractor 1099-NEC tracker (if you hire help)

WHO THIS IS FOR

- Freelancers, contractors, consultants
- Etsy sellers who need Schedule C tracking
- Side hustlers whose 1099 income crosses the $400 self-employment threshold
- Anyone who got a surprise April tax bill last year and doesn't want a repeat

HOW TO USE

1. Open in Excel or Google Sheets
2. Log invoices as they're paid. The set-aside amount auto-calculates
3. Categorize expenses with the Schedule C dropdowns as they happen
4. Check the Quarterly tab on March 31, May 31, Aug 31, Dec 31. Transfer the estimated amount to the IRS
5. At year-end, hand the Summary tab to your CPA

FILE DETAILS

- Format: .xlsx
- Tabs: Income, Expenses, Mileage, Home Office, Quarterly, Summary, Instructions
- Fully editable
- Works across Excel, Sheets, Numbers

IMPORTANT

This is a tracking and estimation tool, not tax advice. Always verify quarterly amounts with a CPA or tax professional before sending to the IRS.
Updated with 2026 tax brackets and standard mileage rates.
Digital download. All sales final. Personal use.