How do I consolidate multiple companies for reporting purposes?
Description
Cause
Resolution

Requirements:

All the companies you consolidate must meet the following requirements:

  • Have the same open fiscal years
  • Have the same fiscal year structure
  • Use the same accounting method (that is, cash or accrual)
  • Use the same Account Type for any shared General Ledger Account IDs (example: 10000 can't be a cash account in one company and an expense account in another)
  • Have the same account number for the Equity — Retained Earnings accounts (they’ll use a combined account)
  • Created in or converted to the same release of Sage 50 (for example, Sage 50 2023)
  • Created in or converted to the same flavor of Sage 50 (for example, Sage 50 Quantum)
  • If one subsidiary has users set up, the others must have them as well

Section 1: Consolidate companies

  1. Start Sage 50.
  2. Create a backup of each company you plan to consolidate.
  3. Select File, New Company, and then click Next.
  4. Enter the information for your consolidated company and click Next.
  5. Select Consolidate existing Sage 50 Accounting companies and then click Next.
  6. Select the posting method for your company and click Next.
  7. Click Finish.
  • The new consolidated company will contain transaction and budgeting information brought over from the subsidiary companies
  • Consolidated company budgets show the totals of the budgets of corresponding subsidiary company accounts
  • The charts of accounts of subsidiary companies will import into the consolidated company
  • The consolidated company requires the same login credentials used in any subsidiary company (if any)
  • General Journal descriptions will include the name of the subsidiary company they came from
  • Sage 50 will use the reference "Consolidated Trans." to mark all transactions created in the consolidated company

Section 2: Updating a consolidated company

  1. Create a backup of each consolidated company you plan to update.
  2. Select File, Reconsolidate Company.
  3. Select a company and click Add.
  4. Continue this process until you've added all companies to the Selected subsidiary companies list.
  5. Click the Reconsolidate button.
Steps to duplicate
Related Solutions