Etsy Seller Profit Tracker

Find out what you really earn on Etsy, order by order. The Etsy Seller Profit Tracker is for handmade and digital Etsy sellers. Add your products and their costs once, log your orders, and it works out every Etsy fee plus your materials, labor and postage. You get the real profit on each order, each product and each month, and a pricing calculator that suggests a price for the profit margin you want. WHAT'S INCLUDED • Shop dashboard: revenue, Etsy fees, net profit, profit margin, orders, average order value, fees as % of revenue and profit per order, with a monthly chart, a cost-and-profit split and your top 5 products • Order log (1,500 rows): product dropdown, quantity, price, shipping charged, discount and Offsite Ad flag. Etsy fees, product cost, postage, profit and margin are calculated for you • Products (up to 40): physical or digital, list price, materials, your time, packaging and postage, with units sold, revenue, profit and margin • Profit & loss by month: sales, discounts, shipping, each Etsy fee type, product costs, your own costs (Etsy Ads, supplies, subscriptions) and net profit • Product ranking from most to least profitable • Pricing calculator: suggested price for your target margin, plus prices for 10% to 60% margins and your break-even price • Fee settings you can edit: listing fee, transaction fee, payment processing, Offsite Ads (with cap), currency conversion and labor rate • Start Here guide • Two files: a blank tracker and a filled-in example ABOUT THE FEES Fee defaults match Etsy's published fees for US sellers in 2026 ($0.20 listing, 6.5% transaction, 3% + $0.25 payment processing, 15% Offsite Ads). Etsy can change its fees, and rates differ by country, so please check Etsy's current fee page and update the Fee Settings tab. Sales tax and VAT aren't tracked. WORKS WITH • Microsoft Excel (2010 or later, Windows and Mac, and Excel online) • Google Sheets (free): upload the file to Google Drive and open it with Google Sheets HOW IT WORKS 1. Purchase and download instantly from your Etsy Purchases page. 2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets. 3. Check the fee settings, add your products, then log orders as they come in. PLEASE NOTE • This is a digital download. No physical item will be shipped. • Not made by or affiliated with Etsy. It doesn't connect to your Etsy account; you type in your orders. • Amounts are in US dollars ($). Currency formatting can be changed in your spreadsheet app. • For personal use. Please don't resell or share the file. • Not tax or financial advice. How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed. Questions? Send us a message. We usually reply within a day.