IRVINS Channels & Products

IRVINS SG Commercial Dashboard

Based on Finance's P&L Closing
Monthly Revenue Trend SGD
P&L Waterfall
GP & Net Margin Trend %
🏢 BU Performance Overview
📊 Individual BU Channel P&L
📈 Revenue by Business Unit
Top 15 SKUs by Revenue
Top 15 SKUs by Qty Sold
SKU Revenue Share
Channel Revenue Split
Top 10 SKU Monthly Trend
Product x Channel Revenue Matrix
Top Products in Channel
BU Revenue Ranking
All Channels Monthly Revenue
Channel Revenue vs Qty
Channel Product Details
📤 Import Data

Upload an Excel file or connect a Google Sheet with the same structure as 15Feb-Raw-Data.xlsx.

📄 Upload Excel File

Drag & drop your .xlsx here, or click to browse

— OR —

🔗 Google Sheet

Publish each tab as CSV: File > Share > Publish to web > CSV

Expected Structure:

Tab: P&L Raw Data
ScenarioPeriod (Seq)GL level 1GL NameBU nameCountry nameSGD
e.g. U25b) YTD 25 | 01) Jan | 01) Total Revenue | ... | SG | 123456
Tab: Products Raw Data
YearMonthHistorical Sales CountryBU nameItem No.Item/Service DescriptionQtySGD
e.g. 2025 | 01) Jan | SG-Stores | Changi T3 | FG-S192 | Salted Egg Fish Skin 95g | 500 | 3500