Home / Guides / Quarterly estimated taxes Excel tracker
Guide · Taxes · Excel
Quarterly estimated taxes Excel tracker for freelancers
If clients pay you and nobody withholds federal tax, quarterly estimates are how you stay ahead of April. An Excel tracker — income received, expenses by category, a tax cushion, and four due dates — beats guessing from bank apps once a year. This is a practical workbook workflow, not tax advice; confirm with IRS Form 1040-ES, Pub 505, or a preparer.
May earn commissions. SoloDesk may earn a commission if you buy through affiliate links on this page. Recommendations are based on what we think fits the use case. See our affiliate disclosure.
Free Yellowcell quarterly taxes guide
Yellowcell’s self-employed quarterly taxes Excel guide walks SE tax + estimate inputs and soft-paths into free magnets and the invoice kit. Start there, then pull Schedule C categories and a rate calculator if you still need clean inputs.
Quarterly taxes Excel guide Free Schedule C starter All free downloads
What the tracker should hold
| Sheet / block | Why it matters |
|---|---|
| Income log | Cash received this quarter (not invoices sent) — date, client, amount paid |
| Expense log | Date, vendor, amount, Schedule C–style category, business purpose |
| Quarter summary | Gross − expenses = net; estimate income tax + self-employment tax cushion |
| Due-date checklist | Four federal estimated payment dates + confirmation numbers |
| Safe-harbor note | Often 100% of last year’s tax (or 110% if AGI was high) — confirm current IRS rules |
2026 federal due-date rhythm (typical)
| Period covered | Typical due |
|---|---|
| Jan 1 – Mar 31 | April 15 (or next business day) |
| Apr 1 – May 31 | June 15 |
| Jun 1 – Aug 31 | September 15 |
| Sep 1 – Dec 31 | January 15 of following year |
Weekends and holidays shift the exact day. Check the IRS estimated tax calendar before you pay. Add state estimates if your state requires them.
Simple estimate workflow in Excel
- Sum paid invoices for the period (filter income log by quarter).
- Sum documented business expenses for the same dates.
- Net profit ≈ income − expenses. Rough SE tax cushion is often ~15.3% of net earnings (employer + employee halves combined — confirm current rates and thresholds).
- Add a federal income-tax cushion based on your bracket / last year’s return, or aim at safe harbor.
- Pay via IRS Direct Pay, EFTPS, or Form 1040-ES; paste the confirmation into the tracker.
Yellow inputs for rates and cushions; gray formulas for totals. Keep formulas visible so you can explain the number later.
Common underpayment traps
- Tracking invoices sent instead of cash received
- Mixing personal and business spending so expense totals are guesswork
- Skipping the January (Q4) payment after a strong year-end
- Ignoring state estimates
- No category list — every receipt becomes a blank “misc” pile at tax time
Free magnets that feed the tracker
- Self-employed quarterly taxes Excel guide — SE tax + estimate framing
- Free Schedule C starter — category labels so expense rows sort cleanly
- Free client rate calculator — build tax cushion into hourly / day / project rates before you quote
- Free downloads hub — mileage log and other one-sheet tools
From tracker to invoice kit
Clean quarterly math needs billed amounts, paid amounts, and write-offs in one place. Yellowcell’s Sole Ledger invoice + expense kit keeps those rows in Excel (yellow inputs, no macros) so your estimate sheet is not rebuilt from PDF invoices each quarter.
Related SoloDesk guides
- Quarterly estimated taxes checklist
- Schedule C starter categories (Excel)
- Freelance tax write-offs checklist
- Client rate calculator in Excel
- IRS mileage rate 2026 explained
Free magnets + invoice kit (Yellowcell)
Read the quarterly taxes guide, grab the free Schedule C starter and rate calculator, then use Sole Ledger when you want invoices, expenses, and 2026 mileage in one workbook.
Quarterly taxes guide Schedule C starter Free hub Gumroad invoice kit