Group consolidation

From Marathon Documentation
Jump to: navigation, search

Group consolidation is used for linking togheter balances from different companies in the same installation.

Preparations

Create a company to be used in the consolidation in System: Base registers/General/Companies. The company must have module G/L and the checkbox Company for consolidated balances must be checked in the tab G/L. In System: Base registers/GL/Parameters, tab Other, state which company’s report generator the company shall be linked with. The parameter is called Company for global report generator.

Consolidation workflow

  1. Select New in Accounting/Group consolidation.
  2. Give the consolidation a name and select your company for consolidated balances in the designated field.
  3. Name the companies to be consolidated in the column Cost centre. The name here is the one that the balance will be marked with in reports after the consolidation.
  4. Enter companies to be consolidated in the column From. You can enter one or several cost centres from a company and make calculations. See example 2 below.
  5. If the consolidation is in another currency, state it in the Currency column. Otherwise, the currency of the group consolidation company will be used. The currency is converted per each period, i.e., if the consolidation is made for period 0121 -1221, the months are calculated with the rate of the last date of each month.
  6. You can use Currency sets for a fixed rate throughout the year. Currency sets are created in System: Base registers/General/Currency sets. Contact Marathon support for more information about currency sets.
  7. Save and press the button Consolidate to start the consolidation.
  8. Print out reports in Accounting/Reports/Bookkeeping.


Examples

1. Example of a consolidation between companies CHSE and CHAC.


2. Example of consolidation with only certain cost centres per company included.


Explanation:

Row1 Here everything is fetched from company CHSE except cost centres KST 01, KST 02 and KST3
Row KST 01 in company CHSE
Row 3 KST 01 in company CHAC plus KST 03 in company CHSE