Hair Stylist & Barber Business Spreadsheet — Color Formulas, Tips, Client Retention, Booth Rent vs Suite | Excel + Google Sheets (US Edition)
Hair stylist and barber business spreadsheet for Excel & Google Sheets: color formula cards for every client, tips kept apart from service revenue, client retention, product stock, a booth rent vs suite vs commission calculator and an Action Board that tells you who to call today. US Edition.
One workbook for your chair — built for stylists and barbers, not re-skinned. Log a visit in 4 fields, keep every color formula, see who hasn't come back, and know what you really keep after rent, fees and taxes.
✅ LOG A VISIT IN 4 FIELDS • Date · client (or Walk-in) · service · how they paid — price, minutes, card and app fees, sales tax and your tip are worked out • Walk-ins in one line: "6 fades, cash" = Qty 6, done • No-shows and late cancels with the fee you charged, deposits, tips shared with an assistant • Booking-platform new-client fees counted automatically (StyleSeat, Booksy, Fresha — editable)
✅ COLOR FORMULA CARDS FOR EVERY CLIENT • Up to 4 shades with grams, lightener, developer volume and mix ratio, toner, bond additive, processing time, levels and result • Product cost per service from your grams and your stock costs — and the stock goes down • Extra color to charge: grams above what the service includes, by the bowl or by the gram • Allergy (patch) test log with your policy: before every color, every 6 or 12 months, or new clients only — warns before a color visit without a valid test • Texture services and extensions: move-ups, retwists and toners coming due
✅ CLIENT CARD & CONSULTATION FORM • One page per client: contact, usual gap, next due, hair profile, allergy status, cut recipe, last 5 formulas and last 8 visits • Printable Consultation & Consent form with the client's history, patch-test boxes, estimate and signatures
✅ TIPS KEPT APART — ALWAYS • Services, tips and retail never mixed: tips by cash, card and app, tip %, tips shared • "No tax on tips" estimate for tax years 2025–2028 (barbers and hairstylists are on the IRS list) • 1099-K check against your processor totals • Commission (W-2): tips to report to the salon by the 10th and a paycheck check
✅ WHO HASN'T COME BACK? • Status for every client: booked, active, due soon, overdue, lapsed • New clients who came back, rebooked before leaving, no-show rate, usual gap for barber and other clients • Where clients come from — and what each booking platform really cost per client who stayed • Win-back, due and new-client lists with phone numbers, plus ready-to-send messages
✅ BOOTH RENT, SUITE OR COMMISSION? • Compare commission (W-2), booth rent, salon suite, mobile and home studio with your own numbers • Take-home after costs and payroll or self-employment tax, and the weekly revenue where each model beats commission • Price Calculator: your minimum price per hour, price checks, price increases, memberships and braids / extensions
✅ STOCK, GIFT CARDS & PRINTABLES • Product stock for retail and backbar: bought, used in services, sold, on hand, reorder alerts • Gift cards, packages and monthly memberships with balances, visits left and what you still owe • Printable Receipt, Event & Bridal Quote (travel, early start, service charge, deposit) and Consultation form
✅ YOUR ACTION BOARD — EVERY MORNING Cash to count, rent paid or behind, clients due and lapsed (with phones), allergy tests needed for color booked in the next 3 days, stock to reorder, extra color not charged, licenses and insurance expiring, gift cards and your own task list.
✅ MONEY, MILEAGE & TAXES (US) • Dashboard: service revenue, tips, retail, what you kept, $ per chair hour, rebooking, retention, backbar %, rent %, no-shows • Expenses with stock purchases, assistant pay and the 1099-NEC reminder • Mileage Log with the IRS rate by date; Tax Set-Aside with the four 1040-ES payments and savings for the slow season
WHY PRO SERIES? Most hair stylist spreadsheets track income, expenses, rent and tips. Pro Series adds color formula cards with product cost and allergy-test checks, client retention, a booth vs suite vs commission comparison, product stock, gift cards and memberships, printables and the Action Board — 22 tabs, every row checked by an independent re-calculation and four scenario tests before release.
WHAT'S INCLUDED • READY workbook (.xlsx) — clean, with 72 services and 39 products to set to your prices • DEMO workbook (.xlsx) — a full sample year for a fictional salon suite • Google Sheets versions (READY and DEMO) — menus and protection ready; Google Sheets Access PDF with your Make-a-copy links • Quick Start Guide (PDF) • User Guide (PDF, 26 pages) — every tab, worked examples, FAQ
GOOD TO KNOW • Works in Microsoft Excel 2019 or newer / Microsoft 365 (Windows and Mac) or Google Sheets (also in the Google Sheets phone app) • No macros, add-ons or subscription. Your data stays in your own file • Not a booking calendar — keep your booking app for appointments and reminders • US Edition: US dollars, MM/DD/YYYY dates, IRS mileage rates, Form 1040-ES quarters, 1099-K and 1099-NEC checks • Up to 600 clients, 4,000 visits and 1,500 formula cards per workbook • Prices are illustrative late-2026 US examples — set your own • Digital download — no physical item will be shipped • An organizational tool — not legal, medical, tax or accounting advice. Licensing, booth-rental, sales-tax and gift-card rules vary by state
BOMDOXI — Simple tools. Smarter work.