Consolidation and consolidated financial statements on an Excel basis
Practical implementation based on a case study
4.5
Contents
Theoretical principles are briefly reviewed and then applied in Excel based on the case study:
- Components of consolidated financial statements
- listing requirement
- consolidated group
- Currency conversion
- Capital consolidation with and without minority interests
- Debt consolidation
- Consolidation of income and expenses
- Interim result elimination
- Valuation of associated companies using the equity method
- Group bookings
- Consolidated statement of changes in non-current assets
The case study covers initial and subsequent consolidations.
Learning environment
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
Your benefit
- Learn how to prepare consolidated financial statements securely.
- Get an Excel template for the creation process that can be customized to your own needs.
- Receive a guide that provides orientation on all necessary work steps and instructions on how to implement consolidation measures with Excel.
- Work through a case study about a fictitious small company to better understand and grasp the context.
Methods
Presentation, practical examples, exercises and case study on the PC, sample solutions.
Recommended for
Specialists and managers from corporate accounting, finance, accounting, and controlling, as well as tax consulting and auditing, who are involved in preparing consolidated financial statements for small and medium-sized corporations. A good basic knowledge of corporate accounting is an advantage, but theoretical principles will training be briefly reviewed during training .
We go through the entire process of preparing consolidated financial statements based on individual accounting entries in Excel.
Further recommendations for "Consolidation and consolidated financial statements based on Excel"
42339
Ratings and feedback from our participants
Start dates and details
Tuesday, 02.06.2026
09:00 am - 5:00 pm
Wednesday, 03.06.2026
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Monday, 28.09.2026
09:00 am - 5:00 pm
Tuesday, 29.09.2026
08:30 am - 4:30 pm
Tuesday, 15.12.2026
09:00 am - 5:00 pm
Wednesday, 16.12.2026
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Thursday, 25.02.2027
09:00 am - 5:00 pm
Friday, 26.02.2027
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
About us - The Haufe Akademie
Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.
Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.
A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.
Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.
Do you have any questions?
We are there for you Monday to Friday 8:00 a.m. - 5:00 p.m.
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Munzinger Str. 9
79111 Freiburg
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
