Multi-Marketplace Selling: Managing Reconciliation Across Platforms

Selling on multiple marketplaces multiplies revenue potential, but it also multiplies reconciliation complexity in a way that isn’t linear — three marketplaces don’t mean three times the work, they mean three different report formats, three different settlement cadences, and three sets of fee logic to keep straight simultaneously.

The format problem is the most immediate: Amazon’s settlement export is long-format with a single amount column split across multiple rows per order; Flipkart’s is wide-format with each fee type in its own column; Meesho’s sits somewhere in between. A spreadsheet formula built for one won’t work unmodified on another, and maintaining three separate reconciliation sheets in parallel is where a lot of manual processes quietly fall apart.

The timing problem compounds it: each marketplace settles on its own schedule (Amazon’s cycles differ from Flipkart’s T+7-to-T+10 windows, which differ again from Meesho’s), so "this month’s reconciliation" means three overlapping-but-different date ranges, not one clean calendar month across all three.

The practical approach that scales is normalizing every marketplace’s data into the same internal structure — order ID, gross amount, commission, shipping, TCS, net amount — regardless of what each platform originally called those columns, so that once normalized, the actual matching and discrepancy logic is identical across all three. Building and maintaining that normalization layer by hand in Excel is possible but brittle; it’s the exact problem purpose-built multi-marketplace reconciliation tools are designed to solve, since the underlying reconciliation logic genuinely is marketplace-agnostic once the data’s in a consistent shape.

Whatever approach you use, keep each marketplace’s reconciliation as a distinct pass rather than blending all three into one combined spreadsheet — it’s much easier to spot "something’s wrong with Flipkart this month" when Flipkart’s numbers aren’t averaged in with Amazon’s and Meesho’s.