Consolidated Financial Statements are required by a parent company to show the true view of their current financial position by combining the financial information of all entities. They consist of a balance sheet, income statement, and cash flow statement providing a 260-degree view of the health of a parent organization and its subsidiaries. These statements assist in updating board members, stakeholders, and investors of the company’s financial position in its entirety without needing to look into each entity individually.

What is the Financial Consolidation Process

The financial consolidation process refers to bringing together financial information from numerous departments or entities of an organization for the purpose of reporting. This process usually involves bringing together information from the GL and other data and combining it into a single chart of accounts, making sense of it, and then reporting on it. Consolidated financial statements tell an organization a lot about how they are performing. 

Consolidated Financial Statements Example

ACME has $1,000,000 in revenues and 500,000 of assets that they include in their financial statements. That being said, ACME also oversees 2 subsidiaries, each of which produce $3,000,000 in revenues and $1,000,000 in assets. It would be inaccurate to simply report on the $1,000,000 in revenues of the parent company, as the company oversees the subsidiaries as well. This is where consolidated financial statements come in- they bring together the numbers of the parent company, alongside the numbers of the subsidiaries, to present an accurate and complete picture of financials. 

How to Consolidate Financial Statements

 

  1. Determine which entities are considered subsidiaries of the parent company. This includes any business where the parent company owns the majority of shares. Other holdings would be considered subsidiaries if the parent company has; majority voting rights, the ability to cast the majority of votes, the parent company has the control to remove or replace the majority of the board, or the power to govern over the subsidiary. Once you understand which entities need to be considered, gather all the financial statements from each entity. 
  2. Check the fiscal periods as not to mismatch them. If an entity uses a different timeline from the parent company it is prudent to modify the entity to match the parent company – although this usually occurs during the acquisition, but not always. 
  3. Create your reports, open Microsoft Excel, and create tabs for each sheet, one for the balance sheet, income statement, and so forth.  Copy-and-paste the totals from each entity and label the rows to help organize each section such as cash, inventory, etc. Ensure to include rows for the consolidation of debit or credit transactions. Now double-check the numbers inputted before combining them into your consolidated financial statements as attempting to determine where the mistakes are further in the process will be difficult and timely. 
  4. Create your consolidated balance sheet reflecting the sums determined previously. Now undergo the intercompany elimination processes for any entities that transact with each other. Use this data to compile the consolidated income statement and cash flow statement. 
  5. Once completed review all the sheets with a fine-tooth comb to ensure that none contain duplicate values including intercorporate assets or liabilities and money that flows between the two. 

 

Current Consolidation Methods and Alternatives

The manual process of copying and pasting numbers from multiple reports is a repetitive mistake-prone task. It requires gathering data from across the organization, numbers that are continuously changing – making it a difficult, timely process. 

Luckily there are now software types that assist in the consolidation of financial statements that have value in their ability to automate and speed up these processes. Consolidation software then transforms these numerous data sets into actionable insights all with a mere click-of-a button.  

Utilizing a solution that allows for a unified interface across multiple accounting processes and departments enables the production of truly consolidated financials easily and instantly. Not only does the automation of these processes guarantee accuracy but the time saved gives the finance department time to do what they were hired for – analyzing the data. 

What are consolidated statements of operations?

consolidated statements of operations is a common header that appears on the income statement. Other variations of this title include consolidated statements of income or consolidated reports of operations. Smaller corporations tend to stick with the common “Income Statements”.

Combined vs Consolidated financial statements- What’s the difference?

When it comes to businesses with subsidiaries, there are two main ways to create unified business statements- they can combine them, or consolidate them. A combined financial statement lists together all the activities of a group of related companies. Though it is combined, the financial statements of each entity are listed separately-each subsidiary or group has its own tab. What this does is it gives those that are looking into the statement the opportunity to see the overall performance of the organization, while also being able to see each individual contribution.

Contrastingly, a consolidated financial statement aggregates the numbers of both the parent company and its subsidiaries. This provides one overarching picture of how the organization is performing on the whole. The subsidiary’s business activities become part of the parent company’s financial statements. 

Condensed vs consolidated financial statements- what’s the difference?

A condensed and consolidated financial statement are similar in that they both provide an overview of how an organization is doing. However, they differ on one key point- a consolidated financial statement gives information about an organization and all of its subsidiaries in the same document. On the other hand, a condensed version sums it all up in a few lines. So, a condensed financial statement is much more succinct and to the point. 

What is Financial Consolidation Software? 

Can you imagine taking statements from your ERP, CRM, Excel Sheets, and having them all in one place? Financial consolidation software does that and more. It allows you to compile data sources from across the business, its multiple departments, and even multiple entities for easy reporting to a parent company, shareholders, and management.  It provides the ability to create real-time accurate analytics and insights into the health of a company’s financials instantly. It removes the continuous human error found on excel spreadsheets that takes other employees even more time to troubleshoot and lets financial professionals do what they were hired to do – interpret the data for decision making.

In a recent study by Gartner, it was found that; ‘finance departments can save their teams from 25,000 hours of avoidable rework caused by human errors by deploying robotic process automation (RPA) in their financial reporting processes.”  

With so much evidence pointing to the overwhelming benefits of automation, it makes you wonder, why have only one-third of the finance departments adopted a financial consolidation software? 

Well, the issue with current financial automation software is the fact that accounting has been manually done on Excel Spreadsheets for the better part of three decades. With such a finicky process – that is so detrimental to a company – the mere idea of uprooting all of an organization’s current methods is daunting. But the numbers are in and it is time to consider financial consolidation software or be left behind. 

Financial Consolidation Software made for FP&A professionals

Accounting departments consist of a variety of players including CFO’s, VP’s, Directors, and more, each one requiring something different from a chosen software. Rather than uprooting entire processes and departments, DataRails, the financial consolidation software made by FP&A specialists for finance professionals, works with your existing systems and consolidates them to derive actionable insights.

The platform allows you to upload ERP data, CRM data, and even excel- based spreadsheets all onto one cloud-based platform for the easiest integration as well as in-depth analysis and real-time results. Instead of wasting time on manual processes such as catching errors on endless excel templates, use a software that makes use of your existing infrastructure, and make your reporting processes work for you. 

What used to take me five hours now takes me 15 minutes”

Gregory Henry

Director of Treasury, AGNC

“DataRails maximized our efficiency and made the current process incredibly effective. It was a big win for us.”

Will Lederer

Senior Finance Manager of Business Systems, ForeScout Technologies