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.

This figure shows the General Ledger Trial Balance Report.

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: Blank for printing only detail rows. 1 through 10 for printing relevant number of parent total rows. For example, consider you entered 3 and your account hierarchy for the natural account has 3 levels. You see balances at 2 parent levels and for the natural account segment. For the same structure, if you enter 2 then you see balances at only the 2 parent levels.
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: Yes for zero balances for debit and credit. No for the year beginning balance.
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?	Financial Accountant Financial Manager
When do I use this report?	Use the General Ledger Trial Balance Report to review: Accounting combination or natural account values and description Prior period activity and year-to-date activity Period beginning and period ending balances
What type of reports are these?	Oracle Analytics Publisher