Etsy Seller Spreadsheet: Track Your Real Profit After Etsy Fees

Your Etsy dashboard shows you a number every morning, and it is the wrong number. It shows gross sales — the total your buyers paid. What it does not show, anywhere on one screen, is the figure that actually decides whether your shop is a business or an expensive hobby: what one order leaves in your bank account after Etsy has taken its cut three separate times, after the postage, and after the materials.

Most sellers work this out once, roughly, in their head, when they set their prices. Then postage goes up, a supplier changes their pricing, an order gets attributed to an offsite ad, and eighteen months later the item that was supposed to make $12 is making $4 — and nobody notices, because the sales number on the dashboard never stopped going up.

This guide builds the spreadsheet that notices. One row per order, every Etsy fee calculated automatically, and a monthly roll-up that walks you from gross sales down to money in the bank.

A note on the fee figures. The rates below are Etsy’s published US rates as of writing: a 6.5% transaction fee, a 3% + $0.25 payment processing fee for US sellers using Etsy Payments, a $0.20 listing fee, and a 15% offsite ads fee (12% for shops that have crossed $10,000 in sales in any 365-day period). Processing rates vary by country, and some countries also see a regulatory operating fee. Check your own rates in Etsy’s Fees & Payments policy and put them in a settings cell, not in forty formulas.

The example order

Everything below runs on one order so you can follow the arithmetic:

Hold on to those numbers. They come back in every section.

Layer 1: a settings tab, because fee rates change

Before you write a single order row, put your fee assumptions in one place: transaction fee percentage, processing percentage, processing fixed amount, listing fee, offsite ads percentage, and your target net margin.

Every order row then reads from those cells.

This sounds like housekeeping. It is the most valuable structural decision in the whole workbook, for one reason: Etsy changes its fee schedule, and when it does you want to change one cell, not four hundred rows. A seller with hardcoded fees finds out about a fee change when their deposit shrinks. A seller with a settings tab types one number and watches which listings turn red.

It also handles the case nobody plans for: crossing $10,000 in sales and having your offsite ads fee drop from 15% to 12%. One cell.

Layer 2: the per-order fee calculation

Six calculated columns. This is the engine of the whole thing.

Three details in that table do more work than they look like they do.

The transaction fee applies to the whole order, including shipping. Etsy’s fee policy is explicit about this: the 6.5% covers the total order amount, shipping and gift wrap included. A spreadsheet that multiplies 6.5% by the item price understates the fee on every single order that had postage attached to it. On our example that error is small — $0.39 — but on 400 orders a year it is $156 of profit you thought you had.

The processing fee has a fixed component, and fixed components hate cheap items. That $0.25 is the same on a $4 sticker as on a $400 quilt. It is 6.25% of the sticker and 0.06% of the quilt. Any pricing decision you make without modelling the fixed part will be wrong at the low end, always in the flattering direction.

The listing fee belongs on the order row, not in a monthly lump. Every listing costs $0.20 to create, and another $0.20 every time it renews — including the automatic renewal that fires when a multi-quantity listing sells one unit. Attaching it to the sale is the honest way to see it, because that is when it is genuinely incurred.

If you want the fee arithmetic on its own, at every price point from $5 to $100, that is walked through in how much Etsy takes from a $20 sale.

Layer 3: the offsite ads column everyone forgets

Offsite ads are where a healthy-looking Etsy spreadsheet turns into fiction.

When Etsy advertises your listing on Google, Facebook, Pinterest or Instagram and a buyer clicks through and orders within the attribution window, you are charged an advertising fee on that order: 15% if your shop has never made $10,000 in any consecutive 365-day period, 12% once it has. Shops that have never crossed $10,000 can opt out; shops that have crossed it cannot, and pay 12% for the life of the shop.

Watch what it does to our order:

Fifteen points of margin, on the same product, sold at the same price. That is not a rounding error — it is the difference between a business and a treadmill, and it lands on some fraction of your orders that you do not control.

So the column belongs in the sheet as a yes/no flag per order, and the monthly roll-up should tell you what percentage of your orders were attributed. If it is 8% of orders you can price around it. If it is 30%, your entire pricing model needs rebuilding on the assumption that roughly a third of sales pay an extra 15%. You cannot know which without logging it.

The pricing formula that survives this — the one that sets a price which still works when the offsite ads fee lands — is worked through in how to price Etsy items to make a profit after fees.

Layer 4: the listing tab, where you find out what is actually selling

