Run consolidation
We recommend that you do not enter previous year journal entries when using consolidation. Prior year journal values are consolidated into the current consolidated period and this will distort current year values.
This posts the balances of the nominal accounts in the subsidiary company to the linked nominal accounts in the parent company. Consolidation is always performed in the subsidiary company. You must consolidate each subsidiary company individually.
Each relevant nominal account in the subsidiary company has a consolidated balance. This is accumulated every time the subsidiary company is consolidated.
When you consolidate, the difference between the actual account balance and the consolidated balance, for the selected period, is posted to the corresponding nominal account in the parent company.
Consolidating for the first time
Nominal account balance |
£100.00 |
Consolidated balance |
£0.00 |
Amount posted to the parent company |
£100 - £0 = £100 |
Subsequent consolidation
Nominal account balance |
£300.00 |
Consolidated balance |
£100 |
Amount posted to the parent company |
£300 - £100 = £200 |
If your subsidiaries operate in different currencies, the exchange rates set in the parent company, are used to convert the consolidation values to the parent company's currency. Any exchange rate differences are posted to the Exchange Differences account in the parent company Nominal Ledger. You will need to make adjustments to your balance sheet in the parent company. To do this, you must follow the process for consolidating foreign currency nominal ledgers.
You can perform consolidation at any time before the period is closed in the parent company.
- The consolidation values are calculated for each nominal account, prepared in a journal and posted to the parent company.
- The consolidated balance for each nominal account is updated.
- A consolidation report is produced.
- If a linked account doesn't exist in the parent, that balance is posted to the suspense account.
Before you begin
- Link the nominal accounts in the subsidiary company to the nominal accounts in the parent company.
- If the subsidiary company uses a different exchange rate to the parent company, make sure the exchange rate table is accurate in the parent company.
Run consolidation in the subsidiary company
Open: Nominal Ledger > Period End Routines > Consolidation.
- Choose the Consolidation period you want to consolidate. Select the relevant open period from the drop-down list.
-
Enter the Consolidation date. This defaults to the last day of the selected Consolidation Period.
This is the Transaction date for the journal A record that holds one or more transactions for posting. Synonymous with batch in batch processing. posted to the parent company.
- Enter a Reference and Narrative for the consolidation journal.
-
Click OK. This posts the consolidation journal to the parent company.
A report is printed showing the journals that have been posted.
Note - warningIf the linked nominal account in the parent company does not exist, the journal for that account is posted to the Suspense account The nominal account automatically updated when an invalid account is specified for a transaction. It is also used when you are unsure what to do with a value. The suspense account can be used as a holding account until you decide what to do with the value. The balance on the suspense account should ultimately be zero..
Steps in this task
Chart of accounts (consolidation)
Other tasks
Consolidating foreign currency nominal ledgers
Overview
Reference