Seller Profit & Fee Tracker for Etsy Shops
See every fee on every order, your real profit per product, and the price you need to hit your margin.
An Etsy seller spreadsheet that shows what you really keep from every sale. It calculates the listing, transaction, payment processing, Offsite Ads, regulatory and currency conversion fees on every order, so you see your true profit and margin, and it has a pricing calculator built in. Works in Microsoft Excel AND Google Sheets.
What You Get
- Etsy-Seller-Profit-Fee-Tracker.xlsx — your tracker, ready to fill in
- DEMO shop — a full sample year (orders, products, expenses) to explore every tab
- Quick start PDF
7 Tabs
- Start Here — 4 simple steps
- Settings — shop, currency, year, monthly goal, your hourly rate, target margin. All Etsy fee rates are editable: when Etsy changes a fee, change it once and every order updates. Also set fees for Shopify, Gumroad, eBay, Amazon Handmade, markets…
- Products & Pricing Calculator — cost per unit (materials, packaging, your time), Etsy fees per sale, profit, margin — and the PRICE YOU NEED to hit your target margin
- Orders — 3,000 ready rows: pick platform + SKU, type price and shipping → fees, product cost, net profit and margin calculate. Multi-item orders supported
- Expenses — ads, subscriptions, bulk supplies, equipment
- Monthly Summary — orders, units, revenue, fees, costs, net profit, margin; results by platform and by expense category
- Dashboard — 10 KPIs, revenue vs profit chart, “where every sale goes”, top 10 products, results by platform, loss-making orders and underpriced products flagged
Why This One
- Fees per ORDER, not just a monthly total — spot the products that lose money
- Pricing calculator built in
- Physical AND digital products, one shop or several platforms
- Excel and Google Sheets
- Undated — reuse it every year
How It Works
- Download instantly after purchase
- Check the pre-filled Etsy rates against your Shop Manager and add your products once
- Log orders — fees and profit fill in automatically
Inside the file
These images are drawn from the real workbook, so what you see is what you download.
Questions
- Is this a subscription?
- No. You pay once, and the files are yours to keep and reuse.
- Does it work in Google Sheets?
- Yes, in Google Sheets and in Excel.
- Does it work outside Etsy?
- Yes. You can also set fees for Shopify, Gumroad, eBay, Amazon Handmade and markets.
- What if Etsy changes its fees?
- Change the rate once on the Settings tab and every order updates.
- Designed by me with the help of digital tools, including AI — then tested formula by formula
- Digital product — nothing will be shipped
- Set it up on a computer in Excel or Google Sheets (not tested in Apple Numbers). The Etsy app can't open downloads — use etsy.com › Purchases
- Requires Microsoft Excel 2010+ / Microsoft 365, or a free Google account
- Independent template — not affiliated with or endorsed by Etsy, Inc. Not tax or accounting advice.
More templates

2027 Budget Spreadsheet
Budget by paycheck: every payday of 2027 with the bills it has to cover, plus sinking funds and a debt-free date.

Small Business Bookkeeping Spreadsheet
Log a sale or a purchase in seconds and get your profit and loss statement and dashboard automatically.

Undated Teacher Planner Spreadsheet
Set your first day of school once: calendars, weekly plans, gradebook and attendance date themselves.

Wedding Planner & Budget Spreadsheet
Guest list, RSVPs, seating, caterer counts, budget and vendor payments in one simple file.

Couples Budget Spreadsheet
Split shared bills fairly, even when your incomes differ, and see who owes whom each month in plain words.

Cleaning Business Pricing Calculator
Quote homes and commercial jobs from your real costs and see your margin before you say a number.

Cleaning Business Bundle
The pricing calculator and the bookkeeping tracker together: price every job and track every dollar.