Etsy Seller Profit Tracker (Excel + Google Sheets)
Most Etsy calculators quietly leave out the Offsite Ads fee and the per-item listing renewal, so your 'profit' is wrong by up to 15% on the orders that matter. This tracker works out every Etsy fee per order, keeps your expenses in one place (paste your bank CSV instead of typing), and shows real net profit month by month.
What you get:
- Orders tab: Etsy fees per order calculated for you: 0.20 listing renewal per item, 6.5% transaction, payment processing (rate + fixed) and Offsite Ads (12% or 15%, capped per order)
- Multi-channel: craft fair, website and wholesale orders are tracked without Etsy fees
- BankImport tab: paste Date / Description / Amount from your bank or card CSV; keyword rules suggest the category; override any row
- Dashboard: revenue, Etsy fees, net profit, margin, tax set-aside; 12-month table; revenue vs profit chart; expenses by category chart
- Fees % of revenue per month, so you can see when ads or discounts eat your margin
- Fee rates on one Settings tab: change them if you sell from the UK, EU, Canada or Australia
- Currency-neutral (no $ signs) and ISO dates, so it works in any country
- Formula cells are locked so you can't break them; no password, so you can still customise
Included files:
- Etsy Seller Profit Tracker.xlsx (blank, ready to use)
- Etsy Seller Profit Tracker - SAMPLE.xlsx (filled with demo data so you can see every chart working)
- 'Start here' instructions tab inside each file
Works in: Microsoft Excel 2019, 2021, Microsoft 365 (Windows and Mac), Google Sheets (free), LibreOffice. One .xlsx file for both Excel and Google Sheets; no separate versions to mix up.
After purchase you get an instant download link by email (Payhip). This is a DIGITAL DOWNLOAD. Nothing physical will be shipped.
Refunds: because this is an instantly downloadable file, sales are final, but if the file doesn't open or a formula misbehaves, email me and I will fix it or refund you.
Designed, built and tested by me. I used AI tools to help write formulas and copy; every formula was recalculated and checked against hand calculations before listing.
This is a planning and record-keeping tool, not legal, tax or accounting advice.