Flipkart Settlement & Fee Analyzer
Upload your Flipkart Settled Transactions Report (.xlsx, .xls) to view your sales, bank settlements, fee deductions, reverse shipping charges, returns, and fee leakages in one place.
Upload Flipkart Settled Transactions Report
Drag and drop your Flipkart Excel report (.xlsx, .xls) here or click to select from your files.
Analyzing workbook sheets...
Processing transactions, calculating marketplace charges and returns browser-side.
Business Health Score
Seller Performance Insights
Total Fee Leakage
₹0.00
Total fees lost on returns
Leakage % of Sales
0.00%
Leakage share of gross sales
Leakage % of Settlements
0.00%
Leakage impact on bank payouts
Fee Leakage Breakup
Top Leakage SKUs
| SKU | Orders | Rev. Shipping Loss | Total Loss |
|---|
Reverse Shipping by Zone
Top Reverse Shipping Loss SKUs
| SKU | Category | Charges |
|---|
Return Distribution
Top Return-Prone SKUs
| SKU | Delivered | Returns | Return % |
|---|
| SKU | Revenue | Settlement | Fixed Fee | Collection Fee | Rev. Shipping | Net Earnings | Fee % | Health |
|---|
Total Ads Charges
₹0.00
Ads Recovery (Topup)
₹0.00
Ads Cost vs Sales
0.00%
Ads Impact %
0.00%
Ads Cost vs Bank Settlement
Ads Wallet Transactions (Top 10)
| Date | Campaign / Trans ID | Type | Topup / Spend | GST |
|---|
Total TDS (IT)
₹0.00
Total TCS (GST)
₹0.00
Tax Deduction %
0.00%
Settlement Impact %
0.00%
Tax Deduction Distribution
Monthly TDS & TCS
| Month | TDS (IT) | TCS (GST) | Total Tax |
|---|
Total SPF Claims
0
Approved SPF Value
₹0.00
Recovery Success %
0.00%
Non-Order SPF Recoveries
| NEFT ID | Payment Date | Claim ID | SKU | Protection Reason | Recovered Value |
|---|
| Order ID | Order Item ID | SKU | Order Date | Dispatch Date | Sale (Rs) | Settlement (Rs) | Commission | Shipping | Rev. Shipping | Status |
|---|
Decoding the 70+ Column Flipkart Settled Transactions Report
Flipkart's raw Settled Transactions spreadsheet is one of the most complex financial reports in Indian e-commerce. With more than 70 columns spanning order details, commission tiers, payment gateway fees, forward and reverse logistics, and tax entries, finding out why a specific amount reached your bank can be overwhelming.
Flipkart Settlement & Fee Analyzer extracts and organizes these intricate transaction rows into focused diagnostic views. It audits total marketplace fees, identifies unrecovered return expenses, and tracks statutory withholdings across your payout cycle.
All processing occurs locally in your browser memory using client-side JavaScript. Your confidential sales records and customer information are never transmitted to any external server.
The Hidden Cost: Fee Leakage on Returned Orders
When a customer returns an order, the sale amount is reversed, but you do not get all your fees back. Instead, you are often left paying for:
- Reverse Logistics Charges: Courier costs for transporting returned parcels back to your warehouse.
- Non-Reversed Closing & Collection Fees: Certain fixed platform expenses that remain billed despite the return.
These unrecovered deductions constitute fee leakage. The Fee Leakage tab isolates these transactions so you can identify products with high return penalties and re-evaluate packaging or catalog descriptions.
Tracking Reverse Logistics Penalties by Delivery Zone
Return shipping fees on Flipkart increase significantly as delivery distances widen.
Under the Reverse Shipping tab, the tool categorizes return courier expenses across Local, Regional, and National zones. This breakdown helps you determine if shipping heavy or bulky products nationwide is generating unsustainable return logistics expenses.
Reconciling Tax Withholdings (TDS & TCS) and SPF Claim Recoveries
Marketplace settlements involve strict tax tracking and claim compensations:
- TDS & TCS Withholdings: The Taxes tab aggregates monthly deductions for Tax Deducted at Source (TDS under Income Tax) and Tax Collected at Source (TCS under GST) to simplify GSTR-8 and 26AS matching.
- SPF Recovery: The SPF tab tracks Seller Protection Fund reimbursements for damaged or swapped customer returns, helping you verify that approved claims were credited.
Step-by-Step: Auditing Your Flipkart Settlement File
- Log in to your Flipkart Seller Portal.
- Navigate to the Reports section and download the Settled Transactions spreadsheet (
.xlsxor.xls). - Drop the file into the upload zone above.
- Explore fee breakdowns, zone shipping charts, leakage reports, and export your order database as a CSV or Excel file.
