Etsy Seller Profit & Bookkeeping

Etsy seller spreadsheet with a profit calculator and bookkeeping in one Excel workbook. Price every product with real Etsy fees, log orders and expenses, and see what you actually kept each month.

WHAT IT DOES

• Pricing calculator: Etsy fees, cost, profit and margin per product, plus your break-even price and the price that hits your target margin (100 products)
• Every fee, every order: transaction fee, payment processing (domestic or international), listing renewals, Offsite Ads with the per-order cap, and optional regulatory or currency-conversion fees, worked out line by line (1,000 orders)
• Country presets for payment processing: United States, Canada, United Kingdom, EU (euro), Australia, New Zealand, or your own rates
• Expenses log with categories: supplies, packaging, shipping labels, Etsy Ads, software and more (500 entries)
• Monthly profit and loss: sales, Etsy fees, expenses and profit by month, fees by type and expenses by category
• Optional GST/HST/VAT/sales tax columns for registered sellers, with an estimate of tax to remit
• Dashboard: sales, Etsy fees as % of sales, expenses, profit and average order for the year
• Any currency

WHAT YOU GET

• Etsy-Seller-Profit-Bookkeeping.xlsx (blank)
• Etsy-Seller-Profit-Bookkeeping-with-Sample-Data.xlsx (a filled-in example year)
• Quick-start guide (PDF)

HOW YOU GET IT

Digital download. After checkout you get a download page right away, plus a receipt by email. Nothing is shipped.

COMPATIBILITY

• Microsoft Excel 2016 or newer (Windows or Mac) and Excel for the web
• Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
• Needs a computer or tablet with a spreadsheet app

PLEASE NOTE

Fee presets were checked against Etsy's published fee policy in September 2026. Etsy can change fees, and every fee rate is editable in Settings. This is a bookkeeping helper, not tax or accounting advice. Not affiliated with or endorsed by Etsy, Inc. Licensed for use in your own shop; please don't resell or share the files.

DISCLAIMER

This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor, lawyer or certified tradesperson). Check the results before you rely on them.

HOW IT WAS MADE

Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.

QUESTIONS

Email varsdigitals@gmail.com and we'll help you get set up.