loader image


Share on facebook
Share on twitter
Share on linkedin

How to implement account mappings and sub group consolidation in Dynamics, Xero, QuickBooks, MYOB, etc.

A typical need for finance professionals is mapping accounts or other system entities (companies, products, contacts, etc.) in a different way than they are structured in their source system. Acterys provides a very simple way to do this either in Excel using the Acterys Excel Add-on or in the Acterys Modeller. Excel is typically the easiest option as you have all Excel features like copy/paste, drag and drop, validate, etc. at your disposal.

Adding groups/mapping/sub consolidations to Dynamics, Xero, QuickBooks, MYOB and other systems

To map your data details just create a new column for the dimension (e.g. accounts, organization) that you want to use in the Acterys Modeller:

Acterys Modeller: Add mapping/consolidation sub groups

Enter a name for the new column in the following dialog box:

Now you can edit details for the new column e.g. mapping organizations to sub consolidations/ accounts to account groups etc. directly in the browser or switch to Excel and use Edit Dimension.

Validation with Linked Columns

The process can also be made easier by using “Linked Columns” that enable you to -in addition to typing the grouping details- select them from a list of allowed entries:

Acterys Linked Dimension

Recent Posts

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

The Acterys Modeller is cloud based service (with on-premise installation option) that allows enables business users to automatically create optimal analysis models (star schema data warehouse) from a variety to ERP. accounting and SaaS systems. The created models are write and planning enabled and can be edited and extended as needed by business users e.g. for adding new products/attributes, account mappings, new scenarios etc.