Skip Headers

Oracle U.S. Federal Financials User Guide
Release 12.1
Part Number E13551-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Summary Trial Balance Report Procedures

Overview

The Trial Balance by Treasury Symbol Report enables users to run the trial balance by treasury symbol range.

The Trial Balance by Treasury Symbol is an RXi report. The Default Attribute set groups the data by treasury symbol, fund, fiscal year, and organization. This attribute set can be copied in order to customize the layout to suit the reporting needs of the agency. In the Default Attribute set, the fiscal year and organization segments were assigned default segment columns. To maintain this level of detail, the agency must create a customized attribute set to map the segment of the Accounting Flexfield to the appropriate column headings.

Requirements

As specified by the Joint Financial Management Improvement Program (JFIMP), agencies are required to provide online summary trial balances at the treasury account symbol level.

Related Topics

Oracle Financials RXi Reports Administration Tool, Oracle Financials RXi Reports Administration Tool User Guide

Prerequisites

Generating the Trial Balance by Treasury Symbol Report

To generate the Trial Balance by Treasury Symbol Report:

  1. Navigate to the Submit Request window.

  2. In the Name field, select Trial Balance by Treasury Symbol.

  3. In the Ledger field, select the ledger.

  4. In the Treasury Symbol Low field, select the low value designating where to begin report generation.

  5. In the Treasury Symbol High field, select the high value designating where to end report generation.

  6. In the Period Name field, select the general ledger period.

Trial Balance by Treasury Symbol Report Description Table for the Default Attribute Set

The following table describes the Trial Balance by Treasury Symbol, Default Attribute Set report.

Trial Balance by Treasury Symbol Report Description for the Default Attribute Set
Column Description
Header Section Report date, Ledger name, currency, period, balance type, treasury symbol range, treasury symbol, fiscal year, and organization
Account General ledger account number
Beginning Balance Beginning balance for account
Debits Period debits
Credits Period credits
Ending Balance Ending balance for account