Percentage increase in tech spending European CFOs expect to see, relative to the previous 12 months.
– Source: First Quarter 2008 Duke University/CFO magazine Global Business Outlook survey
|
|
[ Go to cognos.com ] |
|||||||||||||||
![]() |
|
|||||||||||||||
|
||||||||||||||||
FINANCEFast Close and the reporting supply chain: The need for a joined-up approachOctober 24, 2007
For the past decade many organizations have been preoccupied with the Fast Close – almost to the exclusion of everything else in relation to group financial reporting. But this focus on a single benchmark of performance may be misguided especially as internal and external reporting continues to converge. Although there is no agreed definition of the 'Fast Close,' it is commonly taken to mean the number of days taken by companies to publish their final audited accounts following the year end.
It is a broad brush measure that says little about the efficiency of the underlying process. For example, two companies that produce their results 30 days after the year end are ranked equally, irrespective of whether one of them uses 30 percent more finance resource than the other to meet the deadline. The need for a holistic approachClearly, there is a need for a more holistic approach which not only drives faster reporting throughout the year but also underpins a process of continuous improvement. Another curiosity is that a benchmark focussed exclusively on the year end says nothing about the regular monthly or quarterly reporting cycles which are the lifeblood of management reporting, performance measurement and control. Clearly, there is a need for a more holistic approach which not only drives faster reporting throughout the year but also underpins a process of continuous improvement. To date, the obsession with Fast Close velocity has been narrowly focussed on the consolidation system itself – usually located in group finance at the centre. Naturally, it is highly desirable that modern consolidation software is able to compute the group results quickly. Improvements in hardware and softwareOver the years, successive improvements in hardware capability, together with software techniques such as 'impacted consolidations' (where only the changes since the last full consolidation are re-calculated), have allowed marked improvements in the turn around of a group consolidation. However, whereas these time savings can be measured in hours there are bountiful savings to be made elsewhere in the Reporting Supply Chain (RSC) which can be measured in days. So where are the most fruitful areas to look?
Data capture, mapping key areas to considerThere are several potential areas to consider if an organisation is to yield substantial time savings. These relate to data capture from reporting entities, mapping to group systems and control, as well as the efficiency with which information is marshalled and reported post consolidation – the so-called 'last mile'. But trouble spots aboundCollecting data from subsidiaries has always been fraught with difficulty. The heterogeneous nature of many global businesses, reflected in their diverse operational systems and charts of account has acted as a significant drag on the RSC as group finance grapple with a multitude of different systems interfaces. Successive improvements in hardware capability, together with software techniques such as 'impacted consolidations', have allowed marked improvements in the turn around of a group consolidation. Even the simplest 'mapping' of data from local ERP to group systems can involve extensive manual procedures, spreadsheets, and batch transfers of files, introducing the potential for serious error along every step of the way. The scope for mistakes is also greatly magnified by the number of entities involved and frequent changes in group reporting packs brought about by management demands and regulatory change. The difficulty is that once erroneous data is in the RSC, it tends to travel through the process unchallenged, consuming valuable time and resources to put it right. Data quality solutions having an impactHowever, vast improvements in the management of data quality are beginning to have an impact. Vast improvements in the management of data quality are beginning to have an impact. A new generation of advanced ETL (Extract, Transform and Load) tools which bind subsidiaries' systems tightly into the RSC and require little in the way of formal IT skills are allowing finance functions to exert control over mapping tables, data transfer and changes to charts of accounts so that the process of harvesting data from reporting entities becomes dependable and accurate. This level of automation accompanied by greater control and visibility across the entire organisation greatly accelerates the process whilst simultaneously reducing errors. As are improvements in workflow and collaborationImprovements in workflow and other collaborative technologies, whilst less developed, are also beginning to have a beneficial effect on the latter stages of the RSC. Tighter integration between document management systems and consolidation systems holds out the prospect of being able to produce the Board pack or even statutory accounts without having to navigate an assortment of PDF files, spreadsheets, PowerPoint slides and Word documents. Tighter integration between document management systems and consolidation systems holds out the prospect of being able to produce the Board pack or even statutory accounts without having to navigate an assortment of PDF files, spreadsheets, PowerPoint slides and Word documents so common in the 'Last Mile'. Additionally, improved workflow capability will enhance visibility and control over the latest versions of sensitive documents and manage who is authorised to make changes or view them. Again the automation of these historically fractured processes can be expected to increase the speed and reliability of group reporting. Although the application of these new and developing techniques can be expected to yield welcome time savings and improvements, investments in data quality initiatives such as these should not be viewed in isolation. Creating internal benchmarks the keyCreating internal benchmarks that track the monthly and quarterly reporting cycles are the key to making continuous and enduring process improvements. A faster close around the year end may be admired by the capital markets and competitors but it is the efficiency of internal reporting that underpins a capable management team. About the author
Formerly a partner in Deloitte for more than 16 years, he has led some of the most complex financial reporting and information management assignments for global enterprises in the private and public sector. His latest book, "Fast Close to the Max®" is now available from FSN Publishing Limited.
|
||||||||||||||||
|
Numbers You Need 8.8%
Percentage increase in tech spending European CFOs expect to see, relative to the previous 12 months. – Source: First Quarter 2008 Duke University/CFO magazine Global Business Outlook survey On IT On Finance |
Decision Spotlight
Cognos Finance Forum 2008 The Performance Manager
Demos IBM Cognos TM1
IBM Cognos 8 TM1: MidMarket Edition
IBM Cognos 8 Planning
IBM Cognos 8 Controller
Reporting with IBM Cognos 8 BI IBM Cognos 8 BI Balanced Scorecards
IBM Cognos 8 Go! Mobile
IBM Cognos Now! Operational BI Web Seminars Delivering Financial Results: With or Without Spreadsheets Automating Financial Consolidation Best Practices for Internal Controls Performance and Compliance Leveraging Consolidation and Planning All about IBM Cognos 8 v3 Events |
|||||||||||||||
|
|