Account Reconciliation in Excel: How to Reconcile Supplier/Vendor Statement in Excel🤔
Account Reconciliation in Excel: How to Reconcile Supplier/Vendor Statement in Excel🤔
Жүктеу.....
Пікірлер: 83
@vedsant36243 жыл бұрын
You have a wonderful talent for creating knowledgeable and watchable videos that exude fun. I hope your viewers will support you at an increasing level. Many thanks.
@AccountsGurukul
3 жыл бұрын
Thanks a lot.....
@krishnaprasadanandam667 Жыл бұрын
Thanks Sir and Accounts Gurkul, I have got full clarity on vendor reconciliation.🙏🙏🙏
@AccountsGurukul
Жыл бұрын
Its our pleasure. Thanks a lot.
@Twilight46603 жыл бұрын
Sir Ji! Thank you so much for such detailed information. I've been searching videos for reconciliation on KZread with Excel & found the same here. Very very helpful. 😀😀
@AccountsGurukul
3 жыл бұрын
Thanks.....
@praafullckashelkar37952 жыл бұрын
Sir Very Very helpful video to me, I have search many times not found in KZread but u r given me this information very clearly and correctly thank u and God blessed u
@AccountsGurukul
2 жыл бұрын
Its our pleasure. Thanks
@aadarshyadav16819 ай бұрын
Explained nicely everything in easy format. Thankyou sir Could i get practice file?
@edanmadder3630
5 ай бұрын
yes he should share files as well for us to practice....
@manjeshrao76983 жыл бұрын
👍
@shahbaazkhan28832 жыл бұрын
Wonderful video sir keep up the good work so that we can learn a lot from your efforts Sir hatsoff to you
@AccountsGurukul
2 жыл бұрын
Its our pleasure. Thanks a lot.
@ShaikNadeem-tt2kx2 ай бұрын
Sir, one doubt regarding voucher no, how come voucher number for receipt/payment be same in both our books and vendor books?
@AccountsGurukul
2 ай бұрын
In earlier days that's workable when cheque used to make payment but in online transfer we have to do the recon based on date or amount to amount. Thanks
@pavanpinnamraju638910 ай бұрын
Hi sir, Small doubt...what is debit note under vendor point (vedant)? For buyer (gurukul) debit note means sales returns. From vendor point of view what is debit note?
@mohammadsohail7644 Жыл бұрын
Superb sir tons of thank you so much for sharing the excel practicing file. And request you to make a video on accounts payable KPI AND dashboard sir please
@AccountsGurukul
Жыл бұрын
Yeah sure. Please drop email on accounts.gurukul@yahoo.com thanks
@krishnaprasadanandam667 Жыл бұрын
Sir,could you make video on cash reconciliation with excel
@AccountsGurukul
Жыл бұрын
Yes. Will add in our to do list. Thanks a lot.
@arslanthemughals2 жыл бұрын
Sir, can you please make a video on how to perform inventory reconciliation with real sets of Excel data. Much Thanks 🙏
@AccountsGurukul
2 жыл бұрын
Yes now we are going to come up with reconciliation with practical example so will upload the video in coming week on inventory recon. Thanks
@sriharikasumuru83993 жыл бұрын
Nice explanation Sir! Am requesting you that kindly share the such excel statement for our real time practice purpose. If possible kindly share the same and listening is different from practicing it. unless otherwise practice in a real time environment, it is no use for us.
@AccountsGurukul
3 жыл бұрын
Sure..... our main motto to share the knowledge what we have based on the real experience. Will upload on drive and add the link in description in next one hour so everyone will be able to download. Thanks
@AccountsGurukul
3 жыл бұрын
Done..... we have shared link. Thanks
@sriharikasumuru8399
3 жыл бұрын
@@AccountsGurukul Thanks a lot Sir! just now only I downloaded it.
@AntediluvianBrew Жыл бұрын
Perfect
@AccountsGurukul
Жыл бұрын
Thanks a lot.
@bsthishvarma2 жыл бұрын
Really helpful video Please tell me what are the scenarios vendor issues a debit note
@AccountsGurukul
2 жыл бұрын
Value of invoice increases due to extra goods/services are delivered or incorrect amount( taxable value/tax) is entered in the invoice. In this case, the supplier will issue debit note. Thanks
@zaroonaamir9372 жыл бұрын
Can you share video with comparing a difficult statement of account which some invoices are not matching then can tell about the solution
@AccountsGurukul
2 жыл бұрын
Yes we can. Allow us some time. Thanks
@Enthusiastic_Abhishekk Жыл бұрын
How can I get this data for practical knowledge sir please provide me any link of this data
@AccountsGurukul
Жыл бұрын
Please drop an email at accounts.gurukul@yahoo.com thanks a lot.
@joy.2302 жыл бұрын
Could you share with me a video, which is showing that how to reconcile a bank statement in a excel sheet. TIA
@AccountsGurukul
2 жыл бұрын
We haven't created video related to bank recon but will add this in our to do list and will create the video on it shortly. Thanks
@diegosilang26
2 жыл бұрын
i agree.pls make bank recon tutorials also.
@AccountsGurukul
2 жыл бұрын
Sure will upload it in coming week. Thanks
@edanmadder36305 ай бұрын
can you please provide the data of excel file ?
@thiziz_bharath3 жыл бұрын
Provide excel workings for our practice.
@AccountsGurukul
3 жыл бұрын
We have added recon link in description to download and do the practice at your end. You can add comment if have any query or need any clarification. Link is added here as well. drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
@pankajnegi59642 жыл бұрын
Sir pls share this workbook for practice
@AccountsGurukul
2 жыл бұрын
Please drop email on our email I'd accounts.gurukul@yahoo.com thanks
@javeed6169 ай бұрын
Thanks a lot for your explanation the way you have explained impressed request you to share me the working sheet for further process and I required support from your side thanks 🙏🏻
@AccountsGurukul
9 ай бұрын
We have added recon link in description to download and do the practice at your end. You can add comment if have any query or need any clarification. Link is added here as well. drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
@javeed616
9 ай бұрын
Thanks a lot for your support and the link which you have shared🙏🏻🙏🏻 I have many line items in vendor reconciliation in this am getting huge difference what is the solution sir?
@AccountsGurukul
9 ай бұрын
connect with me over our email id. Will help you out. Thanks a lot.
@javeed616
9 ай бұрын
What is the mail Id sir?
@AccountsGurukul
9 ай бұрын
accounts.gurukul@yahoo.com
@arkuddin80452 жыл бұрын
Hii sir Sir could you plz share a defination of invoice reconciliation and vendor reconciliation plz sir it's imp
@AccountsGurukul
2 жыл бұрын
Invoice reconciliation is the process of identifying and managing discrepancies between invoices and related purchase orders, contracts, or GRN so that they can be paid.
@AccountsGurukul
2 жыл бұрын
Vendor reconciliation is defined as the reconciliation of accounts payable for a vendor with the statement provided by the particular vendor. ... It ensures that there are no discrepancies or mistakes in the amount a vendor charges an entity and the goods or services the entity receives from the vendor. Thanks
@arkuddin8045
2 жыл бұрын
Tq bhai
@AccountsGurukul
2 жыл бұрын
Its our pleasure.
@azeemmohammadalikhan4649 Жыл бұрын
Hello, Sir can you share link for excel sheet for practice
@azeemmohammadalikhan4649
Жыл бұрын
To download excel sheet for practice
@AccountsGurukul
Жыл бұрын
Yes. Please drop an email on accounts.gurukul@yahoo.com thanks
@ismailntp17852 жыл бұрын
Sir please provide excel file for practising
@AccountsGurukul
2 жыл бұрын
Please refer below link to download file. Thanks drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
@bhavneshparikh82833 жыл бұрын
Can be available vendore auto payment advice in excel?
@AccountsGurukul
3 жыл бұрын
Yes with Marco but need to check. Will confirm. Thanks
@bhavneshparikh8283
3 жыл бұрын
@@AccountsGurukul pl share it
@bhavneshparikh8283
3 жыл бұрын
Pl share it this file
@AccountsGurukul
3 жыл бұрын
Pls allow some time. Thanks
@bhavneshparikh8283
3 жыл бұрын
Ok
@prayashborpuzari58022 жыл бұрын
Wonderful session.. Kindly share the excel sheet
@AccountsGurukul
2 жыл бұрын
Please drop an email on accounts.gurukul@yahoo.com thanks
@prayashborpuzari5802
2 жыл бұрын
@@AccountsGurukul check your email
@AccountsGurukul
2 жыл бұрын
Please refer this video kzread.info/dash/bejne/aZ2pl69yYZrNhtY.html Thanks
@prayashborpuzari5802
2 жыл бұрын
@@AccountsGurukul thank you
@vibhuthakur1185
Жыл бұрын
Nice secession . Can anyone share excel sheet with me. Thanks
@RohitSolanki-ed8tm2 жыл бұрын
Sir ,sound quality is not proper in video please improve
@AccountsGurukul
2 жыл бұрын
Thanks..... Yes we have improved for latest videos and thanks will keep in mind.
@azeemmohammadalikhan4649 Жыл бұрын
Hello, Sir, Please check mail.
@AccountsGurukul
Жыл бұрын
Yes we have received it. Will share it shortly. Thanks a lot.
@azeemmohammadalikhan4649
Жыл бұрын
Ok
@AccountsGurukul3 жыл бұрын
We have added recon link in description to download and do the practice at your end. You can add comment if have any query or need any clarification. Link is added here as well. drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
Пікірлер: 83
You have a wonderful talent for creating knowledgeable and watchable videos that exude fun. I hope your viewers will support you at an increasing level. Many thanks.
@AccountsGurukul
3 жыл бұрын
Thanks a lot.....
Thanks Sir and Accounts Gurkul, I have got full clarity on vendor reconciliation.🙏🙏🙏
@AccountsGurukul
Жыл бұрын
Its our pleasure. Thanks a lot.
Sir Ji! Thank you so much for such detailed information. I've been searching videos for reconciliation on KZread with Excel & found the same here. Very very helpful. 😀😀
@AccountsGurukul
3 жыл бұрын
Thanks.....
Sir Very Very helpful video to me, I have search many times not found in KZread but u r given me this information very clearly and correctly thank u and God blessed u
@AccountsGurukul
2 жыл бұрын
Its our pleasure. Thanks
Explained nicely everything in easy format. Thankyou sir Could i get practice file?
@edanmadder3630
5 ай бұрын
yes he should share files as well for us to practice....
👍
Wonderful video sir keep up the good work so that we can learn a lot from your efforts Sir hatsoff to you
@AccountsGurukul
2 жыл бұрын
Its our pleasure. Thanks a lot.
Sir, one doubt regarding voucher no, how come voucher number for receipt/payment be same in both our books and vendor books?
@AccountsGurukul
2 ай бұрын
In earlier days that's workable when cheque used to make payment but in online transfer we have to do the recon based on date or amount to amount. Thanks
Hi sir, Small doubt...what is debit note under vendor point (vedant)? For buyer (gurukul) debit note means sales returns. From vendor point of view what is debit note?
Superb sir tons of thank you so much for sharing the excel practicing file. And request you to make a video on accounts payable KPI AND dashboard sir please
@AccountsGurukul
Жыл бұрын
Yeah sure. Please drop email on accounts.gurukul@yahoo.com thanks
Sir,could you make video on cash reconciliation with excel
@AccountsGurukul
Жыл бұрын
Yes. Will add in our to do list. Thanks a lot.
Sir, can you please make a video on how to perform inventory reconciliation with real sets of Excel data. Much Thanks 🙏
@AccountsGurukul
2 жыл бұрын
Yes now we are going to come up with reconciliation with practical example so will upload the video in coming week on inventory recon. Thanks
Nice explanation Sir! Am requesting you that kindly share the such excel statement for our real time practice purpose. If possible kindly share the same and listening is different from practicing it. unless otherwise practice in a real time environment, it is no use for us.
@AccountsGurukul
3 жыл бұрын
Sure..... our main motto to share the knowledge what we have based on the real experience. Will upload on drive and add the link in description in next one hour so everyone will be able to download. Thanks
@AccountsGurukul
3 жыл бұрын
Done..... we have shared link. Thanks
@sriharikasumuru8399
3 жыл бұрын
@@AccountsGurukul Thanks a lot Sir! just now only I downloaded it.
Perfect
@AccountsGurukul
Жыл бұрын
Thanks a lot.
Really helpful video Please tell me what are the scenarios vendor issues a debit note
@AccountsGurukul
2 жыл бұрын
Value of invoice increases due to extra goods/services are delivered or incorrect amount( taxable value/tax) is entered in the invoice. In this case, the supplier will issue debit note. Thanks
Can you share video with comparing a difficult statement of account which some invoices are not matching then can tell about the solution
@AccountsGurukul
2 жыл бұрын
Yes we can. Allow us some time. Thanks
How can I get this data for practical knowledge sir please provide me any link of this data
@AccountsGurukul
Жыл бұрын
Please drop an email at accounts.gurukul@yahoo.com thanks a lot.
Could you share with me a video, which is showing that how to reconcile a bank statement in a excel sheet. TIA
@AccountsGurukul
2 жыл бұрын
We haven't created video related to bank recon but will add this in our to do list and will create the video on it shortly. Thanks
@diegosilang26
2 жыл бұрын
i agree.pls make bank recon tutorials also.
@AccountsGurukul
2 жыл бұрын
Sure will upload it in coming week. Thanks
can you please provide the data of excel file ?
Provide excel workings for our practice.
@AccountsGurukul
3 жыл бұрын
We have added recon link in description to download and do the practice at your end. You can add comment if have any query or need any clarification. Link is added here as well. drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
Sir pls share this workbook for practice
@AccountsGurukul
2 жыл бұрын
Please drop email on our email I'd accounts.gurukul@yahoo.com thanks
Thanks a lot for your explanation the way you have explained impressed request you to share me the working sheet for further process and I required support from your side thanks 🙏🏻
@AccountsGurukul
9 ай бұрын
We have added recon link in description to download and do the practice at your end. You can add comment if have any query or need any clarification. Link is added here as well. drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
@javeed616
9 ай бұрын
Thanks a lot for your support and the link which you have shared🙏🏻🙏🏻 I have many line items in vendor reconciliation in this am getting huge difference what is the solution sir?
@AccountsGurukul
9 ай бұрын
connect with me over our email id. Will help you out. Thanks a lot.
@javeed616
9 ай бұрын
What is the mail Id sir?
@AccountsGurukul
9 ай бұрын
accounts.gurukul@yahoo.com
Hii sir Sir could you plz share a defination of invoice reconciliation and vendor reconciliation plz sir it's imp
@AccountsGurukul
2 жыл бұрын
Invoice reconciliation is the process of identifying and managing discrepancies between invoices and related purchase orders, contracts, or GRN so that they can be paid.
@AccountsGurukul
2 жыл бұрын
Vendor reconciliation is defined as the reconciliation of accounts payable for a vendor with the statement provided by the particular vendor. ... It ensures that there are no discrepancies or mistakes in the amount a vendor charges an entity and the goods or services the entity receives from the vendor. Thanks
@arkuddin8045
2 жыл бұрын
Tq bhai
@AccountsGurukul
2 жыл бұрын
Its our pleasure.
Hello, Sir can you share link for excel sheet for practice
@azeemmohammadalikhan4649
Жыл бұрын
To download excel sheet for practice
@AccountsGurukul
Жыл бұрын
Yes. Please drop an email on accounts.gurukul@yahoo.com thanks
Sir please provide excel file for practising
@AccountsGurukul
2 жыл бұрын
Please refer below link to download file. Thanks drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing
Can be available vendore auto payment advice in excel?
@AccountsGurukul
3 жыл бұрын
Yes with Marco but need to check. Will confirm. Thanks
@bhavneshparikh8283
3 жыл бұрын
@@AccountsGurukul pl share it
@bhavneshparikh8283
3 жыл бұрын
Pl share it this file
@AccountsGurukul
3 жыл бұрын
Pls allow some time. Thanks
@bhavneshparikh8283
3 жыл бұрын
Ok
Wonderful session.. Kindly share the excel sheet
@AccountsGurukul
2 жыл бұрын
Please drop an email on accounts.gurukul@yahoo.com thanks
@prayashborpuzari5802
2 жыл бұрын
@@AccountsGurukul check your email
@AccountsGurukul
2 жыл бұрын
Please refer this video kzread.info/dash/bejne/aZ2pl69yYZrNhtY.html Thanks
@prayashborpuzari5802
2 жыл бұрын
@@AccountsGurukul thank you
@vibhuthakur1185
Жыл бұрын
Nice secession . Can anyone share excel sheet with me. Thanks
Sir ,sound quality is not proper in video please improve
@AccountsGurukul
2 жыл бұрын
Thanks..... Yes we have improved for latest videos and thanks will keep in mind.
Hello, Sir, Please check mail.
@AccountsGurukul
Жыл бұрын
Yes we have received it. Will share it shortly. Thanks a lot.
@azeemmohammadalikhan4649
Жыл бұрын
Ok
We have added recon link in description to download and do the practice at your end. You can add comment if have any query or need any clarification. Link is added here as well. drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing