The reality is that although there are many reasons
to improve financial consolidation and closing process,
organizations are faced with many roadblocks and challenges.
Here are a few of them.
Time and quality issues with data collection
—
Finance organizations faced with time constraints and shorter closing times are often confronted with data quality issues and manual data collection processes. Financial consolidation requires organizations to collect information from individual entities.
Organizations either must wait too long to receive information from each entity, or there are issues with the data or questions that create back-and-forth (often across time zones and in the high-pressure environment of the monthly closing process.)
No access to real-time data
—
Often organizations are faced with non-automated or even manual data gathering processes that are consolidated in spreadsheets. These offline processes do not allow financial controllers to drill-down to root-causes which have been identified in the financial data. Ability to slice-and-dice and drill-down in real-time is not possible due to poor data integration and/or missing multi-dimensional financial reporting solutions being used to consolidate financial data. Less accuracy and ability to analyse issues lead to a longer close process that ultimately is also less efficient.
Manual consolidations and entries
—
Spreadsheet-centric tasks like mapping accounts, applying consolidation rules, or manually making “off-line journal” entries to tie out the close are main drivers for a slow closing process.
Additionally, the need for adjustment entries from local to IFRS or US-GAAP require the ability to journal and track for audit purposes exactly such adjustments made in spreadsheets.
Inter-company reconciliation and eliminations
—
Tracking down detail behind inter-company transactions, balances, currency rates and other factors absorbs too much time.
Matching inter-company balances, transactions and creating eliminations is a major bottleneck in organizations.
Consolidation process control activities
—
Looking up checklists or manually applying control activities in the consolidation process can tie up members of the team.
Following-up on with group-wide entities any matter related to financial closing and consolidation is a labor intensive and time-consuming process.
Business structure change management
—
Adding newly acquired or created entities can take a significant amount of effort, as well as risking the integrity of consolidated reports.
Organizations need flexible, agile software solutions that support ever changing business structures.
Being able to automate equity reconciliation and elimination is often challenged by changing business structures as the current process and systems do not support it.
Consolidated report creation
—
Taking results from the consolidated systems typically means reformatting results or further spreadsheets manipulations.
Having a process and system in place the supports the “last mile” is a challenge on its own.
Changing reporting requirements
—
New regulatory requirements from various governments and international accounting standards often may mean that existing financial consolidation reporting processes fall out of alignment, requiring further manual effort.