ICAEW.com works better with JavaScript enabled.

Automating the month end

This Finance and Management webinar took place on 30 October 2015.

Overview

Closing month end can be an arduous and time consuming process, involving a long check list of processes including downloads, cuts, pastes, a load of rekeying and a few ‘quick fixes’ too for those who make use of Excel to facilitate the process. You only need to have a couple of errors found on review to have to repeat much of the original work. Time invested in automating as much of this procedure as possible provides a great return in both team efficiency and accuracy.

This one hour webinar, delivered by John Tennent, will demonstrate a few essential functions of Excel and then show how they can be used to build a ‘bridge’ file between an accounting system and a management accounts pack, to truly enable you to automate much of your routine reporting.