To reconcile Flipkart orders with settlement, download the orders, settlement and returns reports for the same period, match them on order item ID, recompute fees against your rate card, net off returns and adjustments, then tie the settlement total to the bank credit. Log every unexplained difference with the order item ID and amount, and raise it with Flipkart within the dispute window in your seller agreement.
Why Flipkart settlements rarely match orders line by line
A Flipkart payout is not the sum of order values. It is net of commission, fixed and collection fees, shipping charges, returns, penalties, adjustments and tax deductions. It also follows the settlement timeline, not the order date. So the order report and the bank credit will never match unless you bridge the gap deliberately.
Reconciliation means tracing every rupee from order item to bank credit and explaining each difference. The aim is not a perfect match on day one. The aim is a short list of unexplained items that you can raise with Flipkart with evidence.
Reports you need before you start
Collect these for the same period, with a few extra days on either side to catch orders that settle late:
- Orders report: order item ID, SKU, order date, status and selling price.
- Settlement or payment report from Seller Hub: per-item settlement value, fee breakup, settlement date and payment reference.
- Returns report: return type (customer return or courier return), status and receipt date.
- Seller agreement and rate card: commission, fixed fee, shipping and collection fee terms for your categories.
- Bank statement: the actual credits received.
- Your sales ledger: what your accounts or ERP booked.
Report names and column headers can change, so download the current versions from Seller Hub and confirm what each column means before building formulas.
Step-by-step: reconcile Flipkart orders with settlement
- Choose the period and the key. Use the order item ID as the common key across all reports. Decide whether you are reconciling by order date (for sales) or settlement date (for cash). Do not mix the two.
- Match orders to settlement lines. Use a lookup on order item ID. Flag delivered orders with no settlement line, and settlement lines with no matching order.
- Check the sale value. Compare the selling price in the orders report with the sale value in the settlement. Differences usually come from offers or price changes.
- Recompute fees. Rebuild commission, fixed fee, shipping fee and collection fee from your rate card and compare with what was charged. Take rates only from your agreement, not from memory or old emails.
- Net off returns. Every return in the period should show a reversal. Check whether fees are reversed or retained as your terms say.
- List adjustments and tax deductions separately. Penalties, protection fund items and tax deductions should each have their own line. Confirm applicable rates and treatment with your tax adviser and the latest rules.
- Tie the total to the bank. Sum the settlement lines per payment reference and match to the bank credit. Any gap is a separate exception.
- Log exceptions. Record order item ID, amount, reason, date found and date raised.
Common mismatches and what usually causes them
| Mismatch | Likely cause | What to check |
|---|---|---|
| Delivered order, no payment | Not yet in the settlement window, or payment held | Order status and the settlement timeline in your agreement |
| Fee higher than expected | Wrong category, weight slab or price slab applied | Rate card, listing category and product weight and dimensions |
| Return not credited | Return not received or marked wrongly | Returns report status and receipt date |
| Bank credit differs from settlement total | Batching, deductions or split payments | Payment reference and bank statement |
| Same deduction twice | Repeated penalty or adjustment | Adjustment lines by order item ID |
Handling timing, returns and disputes
Timing causes most false alarms. An order delivered on the last day of a period may settle in the next one, so carry such items forward as open rather than as errors. Returns work similarly: a customer return may show in the returns report well before a reversal appears in settlement.
For real discrepancies, raise a ticket with Flipkart support using:
- the order item ID and settlement reference
- the expected amount, with the rate card clause you relied on
- screenshots or report extracts showing the charged amount
- for returns, the receipt status and any images you hold
Check your seller agreement and Seller Hub for the time limit on raising disputes, and confirm the latest terms. Delay can cost you recoveries.
Making it repeatable
Reconcile on every settlement cycle rather than once a quarter. Small gaps are easier to explain while the order and return records are fresh. Keep one template, one owner and one exception log with a status for each item: open, raised, recovered or written off.
If spreadsheets are becoming too slow, a tool can help. MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are currently reviewed, and other marketplaces, including Flipkart, are in scope discussion. Pricing is a tailored quote, so confirm coverage with Fundle first.
Worked example
Illustrative example only. The figures below are made up to show the method and are not real rates or results.
| Line (one settlement batch) | Expected (₹) | Actual (₹) |
|---|---|---|
| Sale value of 100 delivered items | 2,00,000 | 2,00,000 |
| Less: returns (12 items) | 24,000 | 24,000 |
| Less: fees as per rate card | 26,000 | 28,500 |
| Net payout | 1,50,000 | 1,47,500 |
The gap is ₹2,500 (illustrative). After checking by order item ID, ₹1,800 came from 6 items charged on a higher weight slab than the rate card allows, and ₹700 came from a return that was received but not reversed. Tax deductions are excluded here for simplicity and should be shown as their own line. You would raise both items with evidence and log them as open exceptions.
Questions and answers
Which key should I use to match Flipkart orders with settlements?
Use the order item ID, because it appears in the orders, settlement and returns reports. Order ID alone can cover several items with different fees and return outcomes. Confirm the exact column names in your current Seller Hub downloads, as headers can change.
How often should I reconcile Flipkart settlements?
Reconcile every settlement cycle if you can, or at least monthly. Frequent checks keep order and return records fresh and leave you inside the dispute window in your seller agreement. Confirm the current time limit with Flipkart before relying on any figure.
Why is my Flipkart payout lower than my order value?
The payout is net of commission, fixed and shipping fees, returns, adjustments and tax deductions. Some orders may also settle in a later cycle. Compare each deduction with your rate card and settlement report to see which are expected and which need a query.
Can I reconcile Flipkart settlements in Excel?
Yes. Export the orders, settlement and returns reports, join them on order item ID, recompute fees from your rate card and list exceptions. It works well at low volumes. As order counts grow, lookups become slow and error-prone, so many brands look at dedicated tools.