Management performance overview — monthly, YTD, LY and AOP
—
Dashboard is empty. Every figure shows — until you load your own data. Go to Data & Uploads → download a Template → fill it → Upload (or paste). Nothing here is sample data.
Each value shown with % of Revenue / Margin %. Variance favourability is colour-coded (green = favourable, red = unfavourable, costs inverted).
PeriodHeatmap● favourable · ● unfavourable · ● within ±2% · click a section to collapse · click a line for 12-month drill-down
Model: Net Revenue (Net Sales) = Revenue − Output VAT. Packing = Net Sales × 2.5%; COGS Adjusted = (COGS − Input Tax × 97.5%) − Packing. Product Margin = Net Revenue − COGS Adjusted − Packing (packing reclass is margin-neutral). Operations → CM1; Marketing → CM2; Branding → CM3; Indirect Salary / Professional / Other → EBITDA; Interest & Depreciation → PBT; Adjustments are shown after PBT. Inward Logistics is excluded from the P&L (shown under CPD). Manual heads editable on Data & Uploads.
SKU Sales Analysis Actual · selected month · emirate filter applies here
No SKU detail loaded for this month. Upload your raw SKU export (Excel/CSV) on the Data & Uploads page — it captures SKU, category & emirate automatically.
Category Summary
Top 10 SKUs by Revenue
Highest revenue contributors
Bottom 10 SKUs by Margin %
Lowest product-margin lines (review pricing/cost)
Full SKU Table click a column header to sort
Marketing Effectiveness Actual · selected month & YTD · Overall, Google Ads & TP channel-partner
Marketing Efficiency — Actual vs AOP vs LY
TP Channel-Partner Performance Net sales, commission & advertisement by aggregator · UPLOAD
Manual CPD Entry — independent; overridden by CPD file upload
Enter the delivery cost build-up for the selected month. Recomputes CPD live and feeds the summary & variances.
Source & Governance
Active value provenance for CPD this month.
Validation rules: orders > 0; every cost ≥ 0; total cost must reconcile to component sum; CPD flagged if > 1.5× the previous uploaded CPD month. CPD is fully independent — it never pulls from SKU, Tally or the Financial sheets. File upload wins over manual entry.
CPD is independent. CPD = Total Delivery Cost ÷ Deliveries, using only the uploaded vendor-wise CPD file (or Manual CPD entry). No automatic pull from SKU, Tally or Financial sheets. Upload via Data & Uploads → CPD or enter manually below.
No SKU detail for this month. Upload the raw SKU export to populate emirate-level performance.
Emirates Analytics
Emirates Ranking
Revenue by emirate — selected month
Contribution Mix
Share of revenue by emirate
Revenue Heatmap
Emirate × month — revenue intensity
Emirates Performance — Actual (vertical table)
Actual figures only. Sales, orders & product margin are actual by emirate (SKU DeliveryState); operating costs are booked at entity level and revenue-weighted allocated. Only Dubai, Abu Dhabi & Sharjah are reported — Ajman and all other emirates consolidate into Dubai. Channel filter (IGP/TP) applies.
Total location expense by month — Actual vs AOP vs LY
Cost Allocation Treemap
Head-level cost concentration — selected month
Variance Heatmap Matrix
Section × emirate — Actual vs AOP variance % (red = overspend, green = under budget)
Emirate-wise Expense Distribution per the Exp-Bifurcation structure · Actual heads direct · T/O-ratio heads allocated by revenue share
No location-expense data for this month. Upload the expense bifurcation file below or enter amounts manually.
Data Entry — Location Expenses
Upload Expense Bifurcation CSV / Excel · long format
Columns: Month, Scenario, Emirate, Section, Head, Vendor, Amount. Scenario = Actual / AOP / LY. Emirate = Dubai / Abu Dhabi / Sharjah / Unallocated (Ajman & others fold into Dubai). Put the vendor / party name in the Vendor column — it shows as its own line under the section. T/O-ratio heads placed under Unallocated are auto-allocated by SKU revenue share.
Manual Entry selected month · per head
Allocation model (per "Exp Bifurcation in Location Performance.xlsx"): heads typed Actual are charged to the emirate where incurred; heads typed T/O ratioT/O are allocated to emirates pro-rata to each emirate's share of SKU revenue (turnover ratio) for the month. Marketing Cost & Professional Fees support vendor / party-wise rows via upload (Vendor column). Stored in INR base; displayed in the selected currency.
No Trial Balance loaded for this month. Upload your Tally TB (grouped) on the Data & Uploads page — the P&L, YTD and the Financial-vs-MIS reconciliation populate automatically.
Profit & Loss — Month (per TB)
From Income & Expense ledgers, IFRS order
Financial YTD (per TB)
Cumulative across uploaded months
Financial vs MIS — Reconciliation TB books vs operational dashboard · selected month
Statutory P&L is built from the TB's Income and Expense groups (Group 2), classified by head (Group 3): Purchases → COGS, Depreciation and Finance shown separately. The TB is read in AED and converted to the ₹ reporting base at the month's FX rate, so it lines up with the MIS. The reconciliation compares it to the operational MIS P&L (SKU + Tally); the variance column quantifies gaps to investigate.
Executive Action Center prioritised, auto-generated from this month's variances & data gaps
Exception Dashboard data integrity & threshold breaches
Source & Provenance Register every metric: source type, upload & last-modified dates, active value
Governance priority is Upload > Manual > Calculated. Upload = sourced from a loaded file; Manual = keyed via an entry panel; Calculated = derived from inputs. Every value is timestamped on change for the audit trail.
Upload & Maintenance
Data Sources
Upload once: LY, AOP, Exchange Rates · Monthly: SKU & Tally. Each shows its template.
SKU Report — Sales, GST, COGS Upload your raw SKU export directly (PnLChannels, Pnl_Date, GrossRev, GST, COGS, Input Tax, ShipCost). Auto-aggregated by month & channel.
Tally Data — Expenses Month,Channel,Emirate,Head,Amount (Emirate optional) · monthly · amounts read in the currency selected here
Last Year (LY) Data Wide P&L CSV · not loaded
AOP / Budget Wide P&L CSV · not loaded
Trial Balance — Financial Management Grouped Tally TB (Ledger, Debit, Credit, Group1, Group2…). Tagged to the selected month; builds the statutory P&L. not loaded
Google Ads — Marketing (IGP Dubai only) Google Ads invoice/report (.xlsx) with campaign Description, Clicks & Amount(AED). Tagged to the selected month · feeds the Marketing report for IGP. not loaded
CPD — Vendor-wise Delivery Cost Vendor, Rider Type, Deliveries, Cost (AED), CPD per Delivery. Independent — drives CPD only, no pull from SKU/Tally. Tagged to the selected month. not loaded
Tamara — BNPL Gateway Tamara Sales XLSX (Merchant Order ID, Order Amount, Fees, Total Payable). Feeds Payment Gateway Reco page. not loaded
Exchange Rates INR per AED · edit inline below, or upload Month,INR_Rate
Persistence — store once, reload anywhere
Data auto-saves to this browser on every change. Export Data Pack writes a single JSON you can keep on your shared drive and re-import on any machine — the reliable "upload-once" store. Use Clear Saved to wipe the browser copy back to empty. Per-month Actual reset is on the Manual Adjustment panel.
This dashboard starts empty. No sample or model figures are pre-filled — every cell shows — until you load it, so anything you see is data you provided. Upload SKU/Tally per month, and LY / AOP / FX once. Months you haven't uploaded stay blank (they are not estimated), so trend and YTD views reflect only loaded months. Derived lines (Net Revenue, Product Margin, CM1–CM3, EBITDA, PBT, AOV, % columns) are calculations on your inputs, not invented data.
Paste CSV (if file picker is blocked)
Manual OPEX Entry (alternative to Tally upload)
Editable cost heads for the selected month / channel (Actual). Recomputes live. Use this or the Tally template — last entry wins.
From Operations Cost onward you can enter values here manually or upload the Tally template (left). Sales, COGS & Packing come from the SKU file and are not editable here. Frozen months are locked.
Monthly Actuals — Freeze Locks
Upload month-by-month (Apr, then May, then Jun…). After a month is final, 🔒 freeze it — future SKU/Tally uploads will skip frozen months, so re-uploading a multi-month file can never overwrite a closed period. Click a tile to toggle.
Exchange Rate Table — INR per AED
Base currency is INR (your SKU data is in ₹). The AED view = INR ÷ this rate. Click any rate to edit — it saves automatically, so you never re-upload. Or set one rate for all 12 months:
Fixed rate (all months):INR per 1 AED
Payment Gateway Reconciliation
Stripe · Tabby · Tamara — matched against SKU order data
Order IDs from each gateway are matched to the SKU export to retrieve SKU, Category, and Emirate. ✓ Matched = found in SKU data; ✗ Unmatched = not in SKU export for selected month. Variance = Gateway amount (AED) minus the matched order's SKU revenue converted to AED at that month's rate (estimated from the order's share of each SKU line).
No Stripe data loaded. Upload the Stripe Itemized Balance CSV on the Data & Uploads page.
Filter:
No Tabby data loaded. Upload the Tabby Sales XLSX on the Data & Uploads page.
Filter:
No Tamara data loaded. Upload the Tamara Sales XLSX on the Data & Uploads page.
Filter:
Model: Stripe: Gross − Fee = Net (Stripe settles net of fees). Tabby: Order Amount − Total Deduction = Transferred Amount. Tamara: Order Amount − Total Fees = Total Payable to Merchant. All amounts in AED. Variance column = Gateway Gross − SKU GrossRev for matched orders (blank if unmatched).