/visma-net-erp/help/general-ledger/manage-consolidations section By using the functionality of the General ledger workspace, you can consolidate data from specific branches of subsidiaries (or consolidation units) into a specific branch of the parent company. 2026-02-19T17:09:06+01:00 # Manage consolidations By using the functionality of the General ledger workspace, you can consolidate data from specific branches of subsidiaries (or consolidation units) into a specific branch of the parent company. By using the functionality of the General ledger workspace, you can consolidate data from specific branches of subsidiaries (or consolidation units) into a specific branch of the parent company. You can configure which data should be consolidated and how exactly the data should be consolidated. After that, you can consolidate the data as often as you need within each financial period. This functionality is available only if the **General ledger consolidation** functionality is enabled in the [Enable/disable functionalities (CS100000)](/visma-net-erp/help/common-settings/enable-or-disable-functionalites/enable-disable-functionalities-cs100000/) window. In the overview below, you can find topics that describe the consolidation process when both the subsidiary and the parent company use Visma Net. Consolidation data is available through the standard simple object access protocol (SOAP) gateway, so third-party software can be used by either side. /visma-net-erp/help/general-ledger/manage-consolidations/general-ledger-consolidation-overview page The consolidation process in the General ledger includes three stages: 2026-02-19T17:09:06+01:00 # General ledger consolidation overview The consolidation process in the General ledger includes three stages: + Consolidation setup, which is performed by each consolidation unit and by the parent company + Data preparation by each consolidation unit + Import of the consolidation data from each of the units by the parent company These stages are described in the sections below. ## Setup by the parent company The parent company should perform the following actions to set up consolidation: + Decide which branches will consolidate which data. + Provide proper information about the accounts and subaccounts in accordance with the required level of consolidation details. This information will be used for mapping in the consolidation units. + Perform the synchronisation to update the lists of ledgers and branches available in the consolidation units for consolidation. + Configure access to the consolidation unit's Visma Net website by specifying valid credentials. ## Setup by the consolidation unit To set up consolidation, the consolidation unit should perform the following actions: + Mapping the unit's accounts to the parent company's accounts on the chart of accounts. + Specifying all the settings for proper mapping of the unit's subaccount segments to the parent company's subaccounts in the [Segment values (CS203000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-values-cs203000/), [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/), and [Consolidation (GL103000)](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) windows. For mapping options and examples, see: [About account mapping for consolidations](/visma-net-erp/help/general-ledger/manage-consolidations/about-account-mapping-for-consolidations/).Selecting the required ledgers as source ledgers for consolidation in the [Ledgers (GL201500)](/visma-net-erp/help/general-ledger/general-ledger-windows/ledgers-gl201500/) window, and specifying a particular branch or branches if needed. ## Restriction on financial periods During the import, consolidation data is grouped by the financial periods of the reporting unit. Thus, financial periods in the consolidation units and in the parent company should be defined similarly; otherwise, the consolidated data will be incorrect. ## Data preparation If a consolidation unit uses multiple currencies or a different base currency than that of the parent company, the unit should translate the data into the base currency of the parent company before the parent company imports the data. If you want to consolidate the translated data, specify the reporting ledger as the unit's source ledger. To consolidate the original data, specify the actual ledger as the source ledger of the unit. ## Data import The consolidation data is imported to the selected branch of the parent company as general ledger batches with system-generated descriptions. Before the system starts to import the consolidation data, the system transforms the unit's subaccounts into the parent's subaccounts using the segment values mapping and other related settings. Consolidation data being imported to the parent company is available by using the SOAP gateway as a set of GLConsolRead instances. Every GLConsolRead instance consists of four data fields: + `AccountCD` (general ledger account) + `MappedValue` (parent company subaccount) + `ConsolAmtCredit` (total credit value for period) + `ConsolAmtDebit` (total debit value for period) To import the consolidation data from the consolidation units to the parent company, use the [Import consolidation data (GL509000)](/visma-net-erp/help/general-ledger/general-ledger-windows/import-consolidation-data-gl509000/) window. Select the unit and the source ledger, and then click **Process**. The financial data will be imported from the database of the consolidation unit to the specified branch of the parent company. To consolidate data of the different types (such as actual data and budget data), use separate ledgers in the parent company. Related reference [Chart of accounts](/visma-net-erp/help/general-ledger/general-ledger-windows/chart-of-accounts-gl202500/) [Subaccounts](/visma-net-erp/help/general-ledger/general-ledger-windows/subaccounts-gl203000/)

