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

  • @vedsant3624
    @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

    @AccountsGurukul

    3 жыл бұрын

    Thanks a lot.....

  • @krishnaprasadanandam667
    @krishnaprasadanandam667 Жыл бұрын

    Thanks Sir and Accounts Gurkul, I have got full clarity on vendor reconciliation.🙏🙏🙏

  • @AccountsGurukul

    @AccountsGurukul

    Жыл бұрын

    Its our pleasure. Thanks a lot.

  • @Twilight4660
    @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

    @AccountsGurukul

    3 жыл бұрын

    Thanks.....

  • @praafullckashelkar3795
    @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

    @AccountsGurukul

    2 жыл бұрын

    Its our pleasure. Thanks

  • @aadarshyadav1681
    @aadarshyadav16819 ай бұрын

    Explained nicely everything in easy format. Thankyou sir Could i get practice file?

  • @edanmadder3630

    @edanmadder3630

    5 ай бұрын

    yes he should share files as well for us to practice....

  • @manjeshrao7698
    @manjeshrao76983 жыл бұрын

    👍

  • @shahbaazkhan2883
    @shahbaazkhan28832 жыл бұрын

    Wonderful video sir keep up the good work so that we can learn a lot from your efforts Sir hatsoff to you

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Its our pleasure. Thanks a lot.

  • @ShaikNadeem-tt2kx
    @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

    @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

  • @pavanpinnamraju6389
    @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
    @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

    @AccountsGurukul

    Жыл бұрын

    Yeah sure. Please drop email on accounts.gurukul@yahoo.com thanks

  • @krishnaprasadanandam667
    @krishnaprasadanandam667 Жыл бұрын

    Sir,could you make video on cash reconciliation with excel

  • @AccountsGurukul

    @AccountsGurukul

    Жыл бұрын

    Yes. Will add in our to do list. Thanks a lot.

  • @arslanthemughals
    @arslanthemughals2 жыл бұрын

    Sir, can you please make a video on how to perform inventory reconciliation with real sets of Excel data. Much Thanks 🙏

  • @AccountsGurukul

    @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

  • @sriharikasumuru8399
    @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

    @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

    @AccountsGurukul

    3 жыл бұрын

    Done..... we have shared link. Thanks

  • @sriharikasumuru8399

    @sriharikasumuru8399

    3 жыл бұрын

    @@AccountsGurukul Thanks a lot Sir! just now only I downloaded it.

  • @AntediluvianBrew
    @AntediluvianBrew Жыл бұрын

    Perfect

  • @AccountsGurukul

    @AccountsGurukul

    Жыл бұрын

    Thanks a lot.

  • @bsthishvarma
    @bsthishvarma2 жыл бұрын

    Really helpful video Please tell me what are the scenarios vendor issues a debit note

  • @AccountsGurukul

    @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

  • @zaroonaamir937
    @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

    @AccountsGurukul

    2 жыл бұрын

    Yes we can. Allow us some time. Thanks

  • @Enthusiastic_Abhishekk
    @Enthusiastic_Abhishekk Жыл бұрын

    How can I get this data for practical knowledge sir please provide me any link of this data

  • @AccountsGurukul

    @AccountsGurukul

    Жыл бұрын

    Please drop an email at accounts.gurukul@yahoo.com thanks a lot.

  • @joy.230
    @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

    @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

    @diegosilang26

    2 жыл бұрын

    i agree.pls make bank recon tutorials also.

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Sure will upload it in coming week. Thanks

  • @edanmadder3630
    @edanmadder36305 ай бұрын

    can you please provide the data of excel file ?

  • @thiziz_bharath
    @thiziz_bharath3 жыл бұрын

    Provide excel workings for our practice.

  • @AccountsGurukul

    @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

  • @pankajnegi5964
    @pankajnegi59642 жыл бұрын

    Sir pls share this workbook for practice

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Please drop email on our email I'd accounts.gurukul@yahoo.com thanks

  • @javeed616
    @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

    @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

    @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

    @AccountsGurukul

    9 ай бұрын

    connect with me over our email id. Will help you out. Thanks a lot.

  • @javeed616

    @javeed616

    9 ай бұрын

    What is the mail Id sir?

  • @AccountsGurukul

    @AccountsGurukul

    9 ай бұрын

    accounts.gurukul@yahoo.com

  • @arkuddin8045
    @arkuddin80452 жыл бұрын

    Hii sir Sir could you plz share a defination of invoice reconciliation and vendor reconciliation plz sir it's imp

  • @AccountsGurukul

    @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

    @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

    @arkuddin8045

    2 жыл бұрын

    Tq bhai

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Its our pleasure.

  • @azeemmohammadalikhan4649
    @azeemmohammadalikhan4649 Жыл бұрын

    Hello, Sir can you share link for excel sheet for practice

  • @azeemmohammadalikhan4649

    @azeemmohammadalikhan4649

    Жыл бұрын

    To download excel sheet for practice

  • @AccountsGurukul

    @AccountsGurukul

    Жыл бұрын

    Yes. Please drop an email on accounts.gurukul@yahoo.com thanks

  • @ismailntp1785
    @ismailntp17852 жыл бұрын

    Sir please provide excel file for practising

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Please refer below link to download file. Thanks drive.google.com/file/d/1tbAGndW6-eIeugLtBCI7pTsnsGNMpp9q/view?usp=sharing

  • @bhavneshparikh8283
    @bhavneshparikh82833 жыл бұрын

    Can be available vendore auto payment advice in excel?

  • @AccountsGurukul

    @AccountsGurukul

    3 жыл бұрын

    Yes with Marco but need to check. Will confirm. Thanks

  • @bhavneshparikh8283

    @bhavneshparikh8283

    3 жыл бұрын

    @@AccountsGurukul pl share it

  • @bhavneshparikh8283

    @bhavneshparikh8283

    3 жыл бұрын

    Pl share it this file

  • @AccountsGurukul

    @AccountsGurukul

    3 жыл бұрын

    Pls allow some time. Thanks

  • @bhavneshparikh8283

    @bhavneshparikh8283

    3 жыл бұрын

    Ok

  • @prayashborpuzari5802
    @prayashborpuzari58022 жыл бұрын

    Wonderful session.. Kindly share the excel sheet

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Please drop an email on accounts.gurukul@yahoo.com thanks

  • @prayashborpuzari5802

    @prayashborpuzari5802

    2 жыл бұрын

    @@AccountsGurukul check your email

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Please refer this video kzread.info/dash/bejne/aZ2pl69yYZrNhtY.html Thanks

  • @prayashborpuzari5802

    @prayashborpuzari5802

    2 жыл бұрын

    @@AccountsGurukul thank you

  • @vibhuthakur1185

    @vibhuthakur1185

    Жыл бұрын

    Nice secession . Can anyone share excel sheet with me. Thanks

  • @RohitSolanki-ed8tm
    @RohitSolanki-ed8tm2 жыл бұрын

    Sir ,sound quality is not proper in video please improve

  • @AccountsGurukul

    @AccountsGurukul

    2 жыл бұрын

    Thanks..... Yes we have improved for latest videos and thanks will keep in mind.

  • @azeemmohammadalikhan4649
    @azeemmohammadalikhan4649 Жыл бұрын

    Hello, Sir, Please check mail.

  • @AccountsGurukul

    @AccountsGurukul

    Жыл бұрын

    Yes we have received it. Will share it shortly. Thanks a lot.

  • @azeemmohammadalikhan4649

    @azeemmohammadalikhan4649

    Жыл бұрын

    Ok

  • @AccountsGurukul
    @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

Келесі