⚡ Meesho P&L Command Center NEW
Sirf 2 tarah ki files — Order report + Payment files — se 100% exact Profit & Loss. Niche guide padho, phir upload karo.
🧭
Upload Guide ?
Sirf 2 tarah ki files — sahi order mein, 30 second mein. Kuch miss nahi hoga.
0 / 2 files loaded — STEP 1 (Orders file) se shuru karo
1
📦 Order ID Report Orders Tab → Download Orders Data
Us month ki order file daalo jiska profit calculate karna hai.
June ki order file → June + July ki payment files chahiye (STEP 2).
2
💳 Payment to Date Files Payments Tab
Bas 2 Payment Files — Order wale mahine ki aur agle mahine ki.
June orders ke liye June + July ki payment files chahiye.
📅 File pairing guide + live checklist⌄
| Order Report (STEP 1) | Required Payment Files (STEP 2) | Kyu? |
|---|---|---|
| June ki order file | June + July | June orders → June + July ke payments |
| July ki order file | July + August | July orders → July + August ke payments |
| August ki order file | August + September | August orders → August + September ke payments |
✅ Aapki report status — Order month: — (pehle STEP 1 file daalo)
📦 Pehle Orders file (STEP 1) upload karo — payment checklist yahan aayegi
📥 Files Upload Karein ?
Pehle STEP 1 (Order) phir STEP 2 (Payments) — dono ek saath bhi daal sakte ho • auto-detect • kabhi double-count nahi
Files yahan drop karo ya click karo
CSV • XLSX • XLS • ZIP — multi-file supported • same file dobara upload = update (idempotent)
Orders file — abhi nahi (Step 1)
Payments file — abhi nahi (Step 2)
Join key: Sub Order No • Profit = Bank − Cost − Ads
📖 Formula:
Gross = ALL orders • Net Sales = Delivered + Shipped only • Returns sirf 1 baar kata •
Net Bank = SUM(Final Settlement) • Final Profit = Bank − Cost − Ads •
Negative settlement + Delivered = 🔁 Customer Return
Total Orders
—
Pehle upload karoGross Sales
—
Pehle upload karoReturns
—
Pehle upload karoNet Bank Earnings
—
Pehle upload karoShipping Charged
—
Pehle upload karoProduct Cost
—
Pehle upload karoFinal Profit
—
Pehle upload karo🩺 Order Health ?
🟢 < 5% • 🟡 5–15% • 🔴 > 15%💸 Money Flow — paisa kahan se aaya, kahan gaya ?
green = income • red = deduction📤 Files upload karo — money flow yahan dikhega.
🧮 Profit Breakdown (pura math) ?
💡 Insights — numbers nahi, samajh ?
📋 Order-Level P&L 0 ?
har order ka exact math — 🔁 Customer Return wali rows red
▸
🔍 Data Mismatch — System ne problem pakad li 0 ?
▸
Orders file aur Payment files kabhi-kabhi 100% match nahi karti (settlement delay, missing rows, alag date ranges).
CANCELLED orders yahan nahi dikhte — unhe settlement ki zaroorat nahi hoti.
Niche aapko har missing order ka exact control milta hai — koi number chhupa nahi.
🏷️ Cost Settings — aapka full control ?
▸
🕘 Recent Uploads ?
▸