How to Do Flipkart Marketplace Settlement Reconciliation Step by Step
Turn the Flipkart settlement report into a simple Expected vs Actual check — and stop losing money to unnoticed deductions.
- • 1. Why Flipkart Settlement Reconciliation Matters
- • 2. Step 1: Download and Read the Flipkart Settlement Report
- • 3. Step 2: Verify Every Flipkart Commission and Fee Deduction
- • 4. Step 3: Build Expected vs Actual and Classify Each Order
- • 5. Step 4: Handle Returns and Cross-Cycle Adjustments
- • 6. Step 5: Raise Disputes With Evidence
- • 7. Reconcile Flipkart Settlements Faster With ecommercetool.io
- • 8. Key Takeaways
1. Why Flipkart Settlement Reconciliation Matters
This guide shows how to do Flipkart marketplace settlement reconciliation step by step. Flipkart pays you after deducting commission, fees, GST on those fees, TCS and TDS — and returns are often adjusted in a later payout cycle. If you only watch the bank credit, you cannot tell whether a lower amount is a normal deduction, a return adjustment, or an error.
Marketplace settlement reconciliation means one thing: for every order, compare what you should have received (Expected) with what actually reached your bank (Actual), and investigate every difference. Done weekly, it takes minutes; done once a year, it becomes impossible.
Difference = Actual Payout − Expected Payout. Zero (within ₹1 rounding) means matched. Anything else needs a reason you can write down.
2. Step 1: Download and Read the Flipkart Settlement Report
In Seller Hub, open the Payments section and download the settlement / payment report for the cycle you want to check. Export it as a spreadsheet so each order sits on its own row.
You do not need every column. For reconciliation you need these fields for each order:
Two orders can have the same value. Always join the settlement report to your order list using the Order ID.
3. Step 2: Verify Every Flipkart Commission and Fee Deduction
Flipkart commission and fee deductions, line by line
Recalculate each deduction from your category rate card and compare it with the report. The example below uses illustrative rates for a ₹799 apparel item (5% GST) — your category, price band, weight and zone will change the numbers.
TCS (0.5% since July 2024) and TDS under Section 194-O (0.1% since October 2024) are not costs — they are tax credits you can claim. Track them separately so they do not look like missing money.
Shipping fee is billed on the higher of actual and volumetric weight. A wrong weight on the courier side is one of the most common reasons a deduction does not match.
| Line item | Basis | Amount |
|---|---|---|
| Selling price | Paid by customer | ₹799.00 |
| Commission | 10% of selling price (illustrative) | − ₹79.90 |
| Fixed fee | Per order | − ₹25.00 |
| Collection fee | 2% of selling price | − ₹15.98 |
| Shipping fee | Weight + zone slab | − ₹70.00 |
| GST on fees | 18% of ₹190.88 | − ₹34.36 |
| Marketplace settlement | ₹573.76 | |
| TCS (GST) | 0.5% of taxable value ₹760.95 | − ₹3.80 |
| TDS (Sec 194-O) | 0.1% of gross sale | − ₹0.80 |
| Expected bank credit | ₹569.16 |
4. Step 3: Build Expected vs Actual and Classify Each Order
For every order, write the Expected value from your calculation and the Actual value from the report. Then classify the difference with simple, consistent rules:
| Status | Rule | What to do |
|---|---|---|
| MATCHED | Difference within ±₹1 | Nothing — close it |
| UNDERPAID | Actual lower than Expected | Check fees, weight, return adjustments |
| PARTIAL | Actual is 60% or less of Expected | Likely a split or pending payment — wait one cycle, then raise a ticket |
| OVERPAID | Actual higher than Expected | Check for a later recovery or reversed refund |
5. Step 4: Handle Returns and Cross-Cycle Adjustments
A returned order may show a positive payout in one cycle and a negative refund line in the next. Reconcile at order level across cycles, not cycle by cycle, or every return will look like an error.
Mark returned orders in your returns log, record the reverse shipping charged, and check whether the refund deduction equals the original credit.
If a refund line and a fresh credit for the same Order ID land in different cycles, net them together before flagging an underpayment.
6. Step 5: Raise Disputes With Evidence
7. Reconcile Flipkart Settlements Faster With ecommercetool.io
The free Settlement Reconciliation module calculates the expected settlement from your logged orders, compares it with the payout you enter, and labels every record as Matched, Underpaid, Overpaid or Partial. You can store the UTR / NEFT reference or dispute ticket ID on each settlement.
All data stays in your browser — your payouts and margins are never sent to a server.
8. Key Takeaways
Frequently asked questions
What deductions appear in a Flipkart settlement?
Typically commission, fixed fee, collection fee and shipping fee, 18% GST on those fees, TCS and TDS, plus refund and reverse-shipping lines for returned orders. Exact rates depend on your category rate card.
Are TCS and TDS a loss for the seller?
No. TCS (0.5% under GST) and TDS under Section 194-O (0.1%) are tax credits. Track them separately and claim them; do not treat them as missing money.
How often should I reconcile Flipkart settlements?
Reconcile every payout cycle, ideally weekly, so disputes are raised while the claim window is still open.
Why does a returned order look underpaid?
Returns are often adjusted in a later payout cycle. Net the original credit and the refund line for the same Order ID before flagging an underpayment.
Free tools for this guide
- SettlementsFree ecommerce settlement reconciliation tool: compare expected payouts after commission, fees, TDS and TCS with what the marketplace paid, order by order.
- OrdersFree ecommerce order management for small sellers: track every order from pending to delivered or returned, linked to dispatches. Data stays in your browser.
- Return ManagementFree ecommerce return management tool: log returns as they arrive and compare them with expected returns per SKU and date to find your return gap early.
- ReportsFree ecommerce GST report tool: daily and monthly profit and loss, product performance, inventory movement and a GST audit built from your own data.
Try it with your own numbers
Open the free seller dashboard: no signup, no fees, and your data stays in your browser.
Open the free dashboard