Marketplace Payment Reconciliation for Amazon.in, Flipkart and Meesho

Two reports from the same marketplace, covering the same dates: an orders report with the order ID, dates, status and order value, and a payments or settlement report with the order ID and the net amount paid or charged. Save them as CSV, or copy the rows with their header row from a spreadsheet. The tool matches columns by words in the header, and you can change any match. Excel files: open them and copy the rows, or save as CSV first.

From the terms you type: fee or commission %, fixed or closing fee, shipping fee, the GST on those fees, TCS and TDS, and what a return costs you. Amazon.in says its referral fee varies by category and Flipkart says its commission does too, so if your products have different rates, check one category at a time or add an expected payout column to your orders report, which replaces the sum.

The one in your own seller panel or agreement. Amazon.in's seller pages say it pays every 7 days, including Pay on Delivery orders. Flipkart's pages count from pickup or dispatch and give figures from as little as 3 days, depending on your tier, to 7 days. Meesho's supplier pages describe a 7-day cycle from delivery, including cash on delivery. The tool adds a few extra days (3 by default, our suggestion) before it calls a payment late.

Flipkart's seller terms of use say a money claim that no Flipkart policy gives its own time limit should be raised within 180 days of the issue, and that its payment, FBF and SPF (Seller Protection Fund) policies can set their own limits. Amazon.in's SAFE-T claims and Meesho's payment tickets have their own rules in Seller Central help and the Supplier Panel. Whatever the limit, our suggestion is to reconcile every payment cycle and raise gaps straight away.

TCS is tax collected at source under section 52 of the CGST Act; from 10 July 2024 its central (CGST) part is 0.25% of the net value of taxable supplies within a State (Notification 15/2024-Central Tax). TDS is income tax deducted at source; the Income Tax Department's rate chart lists 0.1% for e-commerce payments under section 194-O, and from 1 April 2026 TDS comes under section 393 of the Income-tax Act, 2025. The tool leaves the field blank: copy the rates from your payment report and check them with your CA.