It’s common that different companies may have different charts of accounts but still wish to produce consolidated financial statements. In this situation, Management Reporter can still consolidate the data, allowing you to produce consolidated financial reports. This blog (2nd in a series of 7), will highlight how to create consolidated reports with varying chart of accounts.
The high level steps for consolidating when different charts of accounts exist in each company are:
Multiple links to Financial Dimensions can be added to each row in the row definition for each unique company’s chart of accounts. In this example, you can see that CEU is using the set of accounts in the first Financial Dimension link (Column J), and CEE is using the accounts in the second Financial Dimension link (Column K).
Use a reporting tree to define which Link to Financial Dimensions from the row definition is used with each company. You can do this by first selecting the Row Definition in column E, and then selecting the appropriate Row Link in column F.
TIP: When creating the Link to Financial Dimensions, use the Description to identify which companies the link applies to. This makes it easy to select the correct company when creating a reporting tree.
In the column definition, the Reporting Unit field allows you to restrict each column to a particular unit of the reporting tree, so you can view the data side by side, if you wish. If you don’t indicate a specific company for a column, consolidated date for all companies will be displayed.
How do we attach a different chart of accounts to link per financial dimension column? Thanks.
Just add financial dimension columns for each chart of accounts and put in the appropriate account ranges.
I am having a similar problem as Joan B.
The row definition link for the second company only shows the segments for the first company.
I realize that these posts are old, but I think the answer that you're looking for is that you need to save your row format and switch companies before adding your second financial dimension column. If you log out of Company A and in to Company B, then reopen your row format, the dimensions that you can click through to should now be those of Company B as opposed to Company A.
Can both companies have different segment names? I'm running into a problem were data is not being generated for one company.
Yes, different companies can have different segment names. You need to create a link to financial dimensions for each one. Then set that company as default to populate the link. In the reporting tree definition you have to select the row definition and link for each company.
Thank you for the steps.
I have AA enabled and I have two companies one of the companies pulls data properly when I try to print the consolidated or that company by itself I get "Invalid column name 'TranslationDebitAmount' error from the event viewer also the budget for both companies are not showing.