Fill top-down: Company first, then Brands, then Branches. Each level's total cannot exceed
its parent. Names come from your Mapping Template Report groupings.
Monthly Target per Branch
Daily Target per Branch
Set Auto by Percent (%)
Spreads the monthly target across the dates by day-of-week weight. Dates already
passed keep their value; the remaining target is spread over the remaining days.
User Access & Login Maintenance
Username
Full name
Role
Status
Last login
Actions
Data Source
Choose how SALESDASHBOARD receives transactions. Whichever source is active, raw rows are
stored first, validated against the Mapping Template Report below, and only then shown on
the dashboard.
Import ESB Data
Upload the three ESB exports as CSV or Excel. Columns are matched by header name,
so column order does not matter. Each upload is recorded below and can be removed as a unit.
📊
Sales Recapitulation
one row per bill
Drop file or click
🍴
Sales Detail
one row per menu line
Drop file or click
🏷
Sales Promotion
one row per promo
Drop file or click
Mapping Template Report
Reports are ingested raw — nothing in the source file is edited. This mapping decides how each
file is validated and how its rows roll up on the dashboard. A Sales Recapitulation upload is
rejected if its Company (cell B8), or any row's Brand or Branch, is not listed here.