Etsy Seller Profit & Fee Calculator | Pricing Spreadsheet for US & UK Shops

Do you know what you actually keep from an Etsy sale? Between the listing fee, the 6.5% transaction fee, payment processing, the UK regulatory operating fee, VAT on fees and the occasional Offsite Ads charge, a "good" price can quietly become a loss.

This spreadsheet works it out for every product you sell. Choose your shop location (United States, United Kingdom or Custom), then enter each product's price, shipping you charge, materials, packaging, making time, hourly rate and postage cost. You get:

- Estimated Etsy fees per order, itemised into one figure

- Profit before AND after paying yourself for your time

- Profit margin and fees as a % of the order

- The break-even price, and the price you need for your target margin

- A "what if this sale came from Offsite Ads?" switch for each product

- A 12-month profit tracker that turns your Etsy monthly statements into net profit, profit per order and profit per hour, with a chart

Room for 100 products. A fictional sample shop shows how it works; the blank copy is ready for yours.

Fee rates were checked on Etsy Help on 9 November 2026 and every rate is an editable cell, so you can update it when Etsy changes its fees.

What's included: Sample + blank XLSX; How to use, Dashboard, Settings, Pricing and Monthly tabs; START-HERE guide.

Compatibility: Excel, LibreOffice Calc, Google Sheets (File > Import). No macros or add-ins. Tested in LibreOffice.

Please note: Estimates only, not accounting or tax advice, and no promise of sales or profit. Currency conversion fees, Etsy Ads and deposit fees are not modelled. Etsy is a trademark of Etsy, Inc.; this product is not affiliated with or endorsed by Etsy.

Digital download / refunds: Files only. UK consumers normally have 14 days to cancel; if you consent to immediate download and acknowledge losing that right, it ends when the download starts. Statutory rights for faulty or misdescribed content are unaffected.