Etsy Profit and Fees Tracker in Google Sheets: True Per-Order Math After All Costs

Etsy shows you a sales number. It doesn't show you a profit number. Between the transaction fee, payment processing, the shipping label you actually paid for versus what the buyer paid you, and the materials that went into the piece, a $38 sale can quietly net you $26 — or $12, depending on the order. Most sellers never see the gap because their bookkeeping stops at "deposits received."

An Etsy profit tracker in Google Sheets closes that gap. It's a spreadsheet that takes every sale down to a real per-order profit number, after every cost that touched it, so you know which listings are actually worth your time.

TL;DR

Track each Etsy order with: sale price, shipping charged, platform fee %, payment processing fee, actual shipping cost, and materials (COGS). Net profit = sale price + shipping charged − platform fee − payment fee − shipping cost − materials. Do this per order, not just per month, and patterns jump out — some listings clear 65%+ margin, others barely clear 20%. Add inventory and expense tracking and a quarterly tax set-aside, and you've got a full one-person shop back office. Sheetfolk's Handmade Shop Bookkeeping Bundle has all of this pre-built with the formulas already wired.

Why Isn't Etsy Revenue the Same as Etsy Profit?

Because at least four costs come out before you keep a dollar: the platform fee, payment processing, the shipping you actually paid, and what the item cost you to make.

