Freelancer Quarterly Estimated Tax Tracker Excel Google Sheets Self Employed 1040-ES Calculator
Freelancers and self-employed filers in the US owe estimated tax four times a year — and the IRS payment periods aren't equal quarters. This spreadsheet logs your monthly income and expenses, then calculates what you owe for each of the four real Form 1040-ES periods automatically.
What's inside:- 'Income & Expense Log' tab — type your actual business income and expenses for each of the 12 months.- 'Quarterly Tax' tab — Income, Expenses, Net Profit and Estimated Tax are calculated automatically for each payment period, following the real IRS 1040-ES schedule (Jan–Mar, Apr–May, Jun–Aug, Sep–Dec, not equal calendar quarters), each with its 2026 payment due date. Set your own combined tax rate once in a single editable cell. Enter what you've already paid and 'Still Due' updates automatically, shaded red while a balance remains and green once it's covered.- 'Instructions' tab built right into the workbook.
Included in this instant download:- FreelancerQuarterlyTaxTracker.xlsx — the full editable workbook- FreelancerQuarterlyTaxTracker.pdf — printable blank version of every tab
Works in Google Sheets, Microsoft Excel and LibreOffice Calc. Only the shaded input cells are meant for typing — everything else is protected so the formulas don't break by accident.
This spreadsheet is a planning tool only, not tax advice, and does not replace a qualified tax professional or the official IRS Form 1040-ES instructions. It contains no fixed tax rates — you enter your own rate based on your own situation, and should confirm current-year rules and payment due dates on irs.gov before paying.
Made with the help of AI tools; all designs are original, not copied from another creator.
Because this is a digital file, returns and exchanges are not accepted. If anything is wrong with your file, contact us through this store and we'll fix it quickly.