1. Using General Ledger
  2. General Ledger Account Analysis Reports

General Ledger Account Analysis Reports

This topic includes details about the Oracle General Ledger account analysis reports.

Overview

The account analysis reports assist in reviewing journals and related transactions. You can use these reports as part of your reconciliation process and in preparation of your closing entries.

The image shows an Account Analysis for Contra Account Report.

The account analysis reports include:

Account Analysis Reports

Description

Account Analysis

  • Prints balances by account segment and a secondary segment for each journal entry.

  • Lists the subledger document number for transactions imported from subledgers.

General Ledger Account Details Report

  • Provides journal information to trace each transaction back to its original source.

  • Prints a separate page for each balancing segment value.

  • For each journal line, prints:

    • The account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.

    • Journal details including source, category, journal name, and effective date.

  • Lists accounts in ascending order by account segment value.

  • Prints a CR next to credit amounts.

Account Analysis for Contra Account Report

  • Prints balances by account segment and a secondary segment.

  • Lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.

  • Prints by date range, accounting flexfield range, contra account, and amount range.

Average Balance Audit Account Analysis Report

  • Displays the detail account activity which created the aggregate balances and related average balances.

  • Displays daily average balance information for the selected accounts for the specified range of dates.

  • Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

Note: Use to research how average balances are calculated for an account.

Key Insights

Before running the account analysis 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 for the account analysis reports.

Parameter

Description

Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

Encumbrance Type

When Balance Type of Encumbrance is selected, gives the option to select Commitments or Obligations.

Commitments

Account Type

Indicates whether the amounts represent Base, Period, Quarter, or Year to Date. For Average Balancing, indicates Period Average, Quarter Average, or Year Average to Date.

PATD Period Average to date balance used in average balance processing.

Includes User Transaction Identifiers

List of identifiers linking the account generation and the transaction, for example PO Number. This helps in identifying the parent transaction.

No

Account, Account Range, or Contra Account Filters and Conditions Defined

Restricts the data reported based on the entered filter and condition.

Company equals 101

Additional Segment

To run the report by account and another segment.

Cost Center

Document Sequence

Uniquely identifies each business document or business event with a number if enabled.

Invoice

From and To Document Number

Assigned unique document sequence number.

101

Frequently Asked Questions

The following table lists frequently asked questions about the account analysis reports.

FAQ

Answer

How do 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 preparation of closing entries.

  • In account balance reconciliations.

What type of reports are these?

Oracle Analytics Publisher

GL Account Details Report Data Model and CSV Output

The data model for the General Ledger Account Details report contains some columns that appear only in the CSV output. They provide more information about the periodic journal activity for each general ledger account.

You can use the information 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 GL balances.

Column Description
EFFECTIVE_PERIOD_NUM Period number that's been converted to a more optimal format using this calculation: (PERIOD_YEAR * 10000 + PERIOD_NUM).
ACCOUNT_VALUE Account segment value.
COST_CENTER_VALUE Cost center segment value.
INTERCOMPANY_SEGMENT_VALUE Intercompany 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.
ACCT_DESC Journal account description.
COST_CENTER_DESC Cost center segment description.
ACCT_LEVEL10_VALUE Not currently used. For future use only.
ACCT_LEVEL10_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL9_VALUE Not currently used. For future use only.
ACCT_LEVEL9_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL8_VALUE Not currently used. For future use only.
ACCT_LEVEL8_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL7_VALUE Not currently used. For future use only.
ACCT_LEVEL7_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL6_VALUE Not currently used. For future use only.
ACCT_LEVEL6_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL5_VALUE Not currently used. For future use only.
ACCT_LEVEL5_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL4_VALUE Not currently used. For future use only.
ACCT_LEVEL4_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL3_VALUE Not currently used. For future use only.
ACCT_LEVEL3_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL2_VALUE Not currently used. For future use only.
ACCT_LEVEL2_VALUE_DESC Not currently used. For future use only.
ACCT_LEVEL1_VALUE Not currently used. For future use only.
ACCT_LEVEL1_VALUE_DESC Not currently used. For future use only.

These columns are related to journals.

Column Description
JRNL_HEADER_ID Journal entry header identifier.
JRNL_CURRENCY_CODE Journal entry currency.
SUB_DOC_SEQ_ID Subledger document sequence Identifier.
ACCT_VALUE_IN Journal Account value.
JGZZ_RECON_STATUS Reconciliation status.
BATCH_PERIOD Accounting period.
CODE_COMBIINATION_ID Account combination identifier.
JRNL_EFFECTIVE_DATE Journal entry default effective date.
CP_START_DATE Not currently used. For future use only.
CP_END_DATE Not currently used. For future use only.
CHART_OF_ACCOUNTS_ID Not currently used. For future use only.
ACCT_LEVEL_PARAM Not currently used. For future use only.
PAGE_NUM_START_PARAM Not currently used. For future use only.