Quarterly Estimated Tax Planner Excel for freelancers, self-employed workers, and anyone paying estimated tax — income by quarter, a safe-harbor worksheet, a payments log, and an annual reconciliation with a next-year…
About this template
Quarterly Estimated Tax Planner Excel for freelancers, self-employed workers, and anyone paying estimated tax — income by quarter, a safe-harbor worksheet, a payments log, and an annual reconciliation with a next-year planner. Know what each quarterly payment should be, whether you paid it, and what is still owed at filing.
$24
Excel & Google Sheets template — instant download on Etsy
Quarterly Income Log — quarter, income description, income, withholding, and credits for each quarter. Totals feed the worksheet by formula.
Estimated Tax Worksheet — estimated total tax, prior-year tax, safe-harbor percentage, the 90 percent test, the safe-harbor amount, required total payments, and the quarterly required payment. A second block shows the quarterly amount if you pay the full estimated tax instead.
Payments Log — date paid, quarter, amount due, amount paid, shortfall, months late, interest rate, and estimated underpayment interest for each installment.
Annual Reconciliation and Next-Year Planner — estimated total tax minus withholding, estimated payments, and credits (amount owed at filing), plus estimated interest and the total due with the return, and a next-year quarterly planner.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Quarterly Estimated Tax Planner track?
The Quarterly Estimated Tax Planner tracks Quarterly Income Log; Estimated Tax Worksheet; Payments Log; Annual Reconciliation and Next-Year Planner; Dashboard.
What do the example numbers show?
The included example shows: Income 120,000 (Q1 28,000, Q2 31,500, Q3 26,000, Q4 34,500); withholding 9,600; credits 1,500.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.