Etsy Seller Profit Tracker (Excel & Google Sheets)

Know what you REALLY keep from every sale after Etsy fees, materials, shipping and ads.

Your Etsy dashboard shows sales, but not profit. This spreadsheet works out every fee on every order, takes off your product costs, shipping and advertising, and shows your real net profit, by month and by product.

Built for Etsy sellers who make and sell physical products: jewelry, candles, art prints, clothing, home decor, stickers and more.

WHAT'S INSIDE (9 connected tabs)

✔ Dashboard: revenue, total Etsy fees, COGS, shipping cost, ad spend, net profit, margin, orders, units, average order value and best seller, plus 4 automatic charts (revenue vs profit by month, fees by type, top 10 products by profit, orders by month)

✔ Orders: room for 1,000 rows. Pick a SKU from the dropdown and the product name, listing fee, transaction fee, payment processing fee, Offsite Ads fee, COGS, net profit and margin all calculate for you

✔ Products: SKU, material, packaging and labor time give your COGS per unit, profit per unit and margin (room for 200 products)

✔ Expenses: Etsy Ads, bulk supplies, subscriptions, tools, craft fairs and more, by category

✔ Monthly: month-by-month revenue, fees, COGS, shipping, ads, expenses, net profit and margin, plus a breakdown of every Etsy fee type

✔ Product Performance: units, revenue, profit, margin and share of profit for every SKU, with a top-10 list

✔ Pricing Calculator: enter your costs and target margin to get a suggested listing price after all fees, plus a "what if" table for 5 price points

✔ Settings: shop name, year, currency, your hourly rate and editable fee rates

✔ Start Here: a short step-by-step guide

WHY YOU'LL LOVE IT

• Every fee is calculated per order: listing, transaction, payment processing and Offsite Ads (with the per-order cap)

• Fee rates are editable. Etsy's fees vary by country and change over time, so you update one cell and everything recalculates

• Multi-item orders are handled: the fixed processing fee and the order count are applied once per order number

• Dropdowns for SKU, category, carrier and Offsite Ads mean fewer typing mistakes

• Works for any year and any currency

• No macros, no add-ins, no subscription

YOU WILL RECEIVE

1. Etsy_Seller_Profit_Tracker.xlsx: blank and ready to use
2. Etsy_Seller_Profit_Tracker_EXAMPLE.xlsx: a full year of sample data for a handmade jewelry shop (12 products, 250 orders) so you can see how it works

COMPATIBLE WITH

• Microsoft Excel (desktop, Mac, Excel for the web)

• Google Sheets (free): upload to Google Drive → Open with Google Sheets

• Not compatible with Apple Numbers

PLEASE NOTE

• This is a digital download. No physical item will be shipped.

• Default fee rates are Etsy's standard US rates. Please check Etsy's current fees for your country and adjust them in Settings.

• Figures are estimates to help you run your shop. They are not tax or accounting advice.

• Because this is a digital product, refunds are not offered, but please message me if you have any trouble opening the file.

• Not affiliated with Etsy, Inc.