Flipkart Settlement & Fee Analyzer
Analyze your Flipkart settled transactions reports instantly. Identify sales, settlements, marketplace fees, reverse shipping charges, returns, TDS/TCS, and fee leakages in a single professional dashboard. 100% private and processed locally in your browser.
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 |
|---|
Maximize Your Flipkart Business with Advanced Settlement Analytics
What is Flipkart Settled Transactions Report?
The Flipkart Settled Transactions Report is the single most important financial record provided by the platform to its sellers. It is a comprehensive, transaction-level ledger that details every single rupee processed, withheld, or paid out by Flipkart. Every time an order is placed, dispatched, delivered, cancelled, returned, or refunded, a new transactional row is registered in this report. In addition to individual orders, the report tracks global adjustments such as Seller Protection Fund (SPF) claims, Google and Flipkart Advertising costs, and storage fees.
However, this raw data is typically delivered as a gigantic Excel spreadsheet containing over 70+ columns and thousands of rows. For a busy e-commerce seller, opening this file in Excel can be a daunting task. Key metrics like Commission, Fixed Fee, Collection Fee, Shipping Fee, and Reverse Shipping Fee are scattered across columns V through AI, while crucial tax details like TCS (Tax Collected at Source) and TDS (Tax Deducted at Source) are tucked away in columns 36 and 37. Analyzing this manually to calculate your real margins is near-impossible without an automated flipkart settled transactions report analyzer.
How to Download Flipkart Settled Transactions Report?
To audit your payouts and fees, you must first fetch the actual data sheet from the Flipkart Seller Portal. Follow this step-by-step guide to download your report:
- Access Seller Portal: Open your browser, navigate to the official Flipkart Seller Portal, and log in using your seller credentials.
- Navigate to Payments: Click on the Payments menu item on the top navigation bar and select Payments Overview from the dropdown.
- Find Previous Settlements: Under the payments dashboard, click on the Previous Settlements tab to view a historical record of your weekly/bi-weekly settlement cycles.
- Configure Date Range: Choose your target billing or settlement date range (e.g., Last 30 Days, Last Quarter, or a Custom Date Range).
- Download Settled Transactions: Click the Download dropdown button located on the right side of the list and choose Settled Transactions. The system will compile and download your file in standard Microsoft Excel (.xlsx) format.
Once downloaded, simply drag and drop the Excel file into our local flipkart settlement report analyzer to extract actionable performance insights instantly without uploading any sensitive client data to external servers.
Fee Leakage Analysis
One of the quietest killers of e-commerce profitability is fee leakage. When an order is returned or cancelled, sellers often assume that the transaction is fully reversed. However, Flipkart does not reverse all fee components. You are still billed picking and packing fees, non-reversed fixed fees, collection fees, and most importantly, reverse logistics shipping fees. These unrecovered service charges are known as fee leakage.
Our advanced flipkart fee analyzer automatically isolates these returned and cancelled transactions, sums up all unreversed commission percentages, fixed fees, and collection expenses, and calculates the exact net leakage value. By knowing which SKUs are bleeding the most cash on returned orders, you can adjust your retail pricing, optimize product listings, and stop shipping defective items to prevent heavy leakage losses.
Reverse Shipping Analysis
Returns are an unavoidable reality of online selling in India, but reverse logistics costs do not have to be a black box. In the Flipkart report, Col 26 maps out the exact Reverse Shipping Fee charged when a customer returns a product or when a package is marked as RTO (Return to Origin).
The integrated flipkart reverse shipping analyzer breaks down these charges per shipping zone (Local, Regional, National) and aggregates them per SKU. Since regional and national reverse shipping costs are significantly higher, this zone-level visualization helps you identify if high-weight items are being shipped long distances only to be returned. With this data in hand, you can configure regional delivery constraints, optimize packaging to reduce dimensional weight, and choose shipping partners wisely to safeguard your bottom line.
TDS & TCS Analysis
As per Indian tax regulations, marketplace platforms must deduct tax at source remitting payments to sellers. Under the GST framework, Flipkart deducts 1% TCS (Tax Collected at Source), recorded under Col 36 of the report. Under Income Tax laws, it also deducts 1% TDS (Tax Deducted at Source), listed in Col 37. These withholdings directly reduce your immediate net bank settlements.
Our analyzer compiles these deductions, aggregating them on a monthly basis. This centralized taxation log provides you with precise totals to reconcile with your GST portal (GSTR-8) and Income Tax portal (26AS) during tax filing seasons. Reclaiming this withheld cash ensures that your operational working capital remains fully optimized.
SPF Recovery Analysis
When customer returns arrive damaged, altered, or with missing items, sellers can file a claim under the Seller Protection Fund (SPF). The settled values of approved SPF claims are compiled in the dedicated `Non_Order_SPF` sheet of the Excel workbook.
The tool parses this sheet automatically, displaying your total filed claims count, approved claim amounts, and overall recovery success percentage. Instead of manually cross-referencing claim IDs with payout NEFTs, our engine maps SPF NEFT records directly to corresponding SKUs and transaction dates. This allows you to track your claims pipeline effortlessly, ensuring you recover maximum cost adjustments on return-damaged inventory.
SKU Profitability Analysis
A seller's catalog consists of various items, but not all of them generate equal returns. Some products might have high invoice volumes but contribute negative net profit due to high marketplace fee structures or massive customer returns. The SKU Profitability tab gives you a product-level breakdown of gross revenue, net bank settlements, fixed fee summaries, collection fees, and reverse shipping charges.
By computing the exact net earnings for each item, the tool calculates a custom SKU Health score (ranging from 0 to 100). Products with low return rates and minimal leakage score an "Excellent" rating, whereas high-weight items with low pricing and high return rates are highlighted with a "Risky" badge. This granular SKU intelligence enables you to make data-backed inventory purchasing decisions, prune unprofitable catalogs, and double down on your star products.
Seller Insights Dashboard
Our interactive flipkart seller dashboard acts as your central hub for high-level business intelligence. Upon uploading your workbook, the engine compiles a multi-tab workspace featuring responsive charts powered by Chart.js. The main overview panel presents circular progress gauges of your overall Business Health Score, computed by weighting return rates, fee sales ratio, reverse shipping impact, and profit margins. It also auto-generates custom Seller Performance Insights—such as identifying which shipping zones generate the highest returns, which single SKU dominates your cash payouts, and how much percentage of your bank payouts is consumed by reverse shipping fees.
Why Use This Tool?
Our client-side flipkart settlement analyzer is built specifically for modern e-commerce entrepreneurs who require fast, actionable, and 100% private financial audits:
- 100% Client-Side Privacy: We never upload your spreadsheets to any backend server. All reading, processing, and rendering occur entirely inside your browser's local sandbox memory. Your corporate financial data remains completely offline, secure, and private.
- Zero Configuration: No need to set up complex Excel macros, formulas, or pivot tables. Simply drag, drop, and view your complete business breakdown instantly.
- Multi-Format Exports: Download your virtualized order logs and consolidated reports as clean CSVs, print-ready PDFs, or optimized Excel workbooks with a single click.
- Completely Free: Access institutional-grade financial analytics, fee leakage tracking, and SKU health score indicators at zero cost.
Frequently Asked Questions
How do I download Flipkart Settled Transactions Report?
- Login to the Flipkart Seller Portal.
- Go to Payments > Payments Overview > Previous Settlements.
- Select your desired settlement date range (e.g. last 30 days).
- Click on the Download dropdown and select Settled Transactions report (Excel/xlsx format).