Reconciliation Software for Amazon and Flipkart Sellers

What reconciliation software should do for marketplace settlements

Amazon and Flipkart pay sellers through settlement reports, not one clean line per order. A single payout bundles sales, returns, commissions, fixed and shipping fees, tax collected at source, ad charges and adjustments. Reconciliation software takes those reports, matches them to your orders and shows what you were paid against what you should have been paid.

So the search for the best tool is less about dashboards and more about three jobs:

• Match every order, return and payout line across order and settlement reports.
• Check deductions against your seller agreement and the current rate card.
• Follow up on shortfalls, missing return credits and disputed charges until they are closed.

Features to compare before you shortlist

Use this checklist when you compare vendors. A tool that only totals payouts will not catch the leakages that matter.

• Order-level matching: every order ID tied to its settlement line, not just monthly totals.
• Fee validation: commission, fixed, shipping and other fees compared with your agreed terms, with variances flagged.
• Returns tracking: returns, RTOs and refunds matched to credits received, with ageing of open items.
• Payout-to-bank matching: settlement totals traced to actual bank credits.
• Recovery cases: a log of shortfalls raised with the marketplace, their status and amount recovered.
• Tax lines shown separately: TCS, TDS and GST-related deductions visible so your accountant can reconcile them. Confirm treatment with your tax adviser.
• Audit trail: exports that trace back to the source report and row.

Spreadsheets, ERP add-ons or a dedicated tool

Most brands choose between four routes. None is wrong; the fit depends on order volume, SKU count and how many marketplaces you run.

• Spreadsheets: flexible and cheap, but formulas break when report formats change, and review depends on one person.
• ERP or accounting add-ons: good for booking entries, usually weak on fee validation and return follow-up.
• Dedicated reconciliation tools: built around settlement reports and variance workflows.
• Outsourced reconciliation: useful for clearing a backlog, but ask who owns the working files and how recoveries are tracked.

If you spend several days each month on payouts and still cannot say how much is unrecovered, a dedicated tool is worth evaluating.

How to evaluate vendors in a pilot

1. Ask which reports are supported. Request the exact Amazon and Flipkart settlement and order reports they read, and what happens when formats change.
2. Run one closed month. Use data you have already reconciled by hand and compare the variances found.
3. Check how terms are configured. You should be able to load your own agreed commission and fee terms, not rely on generic defaults.
4. Look at variance categories. Short payment, wrong fee, missing return credit and unexplained deduction should be separate.
5. Test the follow-up workflow. Can you assign, date and close recovery cases?
6. Ask about access and data handling, then get the pricing basis in writing.

Where to confirm rates and rules

Fee rates, TCS, TDS and return policies change, and they differ by category, price band and agreement. Do not rely on a blog or a vendor demo for them. Confirm the latest terms in:

• your signed seller agreement and any addenda;
• the current rate card in your Amazon Seller Central or Flipkart Seller Hub account;
• the settlement report itself, which shows what was actually deducted;
• your tax adviser, for GST, TCS and TDS treatment.

Good software uses these as the baseline for checks. It should not hard-code rates you have not verified.

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. Today we review Myntra Excel reports. Amazon, Flipkart and other marketplaces are in scope discussion, so if those are your main channels, ask about coverage before assuming it. Pricing is a tailored quote based on your setup.