How to Reconcile Accounts using Power Query

theexcelclub.com/how-to-recon...
To download the learn and earn activity visit the post.
Reconciling accounts is a common task carried out by accountants on a regular and reoccurring basis. Creditor statements and bank accounts are examples of accounts that need regular reconciliation.
But what if you could create a model, within minutes, that you could use over and over for these reconciliations? Imagine the time it would save.
With Power Query you can and in this article, you will learn how to reconcile accounts using Power Query and then how you can use that query repeatedly saving you hours and hours.
Find out more about our Learn and Earn Activities
theexcelclub.com/learn-and-ea...
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel - Playlist
#excel #powerquery #exceltips #tutorial #reconcileaccounts #excelforaccountants

Пікірлер: 30

  • @anthonyfernandezgonzalez8262
    @anthonyfernandezgonzalez82623 жыл бұрын

    Thank you Paula, kind regards from Costa Rica.

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    Costa Rica, nice :-)

  • @shamblar
    @shamblar3 жыл бұрын

    Thanks for the video. I have learned a lot. I appreciate your effort in making these tutorials.

  • @stevennye5075
    @stevennye50754 жыл бұрын

    Nice Explanation!

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    4 жыл бұрын

    thank you

  • @wajdimatoussi
    @wajdimatoussi5 жыл бұрын

    Many thanks Paula

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    5 жыл бұрын

    you are most welcome

  • @danjarupath
    @danjarupath2 жыл бұрын

    Awesome 😎

  • @syedaneesdurez7197
    @syedaneesdurez71972 жыл бұрын

    Awesome.Pl need more examples on bank reconciliation topics

  • @angelgarcia7152
    @angelgarcia71524 жыл бұрын

    Great tutorial. I tried to subscribe to the NEWSLETTER, but I got a "page not found". Where can I get the solution for the diff opening balance?

  • @AhmedAbdalalim
    @AhmedAbdalalim4 жыл бұрын

    nice

  • @terbasol
    @terbasol3 жыл бұрын

    Hi Paula, awesome video and tutorial. Just wondering which of your Udemy courses match with Accountant"s needs currently ?

  • @simondechoisy779
    @simondechoisy7794 ай бұрын

    Can you post a link to the Learn and Earn task? I can't seem to find it.

  • @nabaz3040
    @nabaz30404 жыл бұрын

    Thanks for the video, only one thing if you could explain, what if the bank reference and the nominal reference aren't the same?

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    4 жыл бұрын

    I have made a video on this as it requires a little bit of creative thinking. You can access the video here kzread.info/dash/bejne/nZqWs7WSo6aYo5c.html

  • @SheilaMills-lu5ju
    @SheilaMills-lu5ju Жыл бұрын

    Really interesting video. Just a quick question, our bank does not use reference numbers, which is frustrating. Aould you recommend adding your own? Thanks.

  • @Realworldskill
    @Realworldskill3 жыл бұрын

    Nice. seems complex.

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    not really, give it a go

  • @wayneedmondson1065
    @wayneedmondson10655 жыл бұрын

    Hi Paula.. thanks for this video tutorial.. very interesting and challenging with some good opportunities for learning. I should mention.. for whatever reason.. the audio on your videos has an echo and is a bit scratchy on my end. I had the same experience when watching your basic Udemy course on PQ, as well as others in your weekly releases. I don't experience the same with other videos, so it seems isolated to your recordings. Just mentioning this for your information.. no offense or criticism intended. Thanks for sharing your knowledge and your lessons.. much appreciated. Thumbs up!

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    5 жыл бұрын

    thank you for the feedback

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

    how to reconcile if there is no common reference in both sheets or you cannot have any clue about the similarity in both sheet. For Example, your check sheet only have check numbers and your bank book have check numbers with something with Text also and you have separated checks from text and further you match them in query. suppose if both the sheets have different reference number but they must reconcile with value, then how to achieve that?

  • @rokrman22
    @rokrman223 жыл бұрын

    Good idea but the setup it is very manual and really messy. You can try with vba or typescript in office 365 web.... or even python (format and reconcile) DONE.

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    For me, using VBA or even python would be messy, and also manual :-)

  • @evanyeung3801
    @evanyeung38013 жыл бұрын

    This only works in the ideal world that payment ref is the same as GL reference.

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    yes, but there are ways around this!!!!!!

  • @AbcdAbcd-ol5hn

    @AbcdAbcd-ol5hn

    Жыл бұрын

    @@PaulaWeb3andCrypto can you please lead us to those ways??? Please....

  • @mustafeabdi8483

    @mustafeabdi8483

    2 ай бұрын

    yeah, that is what i have been looking for?

  • @srinivaskandru5034
    @srinivaskandru50344 жыл бұрын

    I liked everything except the frequent used word ...."I am going to".. Thumbs up...Good luck

  • @ronaldgolooba
    @ronaldgoloobaАй бұрын

    This is awesome Paula! I am completely ignorant about accounting, but I have to teach my wife who is doing ATM reconciliation! I only know basic excel more than she does so let me take time to learn! if there is any additional video u can send me a link on ronaldgolooba@gmail.com. my You tube channel is @ronaldgolooba