Review the beginning, ending and net balances as well as period activity for a set of accounts. View your actual balances and activity in your ledger currency, foreign currency, or STAT. You can also use this report to review your translated balances and activity by specifying a balance-level reporting currency.
The report prints a line for each account segment value and sorts them in ascending order. For each account segment value, the report prints the account description, beginning balances, period activity, ending activity, and ending balances for the period you request.
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 balances, choose the Balance-level reporting currency that was used as the target ledger during 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 the 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 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 and the Currency Type Total, all balances that were entered using the currency of 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.
Period: Choose the accounting period for your report.
Account From/To: Enter the starting and ending account segment values in the range for your report.
Balancing Segment: Enter the balancing segment value for which you want to report. Or, leave this field blank if you want to report on all balancing segment values.
Precision: Choose one of the following levels of precision:
Class Level: Print a sub-total for each class, or for each value of the most significant digit of the account segment.
Class and Sub-class Level: Print sub-totals for each class and sub-class, or for each pair of values of the two most significant digits of the account segment.
Class, Sub-Class, and Group Level: Print sub-totals for each class, sub-class, and group, or for each set of values of the three most significant digits of the account segment.
For example, the account segment values 4310 and 4450 belong to the same class (4) but different sub-classes (43 and 44), while the account segment values 4520 and 4570 belong to the same sub-class (45) but different groups (452 and 457).
Refer to the selected heading descriptions below for additional information.
Account: account segment value for each line of your report.
Description: description of your account segment value.
Begin Total Activity: beginning debit and credit balance for each account segment value.
Period Activity: total debit and credit activity for each account segment value.
End Activity: ending debit and credit amounts for each account segment value.
End Balance: ending balance, or the net of ending debit and credit amounts, for each account segment value.
Total/Net Group: total and net debits and credits for each group if you requested Class, Sub-Class, and Group Level precision.
Total/Net Sub-Class:total and net debits and credits for each sub-class if you requested Class and Sub-Class Level or Class, Sub-Class, and Group Level precision.
Total/Net Class: total and net debits and credits for each Class.
Total Balancing Segment: total beginning balances, period activity, end activity, and end balance for the balancing segment.