Use one Excel file with invoice-level rows:
country, city, showroom, salesman_no, salesman_name, date, invoice_no,
invoice_amount, discount_amount, target. Treat invoice_amount as sales before
discount; bonuses use net sales after discount.
Slabex BonusAED 0MarginShield BonusAED 0Net ImpactAED 0Net SalesAED 0
Upload data to generate the executive summary.
Bonus system comparison
No data
Discount band mix
No data
Monthly sales trend
No data
Variance by country
No data
Highest impact showrooms
By bonus difference
Showroom
Sales
Slabex
MarginShield
Diff.
Upload data to view impact.
Highest impact salesmen
By bonus difference
Salesman
Sales
Slabex
MarginShield
Diff.
Upload data to view impact.
MarginShield uses total invoice bonus x achievement, clamped to the selected range.
Total Slabex BonusAED 0Total MarginShield BonusAED 0DifferenceAED 0Loaded Invoices0