Ecommerce · Intermediate · about 17 minutes

Channel and marketplace reporting — reading six dashboards as one business

Amazon reports gross before returns. Flipkart nets some deductions. Your own site reports orders including cancelled.

You need

Consolidated table (apparel, ₹8.4 crore annual): Amazon FBA | Net rev 3.20cr | Fees 0.58 | Fulfil 0.41 | Returns 0.44 | Ads 0.29 | Contribution 1.48 | 46% Flipkart | 1.90cr | 0.33 | 0.24 | 0.29 | 0.14 | 0.90 | 47% Own site | 0.85cr | 0.02 | 0.11 | 0.05 | 0.22 | 0.45 | 53% General trade | 2.45cr | 0…

Tool

Power Query with one query per channel

You get

1. CONTRIBUTION RANKING — General trade ₹2.34cr (96%), Amazon ₹1.48cr (46%), Flipkart ₹0.90cr (47%), own site ₹0.45cr (53%).

Time saved

Monthly consolidation from a full day to about 45 minutes once the mapping and Power Query are built.