1. Using General Ledger
  2. General Ledger Journal Reports

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.

This figure shows the Journals Report.

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

Journals Report Data Model and CSV Output

The data model for the Journals report contains some columns that appear only in the CSV output. They provide more information about your batches, journals, and journal lines. You can use them for improved reporting and for audit purposes.

These columns don’t appear in the other report output formats (PDF, Excel, HTML).

Note: Some columns are planned for future use.

These columns are related to batches.

Column Description
BATCH_ID Journal entry batch identifier.
BATCH_POSTED_STATUS Journal entry batch status.
BATCH_DESC Journal entry batch description.
BALANCE_TYPE Balance type (Actual or Encumbrance)

These columns are related to journals.

Column Description
HEADER_ID Journal entry header identifier.
PERIOD_NAME Accounting period type.
JRNL_ACCT_SEQ_NAME Journal accounting sequence name.
JRNL_ACCT_SEQ_VERSION Journal accounting sequence version.
JRNL_ACCT_SEQ_NUM Journal accounting sequence number.
JRNL_DOC_SEQ_NAME Journal document sequence name.
JRNL_DOC_SEQ_NUM Journal document sequence number.
JRNL_REP_SEQ_NUM Journal reporting sequence number.
JRNL_REP_SEQ_VERSION Journal reporting sequence version.
JRNL_REP_SEQ_NAME Journal reporting sequence name.
JRNL_EFFECTIVE_DATE Journal entry default effective date.
JRNL_DESC User entered description of the journal header.

These columns are related to journal lines.

Column Description
REFERENCE1 Sequential numbering sequence.
ACCT_DESC Account description.
BALANCING_SEGMENT_DESC Balancing segment description.
NATURAL_ACCOUNT_DESC Natural account segment description.
COST_CENTER_DESC Cost center segment description.
MANAGEMENT_SEGMENT_DESC Management segment description.
INTERCOMPANY_SEGMENT_DESC Intercompany segment description.
GL_SECONDARY_DESC Secondary balancing segment description.
ACCT_VALUE Account segment value.
BALANCING_SEGMENT_VALUE Balancing segment value.
COST_CENTER_VALUE Cost center segment value.
MANAGEMENT_SEGMENT_VALUE Management segment value.
INTERCOMPANY_SEG_VAL Intercompany segment value.
SECONDARY_TRACK_SEG_VAL Secondary balancing segment value.
LEGAL_ENTITY_ID Legal entity identifier.
LEGAL_ENTITY_NAME Legal entity name.
LE_ADDRESS_LINE_1 Legal entity address line 1.
LE_ADDRESS_LINE_2 Legal entity address line 2.
LE_ADDRESS_LINE_3 Legal entity address line 3.
LE_CITY Legal entity city name.
LE_POSTAL_CODE Legal entity postal code.
LE_REGISTRATION_NUMBER Legal entity registration number.
LE_ACTIVITY_CODE Legal entity activity code.

Here are the general columns.

Column Description
CHART_OF_ACCOUNTS_ID Key flexfield structure instance.
PERIOD_TO_PARAM Not currently used. For future use only.
PAGE_NUM_START_PARAM Not currently used. For future use only.
DOC_SEQ_NAME_PARAM Not currently used. For future use only.
START_DOC_SEQ_NUM_PARAM Not currently used. For future use only.
END_DOC_SEQ_NUM_PARAM Not currently used. For future use only.
ACCT_SEQ_NAME_PARAM Not currently used. For future use only.
START_ACCT_SEQ_NUM_PARAM Not currently used. For future use only.
END_ACCT_SEQ_NUM_PARAM Not currently used. For future use only.
REP_SEQ_NAME_PARAM Not currently used. For future use only.
START_REP_SEQ_NUM_PARAM Not currently used. For future use only.
END_REP_SEQ_NUM_PARAM Not currently used. For future use only.
USER_JRNL_SRC_PARAM Not currently used. For future use only.
JRNL_CATEGORY_PARAM Not currently used. For future use only.
FILTER_CONDITIONS_ATT Not currently used. For future use only.
FILTER_CONDITIONS_OPT Not currently used. For future use only.
LEDGER_ID Ledger unique identifier.
CONFIGURATION_ID Not currently used. For future use only.
ENVIRONMENT_CODE Not currently used. For future use only.