How to save time in financial data consolidation

What is Financial Consolidation?

In the accounting world, financial data consolidation refers to the process of collecting data from multiple, disparate data sources and combining them into one consolidated report. Data usually comes from several subsidiaries or business entities within an organization, and may be represented in different formats, file types, or source systems (such as ERP systems, accounting systems, CRM systems, etc.).

Complexities in Financial Consolidation

In the accounting world, “financial consolidation” is a well-defined process that includes several complexities:

  • Collecting trial balance data (e.g., Assets, Liabilities, Equity, Revenue, and Expense accounts) from multiple general ledger systems, and mapping it to a centralized chart of accounts
  • Following specific accounting rules and guidelines, such as U.S. GAAP or International Financial Reporting Standards (IFRS)
  • Foreign currency translation
  • Elimination of intercompany transactions and balances
  • Accounting for partial ownership of the company and/or assets
  • Enabling traceability of data such that we know where each number came from (usually very difficult to solve using current systems)

Who does Financial Consolidation?

In large enterprises, the financial consolidation process is typically handled by the accounting department, which is under the supervision of the Controller or VP of Accounting/Reporting, while ultimately it is supervised by the CFO.

However, due to lack of proper standards on how data should be consolidated, we often see Financial Analysts spending more than 50% of their time on data consolidation, and not on strategic financial planning. This is a big problem as the data structures prepared by the Accounting Department are not necessarily useful for the FP&A Department to perform their analysis and provide actionable recommendations.

Tools for Financial Consolidation

We often see these tools used interchangeably in financial departments:

  • General Ledger systems. These work well for small companies, or if there is a single ERP system that holds all data from all parts of the company. If there is a need to collect data from multiple subsidiaries/locations/systems, this quickly become cumbersome.
  • Spreadsheets. When performing data analysis to make strategic decisions, the data analyst’s job requires flexibility that is only found in spreadsheets. However, to perform data analysis, the analyst must first gather and consolidate the data needed for analysis. This creates a cumbersome process where consolidation is done over-and-over again, periodically, which is time-consuming and error-prone.
  • Custom-made software. For large organizations, especially financial institutions, there are sometimes dedicated teams that are in charge of producing customized software for the organization. While this solution usually provides a reasonable fit to the organizational needs, it is very expensive and time-consuming.
  • Cloud-based solutions. Recently there’s been a surge in cloud-based solutions for many business applications, including for financial data consolidation. However, most solutions require a long time to implementation and very expensive customizations.

The True Key to Financial Consolidation

While this all looks quite complicated, the key to true financial consolidation lies in applying proper measures and protocols to make sure that data is consolidated effectively, easily, and periodically (or automatically). 

This is done by consistently applying the same protocols to data consolidation in a way that all data will be available to everyone, in one single repository. This ensures reliability of the data, as we expect all new data to be imported in the same way into our repository. This repository can be a large Excel file (better be careful here), an accounting software, or other software platforms. This ensures easy access for everyone, ranging from finance mangers, financial analysts, and planners from the various departments (supply chain planners, sales planners, inventory planners, etc.).

To conclude, to truly have all data consolidated properly and save lots of time for your financial team, it is important to hold one central repository, the “source of truth” of the company. This repository will hold all data, and new data will be imported using predefined rules. This will ensure reliability of the data, and allow traceability, such that every number can be traceable down to its source system. To implement such a process is not easy, but certainly doable for any financial team.

Other Recommendations

While you’re building your financial repository, we’ve devised several recommendations on how to better perform this consolidation process, specifically in Excel. Our examples are all in Excel but can be applied to other “source-of-truth” systems. We’ve written several blog posts with actionable tips on these specific issues, such as: consolidation of supply chain forecasts and actuals, consolidation of sales plans, calculating forecast errors in a consistent way, and more.

Would you like to learn about hot new disruptive startups, and how they challenge the incumbents?

Read our free newsletter with in-depth analysis of disruptive startups, and how they ramp up against the competition.

How to save time in financial data consolidation

Leave a Reply

Scroll to top