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
Thank you Paula, kind regards from Costa Rica.
@PaulaWeb3andCrypto
3 жыл бұрын
Costa Rica, nice :-)
Thanks for the video. I have learned a lot. I appreciate your effort in making these tutorials.
Nice Explanation!
@PaulaWeb3andCrypto
4 жыл бұрын
thank you
Many thanks Paula
@PaulaWeb3andCrypto
5 жыл бұрын
you are most welcome
Awesome 😎
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
Hi Paula, awesome video and tutorial. Just wondering which of your Udemy courses match with Accountant"s needs currently ?
Can you post a link to the Learn and Earn task? I can't seem to find it.
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
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
Really interesting video. Just a quick question, our bank does not use reference numbers, which is frustrating. Aould you recommend adding your own? Thanks.
Nice. seems complex.
@PaulaWeb3andCrypto
3 жыл бұрын
not really, give it a go
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
5 жыл бұрын
thank you for the feedback
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?
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
3 жыл бұрын
For me, using VBA or even python would be messy, and also manual :-)
This only works in the ideal world that payment ref is the same as GL reference.
@PaulaWeb3andCrypto
3 жыл бұрын
yes, but there are ways around this!!!!!!
@AbcdAbcd-ol5hn
Жыл бұрын
@@PaulaWeb3andCrypto can you please lead us to those ways??? Please....
@mustafeabdi8483
2 ай бұрын
yeah, that is what i have been looking for?
I liked everything except the frequent used word ...."I am going to".. Thumbs up...Good luck
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