Blog / Guide
Settlement reports explained
Every marketplace, courier and payment gateway sends a report with each payout. It shows how they got from what your customers paid to what reached your bank. Here is what each report holds, where to download it, and how to check it.
Four checks that work on every report
1
The lines add up to the payout
Add every amount in the report. The total should equal what the report says was paid. A payout smaller than its own lines is short.
2
Each payout matches a bank credit
Add the rows that share one settlement, NEFT or transaction id. That total should match one credit in your bank statement.
3
Fees match your rate card
Commission, fixed and shipping fees depend on the category, price and date. Check a few against the rate card that applied that day.
4
Returns and adjustments have a reason
Look at reverse shipping, RTO charges and any money taken back. Each should match what happened to the order and your terms.
Marketplaces
Amazon
Settlement report (flat file V2)
Every amount in one Amazon payout, one line each: prices, fees, refunds, reserves and tax held back.
Tab-separated .txt · Every settlement in the last 90 days (about six to seven files).
Flipkart
Settlement report
One row per order item with a column per amount, and the NEFT transfer that paid it.
Excel (.xlsx) · Last 90 days, in one report.
Meesho
Payment file (order payments)
One row per sub-order, with Meesho's own formula for how the columns add up to the final settlement.
Excel (.xlsx) · Last 90 days, one file per month is fine.
Couriers (COD)
Shiprocket
COD remittance report
Which cash-on-delivery orders Shiprocket collected, and which remittance paid them to you.
CSV or Excel · Last 90 days.
Delhivery
COD remittance details
The shipments and cash-on-delivery amounts in each Delhivery remittance.
Excel, sometimes a ZIP per remittance · Remittances from the last 90 days.
Payment gateways
Razorpay
Settlement reconciliation report
Which payments each Razorpay settlement paid out, and the fees and tax taken off.
CSV · Last 90 days.
Across every report
- Where marketplace settlement reports hide revenue: a line-by-line guideWhere money slips in Indian marketplace payouts: fees on refunds, reverse shipping on undelivered orders, courier weight re-rating and TCS/TDS credits.
- TCS and TDS on marketplace payouts: 0.5% and 0.1%, and how to get them backWhy Amazon, Flipkart and Meesho hold back 0.5% GST TCS and 0.1% income-tax TDS from every payout, what they are calculated on, and where the credit shows up.
Menu names and report columns change from time to time; each guide says when it was checked. Whatever you find, the marketplace, courier or gateway decides each claim, so keep the order id, the report lines and your bank statement together.
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.