Flipkart settlement report explained, column by column

What each column of Flipkart's settlement report means, how a row adds up to its bank settlement value, and three checks to see if a payout came up short.

Natium Labs

4 min read ·

Every Flipkart payout comes with a settlement report. It shows, order by order, how Flipkart got from what your customers paid to what reached your bank. It looks dense, but it follows one simple rule: each row is one order item, and each amount has its own column. That is the opposite of Amazon's settlement file, where each line is a single amount (our Amazon settlement report guide covers that one).

Flipkart changes this report's layout from time to time, and the column names differ between versions. The names below are the ones Natium's reader looks for; we haven't yet checked them against a Seller Hub download from this year, so yours may be worded differently. If a name doesn't match, look for the nearest one.

Downloading it

  1. In Seller Hub, open Payments → Settlements, or Reports → Report Centre → Payments.
  2. Pick the dates (up to the last 90 days) and request the settlement report.
  3. Download it when its status shows Generated.

Menu names are Flipkart's own and sometimes move. The report comes as an Excel workbook with several sheets; the one that matters most is the orders sheet. Keep the file as it is: re-saving it can turn long order ids into rounded numbers, and then they no longer match anything.

Reading the orders sheet

Some versions have a row of group headings above the column names, such as one heading over all the fee columns. The column names are on the row below. From there on, every row is one order item in one settlement.

The columns that matter:

ColumnWhat it tells you
Order ID, Order item IDThe order, and the item within it. An order with two products has two rows.
NEFT IDThe bank transfer that paid this row. Many rows share one NEFT ID.
Payment DateWhen Flipkart paid it, not when the order was placed.
Seller SKU, QuantityThe product and how many units.
Fulfilment TypeFBF if Flipkart's warehouse shipped it, non-FBF if you did.
Sale AmountWhat the customer paid for the item.
RefundMoney returned to the customer on a return or cancellation.
Commission, Fixed Fee, Collection FeeFlipkart's fees. The collection fee depends on whether the order was prepaid or cash on delivery.
Shipping Fee, Reverse Shipping FeeDelivery to the customer, and the trip back on a return.
TCS, TDSTax held back from your payout.
Bank Settlement ValueWhat Flipkart paid you for this row after everything above.

You may also see a return type (customer return, or courier return for an order that was never delivered), a Seller Protection Fund (SPF) amount where a claim was paid, a pick and pack fee on FBF orders, and ads charged against your payout.

TCS and TDS

Two taxes are held back on every payout: GST TCS of 0.5% and income-tax TDS of 0.1%, both worked out on the price before GST. Neither is a fee. Both come back to you as credits, as long as what Flipkart reports matches your own sales. Our TCS and TDS guide explains where the credits show up.

Three checks worth doing

Each row adds up to its bank settlement value. Take the sale amount, take off the refund, the fees, shipping, TCS and TDS, and add any SPF amount. The result should equal the row's bank settlement value. Before you add up, check which sign your file uses: some versions show fees as negative numbers, others as positive amounts to subtract. A row that pays less than its own amounts add up to is worth raising.

Each NEFT ID matches a bank credit. Add up the bank settlement value of every row with the same NEFT ID. That total should match one credit in your bank statement, on or near the payment date. A NEFT ID with no matching credit, or a credit for a different amount, is the first thing to ask Flipkart about.

Reverse shipping on undelivered orders. Look at the rows whose return type is a courier return: orders the customer never received. If they carry a reverse shipping fee, compare that with Flipkart's current terms for your account. Whether such a charge applies depends on those terms, so check them in Seller Hub before raising it. Customer returns are a different case, and for damaged or wrong items sent back, Flipkart's Seller Protection Fund may apply, within its filing window.

To check a fee against what you expected for the category and price, the Flipkart fee calculator gives an estimate. Your own rate card in Seller Hub is what counts.

Keep the evidence together

If you raise a ticket, Flipkart decides it. Keep the order id, the order item id, the NEFT ID, the rows from the report and your bank statement line together, so the case is easy to follow.

Part of Settlement reports explained: what every marketplace, courier and payment-gateway report holds, where to download it, and how to check it.

Was this useful?

Written by Natium Labs

Natium checks every marketplace, courier and payment-gateway payout against the orders it came from, and shows you anything that came up short. We write about the fees and rules behind those payouts, with sources.

Responses

What are your thoughts?

We email you a link to confirm, then read each comment before it's shown. Privacy

No responses yet. Questions from other sellers are welcome.

Were you actually paid this?

A calculator shows what an order should pay. Natium checks what each payout really paid: upload the settlement report you already download, and see anything that came up short, with the proof. Finding shortfalls is free, no card.