Salon & Spa Bookkeeping Spreadsheet

Stop doing payday math by hand. This Salon & Spa Bookkeeping Spreadsheet tracks every sale by provider, auto-calculates commissions, splits service vs retail revenue, and rolls everything into a monthly P&L, dashboard, and tax summary — no accounting software needed.

**What it does for you:**
– Service Providers tab — name, role, pay model (Commission or Booth Rent), separate service & retail commission % rates, monthly chair rent, active flag. Mixed teams work in ONE file.
– Daily Income Log — 400 rows: date, provider dropdown, service dropdown, service $, retail $, tip $, payment method. Commission owed and the salon’s share calculate AUTOMATICALLY per row from that provider’s rates.
– Commission Calculator — pick a month, see each provider’s service revenue, retail revenue, tips, commission earned, chair rent owed, and salon keeps. Provider payout = commission + tips, done in seconds.
– Expense Tracker — 300 rows with 15 pre-built salon categories (rent, supplies, retail products for resale, utilities, insurance, marketing, wages, laundry, licenses, professional fees, repairs, software, mileage, merchant fees, other).
– Monthly P&L — service revenue, retail revenue, chair rent income, total revenue, commissions paid, operating expenses, net profit, and profit margin, all auto-rolled from your logs. Negative months flag red.
– Dashboard — YTD revenue, profit, margin, revenue by provider (top performer highlighted), top 5 services, service-vs-retail split, and a monthly profit chart.
– Tax Summary — year totals per expense category, editable tax set-aside %, estimated tax to set aside. Country-neutral; organizing template only, not tax advice.
– Realistic sample month pre-filled (3 providers, services + retail + tips) so you can see every formula working, and a plain-English Start Here guide.

**What’s inside (.xlsx, works in Excel AND Google Sheets):** Start Here · Service Providers · Daily Income Log · Commission Calculator · 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.