Federal Report Definitions Setup

Overview

In the Federal Report Definitions windows, you can customize reports by specifying report definitions and entering report data. Report definitions provide additional information to meet federal government reporting requirements.

Federal report definitions setup is required for the following reports:

FMS Form 224 and CTA submission Setup

In the CTA FBWT Account Definition window, you can define the SGL accounts to report on the FMS Form 224 or CTA file submission. In addition, the Account Type and Agency Location Code (ALC) are assigned to the SGL accounts for default reporting. The Account Type determines the placement when it cannot be derived from the transaction or the FMS 224 Type of the Treasury Account Symbol. The transaction is reported to the ALC indicated for the SGL account when the ALC of the bank account cannot be determined.

FMS Form 1219/1220 Setup

In the FMS Form 1219/1220 Report Definitions Setup window, you can define the Accounting Flexfield values to report on the FMS Form 1219 and FMS Form 1220. In addition, the ALC is assigned to the accounting flexfield for default reporting. The Account Type determines the placement when it cannot be derived from the transaction or the FMS 224 Type of the Treasury Account Symbol. The transaction is reported to the ALC indicated for the SGL account when the ALC of the bank account cannot be determined.

Funds Availability Setup

In the Funds Availability Report Definitions window, you can perform these tasks:

Funds Available - Funding Distributions

The columns in this report represent amounts distributed not including activity against these amounts. For example, the Total Apportioned column represents amounts apportioned for a given period. This amount should not be reduced for amounts allotted. Agencies define a separate account to store initial balances, including transfers, and another account to store activity against the initial balance. This enables agencies to easily segregate initial balances from activity that reduces that balance as described in this example.

The following table describes the agency activity for Example 1:

Example 1: Agency Activity
Account Total Apportioned
Account 4510 - Apportionments (5,000,000)
Account 4610 - Allotments (2,000,000)

The following table describes the entry to record the initial Apportionment for Example 1:

Example 1: Initial Apportionment
Credit/Debit Account Total Apportioned
Debit 4450 5,000,000
Credit 4510 (5,000,000)

The following table describes the entry to record the Allotment for Example 1:

Example 1: Allotment
Debit/Credit Account Total Apportioned
Debit 4510 2,000,000
Credit 4610 (2,000,000)

The following table describes the Balances for Example 1:

Example 1: Balances
Account Total Apportioned
Account 4510 - Apportionments (3,000,000) = (5,000,000) - 2,000,000)
Account 4610 - Allotments (2,000,000)

In this example, the Total Apportioned column cannot be determined because both initial balance and activity are stored in the same account.

This example is the same as the previous example but with a separate account to store the initial apportionment.

The following table describes the entry to record the initial Apportionment for Example 2:

Example 2: Initial Apportionment
Debit/Credit Account Total Apportioned
Debit 4450 5,000,000
Credit 451001 (5,000,000)

The following table describes the entry to record the Allotment for Example 2:

Example 2: Allotment
Debit/Credit Account Total Apportioned
Debit 451002 2,000,000
Credit 4610 (2,000,000)

The following table describes the Balances for Example 2:

Example 2: Balances
Account Total Apportioned
Account 451001 - Apportionments (5,000,000)
Account 451002 - Apportionments Activity 2,000,000
Account 4610 - Allotments (2,000,000)

In this example, the Total Apportioned column is easily determined by the 451001 account while activity is segregated in the 451002 account. This logic applies to all remaining columns in the Funds Available - Funding Distributions report.

Funds Available - Spending Activity

For the Funds Available - Spending Activity Report, agencies should follow the same logic as described in the previous example in the Funds Available - Funding Distributions section for the Budget Authority column only. This column represents the beginning budget balance not including activity. In order to capture the initial budget balance, agencies should consider defining two accounts, one to store the initial balance and another to store activity. For example, these accounts could be defined:

Agency Location Code (ALC) Setup

In the Agency Location Code Addresses window, the agency location code address details are entered and used in the FMS Form 224 report, CTA submission and IPAC processing.

Reporting Codes Window

Map values for the segment of the Accounting Flexfield to the reporting code value as follows:

Note: The Reporting Codes window lets you define the segment at the Treasury Account Symbol and fund level.

Reimbursable Activity Setup

In the Funds Reimbursable Activity Report Definitions window, you can perform these tasks:

Prerequisites

Before setting up federal report definitions, you must:

Oracle U.S. Federal Financials Setup Overview.

Define Bank Accounts.

Setting Up Funds Availability Table Procedure.

Setting Up Reimbursable Activity Report Definitions

Setting Up US SGL Accounts Tables

Setting Up GTAS Attributes Tables

Setting Up FMS Form 224 Report and CTA Submission Definitions

To enter or update federal report definitions for this report, navigate to the CTA FBWT Account Definition window.

The following table describes selected fields on the CTA FBWT Account Definition window.

