General Ledger Trial Balance Report
This topic includes details about the General Ledger Trial Balance Report.
Overview
The General Ledger Trial Balance Report lists actual account balances and activity by ledger, balancing segment, and account segment. The report prints the account number, description, and debit or credit balance for the beginning and ending period. This also includes the debits and credits for the period. The report can print income statement, balance sheet, or all balances for a selected range of accounting combinations.
The following figure shows an example of the General Ledger Trial Balance Report. The report has columns for the account, account description, year beginning balances, net beginning balances, prior periods, period activity, ending balances, and net ending balances.
Key Insights
Before submitting the report, you must complete these tasks:
-
Ensure that balances are available for printing in the selected period and account range.
-
Define the account hierarchy.
You can use the report to print account balances and activity by legal entity. The report enables you to print reporting and accounting sequences.
Report Parameters
The following table lists selected report parameters.
Parameter |
Description |
---|---|
Data Access Set |
Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports. |
Ledger |
Specify the ledger for the selected data access set. Ledger is required for all general ledger reports. |
From Period and To Period |
Indicate the period range for the report data. |
Filter Conditions |
Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger, and define conditions including account value ranges. |
Currency Type |
Specify the currency type, such as entered, statistical, or total. The default value is Total. |
Account Level |
Enter the number of hierarchy levels you want to use for reporting. The valid values are:
|
Top-Level Parent Account |
Indicate the highest level, top-level parent account that you want to work with. This parameter works with the account level parameter. |
Account Class |
Select a specific account class or accept the default value of All. |
Account Delimiter |
Specify the character that must be used as a separator between accounting flexfield segments. |
Zero Beginning of Year Balance |
Select:
|
Trial Balance Type |
Specify the type of account balance to determine the level of detail and results as of the beginning or end of the year. You can select one of the following types: Begin Year, Detail, End Year, Results. The default value is Detail. Use the default value to print all accounts in your selected range. The Begin Year, End Year, and Results trial balance types are provided for compliance with specific country requirements. |
Page Number Format |
Select the applicable page number format. The valid values are Page: n and Page: n of m. The default value is Page: n of m. |
Frequently Asked Questions
The following table lists frequently asked questions about the General Ledger Trial Balance Report.
FAQ |
Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Use the General Ledger Trial Balance Report to review:
|
What type of reports are these? |
Oracle Analytics Publisher |