Review summarized actual account balances and activity by ledger, balancing segment, and account segment value. You can run this report for balances and activity entered in your ledger currency, foreign currency, or STAT. You can also view translated balances by specifying a balance-level reporting currency.
The report prints a line for each account segment value and lists them in ascending order. For each account segment value, the report prints the value, description, beginning balance, net of all debit or credit transactions, and ending balance for the period you request.
When run in YTD mode, the Beginning Balance column lists the beginning balances as of the first period of the fiscal year irrespective of the period for which the report is run. When run in PTD mode, the Beginning Balance column lists the beginning balances as of the beginning of the period for which the report is run.
The title of this report is Trial Balance - <Currency Type> where Currency Type is the Currency Type selected at run time.
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 a 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 primary 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. The title of the report changes depending on the Currency Type specified.
Choose Total to view the total balances for a ledger or reporting currency (journal or subledger level) 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 (journal or subledger level) 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.
Pagebreak Segment: Choose any account segment other than your account segment. General Ledger prints a separate page for each value of the segment you choose.
Pagebreak Segment Low/High: Enter the range of Pagebreak Segment values for your report.
Period: Choose any open accounting period in your calendar.
Amount Type: Choose PTD (period - to - date), YTD (year - to - date), or PJTD (project - to - date).
Refer to the selected heading descriptions below for additional information.
Account: account segment value for each account.
Description: description of your account segment value.