Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Consolidation is a process of inserting the General Ledger details of  Subsidiary Company/Companies into the General Ledger Account details of the Parent Company.

Pre-condition:

  1. Setup Multi-Company. Make sure that there is a Parent Company and at least one Subsidiary companyFor more information on multi-company setup, refer to: How to Setup Multi-Company Replication.
  2. Generate Trial Balance 

 

Here are the steps on how to consolidate:

  1. Setup Multi-Company. Make sure that there is a Parent Company and at least one Subsidiary company setup in parent company. For more information on multi-company setup, refer to: How to Setup Multi-Company Replication.
  2. On General Ledger > Fiscal Year, Close the consolidation date in period under General Ledger 's Fiscal year of of the consolidation date for both Parent  and Subsidiary company.  For more information on closing fiscal period. refer to: How To Close Fiscal Year Periods.
    Image Added
    Note: Fiscal Year Period and status are synchronize.
     
  3. Log in as Administrator using Parent Company.
  4. On In the user's menu panel, Open General Ledger then , Under Activities select Consolidate GL Entries.
  5. On the consolidation date, Select Enter Consolidation Date by selecting the period to consolidate.
    Image Added
    Note: Consolidation date should be a closed period.

  6. Click Consolidate Click consolidatebutton.

    Image Added
  7. Once the consolidation has completed details Grid will display the result of the consolidation.

    Image Added

  8.  If the consolidation was successful, GL accounts detail of all subsidiary company will company within consolidation date will be inserted in Parent Company within consolidation date.

 

Note

Consolidation can only be done if:

  • Current company is the parent company.
  • GL chart of accounts of both Parents and Subsidiary are the same.
  • Consolidation period date of both Parent and Subsidiary company are closed.
  • No unposted transaction in consolidation date.
  • Parent and Subsidiary company have balanced GL details.