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 consolidating period in 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 admin Administrator using parent company 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.
  6. Click consolidate button.
  7. Image Added
    Note: Consolidation date should be a closed period.

  8. Click Consolidate button.

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

    Image Added

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

 

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 date Consolidation period of both Parent and Subsidiary company are closed.
  • No unposted transaction in consolidation perioddate.
  • Parent and Subsidiary company have balanced GL details.