Contents
Components of consolidated financial statements
Installation obligation and organization
Scope of consolidation and reporting package
Currency conversion
- Conversion of balance sheet and income statement.
- Capital features.
- Currency effects in the consolidated statement of changes in non-current assets.
Capital consolidation
- Consolidation techniques.
- First-time and subsequent consolidations.
Debt consolidation
- Consolidation techniques.
- Differences.
- Currency effects.
Consolidation of income and expenses
- Consolidation techniques.
- Dealing with differences.
- Currency effects.
Interim result elimination
- Determination of interim profits.
- Booking techniques.
Group bookings
Consolidated statement of changes in non-current assets
- Creation and coordination problems.
- Dealing with currency effects.
- Dealing with changes in the scope of consolidation.
Learning environment
In your online learning environment, you will find useful information, downloads and extra services for this qualification measure after you have registered.
Your benefit
- You will learn how to prepare consolidated financial statements safely.
- You will receive an Excel template for the creation process, which can be used for all Excel versions from 2007 onwards and which you can adapt to your needs.
- A guide provides you with orientation on all the necessary work steps.
- You will receive instructions on how to implement consolidation measures with Excel.
- Using examples of professional tools, you will receive suggestions for designing the closing process.
- You will work on an end-to-end case study about a fictitious small company so that you can better understand and grasp the interrelationships.
Methods
Presentation, practical examples, exercises and case study on the PC, sample solutions.
Recommended for
Specialists and managers from group accounting, finance, accounting and controlling as well as from tax consultancy and auditing who deal with the preparation of consolidated financial statements for small and medium-sized groups. Good basic knowledge and practical experience in group accounting should be available.
Further recommendations for "Consolidation and consolidated financial statements based on Excel"
Seminar evaluation for "Consolidation and consolidated financial statements based on Excel"







Start dates and details
Thursday, 25.09.2025
09:00 am - 5:00 pm
Friday, 26.09.2025
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Thursday, 06.11.2025
09:00 am - 5:00 pm
Friday, 07.11.2025
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Thursday, 12.02.2026
09:00 am - 5:00 pm
Friday, 13.02.2026
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.