🔒
Account Locked
Too many failed login attempts.
Please wait before trying again.
5:00
Contact admin if you need help
⚠️ You will be logged out in
60
seconds due to inactivity.
Stay logged in
🌶️
Charminar Spices Sales Portal
Loading your sales data…
Connecting to Google Sheets…
0%
Please wait
📦
Data2023
⚡ Embedded
47,389 rows
📦
Data2024
⚡ Embedded
52,524 rows
📦
Data2025
⚡ Embedded
53,515 rows
📦
2026 Jan–Apr
⚡ Embedded
17,228 rows
🔄
2026 May+
(MSSQL live)
Waiting
2023–2026 Apr embedded ·
May 2026+ live from MSSQL ⚡
Charminar Spices Sales Portal
Sign in to your dashboard
Username
Password
Loading...
—
—
● Live
Logout
🔐 Session active ·
—
30:00
Data loaded
↺ Refresh
📊 Dashboard
🏆 Achievements
🔮 Future Target
👥 Team
📈 Analysis
💰 Price List
📊 Dashboard
🏆 Achievements
🔮 Future Target
💰 Price List
Filters & Slicers
Year
All Years
Quarter
All Quarters
Month
All Months
Bi-Monthly
All
Jan–Feb
Mar–Apr
May–Jun
Jul–Aug
Sep–Oct
Nov–Dec
Salesperson
All
Customer
All
City
All
Category
All Categories
Product
All Products
↺ Reset All
💰
Revenue (Before VAT)
—
Total
📦
Bill Quantity
—
Units sold
🧾
Avg Order Value
—
Per customer
🏪
Active Customers
—
Unique ledgers
📅 Year-on-Year —
—
This Year
—
—
Last Year Same Month
—
—
🎯 Top Opportunity Products (Last Year Same Month)
📈 Monthly Revenue Trend
AmountBeforeVat
—
📦 Monthly Bill Qty Trend
Units per month
🍕 Revenue by Category
Share of wallet
📊 Top 10 Products by Revenue
📦 Top 10 Products by Bill Qty
🏆 Top 10 Performers
🥇 Top 10 Products
Revenue + Qty
🏆 Top 10 Categories
Revenue + Qty
👥 Top 10 Customers
Revenue + Qty
⚠️ Needs Attention
📉 Bottom 5 Products
Low
📉 Bottom 5 Categories
Low
📉 Bottom 5 Customers
Low
📋 Detail Tables
Item-wise Summary
—
#
Product
Category
Bill Qty
Amount
Category Summary
—
#
Category
Bill Qty
Amount
Customer Summary
—
#
Customer
Bill Qty
Amount
Achievement Filters
Year
Select Year
Quarter
All Quarters
Month
All Months
Bi-Monthly
All
Jan–Feb
Mar–Apr
May–Jun
Jul–Aug
Sep–Oct
Nov–Dec
Customer
All Customers
Category
All Categories
Product
All Products
Target = Last Year BillQty × 1.10
📅
Last Year
—
Same period
🎯
Target (+10%)
—
BillQty target
✅
Actual
—
This period
📊 Achievement vs Target
BillQty comparison
📦 Product-wise Achievement
Select year & period
#
Product
Last Yr Qty
Target +10%
Actual Qty
Ach%
Gap
🏷️ Category-wise Achievement
#
Category
Last Yr Qty
Target +10%
Actual Qty
Ach%
Gap
Future Target Planner
Year
Select Year
Target for Month
Select Month
Bi-Monthly
Select Bi-Monthly
Jan–Feb
Mar–Apr
May–Jun
Jul–Aug
Sep–Oct
Nov–Dec
Target for Quarter
Select Quarter
Customer
All Customers
Category
All Categories
Product
All Products
↺ Reset All
Target = Same Period Last Year × 1.10
🔮 Select a Year, then choose a Month or Quarter to see your targets
👤 Salesperson Directory
—
#
Name
Username
Phone
Role
Status
Performance Cards
🧑💼 Revenue by Salesperson
📦 Qty by Salesperson
Price List Filters
Category
Select Category
Price List Name
—
W.E.F Date
—
Select a category to view prices
#
PRODUCT NAME
UOM
RATE WITH GST
