Flipkart settlement reconciliation
Last reviewed·ReconPe Editorial
Flipkart’s payout structure packs commission, fixed fee, collection fee, and shipping fee into separate columns of the Payments Report — each with its own category-specific variance pattern. ReconPe parses the four-fee structure, reconciles every order via ACRE probabilistic matching, flags per-fee variance against your rate card, and carries open exceptions across cycles so F-Assured claim reversals and return deductions from earlier runs auto-link when they eventually settle.
Where Flipkart reconciliation breaks down manually
Flipkart has five distinct fee types
Commission, fixed fee, collection fee, shipping fee, and F-Assured fee — each calculated on different slabs. Manually verifying all five across thousands of orders is where margin gets lost.
F-Assured adds another layer of variance
F-Assured orders carry premium fees in exchange for faster delivery promises. ReconPe isolates F-Assured line items and confirms the fee charged matches the Flipkart Plus rate card — catching miscategorised orders automatically.
Return deductions are often opaque
Flipkart deducts return shipping, customer-claim settlements, and quality-check adjustments as separate line items on later settlements. ReconPe links deductions back to the original order so you can trace what was recovered and what wasn't.
Settlement cycle creates timing gaps
Flipkart settles on a T+7 to T+10 cycle depending on seller tier. Funds for a given invoice date may arrive across two bank credits over different days. ReconPe handles split settlements automatically without manual aggregation.
How ReconPe handles Flipkart
Per-order fee variance against rate card
Upload your Flipkart rate card once. Every settlement row is compared against expected commission, fixed fee, F-Assured, and shipping — variance is flagged per order with exact rupee impact.
Audit-ready output for Flipkart account reviews
Every reconciliation run produces a versioned export with source, target, variance, and resolution context. CAs and Flipkart category managers get the clean trail they ask for.
Why a Flipkart payout rarely matches on the first try
The Flipkart settlement workbook is one of the messier files in Indian commerce. These are the specifics ReconPe handles because it was built against the real file — including the rounding and header quirks that only show up in an actual export.
Returns carry a type, and the type matters
A customer return and a courier/logistics return hit your money differently. ReconPe reads the Return Type column, links each reversal back to its original order, and nets same-cycle reversals — so a deduction is traced, not just subtracted.
TCS and TDS are credits, not costs — if you claim them
The 0.5% TCS (GST Sec 52) and 0.1% TDS (Sec 194-O) Flipkart deducts are recoverable: TCS as GST credit via GSTR-2B/8, TDS against income tax via 26AS. ReconPe separates both per cycle, and the GST suite triangulates settlement ↔ GSTR-2B/8 ↔ 26AS so the credit actually lands.
A Flipkart payout is four streams, not one
A single bank NEFT nets your orders, fee rebates, storage-recall charges and ads-wallet settlement together. Match the Orders sheet alone and every payout reads as short. ReconPe aggregates all four into the expected credit, with a ₹5 tolerance that absorbs Flipkart's per-line versus bank-recorded rounding.
Roughly thirteen sheets — one is a help page
The settlement workbook ships Orders, MP Fee Rebate, Storage Recall, Ads, TCS Recovery, TDS, GST Details and more. ReconPe reads the sheets that carry money and skips the instructional cover sheet that otherwise gets parsed as 83 rows of garbage.
Headers arrive with Excel formulas baked in
Real Flipkart exports carry text like "Commission (Rs.) =SUM(...)" inside the header cell. ReconPe sanitises the formula out before mapping — without it, every downstream column shifts by one and the whole file mis-reads.
TCS, TDS and GST come out as their own lines
Rather than lumping statutory deductions into one fee blob, ReconPe separates TCS recovery, TDS and the GST charged on each fee — so the input-credit and TDS-credit figures you file are the reconciled ones.
Inside the Seller Hub settlement workbook
The settlement export is a multi-sheet Excel workbook — roughly thirteen sheets, one of which is an instructional cover page that parses as garbage if software reads it as data. These are the sheets that carry money, and what each one does to your payout:
| Sheet | What it carries |
|---|---|
| Orders | Order-item rows — the money sheet: sale value, commission, fixed fee, collection fee, shipping fee, per item |
| MP Fee Rebate | Marketplace-fee rebates credited back — misses here understate your expected payout |
| Storage Recall | Warehouse storage and recall charges deducted from the cycle |
| Ads | Ads-wallet settlement lines netted into the same NEFT as your orders |
| TCS Recovery | Tax collected at source under GST Sec 52 — credit you claim back via GSTR-2B/8 |
| TDS | Income-tax TDS under Sec 194-O — credit that must show up in your 26AS |
| GST Details | The GST charged on Flipkart's own fees — input credit most sellers never claim |
Plus summary and help sheets that carry no money. Two traps inside the real file: header cells arrive with Excel formulas baked in ("Commission (Rs.) =SUM(...)") — unsanitised, every downstream column shifts by one — and a single bank NEFT nets the Orders sheet and the rebates, storage, and ads sheets together, with per-line rounding that ReconPe absorbs with a ±₹5 payout tolerance.
A worked example: a commission slab error on one order
Illustrative — a single Flipkart apparel order, checked against your rate card. The figures are examples; the per-order variance is exactly what compounds invisibly across a month.
- Order value
- ₹1,499.00
- Commission — rate card says 12%
- − ₹179.88
- Commission — actually charged at 15%
- − ₹224.85
- Fixed + collection + shipping fees
- − ₹123.00
- TCS u/s 52 (0.5%)
- − ₹7.50
- ReconPe flags
- ₹44.97 commission variance (15% vs 12%)
₹44.97 on one order is invisible in a spreadsheet. Across 2,300 apparel orders in a month it is ₹1.03 lakh of commission charged above your contracted slab — recoverable, but only if you catch it inside Flipkart’s dispute window.
Frequently asked
Does ReconPe handle Flipkart Plus and F-Assured fees differently?
Yes. F-Assured orders are flagged in the Flipkart settlement report and ReconPe's rule engine applies the F-Assured fee slab separately from the standard commission. If you expect F-Assured fee on an order and it wasn't charged (or was charged on a non-F-Assured order), ReconPe flags it as a type mismatch.
Can ReconPe reconcile Flipkart returns and RTO entries?
Yes. Returns, RTOs, and customer-claim settlements from Flipkart appear as negative line items on later settlement reports. ReconPe links them back to the original order by SKU + order ID and flags cases where the net refund doesn't match the original settlement.
How does ReconPe handle Flipkart's split settlements?
Flipkart often splits a single order's payout across two settlement dates (typical pattern: commission and fixed fee on one cycle, shipping deduction on the next). ReconPe's matching engine reconciles across the full invoice period rather than forcing a 1:1 match per day.
Does ReconPe work for Flipkart Grocery and Flipkart Wholesale?
Yes. Both Flipkart Grocery and Flipkart Wholesale use the same core settlement report schema. ReconPe's auto-detection handles the variant columns without requiring a new rule set per vertical.
What about commission variance on promotional orders (Big Billion Day etc.)?
Promotional-event orders often carry reduced commission or waived fees. If your rate card captures the promotional rate for that window, ReconPe compares actuals against it. Otherwise, all promotional orders are grouped so you can review them together.
How do I download the Flipkart settlement report from Seller Hub?
In Seller Hub, go to Payments → Reports (Statements), pick the settlement cycle or date range, and download the settlement/payment report as an Excel workbook. Download the full workbook, not a single tab — the fee rebates, storage charges, ads settlement, TCS/TDS and fee-GST all live on separate sheets, and reconciling the Orders sheet alone will make every payout look short.
What are non-order charges in a Flipkart settlement?
Lines that adjust your payout but aren't order events: ads-wallet settlement, storage and recall charges, marketplace-fee rebates, and payment adjustments. They net into the same bank NEFT as your order payouts, which is why ReconPe aggregates all the workbook's money sheets into the expected credit instead of matching the Orders sheet alone.
How do I dispute a wrong Flipkart deduction?
Raise it through Seller Hub support against the specific order ID with the fee line you're contesting, inside the dispute window. The evidence that wins is per-order specificity: your rate card slab, the fee actually charged, and the variance. ReconPe's per-order variance flags give you exactly that line-level context to paste into the ticket.
When does Flipkart pay sellers — what is the settlement cycle?
Prepaid orders typically settle on a T+7 to T+10 cycle from dispatch depending on your seller tier; COD takes longer since it's tied to remittance. Funds for one invoice period can arrive across two bank credits, which is why ReconPe reconciles across the full period rather than forcing per-day matching.
How long does the first Flipkart reconciliation take?
Under 5 minutes. Upload your Flipkart settlement report and bank statement, let schema detection run, review the suggested rule set, and kick off reconciliation. The first clean run ships on day one.
How to verify a Flipkart settlement report (five checks)
The bank credit matches the report total — and the report can still be wrong. Riya verifies a 76-column Flipkart settlement in five checks: NEFT, fees, weight, returns, coverage.
Reconcile your other settlements
Audit your next Flipkart settlement in minutes
Free tier — 5 free reconciliations, 1 marketplace. Catch the fee variance your spreadsheet is quietly missing.
Start free