For all financial entities in the current site's hierarchy, this utility consolidates any unconsolidated ledger records (by mapping accounts and unit codes and converting currencies) up to and including the cutoff date. Each ledger record will be consolidated all the way up the hierarchy. The ledger at this site will be marked as consolidated. For higher level entities, the newly created ledgers are stored, using that entity's chart of accounts and base currency.
You can consolidate the ledger at the end of the year. When you select the Year End check box, the system posts CTA adjustment transactions to the ledger for the revenue and expense accounts.
The following checks are made:
The system uses the currency rate tables that are defined by each financial entity where the consolidation entries are being written. The translation is performed directly on data from the originating site's transaction.
Period totals are created, using the definitions at each entity additionally segregated by hierarchy.
As this utility runs, it creates a report of any exceptions, undoing only the affected ledger record and continuing with the remaining processing.
Before actually posting the transactions, you can run in Verify mode by not selecting the Consolidate check box.
NOTE: Before running this utility, you must specify a valid account in the CTA Account field on the General Parameters form at the corporate entity level; otherwise, an error message displays.
If you are reconsolidating, use the Set Ledger Consolidated Flag utility to reset the Ledger Consolidated flag. Then delete the data in the ledger and pertot database tables for the corporate and lower entities, but not for sites. If you do not take these steps before rerunning Ledger Consolidation, the entity ledger will be out of balance.
To comply with FASB52 or GAAP standards, on the Chart of Accounts form, you must make sure the the currency translation methods are set to Average for revenue and expense accounts and End for asset and liability accounts.
NOTE: This adjustment is necessary only when the ledger is consolidated in a multi-site setup where a subordinate entity's domestic currency is different from its parent entity's domestic currency, different account types are posted with different translation methods, and the exchange rates varies.
See FASB52 Overview.