How to Reconcile Accounts using Power Query 

Thank you Paula, kind regards from Costa Rica.

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

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

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

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

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?

Many thanks Paula

Awesome.Pl need more examples on bank reconciliation topics

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?

Nice Explanation!

Nice. seems complex.

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.

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

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

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!

Awesome 😎

nice

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

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