Skip to content
logo Knowledgebase

Merge your companies together with the Consolidation option

Created on  | Last modified on 

Summary

How to use the consolidation option to merge your companies in Sage 50 Accounts.

Description

The consolidation option merges financial data from multiple companies into a single set of financial accounts. You can then print management reports for the consolidated company.

Resolution

This feature is available in Sage 50 Accounts Professional and Sage 50 Accounts Client Manager.

Are you using Remote Data Access? 

While your data syncs with Remote Data Access, you can't use the consolidation option. As a workaround, you can remove all companies from Remote Data Access, consolidate your data, then upload your data again. 

What Consolidation does

When you run the Consolidation option, the following processes occur:

  • Any nominal codes that don't exist in the parent company are created
  • Sage Accounts looks at the monthly buckets for every nominal code in each of the companies
    The bucket values for each nominal code populate in the parent company. This includes Actuals, Budgets, and Prior Year bucket values
  • A journal posts to the parent company for the total on each nominal code

Consolidation has some limitations 

 NOTE: To consolidate, you must have an unused company available in which to consolidate. For example, if you want to consolidate three companies, you need at least a four-company licence. 

Prepare the companies to be consolidated

Consolidation usually happens at month end or the year end. Ensure that you've posted all required transactions and that you've completed any month-end processes.

▼ Create a company.

The parent company consolidates the accounts of other companies. Before consolidating, you must follow the steps below, which will consolidate both nominal structures into the new parent company. Bringing through any chart of accounts across.

Create a new company.

  1. Click File, then click New, then click Company.
  2. Click Create, then click Continue. 
  3. Enter a Company Name, then click Next and Next again.
  4. Select the Financial Year start date so that it matches the start date of the companies to be consolidated. 
  5. Click Next.
  6. Enter a Standard VAT rate, then click Next.
  7. Select the Base currency so that it matches the companies to be consolidated, then click Next.
  8. Complete the Password screen, and click Next.
  9. Click Create.
▼ Prepare the parent company.

The parent company consolidates the accounts of other companies. Before consolidating, you must:

1. Rebuild the data

  1. Back up your data.
  2. Click File then click Maintenance and confirm Yes to close any open windows.
  3. Click Rebuild.
  4. Select the Keep my Nominal Account records and Keep my chart of accounts checkboxes.
  5. Click OK the click Yes.
  6. Click OK then Close.

2. Ensure the parent company has the same financial year and base currency

Ensure the financial year start date and base currency of the consolidated companies is the same.

 

Consolidate the companies

  1. Open the parent company.
  2. Click Tools , then click Period End and click Consolidation.

  3. Select the companies for consolidation, then click Consolidate and confirm by clicking Yes.

 NOTE: After consolidating, you can have warnings in the data regarding the aged balances. This is normal, and you can ignore them as there are balances on the nominal codes but no invoice transactions.

Once the consolidation is complete, you can post any required adjustments, then print the required management reports.

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Leave your details

Image