Where marketplace settlement reports hide revenue: a line-by-line guide

Where money slips in Indian marketplace payouts: fees on refunds, reverse shipping on undelivered orders, courier weight re-rating and TCS/TDS credits.

Natium Labs

5 min read · · Updated

For Indian brands selling on Amazon, Flipkart and Meesho, money is rarely lost on the product page. It goes missing in the settlement files.

Most brands run their business on orders: what was sold, what the shipping label cost, what the margin should have been. What reaches the bank weeks later is not the order total minus a neat commission. It is a net settlement made of dozens of line items: referral fees, closing fees, weight handling, pick-and-pack, reverse shipping on returns, and tax withheld.

Reconciling these files in a spreadsheet is slow: lookups break, columns change from one quarter to the next, and a small deduction repeated across thousands of orders is easy to miss. How much goes missing differs from brand to brand, and only your own reports can show it. Here is where to look.

Marketplace and courier rules change, and some differ by category, seller tier or contract. Where this post refers to a rule, check the current version on the marketplace's or courier's own policy page before you rely on it.

1. Amazon: fees on refunds

When an order is refunded, Amazon credits the referral fee back to you, less a refund administration fee it keeps. The settlement report shows both: a positive Commission line on the refund and a RefundCommission line for the fee Amazon keeps. Amazon's fee schedule sets how much that is.

Where it slips

  • On orders with several items and a partial return, the reversal is split across several lines, and a missing credit is easy to overlook.
  • Dashboards often book the refund as one net figure, so a refund with no commission credit on it at all doesn't stand out.
  • Items lost or damaged in returns may qualify for reimbursement under Amazon's SAFE-T claims. Those claims have deadlines, so returns are worth checking as they happen, not at year end.

Our guide to reading the Amazon settlement report shows where each of these lines sits.

2. Flipkart: reverse shipping and returns

Flipkart's settlement report splits each order across separate fee columns: commission, fixed fee, collection fee (for prepaid or cash on delivery), shipping and reverse shipping.

Where it slips

  • Undelivered orders (RTO). An order the customer never received can still carry a reverse shipping charge. Whether it should depends on Flipkart's terms for your account, so compare the order's status with the charges on it.
  • Damaged or wrong returns. Flipkart's Seller Protection Fund (SPF) covers some of these, with a deadline for filing and proof such as unboxing images. Check the current window in Seller Hub.

Unless each order's status is compared with its charges, a reverse shipping charge on an undelivered order looks like any other logistics cost.

3. Couriers: weight re-rating

With Delhivery, Shiprocket and other couriers, most surprises come from weight. Couriers charge on the higher of the actual weight and the volumetric weight:

Volumetric weight (kg) = length × width × height (cm) ÷ divisor

Where it slips

  • The divisor. Most surface services use 5,000; some air and express services use 4,000. Working out freight on 5,000 when the courier bills on 4,000 makes every parcel 25% heavier on paper.
  • Slab edges. Couriers bill in slabs, often of 500 g. A parcel declared at 480 g and scanned at 510 g moves into the next slab, and the freight for that slab applies.
  • Dispute windows. Couriers allow only a short time to dispute a weight charge, with photos and measurements. Comparing billed weight with your declared weight as charges arrive, not at month end, keeps disputes within the window.

The volumetric weight calculator shows the slab a box falls into.

4. TCS and TDS

Every marketplace payout is reduced by two taxes held back on your behalf:

  1. GST TCS: 0.5% (0.25% CGST plus 0.25% SGST, or 0.5% IGST) under section 52 of the CGST Act.
  2. Income-tax TDS: 0.1% under section 194-O of the Income-tax Act.

Both are worked out on the price before GST and both come back to you as credits, but only if the amounts the marketplace reports match your own sales and your PAN details are right. Our TCS and TDS guide explains where each credit shows up.

5. Checking it line by line

Catching these takes order-level matching, not monthly averages. Each order is followed from the sale, through the settlement and the courier remittance, to the bank credit, with every amount kept in whole paise so nothing is lost to rounding. Five checks cover most of what goes missing:

  1. Settlement paid short: the payout is less than its own lines add up to.
  2. Fee above the rate card: a commission, closing or shipping fee higher than your rate card says for that category, price and channel.
  3. Fee not credited back on a refund.
  4. Weight above declared: the billed weight is higher than the weight you declared.
  5. COD not remitted, or remitted short: a delivered cash-on-delivery order whose cash didn't arrive in full.

Where to start

  1. Download your last 90 days of Amazon settlement reports (flat file V2) or Flipkart settlement reports.
  2. Pick out the refunds and adjustments, and check whether fees came back and whether reverse shipping was charged on undelivered orders.
  3. Compare billed courier weights with your declared weights on a sample of orders.

Whatever you find, the marketplace or courier decides each claim, so keep the order id, the report lines and your proof together.

Part of Settlement reports explained: what every marketplace, courier and payment-gateway report holds, where to download it, and how to check it.

Questions sellers ask

How much revenue do marketplace settlements usually leave short?

It differs from brand to brand, so there is no reliable average. Checking your own settlement and remittance reports line by line is the only way to know what is missing in yours.

Does Amazon refund the referral fee when an order is refunded?

Amazon credits the referral fee back on a refund, less a refund administration fee it keeps. The settlement report shows the credit as a positive Commission line and the fee kept as RefundCommission.

Why is a parcel billed at a higher weight than I declared?

Couriers bill on the higher of the actual weight and the volumetric weight (length × width × height in cm ÷ 5,000 for most surface services), rounded up to their weight slab. Compare billed weight with declared weight as charges arrive, because dispute windows are short.

Was this useful?

Written by Natium Labs

Natium checks every marketplace, courier and payment-gateway payout against the orders it came from, and shows you anything that came up short. We write about the fees and rules behind those payouts, with sources.

Responses

What are your thoughts?

We email you a link to confirm, then read each comment before it's shown. Privacy

No responses yet. Questions from other sellers are welcome.

Were you actually paid this?

A calculator shows what an order should pay. Natium checks what each payout really paid: upload the settlement report you already download, and see anything that came up short, with the proof. Finding shortfalls is free, no card.