Preparing consolidated financial statements

Hi,

Can anyone share method for preparing consolidated financial statements.

It will be great if anyone is having excel format for preparation of consolidated financials.

thanks and regds

Nimesh

Replies (1)

Hi,

We need to do the line by bline consolidation at schedules/ notes level. Format for the same is simple. E.g. if A is holding and B is subsi then 4 columns are required in BS, PL and notes. Column 1 for A, 2nd for B, 3rd for consol adjustments and 4th for Total. 

 First of all u need to put the FS of A and B as it is in this format. In adjustment column, all the elimination entries, goodwill/CR entry, reclass entry if any will come.

Separate working for all inter company transactions need to be prepared and then will be taken to main file.

 

Thanks

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 04 September 2026
Accounts Executive

Hema Yashwanth & Associates

Chennai

B.Com

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
27 August 2026
ACCOUNTANT

CHARUPREETI & CO

Noida

Graduate (Any)

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details