Consolidated Trial Balance

(0) Share

Report

Posted on by accountinguser2018

129

Hello,

I'm trying to pull a trial balance for 2 entities, with one tab on the output Excel workbook showing the entities consolidated (each account from all entities has a separate row) and also a column specifying which entity the account and balance pertains to. In other words, I'm trying to eliminate some manual work. Is this possible?

Thank you.

*This post is locked for comments

All responses (4)

Answers (2)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Consolidated Trial Balance

Hello accountinguser2018,

I am wondering whether you have been able to get this issue resolved?

Would be great if you could keep us updated here.

Many thanks and best regards,

Ludwig
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Consolidated Trial Balance

Hi,

It should be possible to show the data from the different legal entities in separate columns.

This can be achieved e.g. by making use of a reporting tree that has the different companies included and by referencing the tree elements in the column definition.

You can find a couple of examples on this blog

[View:https://blogs.msdn.microsoft.com/dynamics_financial_reporting/]

Best regards

Ludwig
accountinguser2018 129 on at

Like (0)

Report

RE: Consolidated Trial Balance

Thanks for your reply. I am unsure which standard features you're referring to.
Verified answer

André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at

Like (0)

Report

RE: Consolidated Trial Balance

Hi accountinguser2018,

I don't know all details of Management Reporter in depth. Usually, consolidated reporting is done from within a consolidation company. Have you considered using the standard features for a consolidation company?