BOMDOXI BOMDOXI

BOMDOXI / All products / Hair Stylist & Barber Business Manager

Pro Series · Excel + Google Sheets

Hair Stylist & Barber Business Manager

A complete workbook for independent hair stylists and barbers — booth renters, salon suite owners, commission stylists, mobile and home-studio pros. Visits take four fields, walk-ins one line. Color formula cards keep the shades, grams, developer and result for every client, work out the product cost and the extra color to charge, and check the allergy test before every color. Tips stay apart from service revenue, retention lists show who to call, and the work-model calculator answers the big question: booth, suite or commission?

€16.99on Etsy

Etsy shows the price in your currency at checkout.

Also available on Payhip · Gumroad

  • 22 tabs
  • No macros
  • No subscription
  • One-time purchase
Hair Stylist & Barber Business Spreadsheet: color formulas, tips, client retention and booth rent vs suite, for Excel and Google Sheets
  • Excel + Google Sheets
  • US Edition · English
  • Instant digital download
  • One-time purchase
US Edition

Hair Stylist & Barber Business Spreadsheet — Color Formulas, Tips, Client Retention & Booth Rent vs Suite

Log a visit in 4 fields, keep every client's color formula, see who hasn't come back and know what you really keep — in Excel or Google Sheets.

  • No subscription
  • No macros
  • Excel & Google Sheets
  • US Edition

Log a visit in 4 fields

  • Date, client (or Walk-in), service, how they paid — the rest is automatic
  • Walk-in batches in one line with Qty
  • No-show and late-cancel fees, deposits, tips shared with an assistant
  • Booking-platform new-client fees counted automatically

Color formula cards for every client

  • Shades and grams, lightener, developer and mix ratio, toner, timing, levels, result
  • Product cost per service and stock that goes down by the gram
  • Extra color to charge above the grams included
  • Allergy-test log and policy check before every color

Tips kept apart — always

  • Cash, card and app tips, tip % and tips shared
  • "No tax on tips" estimate (2025–2028)
  • 1099-K check; W-2 tip report by the 10th and paycheck check

Who hasn't come back?

  • Booked, active, due soon, overdue and lapsed clients
  • New clients who came back, rebooking and no-show rates
  • Sources and platform fees per client who stayed
  • Win-back lists and ready-to-send messages

Booth rent, suite or commission?

  • Five ways of working compared after costs and taxes
  • Break-even weekly revenue against commission
  • Minimum price per hour, price increases, memberships, braids and extensions

Run the business

  • Action Board every morning
  • Dashboard: revenue, tips, retail, what you kept, $ per chair hour
  • Product stock, gift cards, packages and memberships
  • Receipt, Event & Bridal Quote and Consultation & Consent to print
  • IRS mileage and 1040-ES tax set-aside
