Bank reconciliation exercise

Even in these days of automatic linking of bank recs in accounting systems (Xero, Odoo) there is still sometimes when you get stuck and there is difference between what your bank statement says and what’s on your ledgers.  I have found that downloading the feed from the bank and exporting report from your accounting system and putting them side by side is a great way to visually compare each list to find what is missing. Colour coding sections, using data filters and the find function can easily identify errant transactions.  

Click the Video Below

Product price calculator
Exam practice template