The Trial Balance by Treasury Account Symbol Report enables users to run the trial balance by Treasury Account Symbol range.
The Trial Balance by Treasury Account Symbol is an RXi report. The Default Attribute set groups the data by Treasury Account 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 Account Symbols must be created in the Define Treasury Account Symbols window.
Treasury Account Symbols must be associated with a fund in the Define Fund Attributes window.
Journals for the accounts under the Treasury Account Symbol created must be posted in General Ledger.
To generate the Trial Balance by Treasury Account Symbol Report:
Navigate to the Submit Request window.
In the Name field, select Trial Balance by Treasury Account Symbol.
In the Ledger field, select the ledger.
In the Treasury Account Symbol Low field, select the low value designating where to begin report generation.
In the Treasury Account 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 Account Symbol, Default Attribute Set report.
Column | Description |
---|---|
Header Section | Report date, Ledger name, currency, period, balance type, Treasury Account Symbol range, Treasury Account 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 |