Skip to content
Growtsy / Etsy spreadsheet templates / Etsy fee & profit calculator
Free .xlsx · works in Google Sheets · rates for 32 seller countries

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.

What’s in the file

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.

OrderOrder totalListing feeTransaction feePayment processingOffsite Ads feeEtsy takesYou 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 countryPayment processingRegulatory operating feeTax on Etsy feesDoes a VAT ID remove it?
Australia3% + 0.25 AUD—10%Yes
Austria4% + 0.30 EUR—20%Yes
Belgium4% + 0.30 EUR—21%Yes
Brazil6.5% + 0.30 USD——Not listed by Etsy
Bulgaria4% + 0.30 EUR—20%Yes
Canada3% + 0.25 CAD0.5%5%Canada: depends on your tax status
Czech Republic4% + 0.30 EUR—21%Yes
Denmark4% + 2.50 DKK—25%Yes
Finland4% + 0.30 EUR—25.5%Yes
France4% + 0.30 EUR1.14%20%Yes
Germany4% + 0.30 EUR—19%Yes
Greece4% + 0.30 EUR—24%Yes
Hungary4% + 0.30 EUR1.97%27%Yes
India5% + 25 INR0.05%18%Yes
Ireland4% + 0.30 EUR—23%No
Italy4% + 0.30 EUR0.8%22%Yes
Japan6% + 0.30 USD—10%No
Mexico4.5% + 8 MXN—16%No
Netherlands4% + 0.30 EUR—21%Yes
New Zealand3% + 0.30 NZD—15%Yes
Norway4% + 2.50 NOK—25%Yes
Poland4% + 0.30 EUR—23%Yes
Portugal4% + 0.30 EUR—23%Yes
Romania4% + 0.30 EUR—21%Yes
Singapore4.4% + 0.35 SGD—9%Yes
South Africa4.5% + 8 ZAR—15%No
Spain4% + 0.30 EUR0.88%21%Yes
Sweden4% + 3 SEK—25%Yes
Switzerland4% + 0.50 CHF—8.1%No
Turkey6.5% + 14 TRY1.67%20%Yes
United Kingdom4% + 0.20 GBP0.48%20%Yes
United States3% + 0.25 USD——No tax on fees

How to use it

  1. Download the file and open it in Excel, or in Google Sheets with File → Import → Upload.
  2. On Settings, pick your shop country from the list and answer the Yes/No questions (the yellow cells are the ones you type in).
  3. On Orders, replace the two example rows with your own orders: item price, shipping you charged and your cost, in US dollars.
  4. Type Yes in the Offsite Ads column for any order Etsy charged an Offsite Ads fee on.
  5. Read each order’s fees and what you keep; the Summary sheet totals them.

Etsy’s rules this sheet uses, word for word

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

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.