Etsy / Shopify Seller Bookkeeping Template

Your Etsy revenue is not your profit. This spreadsheet shows you the difference.

Track your true profit after platform fees (listing, transaction, processing, offsite ads), cost of goods sold, and business expenses. Built for Etsy and Shopify sellers with platform-specific fee calculations.

7 Professionally Designed Tabs

🛒 Sales Log — Order details + auto-calculated fees: Listing, Transaction, Processing, Offsite Ads, Total Fees, Net. 36 sample orders.
📦 COGS — Per-product costs: unit cost, packaging, shipping. 9 products.
💸 Expenses — Non-COGS business expenses by 11 categories. 25 entries.
📊 Monthly Summary — Revenue, Fees, COGS, Expenses, Net Profit, Margin by month.
🎯 Dashboard — 6 KPIs + revenue chart + top products + fee breakdown + expense breakdown.

Key Features

• Etsy fee auto-calculation — Listing ($0.20), transaction (6.5%), processing (3%+$0.25), offsite ads (15%).
• Shopify support — Switch platforms in Settings, fees adjust.
• COGS per product — Materials, packaging, shipping breakdown.
• Fee burden analysis — See what % of revenue goes to platform fees.
• Sample data — “Wildflower Prints” Etsy shop.

Paper+Spark charges $35+ for less. This does more for $17.