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.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250