FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USAS User’s Manual
Chapter 12 – Understanding Financial Tables (continued)

A Detailed Look at the Appropriation Table

Appropriation Table Data Elements and Balances

The following list indicates all the elements that make up a record within the Appropriation table.

Agency FM 01 Balance
Appropriated Fund FM 02 Balance
Appropriation Year FM 03 Balance
Appropriation Number FM 04 Balance
Fund FM 05 Balance
Program Code FM 06 Balance
Organization Code FM 07 Balance
Compt Source Group* FM 08 Balance
Compt Object* FM 09 Balance
LBB Object* FM 10 Balance
Fiscal Year FM 11 Balance
Balance Type FM 12 Balance
Close Indicator FM 13 Balance
Over Exp Date Last Process Date
Close Date Prior Prior Year Balance
Update Number Prior Year Balance

*These elements are not currently in use, meaning no data is posted to them.

Control Key for the Appropriation Table

Agency, appropriation year, appropriation number, appropriated fund, fund, organization code, program code, balance type, and fiscal year are all contained in the control key for the Appropriation table.

Balances of the Appropriation Table

Each month in the fiscal year represents a different column in the financial table. The fiscal month 01 balance represents cumulative balances for the month of September; the fiscal month 02 balance contains the cumulative balances for the month of October, and so on.

The amounts stored in each balance column are cumulative totals of all transactions posted to that record in that month.

For example, assume that in September, two transactions recorded an Appropriation Original Expenditure Budget. One transaction was $6,000 and the second was $3,000, so the total reflected for the month of September is $9,000.

table

Chapter 12 Continued

Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy