training training

Consolidation and consolidated financial statements on an Excel basis

Practical implementation based on a case study

This training is held in German.
Excel can be used to create consolidated financial statements efficiently and cost-effectively for small and medium-sized groups. In this workshop, you will use an end-to-end case study to independently prepare consolidated financial statements based on an Excel template. All necessary work steps, starting with the financial statements of the group companies, through the individual consolidation measures to finalization, are developed on the basis of this template in a holistic approach. You can adapt the template to the needs of your company.

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.

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Read more

Further recommendations for "Consolidation and consolidated financial statements based on Excel"

Seminar evaluation for "Consolidation and consolidated financial statements based on Excel"

4.5 from 5
with 114 ratings
training content:
4.4
Content comprehensibility:
4.1
Practical relevance:
4.5
Trainer expertise:
4.9
Participant orientation:
4.4
Method variety:
4.3
On-site training together
Booking number
2558
€ 1.540,- plus VAT
2 days
in 3 locations
3 Events
German
Events
Train several employees internally
Pricing upon request
  • Customized training courses according to your needs
  • Directly at your premises or online
  • Cost advantage from 5 participants
  • We contact you within 24 hours (Mon-Fri)
2 days
In-person or Online

This training is available as part of course:

certified group accountant course

Start dates and details

  Select time period
0 events
25.09.2025
Hamburg
Booking number: 2558
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Venue
WBS Training AG
WBS Training AG
Heidenkampsweg 45, 20097 Hamburg
Arrival via Deutsche Bahn
Train tickets to this event starting at € 51,90.
Days & Times
2 days
Limited number of participants

Thursday, 25.09.2025

09:00 am - 5:00 pm

Friday, 26.09.2025

09:00 am - 5:00 pm

Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
06.11.2025
Frankfurt a. M.
Booking number: 2558
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Venue
Com Center
Com Center
Dreieichstraße 59, 60594 Frankfurt a. M.
Arrival via Deutsche Bahn
Train tickets to this event starting at € 51,90.
Days & Times
2 days
Limited number of participants

Thursday, 06.11.2025

09:00 am - 5:00 pm

Friday, 07.11.2025

09:00 am - 5:00 pm

Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
12.02.2026
Munich
Booking number: 2558
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Venue
CBT Training & Consulting GmbH
CBT Training & Consulting GmbH
Elektrastr. 6A, 81925 Munich
Arrival via Deutsche Bahn
Train tickets to this event starting at € 51,90.
Days & Times
2 days
Limited number of participants

Thursday, 12.02.2026

09:00 am - 5:00 pm

Friday, 13.02.2026

09:00 am - 5:00 pm

Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Training is guaranteed to take place
Booking number: 2558
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Details
2 days
Limited number of participants
Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Booking number: 2558
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Details
2 days
Limited number of participants
Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Book later
You are welcome to make a non-binding advance reservation.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
Also bookable as in-house training
demand-oriented adaptations possible
on-site or live online for multiple employees
save time and traveling expenses
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

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.

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.