Quarterly Estimated Tax Spreadsheet: Pay the Right Number

Hey folks, it's Ren here. There is a particular kind of quiet that settles over a home office in the second week of a new quarter.

The invoices went out. Money came in. And somewhere on the desk, half under a coffee cup, there is a sticky note that just says "TAX???" in handwriting you do not remember being that panicked.

I have watched a lot of self-employed people live in that gap between "I earned well this quarter" and "I have no idea what I owe on it". The earning is the fun part. The owing is the part that gets shoved into a drawer until April, when it climbs back out much bigger than anyone planned for.

That drawer is exactly what a quarterly estimated tax spreadsheet is built to empty.

"In this world nothing can be said to be certain, except death and taxes." — Benjamin Franklin

🧾 Why does a flat 30 percent set-aside still leave you short?

A flat set-aside percentage guesses at a number that changes every quarter, which is why it drifts out of true. Pick 30 percent and a strong quarter leaves cash trapped that you could have used, while a heavy-expense quarter quietly underfunds the bill.

The bigger reason people come up short is self-employment tax, and it is nearly invisible until it lands.

When you work for someone else, your employer quietly pays half of your Social Security and Medicare and withholds the rest. When you work for yourself, you are both the employer and the employee, so the whole 15.3 percent is yours.

That sits on top of income tax, not instead of it.

So the person who sets aside "a bit for tax" and means income tax has already missed the largest, most predictable slice of a self-employed bill.

If that has been you, please do not be hard on yourself. Almost nobody is taught this, because for most of our working lives an employer handled it quietly in the background.

Here is roughly where a dollar of profit goes for a middle-income sole trader.

The other thing the flat guess ignores is timing. The IRS calls these payments quarterly, but the periods are not equal quarters.

The first covers three months, the second covers two, the third covers three, and the last covers four. Miss that and the June payment always feels like it arrived early, because it did.

📊 What does a quarterly estimated tax spreadsheet actually calculate?

A quarterly estimated tax spreadsheet turns your year-to-date profit into a single number to pay by each deadline, then tracks what you have paid against what you owe. It is a running ledger, not a one-off calculator you open in a panic each quarter.

The useful ones hold five moving parts in one view: income as it arrives, your year-to-date net profit, the tax that profit implies, the safe-harbor target that keeps you penalty-free, and what you have actually sent.

Here is the shape of the sheet I keep coming back to.

The columns matter more than they look. Your estimate is only ever as good as your net profit, and net profit is income minus every deductible expense you are entitled to claim.

Miss the expenses and you overpay all year. That is why the income and expense side wants to be tidy before the tax maths ever runs, and why a dedicated 1099 expense tracker spreadsheet pays for itself by shrinking the profit the estimate is built on.

Below is how the four 2026 periods line up, so the sheet can label each payment with the deadline it belongs to.

Payment	Income period it covers	2026 due date
Q1	1 January to 31 March	15 April 2026
Q2	1 April to 31 May	15 June 2026
Q3	1 June to 31 August	15 September 2026
Q4	1 September to 31 December	15 January 2027

One kindness the sheet can build in: the January payment is optional if you file your full return and pay the balance by early February. Some people would rather just clear it in January and be done, and the sheet should let them choose either way.

🎯 Is it better to pay last year's number or this year's?

The number you must pay to dodge a penalty is the smaller of two safe-harbor figures, and almost no one frames it that way. You are penalty-free if you pay either 90 percent of what you will owe this year, or 100 percent of what you owed last year. Higher earners, with prior-year income above 150,000 dollars, use 110 percent of last year instead.

That word "smaller" is where the whole strategy hides.

Say last year was steady and your total tax came to 9,000 dollars. This year is booming and your true bill is heading for about 16,000. Ninety percent of this year is 14,400. One hundred percent of last year is 9,000.

You are allowed to pay the smaller one, 9,000, across the four quarters and the IRS cannot charge you an underpayment penalty, even though your real bill will be far higher.

This is the bit worth slowing down on, because it is genuinely useful and genuinely easy to get wrong.

Paying the safe-harbor minimum does not make the extra tax disappear. You will still owe that roughly 7,000 dollar gap when you file. What it does is let you keep the gap in your own high-interest savings until April instead of prepaying it to the IRS, who pay you nothing for the loan.

