How to Track Etsy Profit in Google Sheets (Real Setup)

You sold $4,800 on Etsy this quarter and still don’t know what landed in your pocket. The dashboard shows revenue, the fees page shows a wall of line items, and Etsy never tells you your actual profit — only your gross. If you want to know how to track Etsy profit in Google Sheets without building a tracker from scratch, this is the setup that survives a full year of selling and a tax-time review.

I’ve run two digital-download shops through homemade trackers, then through a paid one. After breaking a few formulas and fixing them, here’s the structure that actually holds up — what columns you need, which fees Etsy charges that nobody warns you about, and how to set aside taxes without a separate app.

What “profit” actually means for an Etsy seller

When a buyer pays you $20, Etsy doesn’t deposit $20. By the time the money hits your bank, Etsy has taken five or six bites out of it, and most sellers only track two of them. Profit is what’s left after every fee, every refund, and every dollar you owe Uncle Sam.

A real Etsy profit formula looks like this:

• Gross sale minus
• Listing fee ($0.20 per listing renewal, or per item sold for digital downloads)
• Transaction fee (6.5% of the item price plus shipping)
• Payment processing fee (~3% + $0.25 in the US, varies by country)
• Regulatory operating fee (0.25–1.1% depending on your country)
• Offsite Ads fee (12% or 15% if you’re enrolled and the sale came from Offsite Ads)
• Refunds and partial refunds for the period
• Tax set-aside (typically 25–30% of net for US sole proprietors)

Whatever’s left is your real profit. If you only subtract listing and transaction fees, you’ll overestimate your profit by 15–20% and underpay your quarterly taxes.

The columns your sheet actually needs

A working Etsy profit tracker in Google Sheets needs about 12 columns. Anything fewer and you’ll miss a fee category. Anything more and you’ll stop logging sales after week three.

Here’s the minimum viable structure:

• Date (sale date, not order date)
• Order ID (so you can match a refund back to it later)
• Item price (gross, before any fee)
• Shipping charged (yes, even for digital — Etsy still calculates the regulatory fee on it)
• Listing fee (auto-calc: $0.20 per item)
• Transaction fee (auto-calc: 6.5% × (item price + shipping))
• Payment processing (auto-calc by country)
• Regulatory fee (auto-calc by country)
• Offsite Ads flag (Y/N — formula reads this to apply 12%/15% conditionally)
• Offsite Ads fee (auto-calc)
• Net deposit (gross − all fees)
• Tax set-aside (auto-calc: % × net)

The “Net deposit” column should match what Etsy actually moved to your bank. If it doesn’t, your formulas are wrong — or Etsy added a fee you missed. Either way, you want to catch the gap before tax season, not during it.

The formula nobody gets right the first time

The Offsite Ads fee is where most homemade Etsy trackers break. The fee is 12% if your shop earned $10K+ in the trailing 365 days, and 15% if you’ve earned less. It’s also capped at $100 per order. And it only applies to orders that came through Offsite Ads — not every order.

A working Google Sheets formula for the Offsite Ads fee column looks like:

=IF(I2="Y", MIN(100, IF($B$1>=10000, 0.12, 0.15) * (C2+D2)), 0)

Where I2 is your Offsite Ads flag, $B$1 is your trailing-365 revenue (a separate cell you update monthly), and C2 + D2 is item price plus shipping. The MIN(100, ...) enforces Etsy’s per-order cap.

The takeaway: don’t trust a formula you copied from a forum. Test it against three real orders Etsy already settled — one with Offsite Ads, one without, and one that crossed the $10K threshold. If all three match, the formula is correct.

How to set up the monthly dashboard

A list of rows is bookkeeping. A dashboard is decision-making. The cheapest version: a second tab with five cells.

The five cells you want, in order:

• Gross revenue this month — SUMIFS(C:C, A:A, ">="&date_start, A:A, "<="&date_end)
• Total fees this month — sum of all fee columns
• Net deposit this month — gross minus fees
• Tax set-aside this month — net × 0.27 (adjust for your bracket)
• Take-home this month — net minus tax set-aside

