2027 Seller Planner | Etsy & Small Shop Spreadsheet: Sales, Fees, Inventory & Tax Set-Aside for Excel & Google Sheets

Know what your shop really made in 2027 after fees, materials and shipping, and how much to set aside for taxes.

What it does:

• Setup tab: your fee rates (filled with Etsy's published US rates as an example: 6.5% transaction, 3% + $0.25 payment processing, $0.20 listing, 15% offsite ads) and your tax set-aside %. Change them to match your platform.
• Products & inventory: price, cost to make and starting stock. Units sold, stock left (red at 5 or fewer), gross sales and profit per unit fill in automatically.
• Sales log: pick a SKU from the dropdown; product name, item total, fees, cost of goods and profit calculate. Mark offsite-ad sales Y and the extra fee is added.
• Expenses: supplies, packaging, labels, ads, software, with a category dropdown.
• Dashboard: orders, units, gross sales, fees, cost of goods, shipping, expenses, profit, tax set-aside and what you keep, for each month and the year, plus a sales vs profit chart.

What you get: one .xlsx file (Excel 2016+, Microsoft 365, Excel for the web; imports into Google Sheets) plus a short how-to. Instant digital download.

Honest notes:

• Products, numbers and fee rates in the file are examples. Platform fees change and vary by country; check yours.
• It doesn't connect to Etsy or any shop; you type or paste your sales.
• The tax set-aside is a simple % estimate, not tax advice.

You might also like

• Etsy Fee & Profit Calculator: price one item before you list it.
• Small Business Bookkeeping spreadsheet: full income and expense books.