Etsy Seller Spreadsheet, Etsy Profit Tracker and Fee Calculator, Net Profit per Order and Product, Google Sheets and Excel Template

See what you actually keep from every Etsy order.

This spreadsheet takes your order data and subtracts every Etsy fee (listing, 6.5% transaction, payment processing, Offsite Ads, regulatory fee), your materials, packaging, postage and refunds. You get net profit and margin per order, per month and per product.

HOW IT WORKS
- Paste columns from Etsy's Order Items CSV into the Orders tab (or type orders by hand).
- Add your products once with SKU and material cost.
- The Dashboard shows revenue, Etsy fees, net profit and margin for every month, plus profit by product.

FEATURES
- 500 order rows with all fees calculated per row
- Payment processing reference table for 12 bank countries (US, UK, CA, AU, EU and more)
- Offsite Ads fee with the $100 per-order cap
- Multi-item orders: the flat processing fee is split across the order's rows
- Refunds credit the proportional fees, like Etsy does
- Monthly Costs tab for Etsy Ads and other expenses
- Losses show in red

WHAT YOU GET
+ Etsy-Profit-and-Fee-Tracker.xlsx (Dashboard, Orders, Products, Monthly Costs, Settings, Start Here)
+ How-to-open PDF (Google Sheets and Excel)

HOW TO OPEN IT IN GOOGLE SHEETS
1. Download the .xlsx file from You > Purchases and reviews.
2. Upload it to Google Drive and open it.
3. Choose File > Save as Google Sheets.
It also opens directly in Excel 2016 or newer.

GOOD TO KNOW
- Digital download. Nothing will be shipped.
- Fee rates are editable settings, so you can update them if Etsy changes its fees or your country's processing rate differs.
- The file comes with sample data so you can see how it works.
- Not affiliated with or endorsed by Etsy, Inc.
- Organizes your own numbers. Not tax, legal or accounting advice.

How this was made: we designed this spreadsheet ourselves using AI-assisted tools for parts of the formulas and text, then built and tested every tab by hand with sample data.

Questions or a problem with the file? Message us on Etsy and we will help.