Consolidated Balance Sheet: Definition, Example and Steps to Prepare it

consolidated balance sheet
Tally Solutions | Updated on: October 13, 2021

What is a consolidated balance sheet?

A consolidated balance sheet is a financial statement that shows the financial position of a parent company and its subsidiary companies. In simple words, a consolidated balance sheet is mere consolidation of financial details of all a subsidiary including the parent company and presenting as one balance sheet for the entire group.

A consolidated balance sheet is usually prepared by the business operating as a group of companies that have more than one subsidiary and it portrays the combined details of assets and liabilities.

consolidated balance sheet

Format and example of consolidated balance sheet.

P Ltd acquired Q Ltd on 1.1.2018. Their balance sheet as at 31.3.2017 is given below. Using this, let us prepare a consolidated balance sheet.

P Ltd Balance Sheets as at

31st March 2017

Liabilities

P Ltd

( INR )

Assets

P Ltd

( INR )

Share Capital :

10,000 Equity shares of Rs 10/- each fully paid

5,000  Equity shares of Rs 10/- each fully paid

 

1,00,000

 

    -

Fixed Assets

Investments : 

4,000 Shares in Q Ltd

 80,000

 

 40,000

General reserve

40,000

Stock

 20,000

Profit and Loss Account

20,000

Debtors

 25,000

Creditors

10,000

Cash and Bank

  5,000

 

1,70,000

 

1,70,000

Q Ltd Balance Sheets as at

31st March 2017

Liabilities

Q Ltd

( INR )

Assets

Q Ltd

( INR )

Share Capital :

10,000 Equity shares of Rs. 10/- each fully paid

5,000  Equity shares of Rs. 10/- each fully paid

 

   -

 

50,000

Fixed Assets

Investments: -

4,000 Shares in Q Ltd

 45,000

 

   -

General reserve

10,000

Stock

 10,000

Profit and Loss Account

10,000

Debtors

 10,000

Creditors

  5,000

Cash and Bank

 10,000

 

 75,000

 

 75,000

Consolidated  Balance Sheet P Ltd and it is Subsidiary Q Ltd

As at 31.12.2017consolidated balance sheet example

How do businesses prepare consolidated balance Sheet?

A consolidated balance sheet is a key financial statement in the case of group companies. The financial statements of different companies belonging to the same group are consolidated to present the financial position as a whole.

Manually preparing a consolidated balance sheet involves several steps right from arriving at the share capital, profits, etc. and it is a tedious task. As a result, businesses have automated the task of consolidating financial information using accounting software. Thereby, a consolidated balance sheet is readily available when required. Not just consolidated balance sheet but also several other key financial and accounting reports can be consolidated with a click of a button.

Using TallyPrime, you can consolidate the entire books of accounts, view consolidated reports and seamlessly compare the parent and subsidiary companies' reports.

In TallyPrime, you can do this by creating a group company. It allows you to conveniently view all your companies in one place.

Group company creation in TallyPrime

Group company functions as a single economic entity, where financial reports such as balance sheet, profit and loss a/c, and trial balance are consolidated without any impact on the transactions and real-time basis.

Using the group company, you can compare the performance of your subsidiary companies and keep a tab on the overall business.

TallyPrime

Run Tally, Run Business! Outrun your competitors today with TallyPrime!