Misconceptions About Financial Consolidation Solutions

Financial Consolidation Solutions are Complex and Only Useful for Large Organizations

While most financial consolidation solutions have been designed to address the needs and requirements of large highly complex organizations with hundreds or even thousands of legal entities, such applications can deliver great value but are expensive to purchase, implement and maintain.


Fluence has specifically come to market with a goal of disrupting this reality.  We have designed and built our application to be deployed by small & large organizations that have requirements in the areas of foreign exchange translation, intercompany eliminations, legal structures with a variety of legal entities as well as a need for timely and transparent financial and operational reporting. In a world where simple “apps” can address some of our most complex needs and wants as individual consumers – Fluence applies this approach to delivering a simple and cost effective, yet powerful solution, to address the requirements of financial consolidation.

Financial Consolidation Solutions only solve half my reporting requirements – I need timely and accurate financial statements but my operational reporting needs can’t be addressed by these solutions

While this may have been true a decade or two ago, financial consolidation solutions have evolved to the point where they are capable of “consolidating” all kinds of financial and non financial data to support a wide breadth and depth of reporting.


However, the old adage of “be careful what you wish for” definitely applies.


Many of these solutions require you to learn complex applications that you use infrequently and are expensive to implement and maintain. Fluence has turned this paradigm upside down.


We deliver the power of an integrated database offering a single source of the financial truth –  capturing financial and non financial information to support all your performance management reporting needs. We offer workflow and security that are easy to set up, use and understand.  All the end users leverage Excel to execute the consolidation processes – utilizing a tool that finance professionals are very familiar with.

Financial Consolidation Solutions don’t address the dynamic reporting needs of my organization – they are too hierarchical

It is true that consolidation systems do a very good job at aligning reports with organizational structures which are more often than not, hierarchical. It is also recognized that much of the financial and operational reporting that an organization performs (or wants to perform) is multi dimensional in nature.


What is my revenue by product across these geographies, can I get a margin report for this customer or customer segment across the entire organization – or perhaps just for this legal entity?


If you are leaning on stand alone Excel spreadsheets to do your consolidation and feed this type of reporting – we feel your pain. Fluence provides a multi dimensional data store that contains all your financial and non financial performance management reporting information – supporting not just core financial reporting but the non hierarchical view of the world that you require.

Typical challenges and best practices in financial consolidation

After working in the Corporate Performance Management space for over two decades and being involved in hundreds of financial consolidation projects, we have seen just about every challenge that these projects will present and have identified some of the best practices to help you manage project risk.

Intercompany Reconciliation

We remember one corporate controller saying:


“As long as I can get my intercompany out of balance number below $5 million – I’m good”.


Granted they were a very large company but this type of situation is the reality for most companies –  they use a mixture of excel and email to identify and resolve intercompany out of balance positions and never quite get things completely aligned and end up happy if they can get close. Not only is this time consuming but it presents huge error risks and potentially opens you up to transfer pricing issues.

Best Practice


Applying work flow capabilities and automated matching, reporting and eliminations can dramatically improve controls, reduce errors and accelerate time to complete by up to 70%. Leveraging Fluence and Vena allows finance professionals to leverage Excel to report, analyze and respond but adds the control and transparency of a centralized data store and automated workflow – let’s get you that 70% savings.

Data Collection


Approximately 80% of companies over $50 million in revenue utilize standalone Excel spreadsheets to perform their financial consolidation. This approach can present a significant data integrity risk when it comes to data collection. It is estimated that close to 80% of all large standalone spreadsheets have at least one major unidentified error. Data collection often involves the emailing of standalone spreadsheets and manual effort to combine data from multiple sources/spreadsheets – a time consuming and error prone exercise.

Best Practice


There will be a common theme to many of the best practice recommendations – Automation. All data movement should be automated through certified connectivity – certainly between source applications like your General Ledge and your financial consolidation application. The solution should also manage the process utilizing a work flow engine. Fluence addresses both of these critical elements leveraging the Vena CPM platform.

Equity Reconciliation


Another data integrity risk is often presented in the equity reconciliation process. When organizations consolidate utilizing standalone excel they often do not capture historic data and it is not unusual for prior period opening balances to change in the GL. If such changes are missed it is highly likely that there will be errors in the Consolidated Owners Equity section of the financial statements.

Best Practice


Ensure that data collection processes capture the required level of granularity and automated validation routines and workflow can ensure that all equity reconciliation and equity movement reporting is accurate.

Historic Eliminations


Most companies have experience with business combinations or asset transfers. These transactions are eliminated in the books over an extended period of time. Again – stand alone spreadsheets are only as effective as the memory of the user who needs to remember and document the appropriate eliminations. If the impacted entities have different account rules, this can result in manually calculating depreciation amounts and present further timing delays and risks of errors.

Best Practice

The use of a dedicated consolidation platform and performs automated elimination calculations will not only dramatically eliminate errors but accelerate the overall closing process

Reporting and Data Consumption


While Financial Statements provide the basis for most of an organization’s performance management reporting they are far from everything you need. Aside from a broader spectrum of financial data and KPI’s, non financial operational data (HR and sales metrics to start) there is a need for historical financial and non financial information. If an organization is closing their books in Excel it is very likely that this information is not readily available and not reconciled to your core financial reporting. Aside from the effort and risk involved in gathering and reporting on all this information using standalone spreadsheets many organizations find inconsistencies in their reports and end up sending mixed messages to the consumers of this information

Best Practice

A consolidation and management reporting infrastructure that is based on an integrated database of information, available through the cloud, provides the ease of access and maintenance as well as consistency and integrity of information that is required to optimize performance.


Fluence Technologies, 350 Bay Street, 13th Floor, Toronto, Ontario, Canada, M5H 2S6