Seller Profit & Fee Dashboard for Etsy Shops — Order Profit, Fees and COGS (Excel & Google Sheets)

See 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.

Fee 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.

WHAT'S INSIDE

• Orders log — 1,500 rows; item, shipping, gift wrap, tax collected, discount, destination (domestic, US buyer, or international), refunds
• Estimated 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%)
• Canadian 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
• Discounts 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)
• US-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
• Override columns — type the fee from your statement to replace the estimate
• Optional Shopify and Payhip rows, with their own editable rates
• Products tab — optional, up to 80 names with a default cost of goods; you can also type a name directly on an order
• Dashboard — yearly snapshot, fees by type, monthly sales / fees / profit chart and margin
• Fee Rates tab — the official rates, the date they were checked, and a source note for each fee
• How to Use tab — short setup steps, including how to open the file in Excel or Google Sheets
• A blank copy for your own shop and a filled-in SAMPLE copy so you can see it working

WHAT YOU RECEIVE

Instant download after checkout:

• 1 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 > Import > Upload) or Microsoft Excel

This is a digital download. Nothing will be shipped.

WORKS WITH

Google Sheets (free Google account) and Microsoft Excel desktop. Mobile apps can view and edit, but a computer is easier for setup.

To open in Google Sheets: go to sheets.google.com, then File > Import > Upload and choose the .xlsx. Import it as a new spreadsheet.

PLEASE NOTE

• This 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.
• Tax collected is treated as a pass-through: it is in Gross and is taken out again before profit.
• Regulatory 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.
• The 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.
• Shopify and Payhip default rates are typical starting points, not official quotes. Edit them to match your plan.
• "Etsy" is used only as the name of the marketplace. This product is not affiliated with Etsy, Inc.
• If a file will not open, contact the shop and I'll help.

How 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.