Quarterly Estimated Tax Spreadsheet: Safe Harbor Rule Explained

Quick answer. A quarterly estimated tax spreadsheet calculates what you owe the IRS each quarter based on year-to-date income, less deductions, times your effective tax rate, less prior payments. The safe harbor rule says you avoid the underpayment penalty if you pay at least 100 percent of last year’s tax liability (110 percent if your AGI was over $150,000) or 90 percent of this year’s. Our Annual Tax Planner handles the math automatically, including the 2026 due dates.

The June 15 deadline is six weeks away. If you’re self-employed and you didn’t pay your Q1 estimate (April 15), you’ve already started accruing a small penalty. This post covers what to enter in a quarterly estimated tax spreadsheet, the safe harbor calculation that lets you ignore variable income, and a worked example you can adjust to your own numbers.

The 2026 due dates

Notice Q2 covers two months, not three. The IRS due dates aren’t on calendar quarters. This is the single most common source of “I missed it” emails.

What you owe each quarter

Two ways to figure it.

Method 1: Safe harbor. Pay 25 percent of last year’s total federal tax liability per quarter (or 27.5 percent per quarter if your prior-year AGI was over $150,000). If you do this, you owe no underpayment penalty regardless of what you actually earn this year. Simple.

Method 2: Actual income. Calculate year-to-date income, subtract deductions, apply tax brackets, and pay the projected liability minus what you’ve already paid. More accurate but more work, especially for variable income.

Most people use a hybrid: safe harbor as the floor (so you’re guaranteed no penalty), then top up with method 2 if the year is going much better than last year.

The safe harbor formula

Safe harbor quarterly payment = (Prior year total federal tax) / 4

Or if AGI was over $150,000:

Safe harbor quarterly payment = (Prior year total federal tax * 1.10) / 4

If you paid $24,000 in federal tax in 2025 and your AGI was under $150,000, you owe $6,000 per quarter in 2026 estimates. Pay that on time, your underpayment penalty is zero, even if your 2026 income spikes.

This is the easiest path for variable-income earners. You ignore current-year income noise and pay a predictable amount.

The actual-income calculation

When you’d rather pay closer to your real liability (because last year was unusually high or low), the calculation is:

Q estimate = (YTD net income * effective tax rate) - YTD payments

Where:

• YTD net income = year-to-date gross minus year-to-date deductions
• Effective tax rate = your projected average federal tax rate for the year (not your marginal)
• YTD payments = what you’ve already sent the IRS plus any W-2 withholding

The honest tricky part is the effective rate. For a single filer in 2026:

Add 15.3 percent for self-employment tax (on the first $176,100 in 2026 for the Social Security portion, plus 2.9 percent Medicare on everything above). Subtract the deduction for half of SE tax. Add state tax on top.

For most freelancers, the combined federal plus SE plus state effective rate lands between 25 percent and 35 percent of net business income. The Annual Tax Planner has these tables built in.

A worked example

Lina is a freelance illustrator. 2025 federal tax liability was $14,400. AGI was $112,000 (under $150,000). 2026 is going about the same.

Safe harbor approach (easy): $14,400 / 4 = $3,600 per quarter. She pays $3,600 on April 15, June 15, September 15, and January 15. Total $14,400. If 2026 actual liability ends up higher (say $16,800), she owes the difference at filing in April 2027 with no underpayment penalty because she met safe harbor.

Actual-income approach (more accurate):

Q1 (Jan to Mar 2026): $24,000 gross, $6,500 deductions = $17,500 net. Estimated annual income: $70,000. Effective combined rate: 28 percent. Projected annual tax: $19,600. Q1 payment: $19,600 / 4 = $4,900.

Q2 (Apr to May 2026): YTD gross $42,000, YTD deductions $11,000 = $31,000 net. Annualized to $74,400. Projected annual tax: $20,830. Total to have paid by Q2: $20,830 / 12 * 5 = $8,680. Less Q1 paid ($4,900). Q2 payment: $3,780.

The actual-income approach is more accurate but requires running the calculation each quarter. The spreadsheet does this in two clicks.

Where the spreadsheet helps

The Annual Tax Planner Quarterly Estimates tab takes:

1. Prior year tax liability (one cell)
2. YTD income (updated each quarter)
3. YTD deductions (pulled from your deduction log)
4. Filing status

And outputs:

• Safe harbor amount due each quarter (constant)
• Actual-income amount due each quarter (updated)
• Year-end projected liability vs estimates paid
• Refund or balance due projection

You decide each quarter which number to actually pay. The spreadsheet shows both.

Common mistakes

Forgetting Q1. April 15 is also Tax Day for the prior year. Many first-time filers focus on the prior-year return and miss the new-year Q1 estimate. Set a calendar reminder a week before each due date.

Using calendar quarters instead of IRS quarters. Q2 ends May 31, not June 30. Don’t ask why; the IRS just decided.

Not accounting for state estimates. Most states with income tax also require quarterly estimates with similar (but not identical) due dates. Track them separately.

Paying online but forgetting to record. IRS Direct Pay and EFTPS confirm but don’t mail receipts by default. Save the confirmation number in your spreadsheet so you don’t double-pay or miss-credit at filing.

Treating estimates as optional. Underpayment penalties are small but accumulate. The 2026 underpayment rate is around 8 percent (annual), which on a $5,000 underpayment is $400 by year end. Avoidable.

How to actually pay

Three options:

1. IRS Direct Pay. directpay.irs.gov. Free, takes a checking account routing number, no signup required. The simplest option for occasional users.
2. EFTPS. eftps.gov. Free, requires enrollment (which takes 7 to 10 days the first time, so set up early). Better for recurring quarterly use because you can schedule all four payments at once.
3. IRS2Go app. Mobile version of Direct Pay. Works fine.

Avoid paying by debit or credit card; the processing fees (around 2 percent for credit) cost more than the brief float.

Get the template

• Annual Tax Planner — Schedule A and Schedule C categories with quarterly estimate math built in.
• Annual Tax Planner — Schedule A and Schedule C categories with quarterly estimate math built in.

Related

• Tax Deduction Tracker in Google Sheets: Schedule A Categories Row by Row
• 25 Self-Employed Tax Deductions for 2026