General Ledger Journal Reports

Overview

The journal reports assist in reviewing journals activity. You can use these reports as part of your reconciliation process and in ensuring completion of posting of all entries before period close.

The following figure shows an example of the Journals Report. The report has columns for the line, account, transaction date, description, entered and accounted amounts, and units.

The following table describes each journal report.

Name	Description
Journals Report	Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values. Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal. Includes a total for each balancing segment and a grand total for all the activity.
General Journals Report	Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.
Journals Batch Summary Report	Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range. Provides information about actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. Sorts the information by journal batch within each journal entry category. Includes totals for each journal category and a grand total for each ledger and balancing segment value combination. Doesn't report on budget or encumbrance balances.
Journals Details Report	Provides information about manually entered journals prior to posting, including field by field, all data entered into the application or data imported from external sources.
Journals Day Book Report	Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category. Note: To run the report for all journal sources and categories, clear the Source and Category fields. Sorts journal entries for each accounting date by document number. Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate. Note: When you set the General Ledger Journal Entry Summarization option, as part of the Manage Subledger Accounting Options task, to either Summarize by general ledger date or Summarize by general ledger period, the SUBLEDGER_DOC_SEQUENCE_ID and SUBLEDGER_DOC_SEQUENCE_VALUE columns will be empty in the GL_JE_LINES table, even though document sequencing is enabled. All subledger entry lines are summarized into a single general ledger entry if the following details are the same: accounting period or date, General Ledger journal category, account, entered currency, side, balance type. As a result, the report won't display details in the Subledger Document Sequence and Subledger Document Number columns. Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center value.
Reconciled Transactions Report	Provides details of clearing account journal lines that have been successfully reconciled by both automatic and manual reconciliation,
Unreconciled Transactions Report	Lists all unreconciled clearing account journal lines, specifically the unreconciled lines that aren't subjected to reconciliation yet, those lines rejected by previous automatic or manual reconciliation processes, and those lines that were marked as reviewed.

Key Insights

Before running the journal reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the journal reports and provides examples.

Parameter	Description	Example
Data Access Set	Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.	US Ledger Set
From and To Accounting Date	Determines the date on which the journal is recorded. Must be in an open or future enterable accounting period.	10-01-2014
Includes Adjustment Period	Includes journals posted in adjustment periods, if selected.	No

Frequently Asked Questions

The following table lists frequently asked questions about the journal reports.

FAQ	Answer
How do I find these reports?	Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.
Who uses these reports?	Financial Accountants Financial Specialists
When do I use these reports?	During monthly journal entry processing. During period close to verify all transactions have been imported and journals posted. In account balance reconciliations.
What type of reports are these?	Oracle Analytics Publisher