Etsy & Small Shop Seller P&L 2026 | Excel Profit Tracker
Track Etsy / Shopify sales, fees, COGS & net profit with a monthly P&L dashboard and platform comparison.
Stop guessing whether your shop is actually profitable. The Etsy & Small Shop Seller P&L 2026 gives sellers a clean, original Excel system to:
- Set shop profile, platforms, fee % defaults, and optional tax set-aside %
- 2. Log every order (gross, shipping charged, discounts, platform & payment fees, refunds → net auto-calcs)
- 3. Track COGS & supplies (materials, shipping supplies, tools, packaging — optional linked order ID)
- 4. See this-month and YTD revenue, fees, COGS, net profit, margin %, MoM change, and set-aside estimate
- 5. Compare Etsy vs Shopify vs Other side-by-side
Includes a Quick Start PDF, markdown how-to, and optional CSV sales log template. Yellow cells = your inputs; blue cells = formulas. Sample data included so you can see the flow in under 10 minutes.
Features:
• Excel workbook: SALES LOG, COGS & SUPPLIES, MONTHLY P&L DASHBOARD, PLATFORM COMPARE (+ SETTINGS + START)
• Built for Etsy / Shopify / small online sellers (habit tool — not tax software)
• Auto net, profit, margin %, MoM, and tax set-aside estimate
• COGS tracker for materials, shipping supplies, tools & packaging
• Side-by-side Etsy vs Shopify vs Other after fees
• Quick Start PDF + HOW_TO_USE guide + CSV template · Instant digital download
• No macros — works in Excel & Google Sheets
Disclaimer: Organization and planning tool only — not tax, legal, or financial advice. Not affiliated with Etsy, Shopify, Square, PayPal, Stripe, or any platform. Consult a qualified professional.