Billing & Business

Marketplace Profit/Loss Report

Meesho, Flipkart, Amazon, Snapdeal ki payment report upload karo, product cost daalo — poora profit/loss dekho: SKU-wise, month-wise, platform-wise. Ads, returns, RTO, shipping, fees, TCS/TDS sab alag-alag.

100% free
Data aapke device pe hi rehta hai
Free account

Report seller panel se download karke upload karein — data aapke phone/computer se bahar nahi jata. Login/password kabhi mat dein.
Koi bhi website ya app jo aapka seller-panel password maange, usse bachein. Ye tool sirf file padhta hai, aapke browser ke andar.

1 Payment / settlement report upload karo

Excel / CSV file choose karoek se zyada files aur platforms ek saath chalenge (.xlsx, .xls, .csv)

Meesho — kaunsi file?

Supplier Panel → Payments → Download
"Payments to Date" (jo paisa aa chuka) aur "Outstanding" (jo aana baaki) — dono Excel upload kar sakte ho
Ek file me Order Payments, Ads Cost, Referral, Compensation & Recovery sab sheets padhi jaati hain. Overlap wali files ka double count nahi hota.

Flipkart — kaunsi file?

Seller Hub → Payments → Settlements / Transactions → Download (Excel)
"Orders" sheet se order-wise settlement padha jaata hai; Ads / non-order sheets bhi jud jaati hain

Amazon — kaunsi file?

Seller Central → Reports → Payments → Date Range Reports
Generate Report → "Transaction" → date range → Download CSV
Ads ("Cost of Advertising") alag line me dikhega

Snapdeal / koi aur platform

Seller panel → Payments → payment / settlement report download karo (Excel/CSV)
Agar columns pehchaan me nahi aaye to tool aapse columns match karwayega (Order ID, SKU, Sale, Settlement…). Ek baar match kiya to yaad rahega.

1b Columns match karo

Is file ke columns pehchaan me nahi aaye. Neeche bataiye kaunsa column kya hai — ek baar karna hai, agli baar yaad rahega.

Platform Fees / shipping plus (+) me likhe hain — minus karna hai

2 Product cost daalo (SKU-wise)

Cost per piece (₹) — kharid + GST jo aap claim nahi karte. Ye isi phone/browser me save rehta hai. Combo SKU = poore combo ka cost.

Packing + other cost / dispatched order (₹)Box, tape, label, baaki kharcha — har bheje gaye order pe Return/RTO me kharab ya gaayab maal (%)Wapas aaye maal me se kitna bikne layak nahi Month kis date se?

Raste me (in transit) orders ko delivered maan ke chalo — expected profit SKU table me ads ka hissa bhi baanto (per dispatched order)

SKU	Platform	Units (sold)	Cost / pc (₹)

Cost sheet import

3 Profit / Loss report

Kahan paisa gaya

Gross sales se shuru karke har kharcha alag — aakhir me net profit.

Har kharcha alag-alag

Platform-wise

Month-wise

Gross salesNet settlementProfitLoss

SKU-wise

SKU search

Numbers wahi hain jo aapki report me hain. "Pending" = platform ka estimate (abhi aaya nahi, badal sakta hai). Report me jo order nahi hai (cancelled / abhi dispatch nahi hua) wo yahan nahi dikhega. Tax/GST ki final calculation CA se confirm karein.