Tax Tracker Spreadsheet, 2026 Bookkeeping Template for Freelancers and Contractors

Details

Tax tracker spreadsheet helps freelancers and independent contractors organize 2026 income, expenses, invoices, and quarterly tax estimates in one editable workbook. Use its profit loss sheet, invoice tracker, and tax organizer to keep bookkeeping details together in Excel or Google Sheets. The digital download includes linked tabs for income, expenses, mileage, tax calculations, and a business dashboard.

📊 INDEPENDENT CONTRACTOR BOOKKEEPING SPREADSHEET — 2026 TAX YEAR
Automated bookkeeping for freelancers, 1099 workers & independent contractors

✨ THE ALL-IN-ONE SYSTEM
This instant-download workbook replaces the shoebox. Log income, expenses, mileage and invoices — and the Tax Sheet and Dashboard calculate everything for you with live formulas. No macros, no software to install, no accounting knowledge needed.

✅ WHAT'S INSIDE (9 linked tabs)
• Setup — your details, filing status, and all 2026 IRS rates & limits in one place
• Income — every payment received; each entry auto-gets a month key
• Invoices — tracker with overdue aging; late invoices flag red automatically
• Expenses — category dropdown; your Schedule C line fills in automatically
• Mileage — enter odometer readings; the correct 2026 IRS rate (72.5¢ Jan–Jun / 76¢ Jul–Dec) applies itself
• Tax 2026 — THE AUTOMATED TAX SHEET: net profit → self-employment tax → income tax → four 1040-ES quarterly payments, all recalculated live
• Dashboard — monthly profit & loss, expenses by category, tax snapshot, countdown to the next quarterly deadline
• Tools — hourly rate calculator (taxes included), project quote builder, SEP IRA estimate
• Categories — dropdown source; add a category and it appears everywhere automatically

🚀 KEY FEATURES
✔ 100% automatic — every cell is a live formula, zero macros
✔ Self-employment tax engine: 15.3% on 92.35% of net profit (12.4% Social Security + 2.9% Medicare)
✔ 2026 Social Security wage cap ($184,500) built in
✔ 2026 standard deduction & federal brackets (10–37%), filing-status aware
✔ 1040-ES quarterly payment splitter with due-date countdowns (Apr 15 · Jun 15 · Sep 15 · Jan 15)
✔ Half-of-SE-tax deduction applied automatically
✔ Estimated Section 199A (QBI) 20% deduction — made permanent by the One Big Beautiful Bill Act
✔ Color-coded dashboard with data bars
✔ Works in Excel & Google Sheets

📥 QUICK START (60 SECONDS)
1. Open Setup — enter your name, business name, and pick your filing status from the dropdown.
2. Delete the sample rows on Income, Expenses, Mileage and Invoices — then log your real numbers.
3. Open Tax 2026 — your estimated quarterly payments are already calculated. Type what you've paid into the "Paid" column to track what's left.

👤 WHO IT'S FOR
• Freelancers, gig workers & solopreneurs — designers, writers, developers, photographers, consultants, coaches, drivers, handyfolk
• Anyone receiving a 1099-NEC / 1099-K
• Side-hustlers who want clean books before tax season

💻 COMPATIBILITY
• Microsoft Excel 2016+ (Windows & Mac) and Google Sheets (upload to Google Drive — formulas convert automatically)
• Instant digital download — no physical item shipped. Files: 1 .xlsx workbook + 1 Quick-Start guide (ZIP ~25 KB)

⚠️ PLEASE NOTE
• This is an organizational template, not tax, legal or financial advice. Confirm your numbers with a CPA before filing. 2026 rates are built in and fully adjustable on the Setup tab.
• Personal, non-transferable license — please don't resell or redistribute.

📦 INSTANT DOWNLOAD
Digital items are delivered by Etsy instantly after payment. If you have any issues, message us — we reply within 24 hours.

Happy bookkeeping! 💛