Update these weekly, not monthly. Sellers who reconcile every Friday catch fee mistakes inside 7 days; sellers who reconcile monthly catch them inside 30 — by which point Etsy’s already moved the money and the dispute window is closing.

If you want a setup that already has all of this wired up — the formulas, the dashboard, the fee logic for the US, UK, EU, and Canada — the Etsy Shop Revenue & Profit Tracker is the version I use for my shops. It’s a Google Sheet, not a SaaS, so you log in once and own it forever.

The tax set-aside trick that saves a March 15 panic

Here’s the math that surprises new Etsy sellers: every dollar of profit owes 15.3% in self-employment tax before income tax even enters the picture. Add federal income tax (around 12–22% depending on bracket) and you’re looking at 27–37% gone to taxes on profit.

The fix is a separate column in your tracker that auto-calculates the set-aside on every sale, and a manual habit: once a week, move that amount from your business checking into a savings account labeled “Taxes.” Don’t touch it. When estimated quarterly payments come due — April 15, June 15, September 15, January 15 — that account funds them.

Sellers who skip this step usually pay an extra penalty. The IRS charges interest on underpaid estimated taxes, and the penalty is roughly the federal short-term rate plus 3%. Not catastrophic, but compounding annoying.

What to do when refunds break your numbers

Refunds are the second formula trap. When you refund a buyer, Etsy refunds the buyer in full, but you don’t always get back every fee. The processing fee is typically non-refundable (Etsy keeps it), and the transaction fee is refunded — but only if you process the refund through Etsy, not as a manual bank transfer.

In your tracker, handle refunds as a separate negative row, not as an edit to the original sale row. That keeps your monthly totals clean and gives you a refund-rate metric — divide refund count by sale count and you’ve got a number you can actually act on. If it climbs above 3% for digital products, something in your listings is overpromising.

Conclusion: what tracking actually changes

Learning how to track Etsy profit in Google Sheets isn’t about accounting — it’s about visibility. The shops that know their real margin can confidently raise prices, run sales, or pivot products. The shops that don’t are guessing.

Pick a structure (the 12-column setup above), pre-build the formulas (especially Offsite Ads and refunds), and reconcile every Friday. If you’d rather skip the build entirely and start logging today, the Etsy Shop Revenue & Profit Tracker ships pre-loaded with every formula above, plus a tax dashboard for US, UK, EU, and Canadian sellers. Either way, the move is the same: stop guessing what landed.

FAQ

how do i calculate etsy profit per sale?

Take the item price, subtract the $0.20 listing fee, the 6.5% transaction fee (applied to item price + shipping), the payment processing fee (~3% + $0.25 in the US), the regulatory operating fee (0.25–1.1%), and the Offsite Ads fee if applicable (12% or 15%, capped at $100). What’s left is gross profit. Subtract 27% for taxes and you’ve got take-home per sale.

does etsy charge fees on shipping?

Yes — both the 6.5% transaction fee and the regulatory operating fee apply to shipping charged to the buyer, even though shipping is supposedly a pass-through cost. This is why most sellers underestimate their fees: they assume only the item price is fee-bearing. For digital downloads, shipping is usually $0, so this only affects physical sellers. For a full breakdown of digital-download fees specifically, see the Etsy fees on digital downloads guide.

what’s the difference between net and profit on etsy?

Net deposit is what Etsy moves to your bank after fees — but before taxes and refunds. Profit is what’s left after you set aside taxes and account for refunds in the period. A shop can have a strong net deposit and still operate at a loss if refund rates are high or tax obligations get ignored.

do i need quickbooks if i have a google sheet?

For shops doing under ~$50K/year in revenue, a well-built Google Sheet covers everything you need: profit tracking, tax set-aside, dashboards, and exportable reports for your CPA. QuickBooks becomes worth it when you have payroll, multiple sales channels, or inventory across more than 100 SKUs. Until then, a sheet is faster and free.

how often should i update my etsy profit tracker?

Weekly. Daily is overkill for most sellers; monthly is too infrequent to catch fee mistakes inside the dispute window. A Friday reconciliation routine — log the week’s sales, refunds, and move the tax set-aside to savings — takes about 15 minutes and prevents almost every bookkeeping headache that shows up at tax time.