Bookkeeping and P&L Spreadsheet for Etsy Sellers

An Etsy payout is sales minus transaction fees, processing fees, listing fees, Offsite Ads and shipping labels, so the deposit never matches what you sold. This workbook rebuilds the real picture: gross sales, every fee, cost of materials and true profit per order.

This workbook is set up for etsy sellers. It has 6 income categories (Etsy item sales, Shipping charged to buyers, Digital download sales, Website & other channel sales, Craft fair & market sales, Wholesale & consignment) and 11 expense categories (Materials & supplies, Packaging & shipping supplies, Postage & shipping labels, Etsy Ads & Offsite Ads, Equipment & tools, Product photography & props, Software & subscriptions, Craft fair & market fees, Studio & workspace, Samples & prototypes, Education & courses), each with a note on what goes there, plus spare lines for your own. Fees kept by your card processor or platform are entered next to each sale and reported as their own expense line (etsy fees (transaction, processing, listing)).

The Monthly P&L totals every category by month, then shows net profit, margin, a tax set-aside at the rate you choose and your monthly orders shipped. The Dashboard compares any month with the year to date and tracks 5 trade KPIs against your targets: etsy fees + ads % of etsy sales; average order value; materials cost per order; shipping cost recovery; profit per order. The Annual Summary gives quarterly totals, your best month, the largest cost and the receipts still missing.

Included: a worked-example copy filled with a fictional Etsy shop year, a blank copy, and a 6-page quick-start guide in US Letter and A4 (category map, KPI guide, worked example, tips for the trade). 7 sheets, 6,692 formulas, room for 1,000 income and 1,500 expense entries a year.

General information, not tax or accounting advice.