Salon Revenue & Commission Calculator Free Excel Template for Indian Owners

Enter what each stylist billed. Get the commission worked out on the right base, what the chair actually leaves you, and the two statutory checks that catch commission-heavy salons. Updated for the 5% GST rate that took effect on 22 September 2025.

  • Three payout models side by side: flat percentage, tiered slabs, and share above a target
  • Commission calculated after GST comes out, so you stop paying on tax that was never your money
  • The Code on Wages 50% check and the ESI test, run on every person on the floor, with a switch for salons not registered for GST
No spam. Instant download link to your email.
Petpooja presents
Revenue & Commission Calculator
For Indian Salons & Spas
6
Sheets · Excel template
FY 2026-27
What's Inside

Six sheets, one question: what does this chair actually pay you

01

Commission Calculator

One stylist, one month. Enter what they billed and how you pay them, and the sheet returns the commission, the total payout, and what that chair leaves you after the product it consumed.

02

Three Payout Models

Flat percentage, tiered slabs, and share above a target, all reading the same base. Switch model from a dropdown and watch the payout move without rebuilding anything. The slab thresholds are yours to set, not ours.

03

Team Payout for 12

One row per person, each on their own model, rate and product usage. You get what every person costs you per rupee of net revenue they generate, and their statutory wage base and ESI base worked out beside it.

04

The Month, End to End

Billing, GST payable, product used, staff cost, rent and the rest, ending in an operating profit and five ratios worth tracking month on month.

05

The Two Statutory Checks

The Code on Wages 50% add-back that commission-heavy pay triggers, and the ESI test that decides whether monthly commission joins the contribution base.

06

Rules & Sources

Every rate and rule used in the workbook with its section number and source, so you can check it yourself or hand the sheet to your CA.

Do all of this automatically with Petpooja Invoice

Petpooja Invoice calculates the GST on every bill automatically, so services and retail carry their own rates without anyone remembering which is which, tracks your retail stock in real time as you sell it, and consolidates all your outlets into one report.

Explore Petpooja Invoice
Why This Matters

The commission maths changed in September 2025

Most salon owners set a commission percentage once, write it on a slip of paper, and never look at it again. The percentage is rarely the problem. What it is charged on almost always is.

On 22 September 2025 beauty and physical well-being services, which is salons, barbers, spas, gyms and yoga alike, moved from 18% GST with input tax credit to 5% GST with no credit at all. Two things happened at once, and they pull in opposite directions.

The good news reached your customers: a ₹2,000 service that carried ₹360 of tax now carries ₹100. The bad news stayed with you. Every rupee of GST you pay on colour, developer, rent, electricity, equipment and software used to come back to you as credit. It does not come back any more. It is simply a cost.

So a commission model written before that date was written for a different business. It was built when your input tax came back, and it is being run in a year when it does not. That alone is reason enough to re-do the arithmetic.

Then there is the base. If your menu prices are GST-inclusive, and most salon menus are, the number on the bill is not your revenue. Five per cent of it belongs to the government from the moment the customer pays. Paying commission on the bill total means paying your stylist a share of the tax. On ₹4,00,000 of monthly billing at 15%, that is roughly ₹2,857 a month you never had to spend, repeating every month, for every stylist on that model.

The third thing nobody checks is what commission does to your statutory wage bill. Commission is excluded from wages under the Code on Wages, 2019, which sounds like good news until you read the proviso underneath. The Ministry of Labour's own FAQ on the Labour Codes is worth a read if you are restructuring pay this year. If the excluded parts of someone's pay come to more than half of what they earn, the excess is deemed remuneration and added back to wages. A low fixed salary with a big commission is exactly the shape that triggers it, and it moves the base for provident fund and gratuity.

That has a second edge worth knowing about. A minimum wage is measured against wages as the Code defines them, not against take-home. So a stylist on a small fixed salary and a large commission can be sitting below your state minimum on the statutory figure while their bank balance looks healthy. Check the fixed component on its own before you agree a new structure.

The same money behaves differently again for ESI. Commission counts as wages there only if you pay it at intervals of two months or less. Pay it monthly and it is in. Pay it quarterly and it is out. Most owners have never been told this, and it is a structuring decision with a real cash consequence.

This calculator does the whole chain in one place: strip the GST, take off the product the service consumed, apply whichever of the three models you actually use, and then run both statutory checks on the result. If you are still deciding between structures, the glossary entry on incentive pay sets out the common shapes and what each rewards. If you want to see how the same maths looks with your fixed salaries in it, our guide to payroll software for salons and spas covers the tools side, and the salon daily operations checklist covers the floor.

