ExcelFree — no email required

Quarterly Estimated Tax Worksheet

A five-tab Excel worksheet that solves for the four IRS quarterly estimated tax payments (Apr 15, Jun 15, Sep 15, Jan 15) from your income log, expense totals, filing status, and any W-2 withholding. Self-employment tax (15.3%), the half-SE deduction, and progressive federal income tax brackets are all built in — drop in your numbers and the four payments fall out.

A five-tab Excel workbook for U.S. self-employed makers, bakers, and Etsy sellers who need to stop dreading quarterly estimated tax deadlines. Tab one is a Read Me with the math walked out plainly. Tab two is an Income Log — every receipt with date, channel, gross, fees, and an auto-classified quarter. Tab three is the Quarterly Worksheet itself: pick a filing status from the drop-down, type your quarterly expenses and any W-2 withholding, and the worksheet runs the full self-employment-tax calculation (12.4% Social Security capped at the wage base, 2.9% Medicare uncapped, half-SE deduction above the line) plus a progressive federal-income-tax bracket lookup, then outputs four payment amounts due Apr 15, Jun 15, Sep 15, and Jan 15. Tab four is a Safe Harbor Calc — pay 100% (or 110% above $150K AGI) of last year's tax in equal installments and the IRS won't assess the underpayment penalty regardless of how this year shakes out. Tab five is a Reference with editable 2025 brackets, standard deductions, SE tax rates, and the four IRS deadlines. Pairs with the shipped Schedule C Tax Expense Tracker and Tax Deduction Cheat Sheet for the complete tax bundle.

A Quarterly Worksheet tab that solves for all four payments — Apr 15, Jun 15, Sep 15, Jan 15 — based on income, expenses, withholding, and filing status
Self-employment tax math done correctly: 92.35% adjustment, 12.4% Social Security capped at the wage base, 2.9% Medicare uncapped, half-SE deduction above the line
Progressive federal income tax via a bracket lookup that updates with filing status (single, married filing jointly, head of household)
An Income Log tab with auto quarter classification — drop a date, the quarter assigns itself (Q1 Jan–Mar, Q2 Apr–May, Q3 Jun–Aug, Q4 Sep–Dec)
A Safe Harbor Calc tab using last year's total tax, with the 110% multiplier auto-applied for AGI over $150K — the escape hatch when this year is hard to project
YTD annualization built into the math — early-year columns project the year-end picture and apply the cumulative payment share through the deadline you're paying
A Reference tab with editable 2025 federal brackets, standard deductions, SE rates, and the SS wage base — overwrite each January and the rest of the workbook recomputes
12 sample income rows across Etsy, wholesale, Square, Shopify, and pop-up markets you can replace with your own ledger in minutes

Download

Educational tool only — not tax, accounting, or legal advice. Tax brackets, standard deductions, SE rates, and the Social Security wage base change every year; the worksheet ships with 2025 federal amounts and the Reference tab is editable for the current year. State estimated taxes, the Qualified Business Income (QBI / Section 199A) deduction, and the IRS's annualized-income method (Form 2210 Schedule AI) are out of scope. Review with a CPA or enrolled agent before paying.

When self-employed sellers owe quarterly tax

Self-employed sellers must pay quarterly estimated taxes when they expect to owe at least $1,000 in federal tax for the year and no employer is withholding on their behalf. That covers most full-time Etsy sellers, soap and candle makers, home bakers, and digital-product sellers who clear about $5,000+ in net profit. The IRS expects four installments instead of a single April lump sum, and skipping a quarter triggers an underpayment penalty assessed at the federal short-term rate plus 3% — calculated per missed deadline, even if the year is squared up by April 15.

The four deadlines are Apr 15 (covers Jan 1 – Mar 31 income), Jun 15 (Apr 1 – May 31, only two months), Sep 15 (Jun 1 – Aug 31), and Jan 15 of the following year (Sep 1 – Dec 31). The unequal months are not a bug — the IRS spaces deadlines this way intentionally. Pay through IRS Direct Pay, EFTPS, or by mailing Form 1040-ES with a check.

How the worksheet computes each payment

The Quarterly Worksheet tab uses the IRS's 90% method: project your full-year tax liability based on year-to-date income (annualized for early-year quarters), apply 90% of that as the annual required payment, subtract any W-2 withholding either you or your spouse have for the year, and split the remainder across the four installment dates. Each quarter's payment equals the cumulative share due through that quarter (¼, 2/4, ¾, 4/4) minus what you have already paid in earlier quarters.

Self-employment tax is calculated correctly per Schedule SE: net profit × 92.35% gives "adjusted SE earnings," then 12.4% Social Security tax applies up to the wage base (currently $176,100 in 2025) and 2.9% Medicare tax applies to every dollar with no cap. Half of the SE tax is deductible above the line and reduces the income-tax base. Federal income tax then runs progressive brackets via a SUMPRODUCT lookup that updates with the filing status drop-down.

