General Ledger Journal Reports
This topic includes details about the Oracle 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 |
|
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 |
|
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 |
|
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. |
Journal and Transaction Details Report |
Lists the general ledger journals and subledger transactions activity along with header, line, and distribution-level details. Includes the account combinations on each line for the selected accounts. Note: You can run or schedule this report only from Oracle
Analytics Publisher.
|
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? |
|
When do I use these reports? |
|
What type of reports are these? |
Oracle Analytics Publisher |