Flipkart P&L Calculator SELLER TOOL
Order & Payment Reconciliation · Profit Analysis per Order Item ID
1
Upload
2
SKU Costs
3
Configure
4
Results
📂 Upload Your Flipkart Files
Order Report: Seller Hub → Orders → Download Order Report (XLSX) — contains
Payment Reports: Seller Hub → Payments → Download (XLSX) — upload current month + next month together since Flipkart settles payments in the following month.
order_item_id, SKU, status.Payment Reports: Seller Hub → Payments → Download (XLSX) — upload current month + next month together since Flipkart settles payments in the following month.
Order Report — XLSX
Orders Export
Seller Hub → Orders → Download Report
Multiple files accepted
Multiple files accepted
Payment Reports — XLSX (multiple ok)
Payment Reports
Seller Hub → Payments → Download XLSX
Upload current + next month together
Upload current + next month together
📤 Import SKU Costs from Excel OPTIONAL
Upload an Excel / CSV file with your SKU costs. Must have a SKU column and a Cost column (any column name containing ‘sku’ and ‘cost’ works). Costs will auto-fill the table below.
SKU Cost File
Excel or CSV with SKU + Cost columns
Column names are auto-detected
Column names are auto-detected
Expected Format
| SKU | Cost |
|---|---|
| ez_men beige oversized M | 85 |
| ez_men white oversized L | 90 |
🏷️ Product Cost per SKU
All unique SKUs from your order report. Costs imported above are pre-filled. Edit any value manually. Blank = default fallback from Step 3.
Set all to ₹
| # | SKU | Product Title | Orders | Avg Sale | Your Cost (₹) |
|---|
💡 Avg sale from matched payments. Green row = cost imported from Excel.
⚙️ Cost Parameters
Flipkart already deducts Marketplace Fee, Commission, Shipping Fee from your settlement — these are reflected in Bank Settlement Value. Your P&L = Settlement − Product Cost − Packaging Cost − Misc Costs.
Used for SKUs with no specific cost entered above
Applied only to Delivered orders × qty
Labour, rent, electricity, etc.