General Ledger Trial Balance Reports

Overview

The trial balance reports assist in reviewing general ledger balances. You can use these reports as part of your reconciliation process and in ensuring completion of the period close.

This figure shows an example of the Trial Balance Report. The report has columns for the account, description, beginning balance, debits, credits, and ending balance.

Here are descriptions of the trial balance reports.

Name	Description
Trial Balance Report	Provides summarized actual account balances and activity by ledger, balancing segment, and account segment value.
General Ledger Trial Balance Report	Lists detail or summary actual account balances and activity by ledger, balancing segment, and account segment: the report prints the value, description, debit or credit balance for beginning and period end, and debits and credits for period activity.
Average Balances Trial Balance Report	Provides a listing of ending balances and average balances for selected accounts based on an effective date specified. Prints the ledger currency or foreign-entered balances. Displays period, quarter, and year average-to-date balances.

Name

Description

Trial Balance Report

Provides summarized actual account balances and activity by ledger, balancing segment, and account segment value.

General Ledger Trial Balance Report

Lists detail or summary actual account balances and activity by ledger, balancing segment, and account segment: the report prints the value, description, debit or credit balance for beginning and period end, and debits and credits for period activity.

Average Balances Trial Balance Report

Provides a listing of ending balances and average balances for selected accounts based on an effective date specified.
Prints the ledger currency or foreign-entered balances.
Displays period, quarter, and year average-to-date balances.

Key Insights

Before running the trial balance 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 trial balance reports and provides examples.

Parameter	Description	Example	The Reports That Include It
Data Access Set	Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.	US Ledger Set	Trial Balance Report, General Ledger Trial Balance Report, Average Balances Trial Balance Report
Balancing Segment Filter and Condition	Restricts the data reported based on the entered balancing segment filter and condition.	Company equals 101	Trial Balance Report
Account Filter and Condition	Restricts the data reported based on the account segment filters and conditions.	Cost Center doesn't equal 100	General Ledger Trial Balance Report, Average Balances Trial Balance Report
Summarize By	Determines if the report is summarized by Account, which refers to account combination, Natural Account, or by Natural Account plus another segment.	Natural Account	Trial Balance Report, Average Balances Trial Balance Report
From and To Periods	Determines the accounting period for which account balances are reported.	Apr-21	General Ledger Trial Balance Report

Frequently Asked Questions

The following table lists frequently asked questions about the trial balance 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 Managers Financial Accountants Financial Specialists
When do I use these reports?	During month-end reconciliation. During period close to verify all transactions have been processed.
What type of reports are these?	Oracle Analytics Publisher