Really interesting video. Just a quick question, our bank does not use reference numbers, which is frustrating. Aould you recommend adding your own? Thanks.
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.
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!
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
Thank you Paula, kind regards from Costa Rica.
Costa Rica, nice :-)
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. I have learned a lot. I appreciate your effort in making these tutorials.
Thanks for the video, only one thing if you could explain, what if the bank reference and the nominal reference aren't the same?
I have made a video on this as it requires a little bit of creative thinking. You can access the video here ua-cam.com/video/kfbQSYsC2s4/v-deo.html
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!
thank you
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?
Awesome.Pl need more examples on bank reconciliation topics
Many thanks Paula
you are most welcome
Nice. seems complex.
not really, give it a go
Hi Paula, awesome video and tutorial. Just wondering which of your Udemy courses match with Accountant"s needs currently ?
Awesome 😎
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.
For me, using VBA or even python would be messy, and also manual :-)
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!
thank you for the feedback
I liked everything except the frequent used word ...."I am going to".. Thumbs up...Good luck
nice
This only works in the ideal world that payment ref is the same as GL reference.
yes, but there are ways around this!!!!!!
@@PaulaWeb3andCrypto can you please lead us to those ways??? Please....
yeah, that is what i have been looking for?
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