All templates Free template · Excel · Salon & barbershop

The free salon P&L template.

Five lines at the reception desk after the last client: service revenue (cash and card), retail sales, today’s product cost, tips passed through — and the sheet answers the only question that matters: did today pay?

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

Sheet 1

Start here

Tax rate, card fee, monthly fixed costs (chair rent or salon rent, insurance, software) and open days — the once-only setup.

Sheet 2

Daily P&L

Salon columns: service cash, service card, retail revenue, product & supply cost, tips paid through (tracked for the till, excluded from profit) → EBIT per day.

Built in

Service vs retail split

Running totals for service and retail revenue, so you can see the mix that pays — and whether retail is earning its shelf space.

A salon P&L is five lines, not a bookkeeping course

Salon accounting tools want you to categorize everything. At 8pm after nine clients, you won’t — and you don’t need to. A working salon P&L is five entries: service revenue cash, service revenue card, retail sales, today’s product and supply spend, tips passed through to staff. Everything else — tax, card fees, the daily slice of rent — is arithmetic the sheet does for you.

That five-line discipline is the whole reason it gets filled in. Every extra field you’d add is a field you’ll eventually skip, and a skipped field is the beginning of an abandoned tracker. Five lines takes ninety seconds standing at the desk, which is short enough to survive a bad day.

Tips, and why they’re not your revenue

Tips deserve one honest note. Tips you pass through to stylists move through your till but are not your money — treating them as revenue inflates your takings and your tax base both. This template gives tips their own column, tracked so your drawer reconciles at the end of the night, and keeps them out of the profit line entirely.

If you keep a service charge or retain part of tips, that portion is revenue and goes in the service columns instead. The rule is simple: money that ends up in a stylist’s pocket is a pass-through; money that stays in the business is revenue. The template’s separate tips column makes that line easy to hold.

The service-vs-retail mix that quietly decides your month

Two salons with identical takings can have very different profit, because a service euro and a retail euro don’t cost the same to earn. The template keeps running totals for both, so you can see your mix forming day by day. Retail carries product cost and shelf space; if its margin isn’t covering that, you’ll see it here in a week rather than discovering it at stocktake.

For chairs specifically, pair the template with the free revenue-per-chair calculator to see which stations actually pay their rent — the daily P&L tells you whether today worked; the calculator tells you which chair carried it.

How to use it (90 seconds at the desk)

Once: in Start here, enter tax rate, card fee, your monthly fixed costs and how many days a month you open. Renting a chair rather than a whole salon? Your chair rent is the fixed cost — put it here.

Every night: fill today’s five cells. The sheet computes net revenue, subtracts product cost and the day’s fixed slice, and shows today’s EBIT next to the month so far. When entering it at the desk each night starts to feel like a chore worth automating, nouz for salons is the same five lines in about 60 seconds on your phone — try the demo first, no account needed.

Is this really free, no email?

Yes. Direct .xlsx download — no form, no “free trial” disguise. Works in Excel, Google Sheets, LibreOffice and Numbers.

Daily or monthly — which does this template do?

Daily rows with a month-to-date summary, so you get both: tonight’s answer and the month forming in real time. If you only want a month-end version, fill it weekly — the formulas don’t mind.

How do tips work in the sheet?

Tips passed through to stylists get their own column, tracked so your till reconciles but kept out of revenue and profit. Any tip portion the business keeps is revenue and goes in the service columns instead.

How do I handle booth rent vs commission staff?

Your own chair/booth rent is a fixed cost (Start here sheet). Commission you pay out on services is a variable cost — put it in the day’s product & supply column or the notes. The free booth-rent vs commission calculator compares the two models properly.

What if I miss a few nights?

Backfill from your booking system and till — it takes minutes. But if you’re missing nights every week, that’s the spreadsheet’s honest limit: nouz keeps the same daily P&L running with the math, history and reminders handled. The demo is open, no account needed.

Or skip the spreadsheet.

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

Open the live demo