Bookkeeping and P&L Spreadsheet for Hair Salons

Salon money comes from services, retail and sometimes chair rent, all through a booking app that takes its own cut. Most stylists only find out what they really earned when tax time arrives.

This workbook is set up for hair salons. It has 6 income categories (Haircuts & styling, Colour & highlights, Chemical & smoothing services, Extensions, Retail product sales, Booth / chair rent received) and 12 expense categories (Colour & chemical supplies (backbar), Retail stock for resale, Salon rent & utilities, Staff wages & commission, Booking software & POS, Laundry & towels, Tools & equipment, Education & classes, Licences & insurance, Marketing & social ads, Cleaning & sanitation, Repairs & maintenance), each with a note on what goes there, plus spare lines for your own. Fees kept by your card processor or platform are entered next to each sale and reported as their own expense line (card processing & booking-app fees).

The Monthly P&L totals every category by month, then shows net profit, margin, a tax set-aside at the rate you choose and your monthly client visits. The Dashboard compares any month with the year to date and tracks 5 trade KPIs against your targets: backbar cost % of service revenue; average ticket per client visit; retail share of revenue; retail product cost % of retail sales; payroll % of revenue. The Annual Summary gives quarterly totals, your best month, the largest cost and the receipts still missing.

Included: a worked-example copy filled with a fictional hair salon year, a blank copy, and a 6-page quick-start guide in US Letter and A4 (category map, KPI guide, worked example, tips for the trade). 7 sheets, 6,710 formulas, room for 1,000 income and 1,500 expense entries a year.

General information, not tax or accounting advice.