General Ledger Chart of Accounts 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 following figure shows an example of the Chart of Accounts Mapping Rules Report. The parameters for the report include the chart of accounts mapping name and the tree version effective date. The report provides the account rules and segment rules for the specified mapping.

This figure shows the Chart of Accounts Mapping Rules Report.

The following table describes the chart of accounts reports.

Name	Description
Balancing Segment Value Assignments Report	Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting set ups. Lets you quickly identify overlapping balancing segment value errors and review for any unassigned values. Note: The application does not check for overlapping balancing segment values online.
Chart of Accounts Mapping Rules Report	Provides both the segment and account rules defined for a specific chart of accounts mapping. If the mapping has account rules, the report prints each subsidiary account range and the parent account into which it maps. If the mapping has segment rules, the report prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, the report prints each subsidiary segment value range and its corresponding parent segment value.

Name

Description

Balancing Segment Value Assignments Report

Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting set ups.
Lets you quickly identify overlapping balancing segment value errors and review for any unassigned values.

Note:

The application does not check for overlapping balancing segment values online.

Chart of Accounts Mapping Rules Report

Provides both the segment and account rules defined for a specific chart of accounts mapping.
If the mapping has account rules, the report prints each subsidiary account range and the parent account into which it maps.
If the mapping has segment rules, the report prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, the report prints each subsidiary segment value range and its corresponding parent segment value.

Key Insights

Before running the chart of accounts 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 reports and provides examples.

Parameter	Description	Example
Value Set	Enter the value set that contains the balancing segments you are reporting on.	Corporate Company
From and To Balancing Segments	Enter the description of the balancing segment value to report from and to.	Canada
Assignment Status	Select one of the following options: All, Ledger only, Legal Entity, only, or Unassigned to	Ledger only
Actuating Configuration	Select the ledger you want to report on.	US Primary Ledger
Show Only Balancing Segment Values with Multiple Assignments	Show only those balancing segment values that have more than one legal entity assigned to it.	No
Chart of Accounts Mapping	Select the mapping you have defined.	CN code to US Mapping
Tree Version Effective Date	Select the date that determines which tree version to use as one of the report's criteria.	8/28/2016

Frequently Asked Questions

The following table lists frequently asked questions about the chart of accounts 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