When to use the safe-harbor method instead

The IRS won't assess an underpayment penalty if you pay 100% of last year's total tax in equal quarterly installments — 110% if last year's AGI exceeded $150,000. The Safe Harbor Calc tab handles this in three inputs: last year's Form 1040 line 24 (total tax), last year's line 11 (AGI), and your expected W-2 withholding for the year. The output is "each quarter, pay X" — done.

Use safe harbor when this year's income is volatile or hard to project (your first year scaling, a sudden wholesale account, etc.). The 90% method is more accurate but punishes overprojection — you tie up cash you didn't need to. Most sellers run both calcs and pay the lesser. The actual tax true-up happens at filing time the following April either way; safe harbor only protects against the underpayment penalty.

A spreadsheet runs your quarterly tax math four times a year, if you remember to type the income and expense numbers in. Ardent Seller runs the same numbers continuously — every sale and expense is already tagged to a Schedule C category, the year-to-date P&L is one click away, and on each estimated-tax deadline you copy a number out of a report instead of reconstructing a quarter from bank statements.

Start Free in Ardent Seller See pricing

Schedule C tax categories

Tag every income and expense transaction to a Schedule C line as it's recorded — the categorizing happens once, when the money moves, not at the deadline.

Profit & Loss and Schedule C reports

Pull a quarterly P&L mapped to Schedule C in seconds — the income and expense totals the worksheet asks for, ready to copy.

Multi-channel sales tracking

Etsy orders pulled automatically with fees, direct sales recorded as you ship — so the income side of estimated tax becomes a report, not a re-entry.

Frequently asked questions

When are quarterly estimated taxes due?

The four federal deadlines are April 15 (covers Jan 1 – Mar 31), June 15 (Apr 1 – May 31, only two months), September 15 (Jun 1 – Aug 31), and January 15 of the following year (Sep 1 – Dec 31). Note that the quarters are not equal — Q2 covers only April and May because the deadline falls in mid-June, not at quarter-end. Most states have parallel deadlines for state estimated tax; this worksheet is federal only.

How much should a self-employed maker pay each quarter?

A common planning heuristic — not the IRS formula — is to set aside 25–30% of net profit for federal taxes: 15.3% self-employment tax (Schedule SE) plus your marginal federal income tax bracket, typically 10–22% for most makers. The actual quarterly payment is computed from filing status, projected income, expenses, and any W-2 withholding using the IRS's 90% method or the safe-harbor method (see Form 1040-ES). The Quarterly Worksheet runs both calculations — use the worksheet output, not the heuristic, for what you actually pay.

What is the self-employment tax rate?

Self-employment tax is 15.3% of net SE earnings — that's 12.4% Social Security on earnings up to the annual wage base ($176,100 in 2025) plus 2.9% Medicare on every dollar with no cap. The IRS lets you back out the employer-half of FICA from itself by multiplying net profit by 92.35% before applying the rates, and lets you deduct half the SE tax above the line as an adjustment to income. The worksheet does all three steps automatically.

What is the safe harbor for estimated taxes?

The IRS won't assess an underpayment penalty if you pay 100% of last year's total tax in equal quarterly installments — 110% if last year's AGI exceeded $150,000. So if last year's Form 1040 line 24 was $8,000 and AGI was under $150K, paying $2,000 each quarter (= $8,000 ÷ 4) regardless of what this year's income looks like means no underpayment penalty. The actual tax true-up still happens at filing time.

Can I avoid quarterly payments if my spouse withholds enough from W-2 wages?

Yes — the IRS treats W-2 withholding (yours or your spouse's, on a joint return) as if it were paid evenly across the year, and it counts dollar-for-dollar against your total tax liability. If your spouse's withholding alone covers 90% of your projected total tax (or 100% / 110% of last year's tax under the safe harbor), no estimated payments are required. The worksheet asks for expected withholding so it nets out automatically.

What happens if I miss a quarterly tax deadline?

The IRS assesses an underpayment penalty calculated per missed quarter at the federal short-term rate plus 3% — for 2025 that's roughly 8% annualized, prorated by days late. Paying the missed quarter as soon as you notice (rather than waiting for April) reduces the penalty since it stops accruing. The penalty is calculated on Form 2210 and added to your April tax bill; you cannot avoid it by paying extra in a later quarter — each deadline is evaluated independently.

Schedule C Tax Expense Tracker

A working Excel expense tracker organized by IRS Schedule C category. Drop-down picker on every row, a Monthly Summary that builds itself, a year-end Schedule C view, and a mileage log with the deduction calculated for you.

Small Business Tax Deduction Cheat Sheet

Every Schedule C line that matters to a maker — what belongs, what doesn't, and the mistakes that cost money.

Product Pricing Calculator

A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.

Spreadsheet vs Inventory Software: The Decision Guide

When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.