Why Marketplace Settlements Never Match Your Orders
If you sell on Amazon, Flipkart, or Myntra, you have seen this movie: orders worth ₹10,00,000 ship in a settlement cycle, and the payout that lands is ₹8,73,410. No single line explains the gap. The settlement report has hundreds of rows, the fee heads keep changing, and the finance team closes the month by booking the difference as "marketplace charges" — hoping it is roughly right.
It is usually not roughly right. Here is where the money actually goes.
1. Commission and fee overcharges
Every marketplace deducts a commission, a fixed fee, and a shipping fee per order. Each of these is governed by a rate card — your category, your price slab, your weight slab. In practice, marketplaces misapply them more often than most brands realise:
- A product listed in a lower-commission category gets billed at a higher one.
- The fixed fee slab changes with the selling price, and orders near the slab boundary get charged the wrong tier.
- Shipping fees are computed on the greater of actual and volumetric weight — and the volumetric weight on record is often inflated.
Individually these are ₹20–₹80 errors. Across thousands of orders a month, they compound into a number that matters.
2. Returns that never came back as inventory
When a customer returns an order, the marketplace reverses the revenue — but that is only half the story. Was the item received back in sellable condition? Was a return fee charged? Was the refund issued even though the courier never delivered the return to your warehouse? Each of those is a separate claim, with a separate evidence trail and a separate filing deadline. Miss the window and the claim is gone for good.
3. Missing and delayed reimbursements
Lost warehouse inventory, damaged inbound shipments, carrier-damaged customer orders — marketplaces owe sellers reimbursements for all of these, but they are rarely paid automatically in full. The amounts are small per unit, the reports are hard to reconcile, and the default outcome is that sellers simply never claim.
4. The tax mismatch
GST on marketplace fees is an input credit — but only if the fee amounts in your books match what the marketplace actually charged. When fees are overcharged, your GST credit is wrong too. And when your receivables are inflated by settlements you will never receive, your GST outflow is computed on revenue that does not exist. Reconciliation errors flow straight into tax.
5. Settlement timing
Marketplace settlements follow their own cycles, and payment gateways follow T+2 or T+3. A payout that lands late — or partially — creates a working-capital gap that never shows up in any single report. Unless you track order-to-settlement ageing, delayed payouts are invisible until the cash is needed.
Why spreadsheets don't fix this
Most finance teams start with a spreadsheet: download the settlement report, pivot the fees, eyeball the outliers. It works at 200 orders a month. It collapses at 5,000, across three marketplaces and a D2C website, with rate cards that change mid-quarter. The problem is not effort — it is that every channel speaks a different file format, a different fee vocabulary, and a different claims process.
What good reconciliation looks like
A proper marketplace reconciliation does five things, every month, without exception:
- Consolidates settlement, order, return and fee data from every channel into one view — no reformatting.
- Auto-matches every order to its settlement, every return to its reversal, every fee to the rate card.
- Flags discrepancies — overcharges, shortfalls, missing reimbursements — with evidence attached.
- Prepares claim packs and tracks each claim until the money is recovered, not just filed.
- Posts clean entries — sales, returns, settlements, fee adjustments — straight into Tally, Zoho Books, or your ERP, so the books close on time.
That is exactly what we built LogiRecon to do — with a Chartered Accountant-led team that prepares the entries, reviews the discrepancies, and follows up with marketplaces on your behalf. Books committed by the 10th of every month, no exceptions.
If your settlement reports have a "difference" line that nobody can fully explain, book a 20-minute walkthrough. We will show you, on your own data, exactly where the gap comes from.