UAE E-Commerce Profitability Dashboard: Channel Margin and Returns

Top-line sales can grow while cash and contribution decline. A useful e-commerce dashboard connects commercial activity to reconciled settlement, inventory and ledger records, then highlights the few decisions management can actually change.

Which revenue measure should the dashboard use? Distinguish order value, gross merchandise value, invoiced sales, recognised revenue and cash received. The primary profitability view should use the revenue measure supported by the accounting policy, net of defined returns and discounts and excluding VAT or pass-through amounts where appropriate. Show reconciliation bridges rather than mixing definitions.

Channel comparisons fail when one source reports order date and another reports settlement date. Align the period before comparing performance.

Which costs belong in channel contribution? Start with landed product cost, marketplace commission, payment fees, fulfilment, pick-and-pack, delivery subsidy, returns processing and directly attributable advertising. Present shared overhead separately unless a documented allocation supports a decision. Show both AED contribution and percentage so small high-margin channels are not confused with large cash contributors.

Do not treat marketplace or gateway fees as invisible netting; use the outputs of the settlement and gateway reconciliations.

How should returns be measured? Track return requests, completed refunds, items received, resaleable inventory, damaged stock and unreturned refunds separately. Measure return rate by order count and value, then analyse product, reason, channel and cohort. A refund recorded this month may relate to prior-period sales, so show both accounting effect and operational cohort.

Avoid one blended return rate if product categories and fulfilment models differ materially.

What inventory measures matter? Show units and value on hand, goods in transit, inventory cover, ageing, stock-outs, slow-moving items, negative stock and write-offs. Use controlled [landed cost](/insights/landed-cost-inventory-accounting-uae-ecommerce) rather than supplier price alone. Connect stock targets to lead time, demand variability and cash capacity.

Inventory cover is a management measure, not a statutory UAE threshold. Record its formula and data cut-off.

How should cash and settlements appear? Include bank cash, expected marketplace and gateway settlements, aged clearing balances, rolling reserves, cash-on-delivery exposure, supplier commitments and near-term tax or payroll obligations. Separate valid cut-off timing from overdue or disputed items. The working-capital view should explain why accounting profit differs from cash.

Use the broader working-capital dashboard for treasury decisions.

What makes a dashboard decision-ready? For every measure, define the formula, source, owner, refresh frequency, reconciliation status and action threshold. Show current period, comparable prior period, approved plan and variance driver. Limit the executive page to decisions; keep transaction evidence in drill-down schedules.

A red indicator should name the next action, not merely display a colour.

How should data quality be governed? Reconcile dashboard revenue to the ledger, channel deductions to statements, product cost to inventory, advertising to invoices and cash to banks. Maintain a metric dictionary and mapping-change log. Flag estimated, late or incomplete data rather than blending it into an apparently precise number.

Reviewer sign-off should cover source completeness, manual adjustments and unresolved exceptions.

When is fractional CFO support useful? Support may help when management sees sales but not contribution, channels use inconsistent definitions, inventory absorbs cash, returns are rising, or budgets lack operational drivers. A fractional CFO scope should define decisions, cadence, source systems, reporting ownership and hand-off to accounting.

The pillar e-commerce accounting guide shows the controls that make this dashboard dependable.