All templates Free template · Excel · Barbershop

The free barbershop daily P&L template.

For shop owners and chair renters both: log the day’s cuts and services (cash and card), any product sales, product cost and tips passed through — and read tonight’s profit with your rent already sliced across the day.

Direct .xlsx download · no email required · Excel, Google Sheets, LibreOffice & Numbers

Sheet 1

Start here

Tax rate, card fee, monthly fixed costs (shop rent or your chair rent, insurance, booking app) and open days — set once.

Sheet 2

Daily P&L

Barbershop columns: service cash, service card, product sales, product cost, tips paid through (tracked, excluded from profit) → EBIT per day.

Built in

Chair-rent friendly

Renting a chair rather than running the shop? Put your chair rent in as the fixed cost and the sheet slices it across your days — the same maths, your numbers.

Built for how a barbershop actually takes money

A barbershop’s day is walk-ins and appointments, cash and card, the odd bottle of pomade or beard oil. This template maps exactly that: services split by how they were paid, product sales kept separate, and tips tracked but held out of profit. No categories you’ll never use, no double-entry — five inputs and tonight’s number.

Because so many barbers rent a chair rather than own the shop, the template works both ways. Owner? Your fixed cost is the shop rent and overheads. Chair renter? Your fixed cost is your chair rent, and the sheet slices it across your working days just the same, so your daily EBIT is the profit after your rent is paid — the number that actually tells you whether the week is working.

Tips and product: the two lines barbers get wrong

Tips move through the till but aren’t your revenue when they’re passed to the barber who earned them — counting them as takings flatters the day and inflates what you think you owe in tax. The template gives tips their own column so the drawer reconciles while profit stays honest.

Product is the opposite trap: it’s easy to treat a €12 pomade sale as pure profit and forget it cost you €6. Retail carries product cost, and at a barbershop’s volumes it’s a small but real margin that’s worth seeing separately — the template keeps product sales and product cost on their own lines so you know whether the shelf is earning or just decorating.

How to use it (after the last chair)

Once: in Start here, enter tax rate, card fee, your monthly fixed costs (shop or chair rent, insurance, booking software) and how many days a month you work.

Every night: fill today’s row — service cash, service card, product sales, product cost, tips passed through. The sheet nets tax and card fees, subtracts product cost and the day’s rent slice, and shows tonight’s EBIT beside the month to date.

Renting chairs to other barbers? The rent you collect is revenue and the rent you pay is a fixed cost — the free booth-rent vs commission calculator models which arrangement pays better before you set it.

When the notebook or spreadsheet stops keeping up

Plenty of shops run on a cash notebook and a gut feel for the good weeks. It works until it doesn’t — until you can’t say whether Tuesdays actually pay, or whether adding a Sunday would clear its own cost. A daily P&L answers those in numbers instead of memory.

The spreadsheet is the free way in. When entering it nightly gets old, nouz runs the same barbershop daily P&L in about 60 seconds on your phone and keeps the history so you can see your real pattern by day of week. Try the demo on sample data first — no account, no card.

Is it free, and do I need to give an email?

Free, no email, no sign-up. Direct .xlsx download; opens in Excel, Google Sheets, LibreOffice or Numbers.

I rent a chair — does this still fit me?

Yes, cleanly. Put your chair rent in as the monthly fixed cost on the Start here sheet; the template slices it across your working days, so your daily EBIT is your real take-home after rent. It’s arguably even more useful for a chair renter than a shop owner.

How are tips handled?

Tips passed to barbers get their own column, tracked so the till reconciles but kept out of revenue and profit. Any portion the shop keeps is revenue and goes in the service columns.

Does it track individual barbers’ takings?

Not by design — it’s a shop-level daily P&L to keep the nightly entry short. If you need per-barber numbers, add a note column or keep a second sheet; but the daily profit question is answered at shop level in five inputs.

Barbershop or salon template — which should I use?

They share the same engine. Use this one for a cuts-and-product barbershop; use the salon template if you carry a bigger retail range and colour/treatment product costs. Either works — pick the labels that match how you talk about your day.

Or skip the spreadsheet.

nouz runs the same daily P&L — formulas, fixed-cost slicing and history handled — for your barbershop. See it working with sample data first; no account needed.

Open the live demo