1General Ledger

This chapter contains the following:

Reporting

General Ledger and Subledger Accounting Reports

Oracle General Ledger and Oracle Subledger Accounting provides a variety of reports to support your reporting requirements for trial balances, detail journals and account analysis. These reports also support the needs of your organization for internal reporting, reconciliation, and communication with third parties like customers and suppliers.

The general ledger and subledger reports are categorized into:

  • Account Analysis Reports: These reports support fiscal verification processes in countries like Europe and South America. They inform shareholders on the financial situation of the company in countries like the United States.

    The account analysis reports:

    • Provide a legal account ledger

    • Reconcile subledger balances with the general ledger balances

    • Maintain an audit trail

    • Allow a periodic internal verification

  • Journal Reports: These reports verify that your journals, accounting entries, and source documents are in compliance with legal requirements.

  • Third-Party Detail and Balances Reports: These reports provide balances per third-party control account, third party, and third-party site. These reports verify that the third-party subledgers are consistent with the general ledger.

    Use the third-party detail and balances reports to:

    • Review the accounting process details by third party and third-party site.

    • Audit third-party accounts in detail.

    During the accounting process, run the reports to ensure that subledger and general ledger balances reconcile, and to identify discrepancies.

  • General Ledger Journal and Balance Reports: These reports list general ledger journals and account balances for all periods in a selected period range. For each account, the reports provide beginning balance, general ledger posted journal lines, and ending balance.

  • General Ledger Trial Balance Report: This report checks your account balances and reviews your accounting activity. You can run the report using zero beginning balances at the start of the fiscal year.

The following table lists the reports provided for each category.

Report Category List of Reports

Account Analysis Reports

  • General Ledger and Subledger Account Analysis Report

  • General Ledger and Subledger Accounting by Journal Lines Report

  • Account Analysis by Legal Entity Report

Journal Reports

  • Daily Journals Report

  • Subledger Detail Journal Report

  • Journal Ledger Report

Third-Party Detail and Balances Reports

  • Third-Party Detail and Balance Report

  • Third-Party Balances Summary Report

  • Third-Party Account Balance Report

General Ledger Journal and Balances Report

  • General Ledger Journal Entry Report

  • General Ledger Journal and Balance Report

Trial Balance Report

  • General Ledger Trial Balance Report

General Ledger Journal and Balances Reports

This topic includes details about the General Ledger Journal and Balances reports.

Overview

General ledger journal and balance reports provide details on journal entries and account balances. The reports list posted accounting activity for account balances for all periods in a selected period range. For each account, the reports provide beginning balance, general ledger posted journal lines, and ending balance. Journal entry reports print all details of general ledger journals.

General Ledger Journal and Balance reports include the following reports:

  • General Ledger Journal Entry Report: Provides general ledger journal activity for a given period or date range, and optionally other criteria including journal source, entered currency, and journal batch. Flexible grouping and sorting options are provided at report submission. To improve the performance of the report:

    • If you have entries in multiple currencies, run the report for one currency at a time. Only the accounting lines of the selected currency display, instead of all accounting lines of a multicurrency journal.

    • Enter values for the company or balancing segment when running the report. With this method, you can't see all the accounting lines of your intercompany journal.

    The following figure shows an example of the General Ledger Journal Entry Report. The report has columns for the line, account, account description, line description, posting status, and entered and accounted amounts.

    This figure shows the General Ledger Journal Entry
Report.
  • General Ledger Journal and Balance Report: Retrieves all information for the reports that require journal entries and account balances. The account balances can be printed for selected levels of the hierarchy for actual, encumbrance, or budget balance types. To improve the performance of the report, filter by company or balancing segment value.

    The following figure shows an example of the General Ledger Journal and Balance Report. The report has columns for the batch, journal, category, effective date, journal number and line, description, and amounts.

    This figure shows the General Ledger Journal and
Balance Report.

Key Insights

Before submitting the reports, you must transfer subledger journals to the general ledger.

Report Parameters

The following table lists the common parameters applicable to all the General Ledger Journal and Balance Reports.

Parameter Description

Data Access Set

Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports.

Ledger

Specify the ledgers for the selected data access set. Ledger is required for all general ledger reports.

From Period and To Period

Indicate the period range for the report data.

Filter Conditions

Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger, and define conditions including account value ranges.

The following table lists selected parameters for the General Ledger Journal Entry.

Parameter Description

Posting Status

Select the applicable posting status. Valid values are Error Status, Posted Journals, and Unposted Journals.

Journal Source

Enter the source of journal entries such as, payables, receivables, or manual.

The following table lists selected parameters for the General Ledger Journal and Balance Report.

Parameter Description

Currency Type

Specify the currency type, such as entered, statistical or total. The default value is Total.

Balance Type

Specify whether the balance type is actual or encumbrance. The default is Actual (A).

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Journal and Balance Reports.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Accountant

When do I use this report?

Use these reports to declare withholding and payments on account of income from employment, economic activities, prizes, certain capital gains and income allocations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Trial Balance Report

This topic includes details about the General Ledger Trial Balance Report.

Overview

The General Ledger Trial Balance Report lists actual account balances and activity by ledger, balancing segment, and account segment. The report prints the account number, description, and debit or credit balance for the beginning and ending period. This also includes the debits and credits for the period. The report can print income statement, balance sheet, or all balances for a selected range of accounting combinations.

The following figure shows an example of the General Ledger Trial Balance Report. The report has columns for the account, account description, year beginning balances, net beginning balances, prior periods, period activity, ending balances, and net ending balances.

This figure shows the General Ledger Trial Balance
Report.

Key Insights

Before submitting the report, you must complete these tasks:

  • Ensure that balances are available for printing in the selected period and account range.

  • Define the account hierarchy.

You can use the report to print account balances and activity by legal entity. The report enables you to print reporting and accounting sequences.

Report Parameters

The following table lists selected report parameters.

Parameter Description

Data Access Set

Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports.

Ledger

Specify the ledger for the selected data access set. Ledger is required for all general ledger reports.

From Period and To Period

Indicate the period range for the report data.

Filter Conditions

Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger, and define conditions including account value ranges.

Currency Type

Specify the currency type, such as entered, statistical, or total. The default value is Total.

Account Level

Enter the number of hierarchy levels you want to use for reporting. The valid values are:

  • Blank for printing only detail rows.

  • 1 through 10 for printing relevant number of parent total rows. For example, consider you entered 3 and your account hierarchy for the natural account has 3 levels. You see balances at 2 parent levels and for the natural account segment. For the same structure, if you enter 2 then you see balances at only the 2 parent levels.

Top-Level Parent Account

Indicate the highest level, top-level parent account that you want to work with. This parameter works with the account level parameter.

Account Class

Select a specific account class or accept the default value of All.

Account Delimiter

Specify the character that must be used as a separator between accounting flexfield segments.

Zero Beginning of Year Balance

Select:

  • Yes for zero balances for debit and credit.

  • No for the year beginning balance.

Trial Balance Type

Specify the type of account balance to determine the level of detail and results as of the beginning or end of the year. You can select one of the following types: Begin Year, Detail, End Year, Results. The default value is Detail. Use the default value to print all accounts in your selected range. The Begin Year, End Year, and Results trial balance types are provided for compliance with specific country requirements.

Page Number Format

Select the applicable page number format. The valid values are Page: n and Page: n of m. The default value is Page: n of m.

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Trial Balance Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

When do I use this report?

Use the General Ledger Trial Balance Report to review:

  • Accounting combination or natural account values and description

  • Prior period activity and year-to-date activity

  • Period beginning and period ending balances

What type of reports are these?

Oracle Business Intelligence Publisher