Meesho payment file kaise padhe

Is page ke numbers ek real store ki payment files se hain, May to October 2026. Delivered order pe listing price ka around 98% mila (most orders 97.5% se 98.2%). Sabse bada cut forward shipping ka hai, lekin most of it customer ne aapke price ke upar pay kiya: shipping ka real cost kitna hai.

File kahan se download karein

Yeh woh file hai jo panel mein payments download karne pe milti hai. Kuch sellers ise payment report ya settlement report bolte hain. Supplier panel mein payments section open karein. Date range select karke previous payments (jo payment aa chuka hai) ya outstanding payments (jo abhi aana baaki hai) download karein. Ek zip aata hai, andar ek Excel file hoti hai.

Excel mein 5 sheets hain. Important sheet Order Payments hai. Ads Cost mein dikhta hai ads ne payment se kitna liya. Referral Payments aur Compensation and Recovery empty thi: claim aur fee recovery Order Payments mein hi aaye.

Important columns

File mein 40 se zyada columns hain. Kai columns har order pe ₹0 the: commission, fixed fee, warehousing, platform fee. Real amount in columns mein hota hai:

Kuch amounts minus mein kyun hote hain

Around 94% returns pe return shipping flat ₹175 thi, product ka price kuch bhi ho. Har RTO pe ₹0. Packaging file mein hai hi nahi, lekin har parcel pe aapka cost lagta hai. Detail: return aur RTO charge.

Around 12 mein se 1 row ka status blank tha. Yeh bhi real money hai: claim (return mein wrong, damaged ya incomplete parcel aaye toh milta hai; reason Claims Reason mein hota hai) aur Recovery (jo amount Meesho wapas leta hai; yahan always "Affiliate Fee"). Yeh usually order ke 2 se 4 weeks baad aate hain.

Payment ko orders aur bank se match kaise karein

Sellers ise payment reconciliation bolte hain: bank ka har rupee kisi order se match karna. Excel mein yeh 3 steps hain.

1. Pehle repeat rows remove karein. Jin downloads ki dates overlap karti hain, unmein same rows dobara aati hain. Excel mein: sheet select karein, phir Data → Remove Duplicates click karein. Humare check mein around 3,200 rows mein se sirf 1,260 bachi.
2. Har order ka total. Pehle rows 1 aur 3 delete karein (Meesho ke notes aur formulas). Phir Insert → PivotTable click karein, Sub Order No ko Rows mein aur Final Settlement Amount ko Values mein daalein. Count dikhe toh Sum kar dein. Ab har order ka ek total dikhega.
3. Ek bank credit match karein. Yahi Payment Date ko Rows mein daal ke karein. Har payment day ka ek hi Transaction ID tha, matlab every day ka total bank mein ek amount hai.

Monthly profit ke liye Order Date check karein, Payment Date nahi. Payment order ke around 14 days baad aaya, isliye "September" ki payment file mein mostly August end aur September ke orders hote hain. Jo payment abhi aana hai, uske liye outstanding payments open karein: usme expected date hoti hai, ya "unschedule" jab tak parcel transit mein hai. Detail: Meesho payment kab aata hai.