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.
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
Treasury symbols must be created in the Define Federal Account Symbol window.
Treasury symbols must be associated with a fund in the Define Appropriation Parameters window.
Journals for the accounts under the treasury symbol created must be posted in General Ledger.
To generate the Trial Balance by Treasury Symbol Report:
Navigate to the Submit Request window.
In the Name field, select Trial Balance by Treasury Symbol.
In the Ledger field, select the ledger.
In the Treasury Symbol Low field, select the low value designating where to begin report generation.
In the Treasury Symbol High field, select the high value designating where to end report generation.
In the Period Name field, select the general ledger period.
The following table describes the Trial Balance by Treasury Symbol, Default Attribute Set report.
| 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 |