How do I reconcile Amazon and Flipkart settlements with my books?
Match marketplace settlement reports to orders, fees, returns and tax deductions, so every rupee paid or withheld by Amazon and Flipkart is explained.
Anadoris Digital · · 4 min read

Marketplaces pay you the order value minus a long list of deductions: commission, fixed fees, shipping, collection charges, penalties, tax collected at source and sometimes advertising. They also adjust earlier payments for returns and claims. The payout that lands in your bank is a net figure that rarely matches the sales you recorded for the same period.
Many brands simply book the bank receipt as sales and move on. That hides lost money: orders never paid, fees charged at the wrong rate and reimbursements for lost or damaged returns that never arrived.
What a settlement report contains
- Order-level sale amounts, including shipping charged to the customer.
- Commission and fixed or closing fees per order.
- Shipping and logistics fees charged by the marketplace.
- Refunds and reversals for returned or cancelled orders.
- Tax collected at source under GST and tax deducted under income tax, where applicable.
- Other adjustments such as claims, reimbursements, penalties and advertising charges.
- The net amount transferred and the settlement period.
Each marketplace uses its own format and its own names for similar charges. The first job is to map each charge type to an account in your books.
Step-by-step reconciliation
- Import the settlement report for the period into the ERP.
- Match each order line to the invoice you raised for that order.
- Post fees and charges to expense accounts, with GST on fees as input tax where applicable.
- Record tax collected or deducted at source as receivable from the government.
- Match refunds to credit notes for returned orders.
- Compare the net settlement with the bank receipt.
- List unmatched orders, unexpected fees and missing reimbursements for follow-up.
What usually goes wrong
Orders delivered but not yet settled are normal, since marketplaces pay on their own cycles. They become a problem when they stay unpaid beyond the expected cycle. A good reconciliation keeps a list of delivered-but-unsettled orders with their age.
Fees are another common issue. Rate cards change, weight slabs are misapplied and categories are sometimes wrong. Comparing actual fees per order with the expected fee from the current rate card shows overcharges you can raise with the marketplace.
Returns create the most noise. A return reverses the sale, may still carry a fee, and may arrive damaged or not arrive at all. If a returned unit is lost or damaged in the marketplace’s care, a reimbursement claim may be possible within the marketplace’s time limits.
Reconciling tax collected at source
Marketplaces collect GST TCS on sales made through them and report it against your GSTIN. You can then claim it in your GST cash ledger. Record TCS from each settlement in your ERP and compare the monthly total with what appears on the GST portal. Differences should be raised with the marketplace before the period closes.
Settlement reconciliation checklist
- Every settlement report downloaded and imported, with no gaps in periods.
- Each charge type mapped to an account.
- Order-level matching to invoices and credit notes.
- Ageing list of delivered but unsettled orders.
- Fee check against current rate cards.
- Claims list for lost or damaged returns, with deadlines.
- Monthly TCS comparison with the GST portal.
- Net settlement matched to bank receipt.
Marketplace report formats, fee structures and claim windows change. Recheck your mapping whenever a marketplace announces a change, and read the current seller policies rather than relying on past experience.
Advertising and other charges
Some marketplaces deduct advertising spend, storage fees for their fulfilment centres, or charges for optional services directly from settlements. Others invoice them separately. Either way, record them as distinct expense lines rather than mixing them into commission. When advertising is buried inside settlement deductions, it becomes hard to see the real return on ad spend per channel.
Download the monthly fee and service invoices each marketplace issues to you. They are the documents your CA needs to claim GST credit on those charges, and they should agree with the total fees in that month’s settlements.
Who should own reconciliation
Give one person clear ownership of marketplace reconciliation, with a weekly slot to do it. In small brands this is often someone in accounts or operations who already works with the seller panels. The founder should see a short summary: amount reconciled, amount unmatched, and claims raised and recovered.
Tracking recoveries matters. When the team can see that claims and fee disputes bring money back, reconciliation stops feeling like clerical work and starts being treated as part of protecting margin. It also gives you evidence when discussing recurring issues with your marketplace account manager.
Where to start
- Download the last three months of settlement reports for each marketplace.
- Build a mapping of charge types to accounts with your accountant.
- Reconcile one month manually to see where the gaps are.
- Set up automatic import and matching in the ERP.
- Review unmatched items weekly and raise claims promptly.
Anadoris Digital builds marketplace settlement reconciliation into ERP setups, so unpaid orders and fee differences surface every week rather than at year end.
Related service: ERP Solutions · More on this topic: ERP Solutions articles
