Etsy fee & profit calculator spreadsheet
One row per order. Type the item price, the shipping you charged and your cost; the sheet works out every Etsy fee with formulas — the $0.20 listing fee, the 6.5% transaction fee, payment processing for your country, the regulatory operating fee, Offsite Ads and the tax Etsy adds to its fees — and what you keep. A Summary sheet adds them up.
Excel .xlsx. Google Sheets: File → Import → Upload. No signup, no email.
Or see Growtsy’s verdict on a sample listing — free, no signup →
What’s in the file
- Settings — your shop country, whether a VAT ID is on file with Etsy, and whether your shop has reached Etsy’s $10,000 USD Offsite Ads threshold.
- Orders — 200 rows, one per order, with the fee lines and what you keep as formulas.
- Summary — totals for every fee line, what you keep and Etsy’s share of your order totals.
- Rates — the fee table for 32 seller countries with the date each was verified (2026-10-30) and the Etsy page it comes from.
Every calculation is a formula you can click and read, not a pasted result.
What the template shows for the example orders
The two example rows that come in the file, worked by its formulas for a US shop. Change the country on the Settings sheet and every line follows the Rates sheet.
| Order | Order total | Listing fee | Transaction fee | Payment processing | Offsite Ads fee | Etsy takes | You keep |
|---|---|---|---|---|---|---|---|
| Found on Etsy$30.00 item + $6.00 shipping, $8.00 cost | $36.00 | $0.20 | $2.34 | $1.33 | $0.00 | $3.87 | $24.13 |
| Through Offsite Ads$30.00 item + $6.00 shipping, $8.00 cost | $36.00 | $0.20 | $2.34 | $1.33 | $5.40 | $9.27 | $18.73 |
The Rates sheet
Payment processing, regulatory operating fee and the tax Etsy adds to its fees for each seller country, as the file carries them. The listing fee ($0.20) and transaction fee (6.5%) are the same everywhere. Verified 2026-10-30; the fixed part of payment processing is turned into US dollars with ECB reference rates of 2026-09-04. For Australia, Canada and New Zealand the rate shown is the domestic one; Etsy charges a different rate on international orders (payment processing by country).
| Seller country | Payment processing | Regulatory operating fee | Tax on Etsy fees | Does a VAT ID remove it? |
|---|---|---|---|---|
| Australia | 3% + 0.25 AUD | — | 10% | Yes |
| Austria | 4% + 0.30 EUR | — | 20% | Yes |
| Belgium | 4% + 0.30 EUR | — | 21% | Yes |
| Brazil | 6.5% + 0.30 USD | — | — | Not listed by Etsy |
| Bulgaria | 4% + 0.30 EUR | — | 20% | Yes |
| Canada | 3% + 0.25 CAD | 0.5% | 5% | Canada: depends on your tax status |
| Czech Republic | 4% + 0.30 EUR | — | 21% | Yes |
| Denmark | 4% + 2.50 DKK | — | 25% | Yes |
| Finland | 4% + 0.30 EUR | — | 25.5% | Yes |
| France | 4% + 0.30 EUR | 1.14% | 20% | Yes |
| Germany | 4% + 0.30 EUR | — | 19% | Yes |
| Greece | 4% + 0.30 EUR | — | 24% | Yes |
| Hungary | 4% + 0.30 EUR | 1.97% | 27% | Yes |
| India | 5% + 25 INR | 0.05% | 18% | Yes |
| Ireland | 4% + 0.30 EUR | — | 23% | No |
| Italy | 4% + 0.30 EUR | 0.8% | 22% | Yes |
| Japan | 6% + 0.30 USD | — | 10% | No |
| Mexico | 4.5% + 8 MXN | — | 16% | No |
| Netherlands | 4% + 0.30 EUR | — | 21% | Yes |
| New Zealand | 3% + 0.30 NZD | — | 15% | Yes |
| Norway | 4% + 2.50 NOK | — | 25% | Yes |
| Poland | 4% + 0.30 EUR | — | 23% | Yes |
| Portugal | 4% + 0.30 EUR | — | 23% | Yes |
| Romania | 4% + 0.30 EUR | — | 21% | Yes |
| Singapore | 4.4% + 0.35 SGD | — | 9% | Yes |
| South Africa | 4.5% + 8 ZAR | — | 15% | No |
| Spain | 4% + 0.30 EUR | 0.88% | 21% | Yes |
| Sweden | 4% + 3 SEK | — | 25% | Yes |
| Switzerland | 4% + 0.50 CHF | — | 8.1% | No |
| Turkey | 6.5% + 14 TRY | 1.67% | 20% | Yes |
| United Kingdom | 4% + 0.20 GBP | 0.48% | 20% | Yes |
| United States | 3% + 0.25 USD | — | — | No tax on fees |
How to use it
- Download the file and open it in Excel, or in Google Sheets with File → Import → Upload.
- On Settings, pick your shop country from the list and answer the Yes/No questions (the yellow cells are the ones you type in).
- On Orders, replace the two example rows with your own orders: item price, shipping you charged and your cost, in US dollars.
- Type Yes in the Offsite Ads column for any order Etsy charged an Offsite Ads fee on.
- Read each order’s fees and what you keep; the Summary sheet totals them.
Etsy’s rules this sheet uses, word for word
- “You will be charged a listing fee of $0.20 USD for each item that you list” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
- “you will be charged a transaction fee of 6.5% of the price you display for each listing plus the amount you charge for shipping and gift wrapping.” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
- “Payment processing fees are a set rate plus a percent of the total sale price of the item. This rate and percent vary by country. The fees are taken from the item’s total sale price, including its shipping fees, and any applicable sales tax.” — What are Payment Processing Fees for Selling on Etsy? — Etsy Help.
- “This fee is charged on the item price and shipping costs” — What is a Regulatory Operating Fee? — Etsy Help.
- “VAT is collected on all Etsy fees for sellers located in countries where VAT should be applied.” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
- “The standard fee you will pay is 15% on Attributed Orders, unless the 12% fee applies” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
- “There is no limit to the number of Offsite Ads fees you may be charged on Attributed Orders, but the total Offsite Ads fee you’ll pay on a single Attributed Order will not exceed $100 USD.” — Etsy Fees & Payments Policy, last updated Oct 5, 2026.
What it doesn’t do
- It doesn’t estimate sales or revenue. Etsy doesn’t publish sales for a single listing; the only numbers in the file are Etsy’s published rates and what you type.
- It works on an order without sales tax. Etsy charges payment processing on the total including any sales tax it collected, so on a taxed US order that line is a little higher.
- It counts one $0.20 listing fee per order, and leaves out currency conversion, Etsy Ads, shipping labels and refunds.
- The rates are a snapshot. Each row says when it was verified; download the file again after a fee change.
Common questions
How do I calculate Etsy fees in Excel?
Add the order total (item price + shipping), then: the $0.20 listing fee, 6.5% of the order total for the transaction fee, your country’s payment processing percentage of the order total plus its fixed fee, the regulatory operating fee where your country has one, and the tax Etsy adds to the sum of those fees. This template does exactly that with formulas, one row per order, reading the rates for your country from its Rates sheet.
Does it include the Offsite Ads fee?
Yes. Type Yes on an order that came through Offsite Ads and the sheet adds 15% of the order total, or 12% once your shop has reached Etsy’s $10,000 USD threshold, capped at $100.00 per order, with the tax on fees on top where your country has it.
Does it include VAT on Etsy fees?
Yes. The Rates sheet carries the tax Etsy adds to its fees for each seller country and whether a VAT ID on file with Etsy removes it there. Answer Yes on the Settings sheet if yours is on file.
Why is my Etsy bill a few cents different?
Two reasons. The fixed part of payment processing is charged in your local currency; the sheet converts it to US dollars with ECB reference rates of 2026-09-04. And Etsy charges payment processing on the total including any sales tax it collected, which the sheet leaves out.
Related
- Etsy fee calculator — the same fee math for one order, online.
- Etsy fees by country — every rate explained, country by country.
- Offsite Ads calculator — whether to keep Offsite Ads on.
- All free Etsy spreadsheet templates — the other templates.
Next: the listing itself
A spreadsheet tracks the numbers; Listing Analysis reads one of your listings against live Etsy data and says the one thing to change first — not a score, a decision. Free account, no card.
Or see Growtsy’s verdict on a sample listing — free, no signup →