Good Columns
Shop all

Guides / Etsy fee calculator spreadsheet

Etsy fee calculator spreadsheet: the formulas, row by row

You can work out Etsy's fees on an order with five columns and four formulas. This page shows them, using Etsy's US seller rates as checked on 8 October 2026 on Etsy's fee page and Etsy's payment processing help article. Etsy changes its fees from time to time: check the current Etsy fee page before you rely on any figure here.

The rates used (US sellers, checked 8 October 2026)

Etsy US seller rates, checked 8 October 2026
FeeRate
Listing fee, charged again each time a unit sells0.20
Transaction fee, on item price plus shipping and gift wrap you charge6.5%
Payment processing, on the order total3% + 0.25
Offsite Ads fee, only on orders that came from an Offsite Ad, on item price plus shipping and gift wrap15% (12% once a shop has passed US$10,000 in sales over the prior 365 days), at most 100.00 per order

One order, worked through (example)

Item price 20.00, shipping charged 0.00, sales tax left out.

One US$20 order worked through (example data)
LineNormal orderOffsite Ads order
Item price20.0020.00
Listing fee(0.20)(0.20)
Transaction fee, 6.5%(1.30)(1.30)
Payment processing, 3% + 0.25(0.85)(0.85)
Offsite Ads fee, 15%(3.00)
Left after Etsy fees17.6514.65

The formulas

Put the rates in their own cells so you can change them: B1 listing fee, B2 transaction rate, B3 processing rate, B4 processing fixed fee, B5 Offsite Ads rate. Then for an order in row 9 with item price in A9, shipping charged in B9 and yes or no for Offsite Ads in C9:

What this leaves out

Related guide: Etsy Offsite Ads fee: what one order costs you

The workbook that does this

Etsy Seller Profit Calculator is an Excel workbook, designed to open in Google Sheets. It has an order log for up to 1,000 orders with each fee and your profit on every row, costs for up to 100 products, a price helper and a monthly dashboard. Every fee rate is a cell you can edit.

Buy on Gumroad, US$4.99

See what is in the workbook

Good Columns is not affiliated with or endorsed by Etsy.

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.

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.

Good Columns, Melbourne, Australia. hello@goodcolumns.com