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?	Financial Manager Financial Accountant
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 Analytics Publisher