{# FAQPage only where the questions are rendered on the page (the guide's FAQ section). Must live INSIDE this block: top-level content in a child template is discarded. #}
Amazon tools · Profit & Fees

Flipkart Payment Reconciliation

Flipkart pays in many small NEFT transfers, after fees, TCS, TDS, reverse shipping and returns. Upload the Settlement Report (and your Sales Report) to check every sold item was paid, see what each return cost you, spot fee overcharges and get one Tally journal per bank transfer.

  • Private: your report is processed on our server in memory and deleted straight away. We never store it or look at it.
  • No login and no Amazon API connection needed
Step-by-step guide: which report to download & what to do
Where do I find these reports?
Settings

Tally journal

Guide

How to use the Flipkart Payment Reconciliation

1. Download the reports

Flipkart Settlement Report

  1. 1Flipkart Seller Hub → Payments → Settlements (or Payments Overview) → Download report.
  2. 2Choose the payment dates (for example the whole month, and the first two weeks of the next month so late payments are included) and download the .xlsx.
  3. 3Upload the file as it is: the Orders, Storage_Recall, Ads, Non_Order_SPF, TDS and GST_Details sheets are all read. More than one report? Upload them together; repeated rows are read once.

Flipkart Sales Report (to find unpaid items)

  1. 1Seller Hub → Reports → Report Centre → Tax reports → Sales Report for the month (.xlsx).

Menu names in Seller Central change now and then. If a label looks different, search the report name in Seller Central's search bar.

2. Read the results

Not paid

Items sold (Sales Report) at least the "due after" days before the last payment, that are in no uploaded payment.

Sales vs payments

Every sold item with Flipkart's Sale Amount, refunds, fees and what reached you. A gap up to the item's shipping charge counts as paid (Flipkart sometimes leaves it out of Sale Amount).

Returns

Customer returns and courier returns (RTO), the reverse shipping fee, the fees Flipkart kept and any protection fund (SPF) paid. Returns Flipkart does not expect back with no SPF are flagged.

Fee check

Commission, fixed, collection, pick & pack and shipping fees well above the SKU's usual, and weight slabs above the SKU's usual slab.

Charges by type

Every fee, storage and recall fee, ads and SPF in the reports, with GST.

Bank transfers

One row per NEFT ID: match the amount with your bank statement.

Tally journal

One journal per NEFT: Dr Bank, Cr customers, Dr Flipkart (fees + GST), TCS and TDS receivable, SPF income.

3. What to do next

  • Raise a Seller Hub ticket for each "Not paid" item that was delivered, with the order ID.
  • For returns Flipkart doesn't expect back (and anything damaged, used or wrong), raise an SPF claim with photos and the unboxing video.
  • Check the weight and dimensions of SKUs in the Fee check: a wrong weight slab costs you on every order.
  • Import the Tally XML after your sales vouchers (Flipkart to Tally), so the customers ledger clears.

4. Good to know

  • •Settlement Reports go by payment date, Sales Reports by invoice date: upload the settlements for the sales month and the next month.
  • •TCS and TDS shown here are claimable: TCS in your GST return (it shows in GSTR-2A / TCS credit), TDS in your income-tax return (Form 26AS / AIS).
  • •GST on Flipkart fees is input tax credit through Flipkart's monthly commission invoice; with "fees to the party ledger", book that invoice as a purchase.

5. FAQ

Why is "Sale Amount" different from my invoice value?

Flipkart sometimes pays the shipping charge separately or funds part of an offer. Differences up to the shipping charge are treated as paid; anything else is listed under "Paid a different amount".

Are my files stored?

No. They are processed on our server in memory and deleted straight away. Settlement and Sales Reports hold no buyer names or addresses.

It says a column is missing. What now?

You probably uploaded a different report, or Amazon renamed a column. Download the report exactly as in step 1. If it still fails, tell us the report name and we'll add support.

Request a feature

Tell us what would save you time. We'll reach out if we have questions.

Your contact details, so we can ask questions

Open full form