Best Reconciliation Tool for Amazon, Flipkart and Myntra

What a reconciliation tool actually needs to do

Marketplace payouts rarely equal what you expect. A settlement bundles sales, returns, commissions, shipping and other fees, adjustments and tax-related deductions into one figure. A reconciliation tool breaks that figure back into orders, so your finance team can say whether the money received is the money owed.

At a minimum, it should do four things:

• Match sales to settlements: every order line is traced to the payout that covered it, and unmatched lines are flagged.
• Check fees against terms: commissions and fees are recomputed from your seller agreement or rate card, not accepted as charged.
• Track returns: returned, lost or damaged units are followed until the money or stock is accounted for.
• Manage recovery cases: every shortfall becomes a case with an owner, a status and an amount.

Features to compare before you shortlist

Most vendors will say they do reconciliation. The differences show up in the details, so compare these points:

• Report ingestion: can it read the actual settlement and order files you download, without heavy manual clean-up?
• Your own rules: commission and fee terms differ by category, agreement and period. The tool should let you enter your terms rather than assume a standard rate.
• Order-level audit trail: you should be able to click from a payout total down to the order, return and fee line behind it.
• Returns ageing: it should show which returns or claims are still open and for how long.
• Accounting output: summaries and exports your accountant can post without re-working.
• Multi-marketplace view: one place to compare unmatched amounts across channels.
• Access and support: role-based access, and a person who can help when a report format changes.

Whatever rate or rule matters for your business, take it from your seller agreement, the marketplace's current rate card and your settlement report, and confirm the latest terms before you configure anything.

Amazon, Flipkart and Myntra: three formats, one process

Each marketplace has its own settlement report, its own fee names, and its own timing for returns, adjustments and payouts. Columns and fee structures also change over time. A tool that works well for one marketplace may need separate configuration for another, so do not accept a generic demo file as proof.

Ask every vendor to run your real reports from each marketplace you sell on. Also ask which marketplaces are live today and which are set up on request. For example, MarketplaceMetrics by Fundle currently reviews Myntra Excel reports, while other marketplaces, including Amazon and Flipkart, are handled through a scope discussion. That is the kind of clear answer you should expect from any vendor.

A practical checklist for evaluating tools

1. Download the last full month of settlement, order and returns reports from each marketplace.
2. Collect your seller agreements and rate cards, and note the commission, fixed fee and other charge terms that apply to you.
3. Ask the vendor to reconcile that month and show unmatched orders, missing payouts and fee differences.
4. Verify a sample of about 20 orders yourself against the raw reports.
5. Check how recovery cases are raised, assigned and closed, and who can see them.
6. Confirm the outputs your accountant needs, such as period summaries and export formats.
7. Ask about data handling, user access and how pricing is decided.

A tool that cannot explain a difference down to the order is not reconciling; it is only summarising.

Spreadsheet, accounting software or a dedicated tool?

• Spreadsheets: fine for one marketplace and low order volume. They struggle with version control, large files and repeating checks every month.
• Accounting software: good at recording payouts and expenses, but generally built to record entries, not to audit each fee against your agreed terms.
• Dedicated reconciliation tool: makes sense when you sell on several marketplaces, volumes are rising, or unexplained deductions are hard to chase.

Treatment of GST, TCS and TDS on marketplace sales should be confirmed with your tax adviser and the marketplace's own documents. A reconciliation tool should help you see these lines clearly, not decide your tax position.

Where MarketplaceMetrics by Fundle fits

MarketplaceMetrics by Fundle reconciles marketplace sales and settlements for Indian brands, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today; other marketplaces are discussed case by case. Pricing is a tailored quote based on your marketplaces and volumes.

It is a sensible fit if you want order-level checks and a recovery list your finance and ecommerce teams can both work from. If you only need basic bookkeeping entries, your accounting software may be enough.