Really interesting video. Just a quick question, our bank does not use reference numbers, which is frustrating. Aould you recommend adding your own? Thanks.
I have made a video on this as it requires a little bit of creative thinking. You can access the video here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kfbQSYsC2s4.html
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