{"product_id":"etsy-small-shop-profit-fee-dashboard-order-profit-fees-and-cogs-excel-google-sheets","title":"Seller Profit \u0026 Fee Dashboard for Etsy Shops — Order Profit, Fees and COGS (Excel \u0026 Google Sheets)","description":"\u003cp\u003eSee what you actually keep after marketplace fees. Log each order, estimate listing, transaction, payment-processing, Offsite Ads and currency-conversion fees for Etsy shops (with optional Shopify and Payhip columns), subtract cost of goods and postage, and get a monthly profit dashboard.\u003c\/p\u003e\n\u003cp\u003eFee rates are filled in from official Etsy Help (checked 10 November 2026) and sit on a Fee Rates tab you can edit if Etsy changes them. If a statement differs, type the actual fee in the override column for that order — your payment account is the source of truth.\u003c\/p\u003e\n\u003ch3\u003eWHAT'S INSIDE\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eOrders log — 1,500 rows; item, shipping, gift wrap, tax collected, discount, destination (domestic, US buyer, or international), refunds\u003c\/li\u003e\n\u003cli\u003eEstimated Etsy fees — listing (extra-quantity method, documented on Settings), 6.5% transaction, payment processing by shop country (US, Canada, UK, Australia, Eurozone, or your own), Offsite Ads (15% or 12%, capped at US$100), 2.5% currency conversion, and the regulatory operating fee auto-filled from your shop country (Canada defaults to 0.50%)\u003c\/li\u003e\n\u003cli\u003eCanadian shops: choose “US buyer” for orders from the United States so the 3% + C$0.25 domestic processing rate is applied, not the 4% international rate. For every other shop country, US buyer uses that country’s International rate\u003c\/li\u003e\n\u003cli\u003eDiscounts reduce the transaction, processing, Offsite Ads, conversion and regulatory fee bases; refunds credit the transaction fee and a proportional share of the processing fee (per official Etsy Help)\u003c\/li\u003e\n\u003cli\u003eUS-dollar listing fee and Offsite Ads cap are converted at a USD-to-shop-currency rate that defaults to 1.00 if your currency is USD or your shop country is United States, and to 1.40 if your currency is CAD or your shop country is Canada (a CAD example). For any other currency, type the rate from your statement. Until that rate is entered, Etsy orders that need a listing fee or an Offsite Ads cap stay off the Dashboard and their profit stays blank. Official New Zealand processing rates are not pre-filled — type them from Etsy Help. VAT on seller fees is not estimated\u003c\/li\u003e\n\u003cli\u003eOverride columns — type the fee from your statement to replace the estimate\u003c\/li\u003e\n\u003cli\u003eOptional Shopify and Payhip rows, with their own editable rates\u003c\/li\u003e\n\u003cli\u003eProducts tab — optional, up to 80 names with a default cost of goods; you can also type a name directly on an order\u003c\/li\u003e\n\u003cli\u003eDashboard — yearly snapshot, fees by type, monthly sales \/ fees \/ profit chart and margin\u003c\/li\u003e\n\u003cli\u003eFee Rates tab — the official rates, the date they were checked, and a source note for each fee\u003c\/li\u003e\n\u003cli\u003eHow to Use tab — short setup steps, including how to open the file in Excel or Google Sheets\u003c\/li\u003e\n\u003cli\u003eA blank copy for your own shop and a filled-in SAMPLE copy so you can see it working\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWHAT YOU RECEIVE\u003c\/h3\u003e\n\u003cp\u003eInstant download after checkout:\u003c\/p\u003e\n\u003cul\u003e\u003cli\u003e1 ZIP containing the blank Excel (.xlsx) file, a filled-in SAMPLE copy, and a PDF with plain instructions for opening the file in Google Sheets (File \u0026gt; Import \u0026gt; Upload) or Microsoft Excel\u003c\/li\u003e\u003c\/ul\u003e\n\u003cp\u003eThis is a digital download. Nothing will be shipped.\u003c\/p\u003e\n\u003ch3\u003eWORKS WITH\u003c\/h3\u003e\n\u003cp\u003eGoogle Sheets (free Google account) and Microsoft Excel desktop. Mobile apps can view and edit, but a computer is easier for setup.\u003c\/p\u003e\n\u003cp\u003eTo open in Google Sheets: go to sheets.google.com, then File \u0026gt; Import \u0026gt; Upload and choose the .xlsx. Import it as a new spreadsheet.\u003c\/p\u003e\n\u003ch3\u003ePLEASE NOTE\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eThis is a record-keeping and estimating tool, not tax or accounting advice. Etsy can change fees. Please confirm current rates at etsy.com\/legal\/fees and on your payment account.\u003c\/li\u003e\n\u003cli\u003eTax collected is treated as a pass-through: it is in Gross and is taken out again before profit.\u003c\/li\u003e\n\u003cli\u003eRegulatory operating fee: filled in automatically from your shop country using Etsy's published rates (for example Canada 0.50%, UK 0.48%; none for US sellers). Type an override on Settings if you need a different rate.\u003c\/li\u003e\n\u003cli\u003eThe listing-fee estimate on each order is US$0.20 × (quantity − 1) for the extra-quantity fee Etsy charges when more than one unit sells, converted from USD. The first US$0.20 is charged when you create or renew a listing, not automatically on the first unit of the order. A setting lets you also assign one listing fee to every order, or you can type an override.\u003c\/li\u003e\n\u003cli\u003eShopify and Payhip default rates are typical starting points, not official quotes. Edit them to match your plan.\u003c\/li\u003e\n\u003cli\u003e\"Etsy\" is used only as the name of the marketplace. This product is not affiliated with Etsy, Inc.\u003c\/li\u003e\n\u003cli\u003eIf a file will not open, contact the shop and I'll help.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eHow this was made: I designed this template myself — I chose the layout, features and categories and wrote the instructions. I used AI tools to help draft formulas\/text and to speed up mockups, and I tested and edited everything by hand.\u003c\/em\u003e\u003c\/p\u003e\n","brand":"My Store 2","offers":[{"title":"Default Title","offer_id":46358936485957,"sku":"P005-ETSY-FEES","price":12.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0774\/0014\/5989\/files\/p005-01-hero_6068e949-ed92-41d8-8442-8d5e28438e7f.png?v=1794338959","url":"https:\/\/2ahuh5-qg.myshopify.com\/products\/etsy-small-shop-profit-fee-dashboard-order-profit-fees-and-cogs-excel-google-sheets","provider":"My Store 2","version":"1.0","type":"link"}