Setting Up, Using, and Reporting on Consolidations in Business Central

In this how-to video, UG Expert Jo deRuiter explains how to set up, use, and report on consolidations in Dynamics 365 Business Central.

This episode is sponsored by Community Summit North America, the largest independent gathering of the Microsoft Business Applications ecosystem, taking place Oct. 13-17, 2024, in San Antonio, Texas. Register today to connect with thousands of users across the Microsoft business applications ecosystem at the for user, by user event.


00:18 — For the example, Jo creates two sample companies — Cronus US and Cronus USA Inc — to demonstrate how to consolidate them. The setup of one of the source companies will be similar to a Chart of Accounts level. Additionally, in her setup, the G/L account of the source company should match the G/L account of the consolidating company. Lastly, she notes that the setup of the Chart of Accounts for all accounts you wish to roll into the consolidating company.

03:29 — Next, follow the process of consolidations, which the system will guide you through. There are different parameters per consolidation, and different fields indicating various aspects.

06:07 — The data import aspect is highly important for consolidations, explains Jo. Once the source company matches the consolidation company, it’s time to run the consolidation. Once the process has run through, Business Central will let you know if the consolidation was successful, and users can run the consolidated trial balance.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!