Held for several months at a normal savings rate, that float is a couple of hundred real dollars you keep. On a bigger swing year it is more.

The catch, and the sheet exists to enforce it, is that you have to actually reserve the difference. A quarterly estimated tax spreadsheet earns its place by carrying a separate true-up reserve line, so the money you are choosing not to send early is sitting in a labelled column rather than being mistaken for profit and spent.

Pay the smaller safe-harbor number, park the true-up, and settle in April. Skip the reserve and that same strategy turns April into an ambush. The column is the difference between the two.

✅ How to build it in about thirty minutes

You can build a working quarterly estimated tax spreadsheet in one sitting, and it will outlast every panic each April. Here is the order that keeps it honest.

1. Start from clean net profit. Pull your year-to-date income and subtract every deductible expense first, because the estimate is only ever as accurate as the profit underneath it.
2. Add a self-employment tax line. Apply 15.3 percent to your net earnings as its own row, so the biggest and most forgotten slice of the bill is visible before income tax is added.
3. Estimate income tax on top. Layer your income tax bracket over the same profit, then add it to the self-employment line to get your projected full-year tax.
4. Enter both safe-harbor figures. Put 90 percent of this year and 100 or 110 percent of last year side by side, and let the sheet flag the smaller of the two as your penalty-free target.
5. Split the target across four dated cells. Divide the safe-harbor target into the four due dates and tick each one as you pay, so a missed quarter cannot hide.
6. Keep a true-up reserve column. Track the gap between what you are paying now and what you will truly owe, and hold that amount in savings until you file.

📌 Mistakes to sidestep

• Budgeting only for income tax. Fix it: put the 15.3 percent self-employment line in first, then add income tax on top.
• Treating the four periods as equal quarters. Fix it: label each payment with its real income window so the short June period never blindsides you.
• Paying the safe-harbor minimum but spending the difference. Fix it: hold the true-up reserve in a separate savings line you do not touch.
• Rebuilding the maths from scratch each quarter. Fix it: keep one running sheet all year so each deadline is a glance, not a rebuild.

Setting the money aside is only half of it. Funding the bill smoothly across the whole year is its own habit, and the tax planning spreadsheet is the companion that turns a lump-sum dread into a steady monthly transfer.

🌟 Your action steps this week

• Find last year's total tax figure from your return, since it anchors the 100 or 110 percent safe harbor.
• Add up this year's income to date and subtract expenses to get a real net profit number.
• Work out both safe-harbor figures and mark the smaller one as your target.
• Open a separate savings account for tax and move the reserve there today, not next quarter.
• If your income is lumpy, pair this with the small business budget template so the profit feeding your estimate stays current.

❗ Quick answers

Who has to pay quarterly estimated taxes?

You generally have to pay quarterly estimated taxes if you expect to owe 1,000 dollars or more when you file, after any withholding and credits. Most freelancers, sole traders and 1099 contractors fall into this because no employer is withholding tax for them.

How much should I set aside for each payment?

Most self-employed people land near 27 to 30 percent of net profit once the 15.3 percent self-employment tax and income tax are combined. A spreadsheet is more accurate than a flat percentage because it uses your real profit each quarter.

What is the safe-harbor rule?

The safe-harbor rule lets you avoid an underpayment penalty by paying the smaller of 90 percent of this year's tax or 100 percent of last year's, rising to 110 percent if your prior-year income was above 150,000 dollars. It removes the penalty, not the tax you still owe at filing.

When are the 2026 estimated tax payments due?

The 2026 federal due dates are 15 April, 15 June and 15 September 2026, then 15 January 2027. The January payment can be skipped if you file your full return and pay the balance by early February.

Can a spreadsheet replace an accountant?

A spreadsheet keeps your numbers ready all year, but it is a planning tool, not tax advice. It makes the handoff to an accountant faster and cheaper, and helps you avoid surprises, while a professional confirms your final position.

The sticky note under the coffee cup was never really about tax. It was about not knowing, and not knowing is the only part a spreadsheet can truly fix.

Fill the columns in, watch the number stop being a mystery, and let the drawer stay empty for good.

To your financial freedom,
Ren

This article is for general information only and is not financial or tax advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified tax professional or financial adviser before making financial decisions.