A Flipkart settlement report lists, order item by order item, what the customer paid, what Flipkart deducted (commission, fixed and collection fees, shipping fees, GST on fees, tax at source), any return or adjustment entries, and the net amount paid to you. Exact column names vary by report type and version, so read your own file's header row and confirm fees against your seller agreement and rate card.
What a Flipkart settlement report actually shows
A Flipkart settlement report is the seller-side record of how much Flipkart owes you for a set of orders and how it arrived at that number. Each row usually ties an order item to a sale value, a set of deductions and a net amount that reaches your bank account.
Column names, order and grouping differ between report types and change over time. Treat any list of columns, including this one, as a map and not a rulebook. Download the report from your seller dashboard, read the header row of your own file, and ask your Flipkart account manager or support if a label is unclear.
It helps to think of the columns in four groups:
- Identifiers and dates that tell you which order and which payment cycle a row belongs to.
- Value columns that show what the customer paid and who funded the discounts.
- Fee and deduction columns that show what Flipkart charged.
- Returns, adjustments and payout columns that show corrections and the final amount.
Identifier and date columns
These columns let you match a settlement row to your own records. Without a clean match, nothing else can be checked.
- Order ID and order item ID: one order can hold several items, and fees are usually applied per item. Always match at item level.
- SKU or FSN: the product identifier. Use it to map rows to your own SKU master and to compare fees across products.
- Order, dispatch and delivery dates: useful for finding delayed dispatches, which can affect penalties or protection eligibility under your agreement.
- Settlement date, payment reference or UTR: links the row to a bank credit in your statement.
Note that the settlement date can fall in a different month from the order date. If your books follow order or invoice date, you need a timing bridge between the two, otherwise month-end numbers will not agree.
Value columns: what the customer paid versus what you earned
Value columns start the calculation. Typical labels include selling price, invoice amount, shipping or delivery charges collected, and discount or offer amounts.
- Selling price or invoice value: should agree with the invoice you generated or the price you listed at the time of order.
- Seller-funded discounts or offers: these reduce your realisation. Check them against the promotions you actually opted into.
- Marketplace-funded discounts: if shown separately, confirm whether they are added back to your payable value or not, using your agreement and promotion terms.
The most common confusion is between the amount the customer paid and the amount on which fees are calculated. Your rate card or seller agreement defines the fee base. Do not assume it is the same as the selling price.
Fee and deduction columns
This is where most disputes start. Fee columns are often split into several heads, and the names may differ in your file.
| Column group | What it usually represents | Where to verify |
|---|---|---|
| Commission | Marketplace fee on the sale, usually by category or price band | Seller agreement, current rate card |
| Fixed or closing fee | Per-item charge, if applicable to your category | Rate card |
| Collection or payment fee | Charge linked to the payment mode, if applicable | Rate card |
| Shipping or weight-based fee | Forward logistics charge based on weight, zone or slab | Rate card, your product weight data |
| Reverse shipping fee | Charge on returned items | Rate card, return rows |
| Other fees or penalties | Cancellation, delay or service charges | Seller policies, support tickets |
| GST on fees | Tax charged on the marketplace's services | Fee invoice, your tax adviser |
| TCS or TDS | Tax collected or deducted at source | Your tax adviser, tax portal statements |
We have deliberately not listed rates. Fee rates and tax rules change, so always confirm the latest terms in your current rate card and with your tax adviser.
Returns, adjustments and net payout columns
Returns rarely reverse in the same cycle as the original sale. A return can show up as a negative row, or as a reversal of earlier commission, in a later settlement.
- Return or RTO reversal: the sale value taken back. Check whether the commission was also reversed, as per your agreement.
- Reverse shipping or return fees: charged separately in many cases.
- Adjustments, claims or protection credits: money added back for approved claims. Keep the claim reference so you can match it.
- Net settlement amount: sale value less deductions, plus or minus adjustments. This is what should match your bank credit once rows are grouped by payment reference.
If a returned item has a deduction but no matching credit, or the return never appears, that row belongs in a recovery list.
A practical way to check each row
- Match the order item ID to your own order or invoice data, and confirm SKU and price.
- Recompute each fee from your rate card using the fee base and slab that applies to that item.
- Compare your expected total deduction with the total charged and note the variance.
- Group rows by payment reference and confirm the sum equals the bank credit.
- Carry unresolved variances and unreversed returns into a tracker with the order ID, amount, date raised and status.
Doing this by hand for thousands of rows is where teams lose time. 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 reviewed today, and other marketplaces, including Flipkart, are a scope discussion.
Worked example
Illustrative example only. All figures are made up to show the method and are not real rates or results.
| Line (one order item) | Amount (₹, illustrative) |
|---|---|
| Selling price | 1,200 |
| Commission | -180 |
| Fixed fee | -20 |
| Collection fee | -25 |
| Shipping fee | -70 |
| GST on fees | -50 |
| Tax deducted at source | -20 |
| Net settlement | 835 |
Total fees charged (excluding tax at source) are 180 + 20 + 25 + 70 + 50 = ₹345. Suppose your rate card and weight data give an expected total of ₹325 for this item. The variance is ₹20. You would raise it with the order item ID, the fee head that looks different (for example, the shipping fee slab) and your supporting weight or rate card evidence. If the item is later returned, check that the sale value and the related fee reversals appear in a following cycle.
Questions and answers
Why do my Flipkart settlement report columns look different from another seller's?
Column names and layout depend on the report type, the version and your account setup. Fee heads can also differ by category and agreement. Read your own file's header row, and ask Flipkart seller support to clarify any column whose meaning is not obvious.
Which column should match my bank credit?
The net settlement or payable amount, once rows are grouped by the payment reference or UTR, should match the bank credit. Individual rows will not match a single credit, so total them by payment reference before comparing with your bank statement.
Where can I find the correct commission and fee rates?
Use your signed seller agreement and the current rate card shared by Flipkart for your category. Rates and slabs can change, so confirm the latest terms with your account manager and keep a dated copy for each period you are checking.
Why are returned orders showing as negative amounts?
A return is usually settled as a reversal of the original sale value, and sometimes related fees, in a later cycle. It may also carry a reverse shipping charge. Match each negative row to the original order item to confirm it is correct.