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)
| Fee | Rate |
|---|---|
| Listing fee, charged again each time a unit sells | 0.20 |
| Transaction fee, on item price plus shipping and gift wrap you charge | 6.5% |
| Payment processing, on the order total | 3% + 0.25 |
| Offsite Ads fee, only on orders that came from an Offsite Ad, on item price plus shipping and gift wrap | 15% (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.
| Line | Normal order | Offsite Ads order |
|---|---|---|
| Item price | 20.00 | 20.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 fees | 17.65 | 14.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:
- Transaction fee:
=ROUND((A9+B9)*$B$2,2) - Payment processing:
=ROUND((A9+B9)*$B$3+$B$4,2) - Offsite Ads fee:
=IF(C9="yes",MIN(ROUND((A9+B9)*$B$5,2),100),0) - Left after fees:
=A9+B9-$B$1-(the three fees above)
What this leaves out
- Sales tax. Payment processing is charged on the total the buyer pays. Add a sales tax column if you want that to the cent.
- Your own costs. Materials, packaging, the shipping label and your time come off after the fees.
- Etsy Ads. The daily budget you set is separate from Offsite Ads and is billed on its own.
- Sellers outside the US. They have different processing rates, and some pay other fees.
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.
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