Overview of Balance Transfers

Two methods of balance transfers are supported in Oracle General Ledger.

Balance data is transferred from:

  1. A primary ledger to a balance level secondary ledger assigned to it.

  2. From one ledger to another without a predefined relationship.

You can drill down from the target ledger balances to the source ledger balances. The drill down can originate from:

  • Financial reports.

  • Smart View spreadsheet.

  • Account Inspector queries.

  • Account Monitor analyses.

  • Journal lines in the target ledger.

When the Source and Target Ledger Currency Are the Same

You drill down on the entered amount from the Journal Lines page or the Journal page in target ledger which resulted from a balance transfer. The displayed page provides the source and target ledger details so you can analyze details. For example, analyze the accounting period and accounts used in the source ledger that transferred to the journal line amount in the target ledger.

Note: When there is a variance between the source and target ledger, there is a warning icon displayed next to the target amount and source amounts. The variance in this case could be due to journals that were posted to the source ledger after the balance transfer between source and target ledger.

When the Source and Target Ledgers Do Not Share the Same Ledger Currency

It is necessary to translate the source ledger to the target ledger's ledger currency before transferring balances. As such, balance transfers drill down also shows the reporting currency balances for the source ledger in the target ledger currency as part of the drill path.

Note: When there is a variance between the source (translated balance) and target ledger, there is a warning icon next to the target amount and source translated amounts.

The variance in this case can be due to:

  • Conversion rate changes after the balance transfer.

  • Journals that were posted to the source ledger after the balance transfer between source and target ledger.