Freelancer and Maker Quarterly Tax Estimator in Google Sheets

If you freelance, sell handmade goods, or run any kind of one-person shop, nobody withholds tax from what you earn. That's on you, four times a year, and the amount is easy to underestimate because it's not a line item that ever leaves your account automatically the way payroll withholding does. A quarterly tax estimator in Google Sheets turns that guess into a number you calculate the same way every quarter, from numbers you already have.

This isn't tax advice — it's a spreadsheet structure. The actual percentage you should set aside depends on your income level, state, filing status, and business structure, and that number should come from a tax professional, not a blog post. What we can give you is the mechanics: how to structure the sheet so the estimate updates itself once you know your rate.

TL;DR

Track net profit by quarter, apply a set-aside percentage (many self-employed filers land somewhere in a 25–30% range once federal, self-employment tax, and — if applicable — state are combined, but confirm your own number with a professional), and the sheet tells you what to park. Formula: Park for Tax = Net Profit × Set-Aside %. Do this per quarter, not once a year, so the number stays current with how the year is actually going instead of a single guess made in January. Sheetfolk's Handmade Shop Bookkeeping Bundle includes a Tax Set-Aside tab that's already linked to your order profit.

Why Track Taxes by Quarter Instead of Once a Year?

Because the IRS expects estimated payments quarterly if you're self-employed, and because a quarter is short enough that your estimate stays close to reality.

A full year of guessing compounds errors — if your first six months ran leaner than the back half, a single annual estimate either way leaves you either short in April or sitting on cash you could have used earlier. Breaking it into quarters means each set-aside is based on what you actually earned in that window, not a projection from January that assumed the rest of the year would look the same.

It also turns tax savings into a habit instead of a scramble. The same logic that works for sinking funds — small, regular contributions toward a known future expense — applies directly here. A quarterly tax set-aside is a sinking fund for a bill you already know is coming.

What Should a Quarterly Tax Tracker Actually Contain?

Four columns, one row per quarter:

The formula in the last column is simple: Park for Tax = MAX(0, Net Profit) × Set-Aside % — the MAX(0, …) just means a quarter where expenses outran profit never asks you to set aside a negative number. The work isn't in the formula — it's in getting an accurate net profit number to feed it, and in confirming a set-aside percentage that actually matches your situation instead of a round number you picked because it sounded safe.

Where Does the "Net Profit" Number Actually Come From?

From your income tracker, not your gross deposits. Net profit means revenue minus every real cost of earning it — platform fees, payment processing, materials, shipping, software, and any other deductible business expense. If you feed the quarterly tracker a gross sales number instead, you'll set aside tax money on revenue you never actually kept.

Here's what that looks like linked to an actual per-order profit tracker. Take a sample batch of six Etsy and shop orders — totes, mugs, a beanie, a wallet, candles, and a wall hanging — after platform fees, payment processing, shipping cost, and materials are backed out of each one:

That $189.83 — not the $277 in gross sales — is what feeds the quarterly tax formula. In a real Tax Set-Aside tab, that quarter's order profit is also reduced by that same quarter's deductible expenses (both pulled automatically by date, one from Orders and one from Expenses), and the result is floored at $0 so a slow or loss-making quarter never produces a negative set-aside. Skipping expenses for a moment and applying a 25% rate directly to this batch's order profit:

Park for Tax = $189.83 × 0.25 = $47.46

Run that same math for Q2, Q3, and Q4 using each quarter's actual net profit minus that quarter's deductible expenses, and you have four numbers to transfer to savings rather than one year-end guess. For the full breakdown of how each order's net profit is calculated — platform fee, payment processing, shipping cost, materials — see our Etsy profit and fees tracker guide.

What Set-Aside Percentage Should You Actually Use?

We're not going to hand you a number and call it your tax rate — that depends on your income, state, filing status, and deductions, and only a tax professional looking at your actual return can tell you the right figure.

What we can say generally, without prescribing your specific rate: many self-employed filers who model this end up somewhere in a 25–30% combined range once self-employment tax and federal income tax are both accounted for, with state tax added on top where applicable. That's a starting point for building the spreadsheet structure — not a number to rely on without confirming it. Treat the Set-Aside % column as an input you update after talking to a professional, not a constant you copy from a blog post.

Build the sheet so that percentage is a single editable cell referenced by all four quarters, rather than typed into each row separately. That way, if your accountant tells you to adjust it mid-year, one change updates every quarter's projection.

How Do You Actually Use the Tracker Through the Year?

