Review your General Ledger standard and average account balances. You can print your ledger currency, foreign-entered, or translated average balances.
This report provides a listing of standard and average balances for selected accounts based on an as-of date you specify. In addition, the report displays period, quarter, and year average-to-date balances. You can also request additional information on this report by specifying balancing segments and account ranges.
When you request this report, General Ledger prompts you to enter the following:
Ledger/Ledger Set: Choose a single ledger, reporting currency, or a ledger set to run this report for multiple ledgers at once.
To view translated average balances, choose the Balance-level reporting currency that was used as the target ledger during average balance translation.
Ledger Currency: If you chose a ledger set in the Ledger Set field, choose the currency of one of the ledgers or reporting currencies in the ledger set. The Ledger Currency filters the data in the report to only report on those ledgers or reporting currencies for which the currency matches the ledger currency specified.
If you chose a ledger or reporting currency, its currency will default and cannot be changed.
Currency Type: Choose Total, Entered, or STAT as follows:
Choose Total to view ledger currency total balances or to view translated balances that were translated to a balance-level reporting currency.
By specifying a ledger and the Currency Type Total, all average balances that were entered using the ledger currency, as well as any foreign entered balances that were converted to the ledger currency will be retrieved.
By specifying a balance-level reporting currency and the Currency Type Total, you can view Translated average balances.
By specifying a reporting currency (journal or subledger level) and the Currency Type Total, all average balances that were entered using the reporting currency, as well as any foreign entered balances that were converted to the reporting currency will be retrieved.
Choose Entered and specify a currency in the Entered Currency field to report on average balances that were entered in a specific currency.
Choose Statistical to report on Statistical average balances.
Entered Currency: If you chose the Entered Currency Type, choose a currency.
Reporting Date: Enter the calendar date for which you want to see average balances. For example, if you want to review average balances as of January 31, 1996, you enter 31-JAN-1996 as the Reporting Date.
Account From/To: Enter the range of accounts you want to include in your report.
The title of the report changes depending on the Currency Type specified as follows:
If the currency type is Total or Statistical, the report title is Average Balance Trial Balance.
If the currency type is Entered, the report title is Entered Currency Average Balance Trial Balance.
Refer to the selected heading descriptions below for additional information.
Ending Balance: the standard ending balance for an account.
Period Average-to-Date: the average of the end-of-day balances for a related range of days within a period.
Quarter Average-to-Date: the average of the end-of-day balances for a related range of days within a quarter.
Year Average-to-Date: the average of the end-of-day balances for a related range of days within a year.
Note: If you are reporting on translated average balances, an asterisk will appear next to any translated balance that is out of date. This can occur if a rate has been changed or new transactions are posted after your balances are translated. You should retranslate your balances, then run the report again.