Barbershop Profit Tracker Excel for your barbershop — service pricing, daily appointment logs, barbers and chair rent, and a monthly P and L dashboard. Know what every cut actually costs — and whether the month actually…
About this template
Barbershop Profit Tracker Excel for your barbershop — service pricing, daily appointment logs, barbers and chair rent, and a monthly P and L dashboard. Know what every cut actually costs — and whether the month actually made money. Built for barbershops, barbers, and small shop owners who need to know, service by service and chair by chair, whether the price covers the products, the barber, and the rent — without accounting software. If a service is losing money, this workbook shows it before the next price list.
$39
Excel & Google Sheets template — instant download on Etsy
Services and Pricing — minutes per service, product and booking fee cost per service, cost per service, price per service, and margin in dollars and percent for every service. Change a product cost and every log profit updates by formula.
Appointments and Sales — date, barber and chair, job type (Walk-In, Booked, Kids, Wedding/Group), service, services performed that day, price per service, revenue, cost per service pulled from the pricing sheet, profit, and margin. One row per barber per day.
Barbers and Chair Rent — barber, payment model (Chair Rent or Commission), services, service revenue, chair rent, commission percent, shop share, and barber pay. Shop share is the chair rent for rent barbers, or revenue times the commission percent for commission barbers.
Monthly P and L — revenue, job cost, barber payouts, shop rent, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and job cost are formulas from the Appointments sheet.
Dashboard — total revenue, services performed, average job value, gross and net profit and margin, best service by margin dollars and by margin percent, best-selling service, best day and best job type, costs by category, total shop share, and total barber pay.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Barbershop Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Barbershop Profit Tracker track?
The Barbershop Profit Tracker tracks Services and Pricing; Appointments and Sales; Barbers and Chair Rent; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 3,049 from 20 daily logs and 93 services; average job value 152.45.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.