The FACTS II reports provide information on Standard General Ledger (SGL) account balances and associated attributes affected by FACTS II requirements.
The FACTS II Trial Balance Report is used by federal agencies to review SGL account balances at the attribute level. Only attributes for accounts reported on FACTS II are captured.
The FACTS II Trial Balance is an RXi report. The Default Attribute set groups the data by treasury symbol, fund, fiscal year, organization, program, and project. 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, organization, program, and project 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.
See: RXi attribute sets, see Oracle Financials RXi Reports Administration Tool, Oracle Financials RXi Reports Administration Tool User’s Guide.
Agencies' financial systems are required to comply with the US SGL at the transaction level for FACTS II reporting in accordance with the Federal Financial Management Improvement Act and section 7(c) of the Office of Management Budget (OMB) Circular No. A-127.
For information on reporting requirements, see the Department of Treasury’s Financial Management Service (FMS) FACTS II information at the following website:
www.fms.treas.gov/ussgl/factsii
The prerequisites for generating the FACTS II bulk file are also applicable to generating the FACTS II Report.
To run the FACTS II Trial Balance Report, do the following:
Navigate to the Submit Request window.
In the Name field, select FACTS II Trial Balance.
In the Ledger field, select a ledger.
In the Fund Low field, select a fund value designating where to start report generation. .
In the Fund High field, select a fund value designating where to end report generation.
In the Currency Code field, select a currency type.
In the Period field, select a period.
In the Attribute Set field, select the attribute set.
In the Output Format field, select the output format for the report.
The following table describes the FACTS II Trial Balance Report Description for the Default Attribute Set.
| Column | Description |
|---|---|
| Header Section | Ledger name, report date and time, currency, accounting period, fund range, treasury symbol, fund, fiscal year, organization, program, and project |
| Acct No | Natural account segment |
| AUT | Authority type |
| DEF | Definite (D) or Indefinite (I) flag. |
| PL | Public law code |
| CAT | Apportionment category |
| PRC | Program Reporting Category for Category A |
| CBS | Apportionment Category B Code |
| RIF | Reimbursable flag: Direct (D) or Reimbursable (R) |
| AVT | Period of availability: Available in current period (A) or Available in a subsequent period (S) |
| TRP | Transaction partner code: Federal (F), Non-federal (X), Non-federal exception (E) |
| BOR | Borrowing Source |
| BEA | Budget Enforcement Agency (BEA) category: Discretionary (D) or Mandatory (M) |
| YRB | US SGL attribute that distinguishes between outlays from new budget authority versus outlays from balances carried forward from a prior year; used for noncredit financing No-year appropriations only; NEW or BAL |
| TAG | Department identifier of the agency involved in the transfer |
| TAC | Main account code of the agency involved in the transfer |
| ADF | Indicates that a portion of the appropriation is advanced from a future year (F) or made available in a prior year (P) |
| FUN | Classifies data according to major purpose served: Defense (DEF) or Non-Defense (NND) |
| CYR | Cohort year; two-digit year |
| PYA | Adjustments to prior year reporting |
| Beginning Balance | Beginning balance of period |
| Current Period Debits | Debits for the period |
| Current Period Credits | Credits for the period |
| Ending Balance | Ending balance of period |