1General Ledger
This chapter contains the following:
Reporting
General Ledger and Subledger Accounting Reports
Oracle General Ledger and Oracle Subledger Accounting provides a variety of reports to support your reporting requirements for trial balances, detail journals and account analysis. These reports also support the needs of your organization for internal reporting, reconciliation, and communication with third parties like customers and suppliers.
The general ledger and subledger reports are categorized into:
-
Account Analysis Reports: These reports support fiscal verification processes in countries like Europe and South America. They inform shareholders on the financial situation of the company in countries like the United States.
The account analysis reports:
-
Provide a legal account ledger
-
Reconcile subledger balances with the general ledger balances
-
Maintain an audit trail
-
Allow a periodic internal verification
-
-
Journal Reports: These reports verify that your journals, accounting entries, and source documents are in compliance with legal requirements.
-
Third-Party Detail and Balances Reports: These reports provide balances per third-party control account, third party, and third-party site. These reports verify that the third-party subledgers are consistent with the general ledger.
Use the third-party detail and balances reports to:
-
Review the accounting process details by third party and third-party site.
-
Audit third-party accounts in detail.
During the accounting process, run the reports to ensure that subledger and general ledger balances reconcile, and to identify discrepancies.
-
-
General Ledger Journal and Balance Reports: These reports list general ledger journals and account balances for all periods in a selected period range. For each account, the reports provide beginning balance, general ledger posted journal lines, and ending balance.
-
General Ledger Trial Balance Report: This report checks your account balances and reviews your accounting activity. You can run the report using zero beginning balances at the start of the fiscal year.
The following table lists the reports provided for each category.
Report Category | List of Reports |
---|---|
Account Analysis Reports |
|
Journal Reports |
|
Third-Party Detail and Balances Reports |
|
General Ledger Journal and Balances Report |
|
Trial Balance Report |
|
General Ledger Journal and Balances Reports
This topic includes details about the General Ledger Journal and Balances reports.
Overview
General ledger journal and balance reports provide details on journal entries and account balances. The reports list posted accounting activity for account balances for all periods in a selected period range. For each account, the reports provide beginning balance, general ledger posted journal lines, and ending balance. Journal entry reports print all details of general ledger journals.
General Ledger Journal and Balance reports include the following reports:
-
General Ledger Journal Entry Report: Provides general ledger journal activity for a given period or date range, and optionally other criteria including journal source, entered currency, and journal batch. Flexible grouping and sorting options are provided at report submission. To improve the performance of the report:
-
If you have entries in multiple currencies, run the report for one currency at a time. Only the accounting lines of the selected currency display, instead of all accounting lines of a multicurrency journal.
-
Enter values for the company or balancing segment when running the report. With this method, you can't see all the accounting lines of your intercompany journal.
The following figure shows an example of the General Ledger Journal Entry Report. The report has columns for the line, account, account description, line description, posting status, and entered and accounted amounts.
-
-
General Ledger Journal and Balance Report: Retrieves all information for the reports that require journal entries and account balances. The account balances can be printed for selected levels of the hierarchy for actual, encumbrance, or budget balance types. To improve the performance of the report, filter by company or balancing segment value.
The following figure shows an example of the General Ledger Journal and Balance Report. The report has columns for the batch, journal, category, effective date, journal number and line, description, and amounts.
Key Insights
Before submitting the reports, you must transfer subledger journals to the general ledger.
Report Parameters
The following table lists the common parameters applicable to all the General Ledger Journal and Balance Reports.
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 ledgers 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. |
The following table lists selected parameters for the General Ledger Journal Entry.
Parameter | Description |
---|---|
Posting Status |
Select the applicable posting status. Valid values are Error Status, Posted Journals, and Unposted Journals. |
Journal Source |
Enter the source of journal entries such as, payables, receivables, or manual. |
The following table lists selected parameters for the General Ledger Journal and Balance Report.
Parameter | Description |
---|---|
Currency Type |
Specify the currency type, such as entered, statistical or total. The default value is Total. |
Balance Type |
Specify whether the balance type is actual or encumbrance. The default is Actual (A). |
Frequently Asked Questions
The following table lists frequently asked questions about the General Ledger Journal and Balance Reports.
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 these reports to declare withholding and payments on account of income from employment, economic activities, prizes, certain capital gains and income allocations. |
What type of reports are these? |
Oracle Business Intelligence Publisher |
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 Business Intelligence Publisher |