Beauty Parlour Management System in Excel: Packages, Sessions, Product Stock, Staff Incentive and Bills

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: beauty-parlour-management-system-template.xlsx: a 9-sheet system with example data and real formulas (Read me, Setup, Services, Sessions, Packages, Stock, Staff incentive, Bill, Dashboard). Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and every report and the dashboard recalculate.

Made-up data: every name, amount, business and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The business story

Rani Beauty Parlour, Solapur, 1 to 17 October 2026 (made-up data). Six services, four products and three staff (Rani, Zoya and Ravina). Staff incentive is an example 10% of service value.

10 of the 56 services were package sessions, billed at ₹0 because the package was paid in advance. For appointments and stylist commission in a larger salon, see the salon management system; this page adds packages and product stock.

2. Build it sheet by sheet

Step 1. Setup and Services

1. Setup: B3 as-of date, B4 incentive % (10%, your choice), B5 package expiry warning (15 days). Staff in D3:D5, payment types in E3:E6 including Package.
2. Services row 4: Service, Price, Product used, Product qty per service. A facial uses 1 facial kit; waxing uses a quarter jar.

Step 2. Sessions: one row per service

1. Row 4: Date, Client, Service, Staff, Payment, Package ID, Amount, Service value, Product, Product qty, Bill no.
2. G5 =IF(E5="Package",0,XLOOKUP(C5,Services!$A$5:$A$10,Services!$B$5:$B$10,0)): a package session is already paid.
3. H5 service value at menu price (for incentive), I5 and J5 look up the product and quantity, K5 ="B-"&TEXT(ROW()-4,"000").

Step 3. Packages

1. Row 4: Package ID, Client, Service, Sessions bought, Price paid, Start, Validity, Used (Oct log), Used before Oct, Remaining, Expiry, Days left, Flag.
2. H5 =COUNTIF(Sessions!$F$5:$F$1000,A5), J5 =D5-H5-I5, K5 =F5+G5, L5 =K5-Setup!$B$3.
3. M5 =IF(L5<0,"Expired",IF(J5<=0,"Used up",IF(L5<=Setup!$B$5,"Expiring","Active"))). Expiring rows go amber: call those clients first.

Step 4. Stock: products used by services

1. Row 4: Product ID, Product, Unit, Cost, Opening, Reorder level, Used, Closing, Order?, Product cost used.
2. G5 =SUMIFS(Sessions!$J$5:$J$1000,Sessions!$I$5:$I$1000,A5) adds the product quantity of every service that used it (SUMIFS).
3. H5 =E5-G5, I5 =IF(H5<=F5,"Yes","No") in red, J5 cost of product used.

Step 5. Staff incentive and bill

1. Staff incentive rows 5 to 7: services (COUNTIF), service value and cash (SUMIFS), incentive =ROUND(C5*Setup!$B$4,0). Rows 11 to 16 count services and cash per service.
2. Bill: type a bill number in B4; rows 6 to 11 pull date, client, service, staff, payment and amount with XLOOKUP. Print A1:C14.

Step 6. Dashboard

1. Cards: services done, cash collected, package sessions, packages expiring, products to order and incentive payable.
2. Chart 1 at A8: cash by service. Chart 2 at A25: service value by staff.

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in LibreOffice with zero errors.

4. Common mistakes

1. Charging a package session again. Pick Package as payment and type the package ID; the amount becomes 0 and the session counts against the package.
2. Paying incentive only on cash. Package sessions are work too. Incentive on service value at menu price is fairer.
3. Counting product stock by eye. Product used per service in the menu does the counting. Check it against a real count once a week.
4. No expiry on packages. A package without validity is an open promise. Keep a validity in days and flag it.
5. Typing client names differently. Pick one spelling, or add a client ID, so package and visit history stay together.

5. More real examples

Example 1: Bridal packages. A bridal package has several services. Add one row per service in a package-items sheet and count each with COUNTIFS on package ID and service.

Example 2: Home-service beautician. Add a Travel charge column on Sessions and a km column; incentive stays on service value.

Example 3: Nail studio. Products become gel colours and tips; product qty per service works the same way.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I track package sessions in Excel?

Log package sessions with the package ID; =COUNTIF(Sessions!F:F,A5) counts them and remaining = bought − used.

How do I reduce product stock automatically per service?

Give each service a product and quantity in the menu, look them up on every session row and total by product with SUMIFS.

How do I calculate staff incentive?

Total service value per staff with SUMIFS and multiply by the incentive %: =ROUND(C5*Setup!$B$4,0).

Should GST be added to the bill?

That depends on your registration and the rate for your service. The template shows amounts as charged; check with your accountant before adding a GST column.

How do I flag packages about to expire?

Days left = start + validity − today; show Expiring within 15 days, and Used up when no sessions remain.

7. Quick quiz

Ten questions on this page. Sign in to save your score.