Small and medium business | Business Central, N...

Consolidation in Business Central

(2) Share

Report

Posted on by CU14031519-0

I've been running monthly consolidations in Business Central for the past year but it seems quite risky as each month I am only importing the movement on each g/l account in each subsidiary between 2 specified dates.

Therefore any back posting wouldn't be picked up. Also the consolidated balance sheet isn't controlled with any checks against the balances in the individual subsidiary balance sheet accounts.

Is there a better way of doing things?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (2)

Report

You can rerun consolidations for a period that has already been processed. When you do, the system will zero out the previous consolidation and replace it with the updated numbers. This is useful when you backpost in a previously consolidated period.

If you need to perform a check, that will have to be done manually.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
CU14031519-0 10 on at

Like (0)

Report

Thanks Valentin,

It doesn't seem very robust to me.

We have lots of subsidiaries to consolidate and it seems very difficult to go back from the consolidated figures to the individual company entries. The consolidation import doesn't even include the g/l account code so it's very hard for an auditor to trace where the numbers have come from. Is there a way to get the g/l accounts of the subsidiaries to appear in the consolidation?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

I think only customization can do that.

Or you can export it for analysis outside the system.

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-consolidated-company-reporting#export-and-import-consolidated-data-between-databases

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Find the right app | Microsoft AppSource

Business Central 2024 wave 2 (BC25): Use Excel reports for consolidation and fixed assets | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (1)

Report

if this helps as well:https://www.youtube.com/watch?v=I8LKSrcYfPM

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-consolidated-company-reporting

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report
Hello,

Here are a few suggestions to improve the accuracy and reliability of your consolidations in Business Central:

Full Data Import: Instead of importing only the movements, consider importing the full trial balance for each subsidiary. This way, any back postings will be included, and you'll have a complete picture of each subsidiary's financials.

Intercompany Postings: Utilize Business Central's intercompany postings feature to ensure that transactions between subsidiaries are automatically recorded and reconciled. This can help maintain consistency and accuracy across your consolidated accounts.

Automated Reconciliation: Implement automated reconciliation processes to compare the consolidated balance sheet with the individual subsidiary balance sheets. This can help identify discrepancies and ensure that your consolidated financials are accurate.

Consolidation Tools: Explore third-party consolidation tools that integrate with Business Central. These tools often offer more advanced features for handling complex consolidation scenarios, including back postings and intercompany eliminations.

Regular Reviews: Schedule regular reviews of your consolidation process and financial statements. This can help catch any issues early and ensure that your financials are accurate and up-to-date.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No