Amazon MTR B2C report. 78 column aur unme se kaam ke sirf do

Sirf do column pe bharosa karo

Tax Exclusive Gross aur Total Tax Amount. Ye do har row mein sahi hote hain.

Invoice Amount hamesha inhi dono ka jod hota hai, aur Total Tax hamesha Tax Exclusive Gross ka rate wala hissa hota hai. 2,409 row wali ek file mein ye dono baat har row pe sahi nikli.

Rate fraction mein hota hai

Amazon 18 percent ko 0.18 likhta hai, 5 ko 0.05. Meesho aur Flipkart seedha 18 aur 5 likhte hain.

Agar koi tool ise seedha uthaa le to rate 100 guna galat ho jayega.

Principal Amount se turnover mat nikalo

Principal Amount mein tax bhi shaamil hai, aur discount se pehle ka hai. Usse turnover nikaloge to zyada aayega.

Igst Tax wala column bharosemand nahi hai

Ek file mein 2,409 mein se 558 row aisi thi jahan Igst Tax, Cgst Tax aur Sgst Tax ka jod Total Tax Amount se match nahi karta tha. Wo discount se pehle ke figure hain.

Shipping Igst Tax bhi bhara hota hai par Total Tax mein nahi ginta. Alag se jodoge to double ho jayega.

Refund mein value minus hoti hai, quantity nahi

Refund row mein Tax Exclusive Gross minus hota hai, par Quantity plus hi rehti hai. Quantity ka minus aapko khud karna padta hai.

Cancel aur FreeReplacement row zero hoti hain

Ek file mein 650 aisi row thi. 639 Cancel aur 11 FreeReplacement. Sabki value zero. Unhe hatana hi behtar hai.

Purane mahine ki row bhi hoti hain

August ki file mein 59 row June aur July ki thi. Refund purane invoice ka ho sakta hai, wo normal hai. Par shipment purane mahine ka ho to dhyaan se dekho.