Multi-Marketplace Settlement Reconciliation in One Dashboard

Why separate spreadsheets break down across Amazon and Flipkart

Most Indian brands start by downloading a settlement report from each marketplace and reconciling it by hand. That works for one channel and a few hundred orders. It becomes fragile when you sell on Amazon and Flipkart together, because each portal names columns differently, groups deductions differently and pays out on its own cycle.

The common problems are predictable:

• The same concept (commission, shipping fee, return adjustment) appears under different labels, so totals cannot be compared directly.
• Payout dates do not line up with order dates, so a month's sales and a month's receipts never match cleanly.
• Returns and reversals land in later settlement periods, which hides their true cost.
• Every analyst builds formulas slightly differently, so two people get two answers.

A single dashboard does not remove these differences. It maps them into one structure so you can ask the same questions of every marketplace.

What a unified settlement view needs to contain

Before choosing any tool or building your own, agree the fields you need at order-line level. Check the exact names in your latest settlement reports, since marketplaces change formats.

• Order and item identifiers: order ID, SKU, order date, shipment or dispatch date.
• Sale value: selling price, discounts or seller-funded offers, and the invoice value.
• Deductions: commission, fixed or closing fee, shipping or fulfilment fee, payment-related fees, and any penalties or adjustments.
• Tax items withheld: GST on fees and any TCS or TDS shown in the report. Rates and rules change, so confirm the current position with your tax adviser and the marketplace's latest notices.
• Returns and reversals: return type, date, amount reversed and fees refunded or retained.
• Payout reference: settlement ID, payout date and amount credited to your bank.

When each marketplace is mapped to these fields, comparison across channels becomes straightforward.

A step-by-step reconciliation flow

1. Import settlement and order data for each marketplace for the same period.
2. Normalise column names and sign conventions (deductions as negatives, for example) so all channels read the same way.
3. Match orders to settlements by order and item ID. Flag orders delivered but not yet settled, and settlements with no matching order.
4. Recompute expected fees from your seller agreement or rate card and compare them to what was actually deducted.
5. Tie settlements to bank credits using the payout reference and amount.
6. Raise and track exceptions as cases with owner, amount, date raised and status.

Step 4 is where most unnoticed leakage sits. Your commission and fee terms live in your agreement or the current rate card in your seller portal, not in a generic online table. Always use your own terms, and confirm the latest version before each review.

Where money typically goes missing

Look for these patterns first when you review Amazon and Flipkart settlements side by side:

• Fee mismatches: a deduction that differs from the category, weight slab or fee schedule you agreed.
• Returns not credited back: items returned to you in sellable condition, or lost in transit, with no matching reversal or compensation.
• Delivered but unsettled orders: orders past the expected settlement window with no payout line.
• Duplicate or unexplained adjustments: manual charges without a clear reference.
• Offer funding differences: discounts you did not agree to fund appearing against your payout.

Not every difference is an error. Some are timing, some are valid. The dashboard's job is to separate those quickly so your team spends time only on genuine exceptions.

What to ask when evaluating a reconciliation dashboard

If your intent is to buy rather than build, test the shortlist against practical questions:

• Which marketplaces and report formats are supported today, and which need scoping? Ask for this in writing.
• Can it check fees against your agreed terms, not just display deductions?
• Does it track returns and recovery cases through to resolution?
• Can finance export order-level detail that ties to your books and bank statements?
• How are new report formats handled when a marketplace changes its layout?

MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today; Amazon, Flipkart and other marketplaces are a scope discussion, so share your report samples early. Pricing is a tailored quote based on your marketplaces and volumes.

A monthly routine that keeps it manageable

Whatever you use, a fixed rhythm matters more than the tool. Reconcile weekly for open exceptions and close the month with a short review: unsettled orders, fee variances, return reversals pending and recovery cases open with their ageing. Keep marketplace support references with each case, and record the outcome so repeat issues can be raised as a pattern rather than one-off tickets.