Management Intelligence System
👁
First login? Default password: Admin@#1  ·  Admin: Jcbounce#123
🔒 Encrypted · Session-protected · Audit-logged
JCB
Admin Portal
Portal
30:00
A
Adminv
Admin Overview
Welcome
Active Users
0
Accounts
Salons
0
In system
Data Points
0
Records
Activity (30d)
0
Logged
Active Users
Recent Activity
Active Filters
User Management
Create, edit & manage access
Status Role Visibility
🔽
Users
Name Username RoleSalon AccessStatusVisibilityLast LoginActions
Data Management
Upload, preview & export analytics data
Google Sheets Connection
Not connected - enter your Apps Script URL below
Data will be pushed to and pulled from Google Sheets
Paste the URL after deploying the Apps Script. See setup guide below.
📋 Setup Guide - Click to expand
Step 1: Go to sheets.google.com -> Create a new spreadsheet -> Name it JCB Salon Dashboard
Step 2: In the spreadsheet, click Extensions -> Apps Script
Step 3: Delete all existing code, paste the Apps Script code (download below), click Save
Step 4: Click Deploy -> New deployment -> Web App
    Execute as: Me
    Who has access: Anyone
    Click Deploy -> Copy the URL
Step 5: Paste the URL above -> Save & Connect -> Initialize Sheets
Step 6: Upload your Excel file below - data goes straight to Google Sheets!
Upload Excel File
📊
Click or drag your Excel file here
Supports .xlsx · Same column layout as always
Export Options
Full Data Export
All records, all FYs
Filtered Export
Based on active filters
Users Export
List (no passwords)
Salon Management
Visibility, status & metadata
Brand Zone City Status Visibility
🔽
Salons
SalonBrandZoneCityManagerStatusVisibilityActions
Dashboard Filters
Apply global filters to the analytics dashboard
Salon
Brand
Zone
City
Financial Year
Month
Manager
Active Filter Summary
No filters applied
Security Settings
Password policy, session & access control
A+
Security Score
All controls active
Password Policy
Min Length
Require Special Char
Require Number
Require Uppercase
Session & Login
Session Timeout (min)
0 = never
Max Login Attempts
Lockout Duration (min)
Log All Activity
Locked Accounts
No locked accounts
Change Your Password
👁
👁
Activity Log
Complete audit trail
User Action
🔽
Log
TimestampUserActionDetails
30:00

Executive Overview

FY 2025-26 · All Salons · Real-time from stored data
All FYs
All Brands
All Zones
All Cities
All Salons
All Months
Monthly Trend — All Salons
Current FY vs Previous FY
Salon Contribution
Share of total sales by salon
YOY Growth by Salon
Current FY vs Previous FY % change
City Performance
Total by city this FY
Salon Performance Summary
⌕

YOY & MOM Analysis

All Years
All Brands
All Zones
All Salons
All Metrics
Year-on-Year
Month-on-Month
FY Comparison

Data Matrix

★ Max Ever ▲ Max Year
All Years
All Brands
All Zones
All Cities
All Salons
All Metrics
Salon Level
City Level
Zone Level
Brand Level

★ Records — Max Ever & Max Year

★ Max Ever All-time highest monthly value ·   ▲ Max Year Highest month within selected FY
All FYs
All Brands
All Zones
All Cities
All Metrics
All Salons

Data Upload

Upload your Excel file in the standard format to update all salon data
Upload Excel File
📊
Click or drag & drop your Excel file
Supports .xlsx format · Same column layout every time
Processing… 0%
Required Column Format
Each row = one salon × one month × one FY. All columns required.
Column Example Notes
BRANDJCBAny value
ZONEWESTSalon zone
CITYPUNESalon city
MatrixN+RAny value
Status2025-2026Financial Year
SalonAundhMust match salon name
MonthJAN3-letter month code
N+R22.12₹ Lakhs
CASH22.07₹ Lakhs
PRODUCT2.577₹ Lakhs
SERVICE19.543₹ Lakhs (optional)
FOOTFALL367Total footfall
FOOTFALL NEW85New customers
FOOTFALL EXISTING282Existing customers
NO OF BILLS484Invoice count
ABV4037Avg bill value ₹
Current Data Preview
All 12 months for selected salon × FY. Edit inline and save.
Metric AprMayJunJulAugSep OctNovDecJanFebMar

Manage Salons & FYs

Add New Salon
Add Financial Year
Active Financial Years
All Salons
Salon Brand City Zone Status Data Points Actions