Data is loaded from the API server, not a local file — see the "Upload new data file" button (Admins only) to update it.
fischer India
Sales & Revenue Dashboard
Access is scoped by role — you'll see only the data your role permits.
Set a New Password
Your account was just created — please set a password only you know before continuing.
At least 8 characters, and different from your current password.
Sales & Revenue Overview
All divisions · All states · All channels
— rows in view
fischer India
KPI View
Net Turnover — MTD & YTD
Driven by the sidebar's Year/Month and View Selection filters — see the card above
Show:
Under MTD
Under YTD
Previous Year Net Turnover
Plan Net Turnover
Current Year Net Turnover
Contribution % Previous Year
Contribution % Plan
Contribution % Current Year
Growth % Over Previous Year
Growth % Over Plan
Previous Year Net Turnover
Plan Net Turnover
Current Year Net Turnover
Contribution % Previous Year
Contribution % Plan
Contribution % Current Year
Growth % Over Previous Year
Growth % Over Plan
Net Sales
—
—
Quantity Sold (pcs)
—
—
Active Material Counts
—
—
Active Customers
—
—
Net Sales Trend
Monthly · Previous Year, Plan, and Current Year
Product Classification
Share of net sales
Channel
Detailed View
Comparing the current period across years · per the Date Range Selection
Division, bucketed into Specialized trade / Industry-Project / OEM
Rows where Market = Specified, broken out by Product Family
Rows where Market = Trade, broken out by Product Family
Period-to-Period Comparison
Driven by the sidebar's Date Range Selection
Year
Net Sales
Growth vs Prior Year
Quantity Sold
Growth vs Prior Year
Active Customers
Growth vs Prior Year
Active Materials
Growth vs Prior Year
Year over Year — Breakdowns
Comparing across years · per the Date Range Selection
One row per month, in chronological order · Contribution % shown per year
Contribution % shown per year
Contribution % shown per year
Division, bucketed into Specialized trade / Industry-Project / OEM · Contribution % shown per year
Contribution % shown per year
Contribution % is for the most recent year
Contribution % shown per year
Rows where Market = Specified, broken out by Product Family · Contribution % is share of Specified sales
Rows where Market = Trade, broken out by Product Family · Contribution % is share of Non-Specified sales
Contribution % shown per year
Contribution % shown per year
Price Variance Analysis
—
Price Variance = (Current Year Avg Price − Previous Year Avg Price) × Current Year Quantity, at the material number level.
A positive value means price increases added to net sales; negative means price decreases reduced it — independent of any volume change.
Monthly Net Price Variance Trend
(Current Year Avg Price − Previous Year Avg Price) × Current Year Qty, at the material level · new and discontinued materials excluded
Top 20 Materials by Price Variance
Biggest gains from price increases
Bottom 20 Materials by Price Variance
Biggest losses from price decreases
Price Variance — By Zone / Region / Sales Employee / Customer / Material
Calculated at the material level within each group, then summed
Zone
Prior Year Avg Price
Current Year Avg Price
Price Change
Price Change %
Current Year Qty
Price Variance
Price Variance %
Region
Prior Year Avg Price
Current Year Avg Price
Price Change
Price Change %
Current Year Qty
Price Variance
Price Variance %
Sales Employee
Prior Year Avg Price
Current Year Avg Price
Price Change
Price Change %
Current Year Qty
Price Variance
Price Variance %
Customer
Prior Year Avg Price
Current Year Avg Price
Price Change
Price Change %
Current Year Qty
Price Variance
Price Variance %
Material
Prior Year Avg Price
Current Year Avg Price
Price Change
Price Change %
Current Year Qty
Price Variance
Price Variance %
How Collection Period Is Calculated
Aging & Devaluation of Receivables
Based on the Due Date column and the selected Date Range month — see the card above
Aging Bucket
Balance
% of Total Outstanding
Devaluation %
Devaluation Amount
Devaluation Amount % over Total Outstanding
Collection Period — By Customer / Zone / Region / Sales Employee
Same four breakdowns as before, one at a time instead of stacked — pick a view below
Sorted by outstanding balance
Customer
Outstanding Balance
Credit Balance
Net Outstanding
Overdue Amount
Overdue Amount %
Collection Period (Days)
Collection Period Last Year (Days)
Devaluation Amount
Devaluation Amount %
Connected via each row's Sales Employee — see the card above for how
Zone
Outstanding Balance
Credit Balance
Net Outstanding
Overdue Amount
Overdue Amount %
Collection Period (Days)
Collection Period Last Year (Days)
Devaluation Amount
Devaluation Amount %
Same connection as Zone, one level up
Region
Outstanding Balance
Credit Balance
Net Outstanding
Overdue Amount
Overdue Amount %
Collection Period (Days)
Collection Period Last Year (Days)
Devaluation Amount
Devaluation Amount %
Direct match on each Outstandings row's own Sales Employee column
Sales Employee
Outstanding Balance
Credit Balance
Net Outstanding
Overdue Amount
Overdue Amount %
Collection Period (Days)
Collection Period Last Year (Days)
Devaluation Amount
Devaluation Amount %
New Customer Acquisition
—
Monthly Net Sales Trend
New customers only · each year's own cohort — a customer counts only in the specific year they're marked as newly acquired
New Customer Acquisition — Breakdown
Only customers marked as newly acquired in the currently selected year · Contribution % is of total company net turnover
Division, bucketed into Specialized trade / Industry-Project / OEM
Top 20 by net sales
Top 20 · rows where Market = Specified, broken out by Product Family
Top 20 · rows where Market = Trade, broken out by Product Family
Top 20 by net sales
Create / Update User
Passwords are hashed on the server — never sent back or stored in plain text
Bulk Upload Users
Create or update many users at once from an Excel file
Upload an .xlsx file with a header row: Username, Password, Role, Label, Assigned Values.
"Assigned Values" is comma-separated and only needed for Zone Manager, Region Manager,
Business Unit Manager, and Sales Employee roles — leave it blank for Admin/Management.
Existing usernames are updated; new ones are created. Not sure of the exact format?
Download the template below first.
