Report Designer: Creating Financial Reports with Different Chart of Account Structures

The Sage Intelligence Report Designer uses a reporting model which makes all relevant financial data available to report on. The data is retrieved from your ERP or Accounting software, pulled into Microsoft Excel tables and then loaded into memory. The Excel reporting tools, such as the Report Designer Task Pane, then interact with the data in memory to allow for fast and flexible reporting.


How do I create a financial report for two companies when their Chart of Account setup is different?

Let’s use the example of the following two companies:





Sage Intelligence retrieves all relevant financial data.  This means that it allows you to report on both companies, regardless of their different legislations or chart of account structures.  You can simply use Excel to achieve this:

  1. Set up your report parameters, such as current year and current period.
  2. When setting up your report rows, use two separate columns to specify your account rules as illustrated below.

Column C contains account rules for Company A
Column D contains account rules for Company B



3. Set up your columns for each company using Sage intelligence Formulas which reference the correct column.

Company A Formulas will reference Column C account rule
Company B Formulas will reference Column D account rules

The flexibility of Excel as the report design platform means that you can define custom report rows inside the Excel worksheet, which are linked to your chart of accounts, using Sage Intelligence Excel formulas and can therefore overcome the difference in account structure.  The Task Pane provides access to information such as Accounts and Account grouping which can be used as a guideline when defining the custom report rows in Excel.