Related pages

Concepts

• About account mapping for consolidations

/visma-net-erp/help/general-ledger/manage-consolidations/about-consolidation-configuration page This topic provides instructions on how to configure consolidation for your company. 2026-02-19T17:09:06+01:00 # About consolidation configuration This topic provides instructions on how to configure consolidation for your company. Before you get started, review the hierarchy of the companies whose data should be consolidated, and determine which companies report to which. In this section, consider only a two-level hierarchy: a parent company and one or more subsidiaries (consolidation units) that report to it. This simple hierarchy can be used as a part of a more complicated hierarchy, with the consolidation process going from the bottom to the top and with parent companies after consolidating data from the units becoming units of the next level. Suppose that both a parent company and subsidiaries use Visma Net. If a consolidation unit uses a third-party ERP software, the parent company can consolidate the data by importing the trial balance prepared by the unit and exported to a CSV file by using its third-party software. Mapping of accounts and subaccounts should be performed in this case manually directly in the file, before the parent company will perform import from this file. For more information about the functionality intended for consolidations, see [General ledger consolidation - overview](/visma-net-erp/help/general-ledger/manage-consolidations/general-ledger-consolidation-overview/). ## Consolidation requirements For correct consolidated data, the following requirements should be met: + The parent company and its subsidiaries should have the same configuration of financial year and periods, since the consolidation data is grouped by the financial periods of subsidiaries. + The parent company and its subsidiaries should have similar structure of charts of accounts, with fewer accounts on the parent chart. Data from multiple accounts used in a subsidiary can be consolidated into one account of the parent company. + A subsidiary should have a subaccount structure similar to that of the parent company. The parent company may have one additional segment (compared to the subsidiary) with values designating subsidiaries. ## Consolidation procedures Generally, the consolidation process includes these three stages: + Consolidation setup, which is performed by each subsidiary and by the parent company + Data preparation by each of the subsidiaries + Import of each subsidiary consolidation data by the parent company The procedures required for configuring and performing consolidation are discussed in the following topics: + [Configure consolidation in a parent company](/visma-net-erp/help/general-ledger/manage-consolidations/configure-consolidation-in-a-parent-company/) + [Configure consolidation in a subsidiary](/visma-net-erp/help/general-ledger/manage-consolidations/configure-consolidation-in-a-subsidiary/) + [Prepare the consolidation data in a subsidiary](/visma-net-erp/help/general-ledger/manage-consolidations/prepare-the-consolidation-data-in-a-subsidiary/) + [Import the consolidation data from a subsidiary](/visma-net-erp/help/general-ledger/manage-consolidations/import-the-consolidation-data-from-a-subsidiary/) /visma-net-erp/help/general-ledger/manage-consolidations/configure-consolidation-in-a-parent-company section The following actions should be performed in the system of the parent company to set up consolidation: 2026-02-19T17:09:06+01:00 # Configure consolidation in a parent company The following actions should be performed in the system of the parent company to set up consolidation: + Provide access to each subsidiary Visma Net website by specifying valid credentials. + Perform synchronisation to update the list of ledgers and branches available in each subsidiary as sources of consolidation data These actions, performed in the [Consolidation (GL103000)](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) window, are described in detail in the sections below. ## Before you proceed + Provide information about the parent company accounts and subaccounts to personnel at subsidiaries, so that this information can be used for mapping. + Provide information about the parent company base currency to appropriate personnel, to allow subsidiaries to translate the data intended for consolidation from the base currency of each subsidiary to the base currency used by your company. + Make sure the ledgers in each subsidiary whose branches store the data to be consolidated have been specified as the consolidation sources. ## Provide access to subsidiary systems 1. Go to the [Consolidation (GL103000)](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) window. 1. In the **Consolidation segment number** field, specify the number of the subaccount segment used in the parent company to designate the subsidiaries (consolidation units). 1. Provide access information for each of the branches of the parent company that will be importing data from the branches of subsidiaries, following the steps below for each subsidiary. 1. Click **** to insert a row in the table. 1. In the **Consolidation branch** column, select the consolidation branch to hold the consolidated data. 1. In the **Consolidation ledger** column, notice the consolidation ledger associated with the branch. 1. Specify the **Consolidation segment value**, which is used to designate this subsidiary or this branch of the subsidiary. 1. Select the **Paste segment value** check box if the consolidation segment is not present in the subsidiary segments. 1. In the **Paste segment value** column, specify the business name of the subsidiary. 1. In the appropriate columns, provide the **User name** and **Password** that can be used to access the website of the subsidiary, as well as the **URL** of the website. 1. In the **From period** and **To period** columns, specify the start and end period for consolidation. 1. Click ****. ## Perform synchronisation between the websites involved 1. While you are still in the [Consolidation (GL103000)](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) window, perform synchronisation between the websites in one of the following ways: It may take several minutes to compile the web services that are used for consolidation. If you receive an **Internal error** message, wait two minutes and repeat the attempt to perform synchronisation. + By using the unlabelled check box, select the added or modified record for each appropriate subsidiary, and click **Synchronise** in the window toolbar. + Click **Synchronise all**. 1. Once synchronisation is completed, in the **Source ledger** column of the table, specify the source ledger and the source branch. 1. Click ****. Parent topic: [About consolidation configuration](/visma-net-erp/help/general-ledger/manage-consolidations/about-consolidation-configuration/) /visma-net-erp/help/general-ledger/manage-consolidations/configure-consolidation-in-a-subsidiary section To set up consolidation with the parent company, for the subsidiary, you perform the following actions: 2026-02-19T17:09:06+01:00 # Configure consolidation in a subsidiary To set up consolidation with the parent company, for the subsidiary, you perform the following actions: + Map the subsidiary general ledger accounts to the parent company accounts by using the [Chart of accounts (GL202500)](/visma-net-erp/help/general-ledger/general-ledger-windows/chart-of-accounts-gl202500/) window. + Map the subsidiary subaccount segments to the parent company subaccounts by using the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window and the [Segment values (CS203000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-values-cs203000/) windows. + Select the source ledger for consolidation in the [Ledgers (GL201500)](/visma-net-erp/help/general-ledger/general-ledger-windows/ledgers-gl201500/) window. ## Map accounts to the parent company accounts 1. Go to the [Chart of accounts (GL202500)](/visma-net-erp/help/general-ledger/general-ledger-windows/chart-of-accounts-gl202500/) window. 1. For each account, in the **Consolidation account** column, specify the parent company account to consolidate the data. You may select from the list of the subsidiary accounts if the parent company chart of accounts is similar to the subsidiary chart. Multiple accounts may be mapped to the same account on the parent chart. 1. Click ****. ## Verify that all accounts are mapped 1. Click the **** icon. 1. In the **Filter settings dialog box**, select **Consolidation account** as the property and **Is zero** as the condition. If you want to save the filter for future use, click **Save** and enter a filter name before you close the **Filter settings** dialog box. 1. Click **OK** to close the dialog box and apply the filter. 1. The system will display the list of general ledger accounts that were not mapped. 1. Map these accounts, if any, and save the changes. ## Map subaccounts to the parent company subaccounts You can provide mapping for any subaccount structure in the parent or subsidiary. For simplicity, there is the following procedure on these assumptions: + Subaccounts in subsidiaries and in the parent company have the same general structure, with one additional segment in the parent subaccounts used to designate the subsidiary. + The subsidiaries do not have such a segment. + All other segments in the subsidiaries have values that can be easily mapped to the appropriate segment values in the parent company. You map subaccount segments to segments in the parent subaccounts by using the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window as follows: Go to the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window. 1. In the **Segment key ID** field, select **SUBACCOUNT**. 1. For each of the segments, in the **Consol. order** column, type an integer to specify the order of this segment in the parent subaccount. 1. In the **Number of characters** column, specify the lengths of appropriate segments in the parent company. 1. Click ****. You map segment values to parent subaccount segment values in the [Segment values (CS203000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-values-cs203000/) window as follows: 1. Go to the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window. 1. In the **Segmented key ID** field, select **SUBACCOUNT**. For each of the segments, perform the following steps: + In the **Segment ID** field, select the segment by its number in the subsidiary subaccount. + In the table area, for each of the segment values, specify the matching value in the parent subaccount segment in the **Mapped value** column. 1. Click ****. ## Specify a ledger as a consolidation source 1. Go to the [Ledgers (GL201500)](/visma-net-erp/help/general-ledger/general-ledger-windows/ledgers-gl201500/) window. 1. Review the list of ledgers available in your system and select the **Is consolidation source** check box for the appropriate ledger. 1. Use the following guidelines in selecting the ledger: + If consolidation will be performed in a base currency other than the base currency of the subsidiary, select the reporting ledger that will contain the translated trial balance or budget data. + If consolidation will be performed in the subsidiary base currency, select the actual ledger. + If consolidation will be performed for only budget data in the subsidiary base currency, select the budget ledger. /visma-net-erp/help/general-ledger/manage-consolidations/prepare-the-consolidation-data-in-a-subsidiary page How the consolidation data should be prepared in a subsidiary depends on whether the subsidiary uses multiple currencies and whether its base currency is the same as the base currency of the parent company. 2026-02-19T17:09:06+01:00 # Prepare the consolidation data in a subsidiary How the consolidation data should be prepared in a subsidiary depends on whether the subsidiary uses multiple currencies and whether its base currency is the same as the base currency of the parent company. This topic discusses the following cases: + A subsidiary uses the same base currency as the parent company does. + A subsidiary uses another base currency than the parent company does. If a subsidiary uses only one currency in the single-currency system, no special data preparation is required. Translation to the base currency of the parent company can be performed in the parent company after the import is completed. ## Prepare data in any subsidiary 1. Prepare the trial balance for the consolidation period. Make sure it is correct. For details, see: [View the trial balance on reports](/visma-net-erp/help/general-ledger/manage-accounts/view-the-trial-balance-on-reports/). 1. Close the financial period for which consolidation will be performed. ## Prepare data in a subsidiary with another base currency 1. Update exchange rates to be used for translation of balances to the base currency of the parent company. 1. Translate the balances to the parent company base currency, and record the translated balances to the ledger that has been specified as the consolidation source. Parent topic: [About consolidation configuration](/visma-net-erp/help/general-ledger/manage-consolidations/about-consolidation-configuration/) /visma-net-erp/help/general-ledger/manage-consolidations/import-the-consolidation-data-from-a-subsidiary page To import the consolidation data from the consolidation units to the branches of the parent company, use the Import consolidation data (GL509000) window. 2026-02-19T17:09:06+01:00 # Import the consolidation data from a subsidiary To import the consolidation data from the consolidation units to the branches of the parent company, use the Import consolidation data (GL509000) window. For more information: [Import consolidation data (GL509000)](/visma-net-erp/help/general-ledger/general-ledger-windows/import-consolidation-data-gl509000/). To import the consolidation data from the consolidation units to the branches of the parent company, use the [Import consolidation data (GL509000)](/visma-net-erp/help/general-ledger/general-ledger-windows/import-consolidation-data-gl509000/) window. For access to the websites of the units, the system uses information provided in the [Consolidation (GL103000)](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) window. The financial data will be imported from the database of the consolidation unit to the specified ledger of the parent company. To consolidate data of different types, such as actual data and budget data, import them to different ledgers in the parent company. ## Before you proceed + Make sure that the previous financial year is closed before importing the data for the first time in the new year. + Make sure that in the parent company, all financial periods for which the data is available in subsidiaries are activated. 1. Log in to the parent company. 1. Go to the [Import consolidation data (GL509000)](/visma-net-erp/help/general-ledger/general-ledger-windows/import-consolidation-data-gl509000/) window. 1. In the list of consolidations, select the check box(es) for the consolidations that you want to process. 1. Make sure the consolidation branches to which the data will be imported from the consolidation units are specified correctly. 1. Click **Process**. Data is imported for all open periods, and only data posted to the source ledgers of the consolidation units after the previous consolidation will be imported to the specified consolidation ledgers of the parent company. You can prepare and review the trial balance and proceed with preparing financial statements for the parent company. /visma-net-erp/help/general-ledger/manage-consolidations/about-account-mapping-for-consolidations page Successful, complete consolidation requires thorough mapping of the subsidiary's accounts and subaccounts to the respective accounts and subaccounts of the parent company. 2026-02-19T17:09:06+01:00 # About account mapping for consolidations Successful, complete consolidation requires thorough mapping of the subsidiary's accounts and subaccounts to the respective accounts and subaccounts of the parent company. This mapping depends on your consolidation scenario: what level of details should be available in the consolidation branch for the required consolidated reports. ## Account mapping The chart of accounts may be different in each subsidiary and in the parent company. Matching accounts for consolidation is a relatively straightforward task when the parent company and subsidiaries have similar charts of accounts. Note that some of the accounts may be assigned to a specific branch. Multiple accounts in a unit can be merged into a single account of the parent company if you set the same external account against different accounts in the consolidation unit in the [Chart of accounts (GL202500)](/visma-net-erp/help/general-ledger/general-ledger-windows/chart-of-accounts-gl202500/) window. If the parent company has a more detailed chart of accounts than some of its subsidiaries do, some consolidated accounts may not contain correct information. For example, consider a parent company with several accounts to record travel expenses and a subsidiary with only one account, Travel expenses. In this case, the only travel expense account of the subsidiary has to be consolidated with one of the parent's travel expense accounts. No matter which account is chosen as a consolidation target, the consolidated data will be incorrect. Note: For correct reporting, we recommend that the subsidiaries keep similar or more detailed charts of accounts than the parent company. ## Subaccount mapping In Visma Net, subaccounts carry additional information about the organisational structure of each company. Subaccounts of the consolidation unit are matched to subaccounts of the parent by mapping the unit's segments to strings of the specified length set in the specified order to form the parent's subaccounts. This makes mapping of subaccounts easier and more flexible. For each subaccount segment in the consolidation unit, you define the following parameters for consolidation mapping in the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window: + Number of characters: The length of the string (segment or part of the segment) in the parent's subaccount to which the segment value is mapped + Consolidation order: The number that represents the place of this string among other strings in the parent's subaccount If a segment in a unit's subaccount does not match any string (segment or part of the segment) in the parent subaccount, set both of these parameters to zeros. This means the amounts associated with the segment will be aggregated. During data collection, the subaccounts of the unit are mapped to temporary or raw subaccounts that may differ from the parent's subaccounts by the absence of the consolidation segment. ## Example of mapping Consider an example when the parent company has four segments, the first of which is a consolidation segment not involved in mapping. The subaccount of the consolidation unit consists of three segments. Each segment of the unit can be mapped to a same-meaning segment of the parent even though the lengths of the segments are different. In the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window, the consolidation mapping parameters for the unit's subaccounts will have the following values. |Segment|Description|Length|Consol. order|Number of characters| |---|---|---|---|---| |1|Project|3|2|2| |2|Department|4|4|2| |3|Brand|3|3|3| The three-character values of the first segment (Project) of the unit's subaccount will be mapped to the two-character values of the second segment of the parent's subaccount, and other segments will be mapped similarly. Particular strings are specified in the [Segment values (CS203000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-values-cs203000/) window in the **Mapped values** column. A segment of a unit may be mapped to a string that is shorter than the segment in the parent's subaccount. Here, in the [Segment keys (CS202000)](/visma-net-erp/help/common-settings/common-settings-windows/segment-keys-cs202000/) window, the consolidation mapping parameters for the unit's subaccounts will have the following values. |Segment|Description|Length|Consol. order|Number of characters| |---|---|---|---|---| |1|Project|3|2|1| |2|Department|4|3|3| |3|Brand|3|4|2| ## Consolidation segment One segment in subaccounts of the parent company should be designated for subsidiaries or consolidation units. Such a segment should be specified as a consolidation segment in the [Consolidation (GL103000)](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) window in the parent company. The values of this segment are associated with the subsidiaries or consolidation units. As a rule, the consolidation segment is not involved in mapping because the subsidiary does not contain such a segment in its subaccounts. In this case, the segment value can be added to the temporary subaccount during import of the data performed by the parent company (if the **Paste segment value** check box in this window is checked). Related reference [Consolidation](/visma-net-erp/help/general-ledger/general-ledger-windows/consolidation-gl103000/) [Subaccounts](/visma-net-erp/help/general-ledger/general-ledger-windows/subaccounts-gl203000/)

Related pages

Concepts

• General ledger consolidation overview