Good Columns
Shop all

Products / Etsy Fee Calculator

Check the fees and profit on one order before you price it.

US$3.99

Excel .xlsx, instant download

Buy on Gumroad, US$3.99

Type your Etsy rates and the figures for one order. The sheet shows each fee, your profit and margin, and the lowest item price that still breaks even.

Who it's for

Etsy sellers who want to test a price or a single order, without keeping a full order log.

The rates in the file are examples. Etsy's current rates are on Etsy's own fees page: you check them and type today's rates into the yellow cells.

Try the free Etsy fee calculator

For a whole shop and not one order at a time, the Etsy Seller Profit Calculator (US$4.99 at launch) is the larger file.

A look at the actual file

Saved items table on the Etsy Fee Calculator tab: five example items with fees, profit and margin
Screenshot of the Etsy Fee Calculator tab with the example data that ships in the file.

What's inside

Two tabs: Start here, and one working tab called Fee calculator, in four blocks.

Tab and blockWhat it does
Start hereFive setup steps, a color key and a guide to the working tab.
Fee calculator: Rates and feesListing fee, transaction fee %, payment processing % and fixed amount, offsite ads % and your target margin %.
Fee calculator: One orderItem price, shipping charged to the buyer, shipping cost paid, item cost and sales tax collected.
Fee calculator: Worked outFee base, each fee, total fees, net received, profit, profit margin % and break-even item price.
Fee calculator: Saved itemsA 12-row table with Item, Price, Item cost, Ship charged, Ship cost, Total fees, Profit and Margin %. Rows turn green at your target margin.

A look at the file

Fee calculator tab: Saved itemsExample items from the file, with the file's example rates, not Etsy's current ones
ItemPriceItem costShip chargedShip costTotal feesProfitMargin %
Ceramic mug, speckled glaze (example)28.007.505.004.603.5917.3252.5%
Linen tea towel set (example)24.006.204.503.903.1615.2453.5%
Soy candle, 8 oz (example)18.004.10–4.202.167.5441.9%
Printable wall art (digital) (example)6.00–––1.024.9883.0%
Leather card holder (example)15.0013.003.004.502.16(1.66)-9.2%

The example rates are a 0.20 listing fee, 6.5% transaction fee, 3% plus 0.25 payment processing and no offsite ads, with a 30% target margin. Rows at or above the target turn green in the file. The card holder is the one row below it, and it loses money once the 13.00 item cost is counted.

Format

File
1 Excel workbook (.xlsx), 2 tabs
Software
Microsoft Excel. Designed to open in Google Sheets.
Limits
One order at a time, plus 12 saved items. The sample rates and items are marked (example) and clear in one step.
Delivery
Instant download after purchase. Nothing is shipped.
Price
US$3.99, one-time. No subscription.

What it does not do

  • It does not know Etsy's current fees. Check Etsy's fees page and type today's rates into the yellow cells.
  • It does not connect to your Etsy account or import orders.
  • It does not work out sales tax or income tax. Sales tax you collected is left out of the fee base.

Questions

Which version of Excel do I need?

Excel 2010 or later on Windows, Excel 2016 or later on Mac, or Excel for the web. We checked every formula in this workbook against the version of Excel that first supported it: the newest thing it uses arrived in Excel 2007, so it needs no Microsoft 365 subscription. There is nothing in it that only newer Excel can run, such as XLOOKUP, LET, IFS or TEXTJOIN, and there are no macros or add-ons. Excel 2003 and earlier are not supported.

The totals look blank when I open it. What is wrong?

Nothing. Excel opens a downloaded file in Protected View and does not calculate until you click Enable Editing. The figures appear as soon as you do.

Does it work on a Mac?

Yes, in Excel for Mac. There are no macros, so nothing in the file is Windows-only. It is also designed to open in Google Sheets in a browser.

Can I use it in Google Sheets?

The workbook is made in Excel and designed to open in Google Sheets: upload it to Drive and open it with Google Sheets. It uses no macros, scripts or add-ons. If something does not work as described there, email hello@goodcolumns.com and we fix it or refund you.

Does it know Etsy's current fees?

No. The rates in the file are examples. Open Etsy's own fees page, then type today's rates into the yellow cells under Rates and fees. Amounts are in whatever currency you type.

What if I want a refund?

No change-of-mind refunds on digital files. If a file is faulty or not as described, email hello@goodcolumns.com within 30 days and we fix it or refund you.

Is this tax, legal or financial advice?

No. It works out fees and profit from the rates and figures you enter. Check Etsy's fees page, and ask a tax professional about your own taxes.

The small print

Good Columns templates help you organise records. They are not tax, legal, accounting or financial advice, are not endorsed by the IRS or any government body, and may not suit your situation. You are responsible for the figures you enter.

Good Columns is not affiliated with or endorsed by Etsy. Fee rates change: check Etsy's fees page and update the rates before relying on any figure.

Licence: use within your own business; no resale or redistribution.

No change-of-mind refunds on digital files. If a file is faulty or not as described, we fix it or refund you.

Full terms: Terms and refunds.