A salon needs three things in a sheet: what was sold each day, what commission each staff member earned, and what the products and fixed costs ate up. Keep commission rates in a Settings tab so you can change them without editing formulas, and let a lookup pull the rate for every sale. Here is a layout that works in Excel and Google Sheets.
What does the Settings tab hold?
Two small tables. The first lists staff names with their commission percentage. The second lists services with their usual price. Both are yours to edit; nothing in the formulas is fixed to a rate.
| Staff | Commission rate (sample) |
|---|---|
| Meena | 30% |
| Rekha | 25% |
| Sunita | 20% |
The rates above are invented to show the layout. Set them to whatever you have agreed, and note whether commission is on top of a fixed salary or instead of it.
How do you log daily sales?
On a Sales tab, add one row for each service done: Date, Service, Staff, Price, Payment mode and Commission. The price can be looked up from Settings or typed in, since discounts and festival offers change it.
In the Commission column use XLOOKUP in Excel 365 or 2021:
=D2*XLOOKUP(C2, Settings!$A$2:$A$20, Settings!$B$2:$B$20, 0)
In older Excel or Google Sheets use VLOOKUP instead:
=D2*VLOOKUP(C2, Settings!$A$2:$B$20, 2, FALSE)
Both look up the staff name in C2 and multiply the price by the rate. The XLOOKUP version gives 0 when the name is not found; the VLOOKUP version shows an error, which is a useful warning that a name is misspelled.
What does a sale look like?
Say a facial priced at ₹1,500 is done by Meena at 30%. Her commission is 1,500 x 0.30 = ₹450 and the salon keeps ₹1,050 before product and fixed costs. Another service, a haircut at ₹400 by Sunita at 20%, earns her ₹80. These are sample numbers.
How do you track products used?
Products are cost without a visible bill. Add a Products tab with product name, price paid, units per bottle or pack and the units used on each service. The cost per use is the price divided by the units. For simple tracking, use a flat product cost per service type, say ₹120 for a facial, and review it when supplier prices change. A rough number you update beats a perfect one you never enter.
How do you get the monthly profit view?
On a Monthly tab, with the first of each month in column A:
- Sales: =SUMIFS(Sales!$D$2:$D$2000, Sales!$A$2:$A$2000, ">="&A2, Sales!$A$2:$A$2000, "<"&EDATE(A2,1))
- Commission: the same SUMIFS on the Commission column
- Staff-wise commission: add a staff name criterion, Sales!$C$2:$C$2000, $E1
- Profit: sales minus commission minus products minus rent, electricity and salaries typed in monthly
What should you review monthly?
- Which services bring the most money after commission and products.
- Whether one staff member's commission is growing faster than their sales.
- Whether the product cost per service still matches what you paid last time.
How do you handle packages and memberships?
When a customer pays upfront for a package of sessions, record the payment as received but log each session as it is delivered, with a price equal to the package price divided by the sessions. That way commission is calculated on delivered services and the money received in advance is visible as a separate number. Decide with your staff, and write down, whether commission is earned when the package is sold or when each session is done.
If a customer pays by UPI and you offer a discount, enter the price actually charged, so commission follows the real money received.
Your rent, supplier and electricity payments live on your bank and card statements. If you import them into SpendixAI, you can see those costs by category and carry the totals into your monthly sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


