Data will be pushed to and pulled from Google Sheets
Paste the URL after deploying the Apps Script. See setup guide below.
Creates all required sheets with headers
📋 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
Processing...0%
Preview
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
BrandZoneCityStatusVisibility
🔽
Salons
Salon
Brand
Zone
City
Manager
Status
Visibility
Actions
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
UserAction
🔽
Log
Timestamp
User
Action
Details
30:00
Executive Overview
FY 2025-26 · All Salons · Real-time from stored data
All Salons
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
Year-on-Year
Month-on-Month
FY Comparison
Data Matrix
★ Max Ever▲ Max Year
All Salons
Salon Level
City Level
Zone Level
Brand Level
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
BRAND
JCB
Any value
ZONE
WEST
Salon zone
CITY
PUNE
Salon city
Matrix
N+R
Any value
Status
2025-2026
Financial Year
Salon
Aundh
Must match salon name
Month
JAN
3-letter month code
N+R
22.12
₹ Lakhs
CASH
22.07
₹ Lakhs
PRODUCT
2.577
₹ Lakhs
SERVICE
19.543
₹ Lakhs (optional)
FOOTFALL
367
Total footfall
FOOTFALL NEW
85
New customers
FOOTFALL EXISTING
282
Existing customers
NO OF BILLS
484
Invoice count
ABV
4037
Avg bill value ₹
Upload Preview
Current Data Preview
All 12 months for selected salon × FY. Edit inline and save.
Metric
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Manage Salons & FYs
Add New Salon
Add Financial Year
Active Financial Years
All Salons
Salon
Brand
City
Zone
Status
Data Points
Actions
Details
Add User
👁
Check specific salons to restrict access - uncheck "All Salons" first
📈 Dashboard Tab Access
Toggle which dashboard tabs this user can see
Dashboard
Main overview
Trends & YOY
Year-on-year
Data Matrix
Detailed table
Upload Data
Excel upload
Manage
Salon/FY manage
🔽 Visible Filters on Dashboard
Uncheck to hide that filter from this user
FY Filter
Financial year
Brand Filter
Brand dropdown
Zone Filter
Zone dropdown
City Filter
City dropdown
Salon Filter
Individual salon
Month Filter
Month selector
Manager Filter
Manager dropdown
🔒 Filter Lock (Force Fixed Values)
Check values to lock - user will be forced to that selection and cannot change it