1. After each quarter closes, pull your total net profit for that period from your income or order tracker — not gross revenue.
2. Enter it in the Net Profit column for that quarter.
3. Confirm your Set-Aside % is still accurate — check in with your tax professional if your income level or structure changed.
4. Transfer the "Park for Tax" amount to a separate savings account the same week you calculate it, before it blends back into your operating cash.
5. Repeat for the next quarter, so the number stays current with how the year is actually unfolding.

If quarterly transfers are the step most likely to slip — and for most people, that's exactly the step that slips — set a standing reminder a week or two before each estimated-payment deadline. TaskDrain works well for this: one recurring task, four times a year, so the transfer happens on schedule instead of getting discovered late.

What Expenses Should Reduce Your Net Profit Before You Calculate Tax?

Shop overhead only — costs that aren't tied to any single order. Never re-enter a per-order cost the Orders tab already deducted.

This is the one rule that matters most here: your Orders tab's net-profit number already has materials, platform fees, payment processing, and the shipping label you paid subtracted from every order. If you also log those same costs on the Expenses tab, the quarterly formula (Net Profit minus Expenses) deducts them a second time and your set-aside comes out too low. Expenses is for costs that never touched a specific order in the first place:

• Software and tools used for the business
• Booth fees, craft fair costs, and similar direct-but-not-per-order expenses
• Home office and mileage, where applicable
• Business insurance, professional fees, and similar recurring overhead

Do not put these on the Expenses tab, even though they're real deductible costs — they're already netted out per order on the Orders tab, and re-entering them here double-counts them:

• Materials and cost of goods sold
• Shipping costs (what you paid for the label)
• Platform and payment processing fees

A separate Expenses tab with a "Deductible?" flag on each line keeps the overhead costs organized and exportable when your tax professional asks for a total. If you're trying to find room in the budget to actually fund these set-asides consistently, Spendcull is useful for finding recurring costs elsewhere in your spending you could trim to free up the cash.

How Does This Fit Into a Full Shop Back Office?

A quarterly tax tab is only as good as the profit numbers feeding it — which is why it works best linked directly to your order-level tracking, not typed in separately.

A complete setup looks like five connected tabs: an Orders tab calculating true per-order profit after fees, shipping, and materials; an Inventory tab so you know stock value and what to reorder; an Expenses tab with a deductible flag; a Tax Set-Aside tab pulling quarterly net profit into a set-aside calculation; and a Dashboard totaling revenue, fees, net profit, margin, and tax parked in one view. That's exactly how Sheetfolk's Handmade Shop Bookkeeping Bundle is built — each quarter row on its Tax Set-Aside tab pulls only that quarter's orders (filtered by date) minus that quarter's deductible expenses, not a straight link to the Orders tab's grand total, so you're never manually re-entering a number you already calculated elsewhere.

Frequently Asked Questions

Is 25% a safe default set-aside rate for everyone? No. It's a common reference point people use as a starting structure, not a rate that fits every income level or state. Confirm your actual rate with a tax professional — this article and any spreadsheet built from it are not tax advice.

Do I need to make estimated payments if I also have a W-2 job? Possibly, depending on how much self-employment income you have relative to your withholding elsewhere. That determination should come from a tax professional, not a general spreadsheet guide.

What if my net profit varies a lot quarter to quarter? That's normal for seasonal shops and freelancers, and it's exactly why quarterly tracking beats an annual guess — each quarter's set-aside reflects what actually happened in that window instead of an average that doesn't match any real quarter.

The Bottom Line

A quarterly tax estimator doesn't need to be complicated. It needs four columns, an accurate net profit number, and a set-aside percentage you've actually confirmed rather than guessed. Do that consistently and the tax bill stops being a surprise — it's just a transfer you already knew was coming.

Want the Tax Set-Aside tab already linked to real order profit? Grab Sheetfolk's Handmade Shop Bookkeeping Bundle — $29 for Orders, Inventory, Expenses, Tax Set-Aside, and Dashboard tabs, all wired together.

Disclaimer: This post is for informational purposes only and is not tax, legal, or financial advice. Quarterly estimated tax obligations, rates, and rules vary significantly by income, state, filing status, and business structure. Consult a licensed tax professional or accountant about your specific situation before setting a percentage, making an estimated payment, or relying on any figure in this article.

See Also

• Etsy Profit and Fees Tracker in Google Sheets
• Side Hustle Income Tracker Spreadsheet
• Sinking Funds Tracker in Google Sheets