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 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