Order rows tell you what happened. Listing rows tell you what to do next.

Five columns per listing — views in the last 30 days, favourites, total sales, revenue, and conversion rate (= sales ÷ views) — and a picture appears that your order log cannot show you:

• High views, low conversion. People find it and do not buy it. That is a photo, price or description problem, not a traffic problem. Advertising it harder makes the loss bigger.
• Low views, high conversion. People who find it buy it. That is a visibility problem, and it is the best possible problem to have — it is the listing worth advertising and worth writing new tags for.
• Low views, low conversion. A candidate for retirement. Every renewal is another $0.20 and, more expensively, another item competing for your own attention.

Add a revenue-per-listing column and sort by it once a quarter. Most Etsy shops discover that a handful of listings carry the shop and a long tail does almost nothing — which is useful, because it tells you exactly where new product development time should go.

Layer 5: ads, tracked against a break-even you have actually calculated

If you run Etsy Ads, the ad tab needs four inputs — date, spend, orders from ads, revenue from ads — and it produces ROAS (= revenue ÷ spend).

ROAS on its own means nothing. What makes it mean something is comparing it to your break-even ROAS, which is 1 ÷ your net margin. Our example order runs a 45.5% net margin, so break-even ROAS is 1 ÷ 0.455 = 2.2. Every dollar of ad spend needs to bring back $2.20 in sales before it has paid for the product it sold.

A 3.0 ROAS is excellent for that shop. A 1.8 ROAS is losing money while looking like a success, because most sellers compare ROAS to 1.0 — as if the product cost nothing to make and Etsy took nothing. The full calculation, including what a realistic click-to-order funnel looks like, is in are Etsy Ads worth it.

Layer 6: the monthly roll-up, which is the actual truth

The per-order number is a screening tool. The month is the reality. A monthly P&L tab should walk from top to bottom in this order:

45.5% on the per-order calculator. 33.6% in the bank. Twelve points, on a shop that is genuinely healthy — eaten by offsite ads, by ad spend that does not attach to any single order, by renewals, and by packaging nobody counts.

Run that same walk on a shop calculating at 20% per order and it lands in single digits, which is the moment you discover you have been buying materials for the privilege of going to the post office.

This is the entire argument for a monthly roll-up that reads from your order rows rather than a fee calculation you did once when you opened the shop.

Layer 7: the tabs that pay for themselves quietly

Three more tabs, none of them about fees, all of them worth having.

Star Seller metrics. Etsy’s badge requires you to reply to 95% of first messages within 24 hours, ship 95% of orders on time with tracking, hold an average review rating of 4.8, and clear at least 10 orders and $300 in sales in the review period. Four of those five are things you can lose without noticing until the badge disappears. A tab with the thresholds and your current numbers turns it into something you manage rather than something that happens to you.

Inventory and supplies. Unit cost, quantity on hand, reorder point. A conditional format that flags REORDER when stock drops below the reorder point is the cheapest insurance in the workbook — a stockout during your busiest fortnight costs more than any fee line in this guide.

Keyword and SEO log. Which tags and title phrases you changed, on what date, and what happened to views over the following 30 days. Etsy SEO is unmeasurable without a change log, because you will not remember in six weeks which of four edits moved the number.

Making it a habit rather than a project

Three rules separate a spreadsheet you maintain from one you built once.

Log orders weekly, reconcile monthly. Weekly logging keeps cost of goods honest while you still remember what went into the item. The monthly reconciliation against your Etsy payment account catches everything else — and when the sheet and the account disagree, the difference is almost always an offsite ads fee or a renewal you did not model.

Re-price after any material or postage change, not at year end. Postage rate changes are the most common cause of a listing that used to work and now does not.

Keep the tax columns filled in as you go. Every fee in this guide is a deductible business expense, and the seller who reconstructs a year of them in April always finds fewer than the seller who logged them. What to track, and the trap in how Etsy reports your gross sales, is covered in what Etsy sellers need to track for taxes.

Putting it together

The loop is short. Fee assumptions in a settings tab → one row per order calculating transaction, processing, listing and offsite ads fees down to net profit → a listing tab showing views, conversion and revenue per listing → ads measured against a break-even ROAS you actually calculated → all of it rolling into a monthly P&L. The per-order number tells you whether a product is worth making. The monthly roll-up tells you whether the shop is worth running.

You can build every tab above from the formulas in this guide. If you would rather start with it already built, that is what our tracker does.