Thank you so much for the valuable information, I really appreciate your efforts and the process is very much useful. Though I'll try this by my own, but I just saw the vidoe and leave a comment
Dear all, I have seen most comman problem of all is PIVOT TABLE not showing. For new Pivot table, click on HELP tab near Data tab, type PIVOTE, here you will get option to create new PIVOTE TABLE click on it to new Pivote table.
Hi, very informative video thank you for sharing. I am confused about pending payment, I mean what does happen to pending payment? when and how do we get paid that pending amount? If we will keep adding every month's pending then how it will get paid? I will really appreciate your reply. Thank you
@@KonnectionBusiness i just learner today, Amazon won't remove mapping from my listing if my brand if in pending status. Even though I'm a brand registered seller, they won't remove the mapping because my brand is pending. A big clap for this logic 😂
it is not possible to check each order id income one by one ord id doesn't show which sku it is in bulk . i want to analyse total payment received over a month.. sku wise. i want to know which skus are in loss..if anyone knows reply me .
Great video.. but confused between order and grand total row... For both u have mentioned its pending amount.. Also if i follow this way .. what formula can i use using these rows to calculate profits
how to recon with MTR report? how to cofirm closing balance end of the month matched with amazon For example:- sale- commission invoice- bank receipts = pending balance
Sab theek hai but sir. Order id hum payment sheet se q lege. Order to hum MTR report se lege na jo fulfilled kiye hai humne. Agr isi payment sheet se lege to ye to sahi hi dikhaega. Order kese verify hoge?
SIR app ka video best hai SIR LAKIN MERE MAN MEI EK QUSTION HAI SIR HUM FBA MEI V PRODUCT SEND KRATA HU US KA V PAYMENT SAME HO GA YA OR KOI DATA LENA PAREGA SIR PLEASE SIR REPLAY
Sir can we add sales amount so that we can come to know how much percentage we are paying to Amazon, same way please share payment reconciliation for flipkart thank you so much for sharing this
सर यह हमारे साथ हमेशा होता रहता है और हमारा अकाउंट हमेशा माइनस में रहता है सेलर सेंटर द्वारा पूछे जाने पर आपकी अकाउंट हेल्थ के लिए काटा गया है सर हमें पसंद नहीं आता है कि मेरा माइनस में क्यों नहीं जाता है
Sir aapne ye nai bataya isame ki ye final jo payment mila he usame se kya gst less hoga kya??. Secendly sir isame se ye pata chal raha he ki hame payment kitna mila or milega. Hame ye kese pata chalega ki ham ne profit kiya he yaa loss... Becos offline me hame pata hota he ki hamne kitna bheja or kitna milega.. Isame ye chiz clear nai ho pa rahi he..
Thank you so much for how helpful this video is I can't say anymore it's like you saved my 5k monthly accounting fees thanks a lot.
AAPNE JIS AASAN TARIKE SE SAMJAYA HEI VEISA KISINE NAHI SAMJAYA .THANKS BHAI GOD BLSS YOU🙏🙏🙏
First time kissi nai acche se samjhaya thankyou so much
Great super sir itna deep ma koi nahi clear karta hay sir koi asa video banav jisma hama konsa products sell karna chaiya please
Apke wajah se bahot help hoti hai Bhai! Good going! Would like to take the course as well.
sir i liked this paid video of yours very much sir it will work on all flipkart report amazon report❤
Awesome video dil sy ap video banaty hain.
Im From Pakistan and I love your video. God gives you more success
Great brother greetings from Pakistan
Thanks for the detailed description.
Sir piovet table ka option hi show nahi ho raha . Please help sirr ..
Check in "insert" option
In Payments details sheet ,orders means not pending amt., it's means total orders payment payble to seller before any deductions and adjustment
Thats the thing where i got confused...are u confirm with ur statement?
When will be the pending payment be recieved
😊
P
P
P
Pooooooop
Myntra ka payment recollection ki video bnao sir
Shayd main labjo me nhi baya kar sakti ki is video ne meri kitni help ki h
Bhaiya love you hai yaar apko
Thankyou so much ❤️❤️❤️
Thank you so much for the valuable information, I really appreciate your efforts and the process is very much useful.
Though I'll try this by my own, but I just saw the vidoe and leave a comment
Thankyou so much 😊😊😊
Very well exolained
Verymuch helpful!
I have a query:
why there is mismatch data November:
Total Ad spend on ad panel: 24000
Total Adjestement in report: 6695
Dear all, I have seen most comman problem of all is PIVOT TABLE not showing.
For new Pivot table, click on HELP tab near Data tab, type PIVOTE, here you will get option to create new PIVOTE TABLE click on it to new Pivote table.
Thanks 👍🏻
Nice👏👏👍👍👍👍👍👍👍
Great video, amazing, helpful every month
Bhai apne mer kam ashan kar diya think's..
Please make a video on tata payments reconciliation
Thinks sir👍👍👍👍👍👍👍👍
1. Rows type
Value total
2. Rows order id
Value total
filpkar seller mein kaise check kre payment reconcillation iska koi video banao
Thanks you Bhai 👍 you are (Great) Person 👍
valuble topic
Great video and great quality 👌
Best way sir than u
Hi, very informative video thank you for sharing. I am confused about pending payment, I mean what does happen to pending payment? when and how do we get paid that pending amount? If we will keep adding every month's pending then how it will get paid? I will really appreciate your reply. Thank you
Very well explained sir 👍 and SUBSCRIBED.
TYSM.
🔥 *E-commerce Courses:* courses.konbusiness.com
📱 *Zoom call with Tathastu:* konbusiness.com/ecommerce-consultation
✅ *Available on WhatsApp 24x7:* wa.link/ukgzor
Mast video
Sir dimag ghum gaya par samjh nhi aya kuch bhut easy hai
thanks guruji
THANKS A LOT SIR , LEARNED SOMETHING NEW TODAYY
Very good video sir
Thanks Brother
i think difference in google spreadsheet yours and mine
Sir Flipkart ka bhi bata dijiye
Sir kya iski nai video bana sakete ho flipkart k liye if possible its helps me too
Done all " like share suscribed and press bell icon too"👍👍💯👌
Good video
Great video I'm learning alot from you!! Thanks
Sir amazone seller ne kitne payment transfer kiya bank m vo transcation keese check kare
Sir Pivot table ka option nahi aaraha hai tho abe kya kre koi dusra tarika bhi hai kya sir
Sir hame add lagana chahiye kya meesho
Good information very helpful
Sir muje Google sheets pe pivot table shows nahi kar raha he me kya karu????
Click on Help near data tab, then type Pivot, you will get option to add Pivot table. Click on it and create.
12:00something is missing here
Mere mei pivot table h nae araha option me
Highly meritorious 🙌 stay blessed
Thanks a lot brother. Good explanation. Loved your effort to make us understand in detail
Thank you
@@KonnectionBusiness i just learner today, Amazon won't remove mapping from my listing if my brand if in pending status. Even though I'm a brand registered seller, they won't remove the mapping because my brand is pending. A big clap for this logic 😂
Sir Flipkart payment report video bhi hai kya
it is not possible to check each order id income one by one ord id doesn't show which sku it is in bulk . i want to analyse total payment received over a month.. sku wise. i want to know which skus are in loss..if anyone knows reply me .
Well explained....i'll check mine data now. Good topic
Please subscribe the channel
So helpful video. Thank you for sharing with us
Didnt get the last point... Remaining amount of May will be added to total paid and pending amount of june ??
🙏Your this video , I can say worth it🙏
Great video.. but confused between order and grand total row... For both u have mentioned its pending amount.. Also if i follow this way .. what formula can i use using these rows to calculate profits
Order=Total Selling Amount & Grand Total = Pending Amount of Selected Month 👍
Dear, hope you are doing good, when we move file from excel to Google spreadsheet in data column can not find the pivot table
Sir what about advertisment cost ,product cost,self shipment cost????
THANK YOU SO MUCH BROTHER FOR VALUABLE INFORMATION
Thank you For this video sir very valuable and informative.
sir humre pivot table me type or total
ka option hi nhi hai hum kese dekhe payment
What if the grand total in pivot table is in negative?
Then u have to pay
how to recon with MTR report?
how to cofirm closing balance end of the month matched with amazon
For example:- sale- commission invoice- bank receipts = pending balance
Thank you so much. Its helping alot.
Sab theek hai but sir. Order id hum payment sheet se q lege.
Order to hum MTR report se lege na jo fulfilled kiye hai humne. Agr isi payment sheet se lege to ye to sahi hi dikhaega. Order kese verify hoge?
Very helpful! Thank you.
Thank you for your video🎥 😇😇😃😃😃😃
very helpfull video bro!!
Sir Flipkart payment ki h koi video
Thank you..... It has helped me.... subscribed😊
contactharry108@gmail.com for monthly reconcilation
SIR app ka video best hai SIR
LAKIN MERE MAN MEI EK QUSTION HAI SIR HUM FBA MEI V PRODUCT SEND KRATA HU US KA V PAYMENT SAME HO GA YA OR KOI DATA LENA PAREGA SIR PLEASE SIR REPLAY
Helpful 👍
Sir nice video
Sir vender centre 🆑 ke bare bataaye
Sir, if we look at the order wise payment sheet, the payment for the order being returned.. to return ka calculation kaise karen sir?
Sir can we add sales amount so that we can come to know how much percentage we are paying to Amazon, same way please share payment reconciliation for flipkart thank you so much for sharing this
Kya flipkart mai bhi aese hi payment reconciliation kar sakte hai??
Exact Profit kaise nikale after refund ..
सर यह हमारे साथ हमेशा होता रहता है और हमारा अकाउंट हमेशा माइनस में रहता है सेलर सेंटर द्वारा पूछे जाने पर आपकी अकाउंट हेल्थ के लिए काटा गया है सर हमें पसंद नहीं आता है कि मेरा माइनस में क्यों नहीं जाता है
Sir aapne ye nai bataya isame ki ye final jo payment mila he usame se kya gst less hoga kya??.
Secendly sir isame se ye pata chal raha he ki hame payment kitna mila or milega.
Hame ye kese pata chalega ki ham ne profit kiya he yaa loss...
Becos offline me hame pata hota he ki hamne kitna bheja or kitna milega.. Isame ye chiz clear nai ho pa rahi he..
Sir मैंने बहूत कोशिश की लेकिन, ( pivot table ) koi option nahi he, hmare Google spread sheet पर, तौ बताये कैसे करें.
Insert
Per mil jay ga
Sir apks video accha laga lekin isme order wala jo amount hai wo pending thodi nahi hai usme se hi sab kaat kar paymant pending hai last me
agar me 10 items sell kr raha hu jinka prices 500 se 1100 tak hai to alag alag product par mera costing kaise pata chalega???
Thanku sir
Filpcart Me ye process kese hota he?
what about order id kis sku ki hai . taake hm profit ya loss nikal sake ?
Why Don't Show Pivot Table?
Very informative video
Bhai customer k paas order pahucha k nhi kese check sellers central Mai kese pata krte hh kitne order customer to buyer kha check krna hota hh
You explained it very well....but my mind got puzzled...
Should i start online sell or not?
cannot find total option please make new video
Very nice …thanks
Pivot Table ka option nhi show ho raha kya karu
hello sir jo mera pending payment he use kese lu amazon se
SIR, PIVOT TABLE DATA ME
NAHI DIKHRAHA HAHAI
Very good sir ji