Sage X3 – How to setup Legal and Analytical Chart of Accounts for Multiple Companies Reporting.

Title – How to Configure Legal and Analytical Reporting Account Setup for a number of firms in Sage X3

Abstract -This performance in Sage X3 will allow the customers to view the Account balances at reporting stage in both Firm’s Native foreign money (Legal) and in different currencies (Analytical) if there are a number of Companies in identical or different international locations.

Under is the situation described together with the setup which can elaborate the completely different features setup that are supposed to be configured when the Firm setup is finished in Sage X3.

State of affairs– A Firm XYZ Pvt. Group Firm is positioned in Nation 1 (Kenya) and in Nation 2 (Rwanda) having their very own respective native foreign money. When the reviews are considered in a Firm which is in Nation 1 (Kenya) it is going to be both in Native foreign money or in another overseas foreign money.

Equally when reviews will probably be considered in Nation 2 (Rwanda) it is going to be both in Native foreign money or within the foreign money relevant in Nation 2 (Rwanda). That is the place the Legal and Analytical setup is required to be configured. The outlined 2 Companies in 2 completely different international locations will probably be handled as 2 separate Legal entities.

Step 1: Chart of Accounts

There will probably be three completely different Chart of Accounts will probably be created for a Firm-

  • Nation 1 Analytical CoA (Kenya)
  • Nation 1 Legal CoA (Kenya)
  • Nation 2 Legal CoA (Rwanda)

Based mostly on the system course of and accessible provision CoA we will probably be outlined. In CoA “Normal Monitoring” and “Analytical Monitoring” examine field must be ticked in all of the CoA outlined.

Step 2: Ledgers

A ledger is related to the setup knowledge of the Chart of Accounts. Ledgers additionally include the administration guidelines related to the matching and year-end guidelines.

There will probably be three completely different Ledgers will probably be created for a Firm which will probably be relevant to the respective authorized entities, one individually for Legal and one other for Analytical-

  • Nation 1 Analytical Ledger
  • Nation 1 Legal Ledger
  • Nation 2 Legal Ledger

Each particular person Ledgers created may have its Distinctive Code together with the opposite particulars of Dimensions and Budgets if relevant.

Step 3: Account Core Fashions

This operate is a construction containing the Chart of Accounts, which is to be utilized to each the authorized firms. One mannequin may be linked to a single or a number of authorized firms inside the identical nation or laws. Each particular person Account Core Mannequin created may have its distinctive code.

The next Account Core Mannequin will probably be created for each the Legal Entities-

  • Nation 1 Commonplace Mannequin
  • Nation 2 Commonplace Mannequin

For each Commonplace Mannequin choose the Correct “Principal Normal ref” as “Legal” and “Principal Analytical ref” as “Analytical”.

Based mostly on that within the desk for Legal and Analytical reference varieties map the right Ledger code created earlier together with the specified foreign money for Legal and Analytical reporting. Refer Screenshot for reference for Nation 1 & 2 Commonplace Mannequin.

Step 4: Accounts

Completely different Accounts will probably be created in particular person Chart of Accounts with their very own respective Account codes.

In every and each Account of Nation 1 Legal CoA, the related Analytical Account Code will probably be tagged which is created within the Nation 1 Analytical CoA. Equally for the Account in Nation 2 Legal CoA, its related Analytical Account Code will probably be tagged.

Refer Screenshot for reference of a selected Account in Legal and Analytical tagged to it.

Fig– Nation 1 Analytical CoA account displaying the Account code tagged to them from each Nation 1 authorized CoA and Nation 2 Legal CoA.


When any transaction is created is Nation 1 and when it’s related Journal Entry will get created within the system, robotically the system exhibits the Nation 1 Legal Account code together with the mapped Nation 1 Analytical Account code. Refer screenshot for reference.


Thus by following the above said steps, authorized and analytical setup required for a number of firms reporting shall be configured in Sage X3.

About Us

Greytrix Africa is a number one Implementation, Reselling and Consulting associate for Sage X3, Sage 300, Enterprise Administration HR (previously Sage X3 Folks) & Sage CRM based mostly out of Nairobi, Kenya in Africa area catering to Tanzania, Ethiopia, Center East, Australia and Asia enterprise sectors.

Greytrix Africa affords skilled providers reminiscent of Implementation & configurationBusiness Process AnalysisProject Management, Customization, Integrations & Migrations, Technical help and Onsite useful resource augmentation together with enhancements inside Sage X3,Enterprise Management HR (Sage X3 People)Sage CRM and Sage 300 (Accpac) throughout varied business verticals like Course of Manufacturing (Food & BeveragesChemical), Discrete manufacturing (AutomotiveTextile & Apparel), Non ProfitHealth-care Industry and Service Business (Financial , Software & Engineering).

For extra data on Sage X3 Consulting Companies, please contact us at We’ll like to hear from you.

Related posts

Leave a Comment