Show the full description (19 modules, specifications, what's included)Hide the full description

1. Start Here

A built-in guide with two paths — I'm a hair stylist · I'm a barber — the first 15 minutes, the weekly 10-minute routine, how the workbook works and the difference between service revenue, tips and retail.

    2. Dashboard

    • Cards: service revenue, tips (kept apart), retail, what you kept, $ per chair hour vs your minimum, rebooked before leaving, new clients who came back, clients due or lapsed, backbar & color spend, rent & chair fees, lost to no-shows, gift cards owed
    • Services, tips and retail by month; this year vs last year; top services; revenue by category; to-do list

    3. Action Board

    • Today & money: visits, cash to count, bookings for the next 7 days, rent paid or behind, renew / notice date, estimated tax, W-2 tip report
    • Clients: due & overdue, lapsed, new clients to follow up, move-ups and retwists due, birthdays, reviews to ask for, January bookings in Nov–Dec
    • Safety & stock: allergy tests needed for color in the next 3 days, stock to reorder, extra color not charged
    • Admin: gift cards, 1099-NEC, licenses, CE and insurance, referral credits, sales tax, entries to fix, my tasks

    4. Clients

    • Contact, birthday, source and referrer, hair texture (1–4C), density, porosity, level, gray %, allergies, cut recipe, text and photo consent
    • Automatic: visits, usual gap, next due, status, spent, average tip, no-shows, allergy status, platform fees, referrals
    • Up to 600 clients

    5. Appointments

    • Date, time, client or Walk-in, Qty, service and 2 add-ons, status, paid by, tip, rebooked
    • Extra columns: deposit, no-show fee, tip shared, extra color charged, gift / package / membership code, location, miles, notes
    • Automatic: price, minutes, new client, product cost, card and app fees, platform fee, salon's share, sales tax, your income and tip
    • Up to 4,000 visits

    6. Color Formulas

    • Color, lightening, toner / gloss, texture, extensions, allergy and strand tests
    • Up to 4 shades with grams, lightener, developer and ratio, bond additive, toner, time, heat, levels, result, photo link
    • Automatic: developer grams, product cost, extra color to charge, allergy-test check
    • Up to 1,500 cards

    7. Client Card

    • One page per client: profile, allergy status, last 5 formulas, last 8 visits — printable

    8. Retail Sales

    • Products sold and returned, discount, sales tax, cost, margin, retail commission
    • Up to 1,000 sales

    9. Gift Cards & Packages

    • Gift cards, prepaid packages and monthly memberships: balances, visits left, still owed, price per visit, cost of the visits, status
    • Warns about gift-card expiry under 5 years
    • Up to 300

    10. Event & Bridal Quote

    • Up to 12 people, travel, early start, assistant, service charge or optional gratuity, sales tax, deposit, balance due date, terms, signatures

    11. Receipt & Invoice

    • Services, extra color, tips, deposits and products on separate lines

    12. Consultation & Consent

    • Client history, consultation questions, patch and strand test, estimate with grams included, consent and policy, signatures (with parent / guardian line)

    13. Client Retention

    • Return rate, rebooking, no-shows, usual gap, status counts, sources with platform fees, win-back / due / new-client / top-15 lists, five messages

    14. Tips & Income Report

    • Month by month: service revenue, tips by method, tips shared, your tips, retail, gift cards, fees, salon's share, what you kept
    • "No tax on tips" estimate, 1099-K check, W-2 tip report and paycheck check

    15. Work Model Comparison

    • Commission (W-2), booth rent, salon suite, mobile, home studio; quick answers, optional details, take-home after tax, break-even, $500–$4,000 sensitivity chart

    16. Price Calculator

    • Minimum price per active hour, price check, price increase, membership check, long services

    17. Service Menu · 18. Product Stock

    • 72 services with minutes, price, product cost, grams included, return weeks, deposit, allergy test, Price Health
    • 39 products, retail and backbar, with stock and reorder alerts
    • Up to 150 services and 200 products

    18. Expenses · 20. Mileage Log · 21. Tax Set-Aside

    • Expenses by category with stock purchases and assistant pay (1099-NEC); up to 1,500
    • IRS mileage rate by trip date; up to 800 trips
    • Monthly set-aside, sales tax apart, four 1040-ES payments, savings for the slow season, time off, education and tools

    19. Settings

    • Business details, license line, work model and rent, chair hours, card and app fees, booking platforms, allergy-test and no-show policies, extra-color pricing, retention alerts, taxes, printed texts and messages, licenses, CE and insurance, lists

    Note: a planning estimate, not tax advice. Ask your tax professional.

    Specifications

    EditionUS Edition (version 1.0)
    Sheets22 tabs
    SoftwareMicrosoft Excel 2019 or newer, Microsoft 365; Google Sheets
    CurrencyUS dollars ($)
    Date formatMM/DD/YYYY
    Clients · VisitsUp to 600 · 4,000
    Formula cards · Retail sales1,500 · 1,000
    Gift cards & packages300
    Service Menu · Product Stock72 services · 39 products pre-filled (up to 150 · 200)
    Expenses · Trips1,500 · 800
    ProtectionFormula cells locked in Excel, no password; warning mode in Google Sheets
    Macros · Add-ons · SubscriptionNone · None · No subscription

    Who it's for

    • Booth renters and chair renters
    • Salon suite owners
    • Commission stylists who want to check their pay — or plan to go independent
    • Barbers, including walk-in shops and membership barbers
    • Colorists, braiders, loc and extension specialists, mobile and bridal stylists, home-studio stylists

    What's included

    • READY (.xlsx)
    • DEMO (.xlsx): a fictional salon suite in Austin, Texas
    • Google Sheets Access
    • Quick Start Guide (3 pages)
    • User Guide (26 pages)

    A closer look

    Good to know before you buy

    We'd rather you know exactly what you're getting.

    • A business tool; it is not a booking calendar and does not send reminders, take payments or file taxes.
    • Not legal, medical, tax or accounting advice. Follow the color maker's instructions for allergy and strand tests.
    • Licensing, booth-rental, mobile-service, sales-tax and gift-card rules vary by state — check yours.
    • Prices and costs are illustrative late-2026 US examples to set to your own.
    • Requires Excel 2019 or newer; Excel 2016 and earlier are not supported.
    • Your data stays in your own file or Google Drive copy.

    Get the Hair Stylist & Barber Business Manager

    One-time purchase. Instant digital download.

    Etsy is our main store. The same product is also on Payhip and Gumroad.
    €16.99on Etsy

    Etsy shows the price in your currency at checkout.

    Also available on Payhip · Gumroad

    You might also like

    Pro SeriesPersonal Trainer Business Manager spreadsheet
    Excel & Sheets

    Personal Trainer Business Manager

    Track every package and session, renew clients before their last session, and price from your own numbers, in Excel or Google Sheets.

    • US Edition
    €16.99
    Pro SeriesHome Bakery Business Manager spreadsheet
    Excel & Sheets

    Home Bakery Business Manager

    Cost every recipe, price every cake, plan your baking days and print cottage food labels, in Excel or Google Sheets.

    • US Edition
    €16.99