Understanding the Compute Restated Balances Program
The Compute Restated Balances program (R11414A) restates balances from a source ledger into a consolidation ledger (AC). Based on the exchange rates and computations that you set up, the Compute Restated Balances program:
Restates a selected period, or all periods up to and including the current period (year to date), as specified in a processing option.
Applies an individual rate to each period that you are restating, or applies a single rate to all periods.
Applies a different exchange rate for a specific range of accounts. If an exchange rate does not exist in the Currency Restatement Rates File table (F1113), the system prints a report with blanks in the exchange rate and restated balance columns. If you choose not to print restated balances for zero amounts, all of the accounts in that range are omitted from the report.
Restates up to three source ledger types to a single destination ledger type. Currency decimals are based on the currency code of the destination ledger type.
The Compute Restated Balances program uses information from the F0902, F1113, and Company Conversions Parameter File (F1114). For adjustments made directly to the restated ledger, such as journal entries for rounding differences between currencies, the Compute Restated Balances program uses information from the F0911 table.
You can run the Compute Restated Balances program as often as necessary. Each time that you run the program, it overwrites existing balances unless you specify a different destination ledger type in a processing option. You can run this program in three different modes:
Proof mode with report
The system prints a report but does not create balances in the destination ledger.
Final mode with report
The system creates balances in the destination ledger and prints a detailed audit trail.
Final mode without report
The system creates balances in the destination ledger but does not print a detailed audit trail.
When reviewing the report, ensure that:
Every AA ledger amount has an AC ledger amount.
No manual journal entries exist for the AC ledger in the translation adjustment or retained earnings account.
For period processing, the report displays account transactions with a blank in the To Currency Period Posting and To Current Period Balance columns and a + sign to indicate that the account balance by currency amounts appear in the last transaction line for the account.
For year-to-date processing, the report displays each account transaction by originating currency in the To Current Period Posting and To Current Period Balance columns. It does not display a + sign.