| How do I consolidate multiple companies for reporting purposes? |
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 - Start Sage 50.
- Create a backup of each company you plan to consolidate.
- Select File, New Company, and then click Next.
- Enter the information for your consolidated company and click Next.
- Select Consolidate existing Sage 50 Accounting companies and then click Next.
- Select the posting method for your company and click Next.
- 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 - Create a backup of each consolidated company you plan to update.
- Select File, Reconsolidate Company.
- Select a company and click Add.
- Continue this process until you've added all companies to the Selected subsidiary companies list.
- Click the Reconsolidate button.
|
|