Etsy currently charges a transaction fee (roughly 6.5% of the order total, including shipping — check Etsy's current fee schedule since rates do change) plus a separate payment processing fee on top. Neither of those is optional, and neither shows up as a clean line item when you glance at your bank deposit. Then there's the shipping label you bought, which is rarely exactly what you charged the buyer, and the materials that went into the item, which never appear anywhere unless you track them yourself.

Add it up and a shop that looks busy on the sales dashboard can be barely profitable — or, just as often, more profitable than it looks, because sellers who only watch gross revenue tend to underprice out of fear rather than data.

What Does a Per-Order Profit Formula Actually Look Like?

Net Profit = Sale Price + Shipping Charged − Platform Fee − Payment Fee − Shipping Cost − Materials (COGS)

Here's how that plays out on a real order. Say you sold a linen tote for $38 and charged $6 for shipping:

That's a healthy order. Now look at a $32 knit beanie sold on a lower-fee platform, with the same style of math:

Same seller, similar-sized order, about ten points of margin apart — purely because of which platform and fee structure the sale ran through. You only see that difference when you calculate it per order.

What Should Every Row in Your Tracker Include?

Thirteen columns get you to a real per-order profit number without over-engineering it:

1. Date
2. Order number
3. Item
4. Platform (Etsy, your own site, a market — fees differ, so track separately)
5. Sale price
6. Shipping charged to the buyer
7. Fee % (your platform's cut — set it once, adjust when rates change)
8. Platform fee (calculated)
9. Payment processing fee (calculated)
10. Shipping cost — what you actually paid the carrier
11. Materials / COGS
12. Net profit (calculated)
13. Margin % (calculated)

Set the fee % and payment-processing formula once at the top of your sheet, and every row below calculates itself as you enter sale price, shipping, and costs. That's the difference between a tracker you update in 30 seconds per order and one you dread opening.

For the income-side version of this same discipline — useful if you also freelance or sell across multiple gig platforms alongside your shop — see our side hustle income tracker guide.

How Do You Know Which Listings Are Actually Worth Keeping?

Sort by margin %, not by sales count.

A listing that sells often but nets 20% after fees and materials is quietly working against you compared to a slower listing that clears 65%. Once every order has a real net-profit number, roll them up by item and look at average margin per listing, not just units sold.

Across a small batch of six sample orders — a mix of totes, mugs, beanies, wallets, candles and a wall hanging, spread across Etsy, a Shopify-style storefront, and an in-person market — this is what the totals look like once fees, shipping cost and materials are backed out:

That overall margin isn't net profit divided by sale price alone — it's net profit divided by everything that actually came in from the buyer, sale price plus shipping collected: $189.83 ÷ ($277.00 + $35.00) = 60.8%. Fees alone ate roughly 9% of revenue on this batch — money that never shows up as an "expense" anywhere unless you're pulling it out of the sale price explicitly. That's the number most sellers are guessing at rather than tracking.

If you're also unsure whether a listing's price or copy is the problem rather than its margin, ListingTonic helps diagnose underperforming listings — pair it with your profit numbers so you're not just cutting the fastest-looking loser but the actual unprofitable one.

Where Do Inventory, Expenses, and Taxes Fit In?

A profit tracker alone tells you what happened per sale. A shop back office needs three more tabs to be complete.

• Inventory — materials on hand, unit cost, quantity, and a reorder flag once stock drops below a threshold. Without this, you find out you're out of clasps mid-order.
• Expenses — shop costs that aren't tied to a single order (software, craft fair booth fees, packaging bought in bulk), each flagged as deductible or not, rolling up to a total.
• Tax Set-Aside — real quarterly math: each quarter's own order profit (pulled by date from Orders) minus that same quarter's deductible expenses (pulled by date from Expenses), floored at $0, then multiplied by a set-aside percentage — so you know what to park before the bill arrives instead of after.

Tax note: rates and rules vary by state, income level, and structure — this is not tax advice. Confirm your actual quarterly obligation with a licensed tax professional before relying on any percentage. If you want the full mechanics of setting a quarterly number aside, we cover it step by step in our quarterly tax estimator guide.

Together with Orders, that's a five-tab shop: Orders, Inventory, Expenses, Tax Set-Aside, and a Dashboard that totals revenue, fees, net profit, margin, stock value, and tax parked in one glance — which is exactly how Sheetfolk's Handmade Shop Bookkeeping Bundle is structured.

How Do You Build This Yourself in Google Sheets?

1. Create an Orders tab with the 13 columns above. Enter your platform's fee % once and write the platform-fee formula as =(Sale Price + Shipping Charged) × Fee %.
2. Add a payment-processing formula — most processors charge a percentage plus a flat fee per transaction (something like 2.9% + $0.30 is a common structure to model against; check your actual processor's current rate).
3. Net profit column: =Sale Price + Shipping Charged − Platform Fee − Payment Fee − Shipping Cost − Materials.
4. Add a margin % column: =Net Profit / Sale Price, and conditionally format it so low-margin orders stand out in a warm color.
5. Add Inventory, Expenses, and Tax Set-Aside tabs, and a Dashboard that sums each with SUM() and SUMIF() formulas.
6. Set a weekly reminder to log new orders — a quick pass through your platform's order history works, or TaskDrain can send you a standing weekly nudge so it never piles up into a backlog.

Building it yourself gives you full control and teaches you the formulas. If you'd rather start entering orders today instead of building formulas first, the Handmade Shop Bookkeeping Bundle has Orders, Inventory, Expenses, Tax Set-Aside, and Dashboard tabs already wired — you set your fee % and starting inventory, and the rest calculates itself.

Frequently Asked Questions

Does gross sales minus Etsy's reported fees equal my real profit? No — Etsy's fee summary only covers platform and payment fees. It doesn't subtract your actual shipping cost or materials, both of which you have to track yourself.

Should I track platforms separately if I sell in more than one place? Yes. Fee structures differ enough (a marketplace percentage versus a flat card-processing rate versus zero fees at an in-person market) that blending them into one number hides which channel is actually most profitable.

How often should I update the tracker? Weekly is realistic for most one-person shops. Daily is better if order volume is high enough that receipts and shipping costs are easy to forget by the weekend.

The Bottom Line

Sales numbers tell you how busy you are. Per-order profit tells you whether that busyness is worth it. Once every order runs through the same fee, shipping, and materials math, you stop guessing which listings to keep making and start knowing.

Ready to see your real numbers? Grab Sheetfolk's Handmade Shop Bookkeeping Bundle — $29 for a workbook with true per-order profit, inventory, expenses, and quarterly tax set-asides, all linked to one dashboard.

Disclaimer: This post is informational only and not financial, accounting, or tax advice. Marketplace fee rates change and vary by seller agreement — verify current rates directly with your platform. Consult a licensed tax professional about your specific deduction eligibility and quarterly tax obligations before making decisions based on any figures in this article.

See Also

• Side Hustle Income Tracker Spreadsheet
• Freelancer and Maker Quarterly Tax Estimator in Google Sheets
• Google Sheets Budget Formulas