Etsy Seller Profit Dashboard - Excel Template (Etsy Fee Calculator, Net Profit per Order, Pricing Calculator)

Find out what you really keep from every Etsy sale. Enter your products and orders (or paste them from Etsy's Order Items CSV) and this Excel template calculates every Etsy fee, your product and packaging costs, shipping labels and monthly fixed costs, then shows your real net profit per order, per product and per month. Pick a month from one dropdown and the whole dashboard updates.

Who it's for

• Etsy sellers who want to know their real profit after fees, not just their revenue
• Makers of candles, ceramics, jewelry, prints, stickers and other handmade or physical products
• Sellers who want to check whether a price still makes money after transaction, processing, listing and ads fees

Features

• Dashboard with 6 KPI cards: Revenue, Etsy fees (with % of revenue), Net profit, Profit margin, Orders (with units sold) and Average order value. Each card shows the change vs the previous month
• Month selector, including a "Latest month" option
• 12-month chart of revenue vs net profit, plus a profit breakdown: revenue − Etsy fees − product & packaging − shipping labels − monthly fixed costs = net profit
• "Where the Etsy fees go" chart: transaction, payment processing, listing, Offsite Ads, Etsy Ads and tax on fees
• Top 5 products by net profit, a list of loss-making products and a low-stock reorder list
• Orders sheet: for every order line it calculates listing fee, transaction fee, payment processing fee, Offsite Ads fee (with the per-order cap), tax on fees, total Etsy fees, product cost, shipping cost, net profit and margin, plus a check column. Shipping, the label cost and the fixed processing fee are counted once per Order ID
• SKU dropdown, and a column mapping for pasting from Etsy's "Order Items" CSV. US-style MM/DD/YY text dates are converted automatically
• Products sheet: unit and packaging cost, stock and reorder level. Shows units sold, revenue, profit, margin, stock status (Reorder) and profit status (Loss-maker) per product
• Settings: shop name, currency, USD exchange rate (for the fees Etsy sets in USD), every fee rate, optional VAT/tax on fees, 8 monthly fixed-cost rows and listing renewals
• Pricing Calculator: the listing price you need for a target profit or a target margin after all fees, solved exactly with a formula (no trial and error), with a .99 rounded suggestion, a check table and a "test your own price" column
• Yellow cells = your input. Formula cells are locked and hidden to prevent accidental changes

What's included (ZIP with 2 .xlsx files)

• Etsy_Seller_Dashboard_DEMO.xlsx: filled with 3 months of fictional sample data (an imaginary candle and home-decor shop, 60 orders, 10 products), so you can explore every feature
• Etsy_Seller_Dashboard_EMPTY.xlsx: ready for your own shop
• A Start Here guide sheet inside each file, with quick-start steps and the Etsy CSV column mapping

Requirements

• Microsoft Excel 2016 or newer (Windows or Mac) or Microsoft 365 desktop. No macros, no add-ins
• It also opens in LibreOffice Calc. Charts and fonts may look slightly different there
• Not designed for Google Sheets, Apple Numbers or Excel mobile apps
• Ready for 2,000 order lines and 200 products

Please note

• This is a digital download. No physical item will be shipped
• The fee rates are editable examples based on US Etsy fees (listing fee 0.20 USD, transaction fee 6.5%, payment processing 3% + 0.25, Offsite Ads 15% with a 100 USD cap). Fees differ by country and can change, so please check your own rates in your Etsy account and edit them on the Settings sheet
• This is a planning and monitoring tool, not bookkeeping or tax software. The results are estimates based on the numbers and rates you enter
• Not affiliated with or endorsed by Etsy, Inc. "Etsy" is used only to describe what the template is for
• The demo shop, its products, orders and numbers are fictional
• Because of the digital nature of the product, refunds are not offered, but message me if anything doesn't work and I'll help