← Quarterly Estimated Tax Calendar

This calendar vs. a spreadsheet

A freelancer, 1099 contractor, or gig worker who pays quarterly estimated tax more than once usually ends up with a spreadsheet for it: a due date typed in for each quarter, and a formula that divides last year's tax (or a guess at this year's) by four. That spreadsheet is correct the day it's built. It fails quietly later — a date that was never business-day-adjusted, a safe-harbor test that only ever checks one of the two IRS branches, or a flat share that keeps repeating after a quarter gets missed — and none of those failures look wrong from the number alone.

What each one is for

A spreadsheet can compute a quarterly tax schedule correctly, and plenty of filers already have one. What it usually doesn't do on its own is shift a nominal due date for the actual weekends and federal holidays of the year you're filing for, run both branches of the IRS's smaller-of safe-harbor test rather than just dividing one number by four, or notice that a missed quarter means the next payment has to be larger than the flat share to catch back up.

This calculator applies IRS Form 1040-ES's own 90%-of-this-year / 100%-or-110%-of-last-year test fresh from the numbers you enter every time, computes the real due date for the tax year you pick (weekend- and federal-holiday-adjusted, not "the 15th"), and tracks what's already due against what's already paid so a missed quarter shows up as a catch-up amount for the next payment, not a repeated flat share.

QuestionWhere to answer it
Can I build a spreadsheet that computes a quarterly safe-harbor schedule? Yes — if the dates are business-day-adjusted for the actual year and the formula runs both branches of the smaller-of test.
Would a formula built around "the 15th" catch a due date that moved? Not unless someone rebuilt it for that year. This calendar recomputes the real date from the year you enter.
Does "last year's tax ÷ 4" apply the 90%-of-this-year test too? Only if the formula does both comparisons and takes the smaller. Most spreadsheets built around one number skip the other branch.
After I miss a quarter, does the sheet tell me the next payment needs to be bigger? Only if someone added that logic. A flat "annual ÷ 4" formula keeps suggesting the same amount regardless of what was actually paid.
Is anything I enter uploaded anywhere? No. This calculator runs entirely in your browser; nothing is sent to a server.

Three things a spreadsheet formula usually gets wrong

The due date itself. The nominal dates — April 15, June 15, September 15, January 15 — shift to the next business day whenever one lands on a weekend or a federal holiday, and the shift can chain through more than one day. Real, published examples: the 2022 Q1 deadline moved to April 18, 2022 (Emancipation Day observed the 15th, then a weekend); the 2023 Q4 deadline moved to January 16, 2024 (the nominal date, January 15, is Martin Luther King Jr. Day that year); and the 2024 Q2 deadline moved to June 17, 2024 (June 15 was a Saturday). A =DATE(year,6,15) formula, or a date typed once and copied down every year, is wrong on all three.

The safe-harbor comparison. Form 1040-ES's floor is the smaller of 90% of this year's estimated tax or 100% (110% above the AGI threshold) of last year's — two numbers, not one. A spreadsheet built around "last year's tax ÷ 4" only ever runs the second branch. On this calculator's own worked example: a filer who owed $15,000 last year and enters that as the only number gets $3,750 a quarter from a last-year-only formula. The same filer entering an $8,000 estimate for this year gets a real required payment of $7,200 for the year — $1,800 a quarter — because the 90%-of-this-year test is lower and wins. The last-year-only spreadsheet ties up an extra $1,950 a quarter — $7,800 for the year — more than the safe harbor actually requires.

What happens after a missed quarter. A flat "annual ÷ 4" formula recomputes the same number every quarter no matter what was actually paid. On this calculator's own worked example: a filer with a $12,000 prior-year safe harbor who has paid nothing by August 1st has a flat quarterly share of $3,000, but two due dates (April and June) have already passed with nothing paid against them — so the amount actually needed to catch back up in one payment is $6,000, twice the flat share a static formula would still be showing.

Open the Quarterly Estimated Tax Calendar to build your own schedule, or see this calendar vs. Keeper's quarterly tax calculator if you're starting from a rough income estimate instead of last year's return.

Common questions

Does a spreadsheet get the quarterly due dates wrong?

Only if it's built from the nominal dates -- April 15, June 15, September 15, January 15 -- rather than the real ones. Each shifts to the next business day when it lands on a weekend or a federal holiday, and the shift can chain through more than one day: the 2022 Q1 deadline moved to April 18 (Emancipation Day observed the 15th, then a weekend), the 2023 Q4 deadline moved to January 16, 2024 (the nominal date is Martin Luther King Jr. Day that year), and the 2024 Q2 deadline moved to June 17, 2024 (June 15 was a Saturday). A =DATE(year,6,15) formula, or a date typed once and reused every year, gets every one of these wrong -- and a reminder set for the wrong day is worse than no reminder, because it reads as on time.

Does a spreadsheet apply the IRS safe-harbor test correctly?

Usually not the full test. Form 1040-ES's safe harbor is the smaller of 90% of this year's estimated tax or 100% of last year's tax (110% above the AGI threshold) -- a comparison, not a single number. A spreadsheet built around 'last year's tax divided by 4' skips the 90%-of-this-year branch entirely, which matters whenever this year's income is lower: on this calculator's own worked example below, a $15,000 prior-year tax bill divided by 4 asks for $3,750 a quarter, while the correct safe harbor -- once an $8,000 current-year estimate is entered -- is $1,800 a quarter, because the 90% test wins and the spreadsheet never ran it.

What does a spreadsheet do after I miss a quarter?

Most keep suggesting the same flat 1/4 share, because that's what the formula computes: annual requirement divided by 4, every quarter, regardless of what actually got paid. This calculator instead compares the running total required by every due date that has already passed against what you've actually paid, and sizes the next payment to catch the shortfall up in one payment rather than carrying it -- and its own interest, under Form 2210 -- to the end of the year.

Is a spreadsheet good enough for a simple year?

For a filer with steady income, no missed quarters, and a AGI comfortably under the high-income threshold, a correctly built spreadsheet using real business-day-shifted dates and the full smaller-of test can get the same answer this calculator does -- the formulas are public, and there's nothing this calculator computes that a careful spreadsheet couldn't. The risk is a formula that goes quietly wrong once: a copied date, a skipped comparison, a missed quarter it never re-checks. This calculator applies the same rules fresh from the numbers you enter each time, so a stale formula can't be the thing that's wrong.

Is anything I enter uploaded anywhere?

No. This calculator runs entirely in your browser; nothing you enter -- last year's tax, this year's estimate, or what you've already paid -- is uploaded or stored anywhere but this device.