Sample Preview

What the sheet returns for a stylist billing ₹1,60,000 a month

GST-inclusive menu, ₹18,000 of retail sold, ₹22,000 of product consumed, ₹14,000 fixed salary, 15% on services and 5% on retail:

Net service revenue: ₹1,52,381. The other ₹7,619 of that ₹1,60,000 is GST, and it was never the salon's money
Commission on services: ₹22,857 at 15% of the net figure, against ₹24,000 if it had been charged on the bill total. The gap is ₹1,143 this month
Total payout: ₹37,620 including ₹763 of retail commission, which is 22.4% of the ₹1,67,635 of net revenue this stylist generated
Contribution from the chair: ₹1,08,015 after the ₹22,000 of product the services used, before rent, power and everything else
The 50% wage check: commission of ₹23,620 against half of total pay at ₹18,810, so ₹4,810 is added back and statutory wages become ₹18,810, not ₹14,000
... plus the ESI test, the team sheet for 12 people, the full month roll-up, and the sources behind every rule.
Key Stats

Three numbers that decide your commission bill

5% no ITC

GST on salon, spa and barber services since 22 September 2025, down from 18%, and with no input tax credit at all. The tax on your colour, rent and electricity is now a cost, not a credit.

Source: 56th GST Council, Annexure-III, S.No. 14; Notification 15/2025-Central Tax (Rate) dated 17-Sep-2025, effective 22-Sep-2025
50%

If commission and the other excluded parts of someone's pay come to more than half of their total remuneration, the excess is deemed remuneration and added back to wages. That moves the base for PF and gratuity.

Source: Code on Wages, 2019, section 2(y), first proviso, consolidated text as on 21-Nov-2025
Common Mistakes

7 commission mistakes Indian salons make

01

Paying commission on the bill total

If your menu prices include GST, 5% of every bill belongs to the government before it belongs to you. That portion is your output tax, collected on the government's behalf. Paying a share of it to your stylist is money out the door every single month, and it never shows up as a line item anywhere.

02

Paying on menu price after giving a discount

Run a monsoon offer at 20% off and the customer pays ₹1,600 on a ₹2,000 service. If commission is still calculated on ₹2,000, you funded the discount twice, once for the customer and once for the stylist.

03

Not taking off the product the service consumed

A global colour can burn through several hundred rupees of product, and your own purchase invoices will tell you exactly how much. Since September 2025 you cannot claim the GST on that back either. Decide deliberately whether commission comes before or after it, and write the answer down.

04

Charging one GST rate across the whole retail shelf

Hair oil and shampoo came down to 5% on 22 September 2025. Hair colour, serums, styling products and most make-up did not, and are still at 18%. One shelf, two rates, and the bill has to get both right. Restaurants hit the same wall in the same reform, which we covered in why a restaurant cannot choose 18%.

05

Writing "slab" in the contract without defining it

Does crossing ₹1,25,000 mean 15% on everything that month, or 15% only on the part above ₹1,25,000? Salons usually mean the first. The contract usually says neither, and the argument arrives on payday.

06

Assuming commission never touches the statutory wage base

It usually does not, but the Code on Wages adds back whatever the excluded components exceed half of total pay by. A ₹12,000 fixed salary with ₹20,000 of commission triggers it, and your PF and gratuity base moves with it. This is labour costing in the strict sense: the real cost of a person is not the number on their payslip.

07

Paying a rent-a-chair stylist as though they were staff

A freelancer is not on payroll. What you pay them is commission with tax deducted at source at 2%, under section 393(1) of the Income-tax Act 2025, which replaced section 194H on 1 April 2026. The threshold depends on what your salon is: ₹20,000 for the year if you are a company, LLP, firm or a "specified person", but ₹50 lakh if you are a smaller proprietorship. Most salons never check which side of that line they sit on.

Comparison

Working it out by hand vs this calculator

Aspect By hand, or on a register With this calculator
Commission base Whatever is on the bill Net of GST, and optionally net of product used
Discounted services Usually paid at menu price Paid on what the customer actually paid
Switching payout model Rebuild the sheet from scratch Change a dropdown, all three models are already in
Retail commission Same rate as services, or forgotten Its own rate, on retail revenue net of its own GST
The 50% wage rule Nobody runs it Run on every person, with the add-back shown in rupees
ESI treatment of commission Assumed the same as PF Tested against the two-month rule separately
Cost per chair Guessed from memory Payout as a share of the net revenue that chair generated
Where the rules come from Whatever the last accountant said Section number and source on a dedicated sheet

