Etsy Seller Spreadsheet: Bookkeeping, Fee & Profit Calculator (Google Sheets + Excel)

NEW in v1.3: pick your seller country (UK, France, Canada, Italy, Spain, Hungary, Türkiye, Vietnam, India and more) and Etsy's Regulatory Operating Fee and payment processing fee fill in automatically.

Optional VAT/GST on Etsy fees is included in every order's fees and your net profit. US sellers get the same results as before.

Stop guessing what Etsy leaves you after fees.

Enter an order (quantity, price, shipping, discount, sales tax, Offsite Ad yes/no). The sheet calculates the transaction fee, payment processing, Offsite Ads fee (with the $100 cap), listing renewals and your net. Your dashboard, quarterly totals, chart and year summary update automatically.

What's inside (v1.3):

Settings: every Etsy fee rate is editable (defaults = Etsy US rates, checked Nov 2026). Change the Year to see any year.

Sales Log: 500 order rows. Item dropdown, automatic fees, refunds and fee credits.

Expenses Log: 500 rows, 6 categories (dropdown).

Product Calculator: profit per sale, margin, and the price you need for your target margin.

Dashboard: 12 months + Q1–Q4 of orders, sales, fees, refunds, expenses, net profit and profit margin, a sales-vs-profit chart, and results by product.

Year Summary: accountant-ready totals and a suggested tax set-aside (% you choose).

Colour-coded: yellow = you type, grey = formulas.

Blank copy + worked example (fictional shop) + 1-page Quick Start PDF.

Works in Google Sheets (upload, then File > Save as Google Sheets) and Excel 2010 or newer. No Microsoft 365 needed, no macros, no add-ons.

Good to know: manual entry (no Etsy CSV import yet). Fees are estimates from the rates you set; your Etsy statement is the source of truth. Instant digital download.

Organizes your numbers only; not tax, legal or accounting advice. Not affiliated with, endorsed by, or sponsored by Etsy, Inc.