Price from what you keep
Etsy takes its cut in up to six places on one order, and most sellers only see the total when the deposit lands. I built this calculator for my own shop so I could see each fee line before setting a price, then checked it against a real sale until it matched the Etsy statement to the penny.
The question
this build answers
How much do I actually keep from an Etsy sale, and what should I charge to hit my margin?
From the first trigger
to the finished job.
The working version, step by step.
Pick the tab for your bank currency
I gave the workbook a UK tab, a US tab and a euro tab, because Etsy sets the payment processing rate by where your bank account is: 4% plus 20p in the UK, 3% plus 25 cents in the US, and 4% plus 30 cents in the eurozone.
Type your price and your costs
The blue cells take your item price, the postage you charge, the cost of goods, packaging, the postage you pay and anything else per order. I made everything outside those cells a formula, so there is nothing else to fill in.
Read every fee as its own line
I put each fee Etsy publishes on its own row: the 6.5% transaction fee on the order total including postage, processing on the tax-inclusive total, the regulatory operating fee for your country, and the listing fee per unit sold. Offsite Ads, your Etsy Ads spend and currency conversion sit underneath when they apply.
Add the VAT Etsy charges on its fees
Sellers in the UK and most of Europe who have not given Etsy a VAT ID pay VAT on those fees. I made that one cell, 20 for a UK seller without a VAT ID and 0 with one, and the total updates from there.
Solve for the price
Working backwards from the same fee lines, the price finder gives the break-even price and the price for the margin you type. A ladder underneath shows how ten prices around yours would land.
Run the whole shop on one screen
A ten-product table applies the same fees and settings to every row you add, which is how I found out which of my own listings were earning their place.
The calculator, instant download
Etsy pricing calculator and profit spreadsheet: every fee line, break-even and margin
You get one Excel workbook that also imports into Google Sheets, plus a README and a sources file naming each Etsy help page it uses. It is an instant download with nothing to install and no account with me. If a fee line stops matching your statement, message me from the order and I will check the schedule the same day.
Open the calculator on EtsyChecked against a real order
The UK tab ships with a worked example from a real £3.99 digital sale in my own shop. The sheet reproduces each line of the Etsy statement: transaction 0.26, processing 0.39, regulatory 0.02, listing renewal 0.15 and VAT on those fees 0.16, which leaves 3.01.
Before listing it, I recalculated every tab with an Excel formula engine running outside Excel, and the results matched the fee model line for line.
Where the numbers come from
Every rate comes from Etsy's own help pages, which I read on 16 September 2026: the fees and taxes page, the payment processing table, the regulatory operating fee page and the page on VAT charged on seller fees. The Sources tab in the workbook names each page next to its figures.
Etsy changes its fees from time to time. Each rate sits in its own blue cell, so a change means editing one number and the rest of the sheet follows it.
The parts that break
The price finder ignores the $100 cap on Offsite Ads, so on a very large order it overstates that fee slightly. The per-order lines above it do apply the cap.
There is no live link to your Etsy account, and I did not build one. You type the numbers yourself, and the CSV tab shows how to check one real order against the sheet by hand.
Before you spend anything
The fit matters.
Who should not buy this
If you are VAT registered and need a full VAT return, I would look elsewhere: this gives you a per-order view, and a return needs your whole period's figures.
If you want tax advice, ask an accountant. The sheet models the fees Etsy publishes and stops there.
Yours to keep
What lands
on your desk.
- An Excel workbook that also imports into Google Sheets, with UK, US, euro and other-channel tabs
- Every Etsy fee line as a formula, with the source page and the date I read it
- A break-even price, a target-margin price, a ten-price ladder and a ten-product table
- A worked example from a real sale that matches the Etsy statement to the penny
- A README and a sources file
See the work
Open the proof.
Published case studies of running systems. Each links to the thing itself.
A few useful
answers.
Does it work in Google Sheets?
Import it through File, Import, Upload. I kept to plain formulas, and every one of them uses a function Google Sheets supports.
Is it accurate for my country?
It carries the UK, US and eurozone processing rates and the regulatory operating fee for the UK, France, Italy, Spain and Canada, as Etsy published them on 16 September 2026. For anywhere else, I would use the other-channel tab or edit the rate cell.
What happens when Etsy changes a fee?
Each rate sits in its own blue cell. Change that one number and the whole sheet follows, and the Sources tab lists the Etsy pages to check.
Does it connect to my Etsy account?
There is no connection to your account. You type your own numbers, and the CSV tab shows how to check one real order against the sheet by hand.
A little further down
the same path.
Related builds for the rest of your business.
Working out the true cost of a handmade piece, time and overheads included
Read the build ↗
Pricing Etsy delivery from each product's packed size and weight
Read the build ↗
Opening an Etsy shop and getting its listings found
Read the build ↗
Keeping an Etsy shop's books and stock in one spreadsheet
Read the build ↗
Getting a custom banner, logo and brand board for an Etsy shop
Read the build ↗
Buying all 17 Etsy seller tools in one download
Read the build ↗Make this work for you
Your tools.
Your working version.
Want this built and handed over working? Tell me what your version needs to do. One line is enough to start.
Start a brief