Swipe the table sideways to see the full comparison.

Stop paying commission on tax you never earned

Download the free calculator and re-run your payout on the base that is actually yours.

FAQ

Frequently asked questions

What GST rate applies to salon and spa services in 2026?
5% with no input tax credit. The GST Council names salons, barbers, health clubs, fitness centres and yoga, all sitting in Group 99972, "beauty and physical well-being services". A spa is not named in so many words, but its treatments fall in the same group, under 999723 for physical well-being or 999729 for other beauty treatment. The rate changed on 22 September 2025, following the 56th GST Council meeting. It was 18% with credit before that, and the Council has confirmed the 18%-with-credit option is no longer available. The lower rate is not free money: because no credit is available, the GST you pay on colour, rent, electricity and equipment is now a straight cost. Hotel rooms up to ₹7,500 a night moved the same way in the same reform, which we broke down in the guide to GST on hotel rooms. Our free GST calculator will split an inclusive price for you if you just need the arithmetic.
Should salon commission be paid on the bill amount or after GST?
After GST, on the net service value. If your menu prices are GST-inclusive, the tax portion of every bill is collected on the government's behalf and paid over, so it is not revenue you can share. Paying 15% commission on a ₹1,60,000 GST-inclusive month means paying about ₹1,143 more than paying 15% on the ₹1,52,381 that was actually yours. Whether product cost also comes off before commission is a commercial choice, not a legal one, but make it deliberately and put it in writing. If your turnover is below the registration threshold and you are not registered for GST at all, none of this stripping applies: the bill is the revenue. The workbook has a switch for that, and it takes every GST line to zero.
Does commission count as wages for PF and ESI?
They go opposite ways. Commission is expressly excluded from basic wages for provident fund under section 2(b) of the EPF & MP Act 1952, and excluded again under the Payment of Gratuity Act 1972, whose section 2(s) names commission in its exclusion list in as many words. For ESI it is the opposite: section 2(22) of the ESI Act 1948 counts additional remuneration as wages when it is paid at intervals not exceeding two months, so monthly commission is in and annual commission is out. Separately, the Code on Wages 2019 adds back whatever the excluded components exceed half of total remuneration by. The PF and ESI compliance checklist covers the filing side.
What GST do I charge on products I sell at the counter?
It depends on the product, not on the fact that a salon sold it. Hair oil and shampoo (HSN 3305), talcum and face powder (3304), shaving cream and aftershave (3307), toilet soap (3401) and combs, hairpins and curlers (9615) came down to 5% on 22 September 2025. Hair colour, developer, serums, masks, styling products, most make-up, perfume and nail preparations were not on that list and remain at 18%. Check the HSN on your supplier's invoice, or use the GST rate finder and HSN directory. Retail is a separate supply from your service, so credit on inputs used for both has to be reversed proportionately under section 17(2) of the CGST Act. The Council spelt this out at Q9 of its FAQs-2 dated 16 September 2025.
How do I pay a freelance or rent-a-chair stylist?
Not through payroll. A freelancer is paid a commission or fee, and tax is deducted at source under section 393 of the Income-tax Act 2025, which replaced section 194H of the 1961 Act from 1 April 2026. The rate is 2% where PAN is furnished and 20% where it is not. The threshold is not the same for everyone: a company, LLP, firm or an individual who meets the Act's specified-person test deducts once payments to that stylist cross ₹20,000 in the tax year, under Table Sl. No. 1(ii). A smaller proprietorship or HUF falls under Sl. No. 6(ii) instead, where the same 2% only bites above ₹50 lakh. Ask your CA which applies to you before you assume you must deduct. If they are registered for GST, they will also charge GST on their fee. Getting the employee-versus-contractor line wrong is expensive in both directions, and the contractor versus employee classification guide walks through the tests. Whatever you pay a salaried stylist still has to clear your state minimum wage, which the minimum wage calculator will check.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement Petpooja helps Indian businesses run better, every day.

Bill it right, and the commission maths starts from the right number

Petpooja Invoice generates GST-compliant bills with the tax calculated automatically on every line, so services and retail carry their own rates, keeps live stock as you sell, and consolidates all your outlets into one report.

Book a Free Demo Call: +91-92279 80766