CTA FBWT Account Definition Window Description
Field Name Description
Account Type Account type

Additional Information: Default value is Disbursement. The values used in the FMS 224 process and CTA process are Disbursement and Receipt and determines the placement on the FMS Form 224 when it cannot be derived from the transaction or from the FMS 224 Type of the Treasury Account Symbol.
Account Natural account segment of Accounting Flexfield.
Agency Location Code Default ALC that is to be reported if an ALC from a bank account cannot be determined for a transaction; values include the ALCs defined for internal account use bank accounts in Payables or Receivables.

Setting Up FMS Form 1219/1220 Report Definitions

To enter or update federal report definitions for this report, navigate to the FMS Form 1219/1220 Report Definitions window.

The following table describes selected fields on the FMS Form 1219/1220 Report Definitions window.

FMS Form 1219/1220 Report Definitions Window Description
Field Name Description
Accounting Flexfield Defined segments of Accounting Flexfield. At least one segment must be entered.
Description Describes the selected Accounting Flexfield values.
Agency Location Code Agency Location Code. Default ALC reported if an ALC from a bank account cannot be determined for a transaction; values include the ALCs defined for internal bank accounts in Payables or Receivables.

Setting Up Funds Availability Report Definitions

To set up funds availability report definitions, navigate to the Funds Availability Report Definitions window.

The following table describes selected fields on the Funds Availability Report Definitions window.

Funds Availability Report Definitions Window Description
Field Name Description
Report Report name
Column Column; not displayed in the Fund Availability reports.
Column Name Column name; displayed in the Fund Availability reports.
From Account from which to begin reporting for this column.
To Account to end reporting for this column.

Setting Up Agency Location Code

The following table describes the Setting Up Agency Location window.

Field Name Description
ALC Type Designates the Agency Location Code (ALC) as internal to the agency or an external Trading Partner ALC.
Disbursing Type Designates the ALC as a Treasury or Non-Treasury Disbursing Office.
Name ALC description name
Business Activity The valid business activities are as follows:

  • Collections Only

  • IPAC Only

  • Payment Only

  • IPAC and Collections

  • IPAC and Payment

  • Payment and Collections

  • IPAC, Collections and Payment
Contact Supplied for IPAC reporting purposes
Phone number Supplied for IPAC reporting purposes
Address information Supplied for IPAC reporting purposes
GWA Reporter Category The valid business activities are as follows:

  • IPAC Only

  • CA$SHLINK Only

  • TDO Payment Only

  • IPAC and CA$SHLINK

  • IPAC and TDO Payment

  • TDO Payment and CA$SHLINK

  • IPAC, CA$SHLINK and TDO Payment
Start Date List of valid effective start dates. The start date can only be entered as the first day of the month for each period.
End Date List of valid effective end dates. The end date can only be entered as the last day of the month for each period.

Note: All agency location code addresses must be entered in the Agency Location Code Addresses window otherwise a warning will be generated when the reports are run listing the ALCs with missing address details.

Defining Reporting Codes

To define the reporting codes, navigate to the Reporting Codes window.

The following table describes selected fields on the Reporting Codes window.

Reporting Codes Window Description
Field Name Description
Code Type Reporting Code Type includes:

  • B: Apportionment Category B Code

  • N: Program Reporting Category Code

  • P: Program Cost Indicator
Treasury Account Symbol Treasury Account Symbols for the ledgers. The value All includes all the Treasury Account Symbols in the ledgers.
Fund Fund values including All, All-Category A, All-Category B, or funds assigned to the Treasury Account Symbol selected. The combination of Treasury Account Symbol and fund must be unique.
Segment All segments except the natural account segment of the Accounting Flexfield for the ledgers.
Use Reporting Code Mapping Indicates if the values of the segment selected must be mapped to reporting codes. If the segment is intended to capture the Reporting Code, then this check box should be set to No.
If the check box is selected, the Report Code Mapping region is enabled.
Segment Value Segment values of the segment selected.
If the value All is entered, then there is only one record in the detail region for the Treasury Account Symbol/Fund combination.
Reporting Code Numeric reporting code.
Reporting Code Description Defaults from the initial Segment value selected.

Setting Up Reimbursable Activity Report Definitions

To set up funds availability report definitions, navigate to the Reimbursable Activity Report Definitions window.

The following table describes selected fields on the Reimbursable Activity Report Definitions window.

Reimbursable Activity Report Definitions Window
Field Name Description
Column Column; not displayed on the Reimbursable Activity Report.
Column Name Column name; displayed in the Reimbursable Activity reports.
Natural Balance Natural balance of the column; if natural balance is debit, debit amounts display as positive and credit amounts display as negative. If natural balance is credit, credit amounts display as positive and debit amounts display as negative.
Receivables SLA Detail Indicates balances should be retrieved from Receivables Subledger Accounting journals.
From Account from which to begin reporting for this column.
To Account to end reporting for this column.

Related Topics