Enterprise Analytics & Reports Engine Live Intelligence
Multi-dimensional reporting across Sales, Branches, Staff Commissions, Services, Products, Customers, and Financial Statements
Gross Sales Revenue
₹1,42,80,000
+14.8% vs last period
Discounts Allowed
- ₹8,40,000
5.8% of Gross Sales
GST Collected (18%)
₹24,19,200
9% CGST + 9% SGST
Net Sales Billed
₹1,58,59,200
Including Tax Invoices
Periodic Sales Ledger Breakdown
| Date / Period | Invoices | Gross Revenue | Discounts | Taxable Value | GST (18%) | Net Sales Realized |
|---|---|---|---|---|---|---|
Multi-Branch Benchmarking & Performance Matrix
Comparison across Patna Flagship, Ranchi Central, Gaya Express, and Jamshedpur Lounge
| Branch Location | Total Revenue | Revenue Share | Total Appointments | Unique Customers | Avg Ticket Size | Branch Efficiency |
|---|---|---|---|---|---|---|
|
|
Stylist Performance & Commission Statement
Total services executed, gross billings produced, and tiered commission payouts
| Stylist / Staff | Designation & Branch | Services Completed | Gross Revenue Generated | Commission Tier | Total Commission Payable | Stylist Productivity |
|---|---|---|---|---|---|---|
👑 Most Booked Treatment
Keratin Hair Spa & Treatment
342 bookings • ₹11,97,000 billed
💎 Highest Revenue Generator
Royal Pre-Bridal Radiance Bundle
₹18,50,000 total • ₹12,999 / ticket
⚠️ Lowest Performing Service
Beard Coloring & Charcoal Mask
14 bookings only • Consider bundling
Complete Service Catalog Performance
| Service Name | Category | Times Booked | Unit Tariff | Gross Revenue | Revenue Share | Performance Rank |
|---|---|---|---|---|---|---|
Retail Product Sales & Stock Movement Velocity
Sales turnover, units consumed in backbar vs retail customer take-home
| Product & SKU | Brand | Units Sold (Retail) | Backbar Consumed | Selling MRP | Total Retail Sales | Movement Status |
|---|---|---|---|---|---|---|
New Client Acquisition
342 New Clients
24.2% of total footfall
Repeat / Returning Clients
1,072 Clients
75.8% High Retention Rate
Average Lifetime Value (LTV)
₹24,800
Across 4 branches
Top Patron Clients & High-Value Spenders
| Client Name & Phone | Customer Classification | Total Visits | Active Packages | Lifetime Billings | Primary Branch |
|---|---|---|---|---|---|
Total Gross Revenue
₹1,42,80,000
100% Top-line
Total Expenses (OPEX)
₹45,69,600
Rent, power & petty cash
COGS & Commissions
₹49,98,000
Backbar (20%) + Staff (15%)
GST Liability (Net)
₹20,56,320
Output GST minus ITC
Net Profit (EBITDA)
₹47,12,400
33.0% Clean Profit
Comprehensive Income & Financial Statement
Standard audited salon account breakdown
| Financial Line Item | Patna Flagship | Ranchi Central | Gaya Express | Jamshedpur | Consolidated Total (₹) |
|---|---|---|---|---|---|
| 1. Gross Salon Services Revenue | ₹54,72,000 | ₹33,76,000 | ₹17,12,000 | ₹8,64,000 | ₹1,14,24,000 |
| 2. Retail Product Sales Revenue | ₹13,68,000 | ₹8,44,000 | ₹4,28,000 | ₹2,16,000 | ₹28,56,000 |
| Total Operating Revenue | ₹68,40,000 | ₹42,20,000 | ₹21,40,000 | ₹10,80,000 | ₹1,42,80,000 |
| Less: Backbar COGS (20%) | -₹13,68,000 | -₹8,44,000 | -₹4,28,000 | -₹2,16,000 | -₹28,56,000 |
| Less: Stylist Commissions (15%) | -₹10,26,000 | -₹6,33,000 | -₹3,21,000 | -₹1,62,000 | -₹21,42,000 |
| Less: Salon OPEX, Rent & Power | -₹21,88,800 | -₹14,34,800 | -₹7,27,600 | -₹4,18,000 | -₹47,69,200 |
| Net Operating Income (EBITDA) | ₹22,57,200 | ₹13,08,200 | ₹6,63,400 | ₹2,84,000 | ₹45,12,800 (31.6%) |