Flipkart Margin Reconciliation FLIPKART
Per-SKU margin and settled payout share % in one click.
Step 1 — Download these files from the marketplace
FILE 01
Flipkart Settled Transactions Report (.xlsx)
Flipkart Seller Hub → Reports → Reports Centre → Request New Report → Payment Reports → Settled Transactions → Request Report → select the date range → Submit → Download. Must contain the "Orders" sheet.
FILE 02
⬇ Download SKU Cost Master template (CSV)
SKU Cost Master (.csv or .xlsx)
Two columns: SKU and Cost per unit. Template below.
Fill it once — Column A: your SKU exactly as on the marketplace, Column B: cost per unit. Reuse it every month.
Step 2 — Upload & generate
Log in to generate this report. New sellers get 3 free reports a month.
What this report does
✓Your true per-SKU profit and margin % on what Flipkart actually settled — after all fees and returns
✓Fees, returns and short-settled orders handled so your margin is never overstated
✓Every SKU tagged Hero / Cash Cow / Bleeder / Kill — a ready reprice / promote / drop list
✓Revenue and unit Pareto — the vital few SKUs, at a glance
✓Flags any SKU with no cost mapped, so nothing slips through uncosted
✓6-sheet Excel: Summary, Cleaned Data + Analytics, SKU P&L Lite, Action List, Unmapped SKUs, Cost Master Used
Use case
Run after every settlement. Separate SKUs that earn from SKUs that quietly bleed on fees and returns, and build the reprice / kill / scale shortlist for the account.