Etsy + Shopify Bookkeeping Pack with Fee Calculators

Sell on Etsy AND Shopify? Stop guessing what you actually keep. This bookkeeping pack calculates your real profit after every fee on both platforms — with fee rates you can update anytime, so the math never goes stale.

**What it does for you:**
– TWO fee calculators — one for Etsy (listing, 6.5% transaction, 3%+$0.25 processing, Offsite Ads toggle, regulatory fee) and one for Shopify (your plan’s card rate auto-applied: Basic 2.9%, Grow 2.7%, Advanced 2.5% + $0.30, plus third-party gateway fee). Enter price, quantity, shipping, discount and unit cost → net profit and margin % appear instantly.
– Adjustable fee rates on Start Here — when Etsy or Shopify changes a fee, update it once and every calculator plus the whole Sales Log recalculates. No stale hardcoded math.
– Sales Log (500 rows) — log every order, pick the channel (Etsy/Shopify dropdown), and fees, net profit and margin % calculate per order automatically.
– Expense Tracker (300 rows) — tax-relevant category dropdown (materials, packaging, advertising, Shopify subscription, mileage, home office, professional services…).
– Monthly P&L — gross revenue, Etsy fees vs Shopify fees (separate columns so you see which platform costs more), COGS, expenses, net profit and margin %, auto-rolled by month.
– Dashboard — YTD revenue/profit, profit by channel, fees paid by channel, overall margin, order count, average order value, top-5 products by net profit, monthly profit chart, tax set-aside preview.
– Tax Summary — income and expense totals by category for your tax year plus an adjustable country-neutral tax set-aside estimate (not tax software — hand the totals to your preparer).
– 24 realistic sample orders (mixed Etsy + Shopify) and 17 sample expenses pre-filled so you can see every formula working before you type a number.
– Locked formula cells on every sheet (password disclosed in Start Here), IFERROR throughout, and only formulas that work identically in Excel and Google Sheets.

**What’s inside (.xlsx, works in Excel AND Google Sheets):** Start Here (instructions + fee setup) · Fee Calculator – Etsy · Fee Calculator – Shopify · Sales Log · Expense Tracker · Monthly P&L · Dashboard · Tax Summary.

Instant download. No shipping, no waiting. Message us if you need help setting it up — we answer fast.