USAS User’s Manual –
Chapter 9 – Financial Inquiry (continued)
Financial Inquiry Screens
Note: Financial Inquiry screens in this chapter are arranged in numerical order.
61 Agency Budget Inquiry
The 61 Agency Budget Record Inquiry screen displays Record financial balances for each line of the agency budget.
A picture of the USAS Agency Budget Record Inquiry screen
TEXAS S061 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/10/95 08:42 AM LINK TO: AGENCY BUDGET RECORD INQUIRY AGENCY: APPN YEAR: ORG CODE: PGM CODE: AP FUND: FUND: COMP SRC/GRP: LBB/COMP/AGY OBJ: AGY OBJ GROUP: ORG LEVEL: PGM LEVEL: INQ TYPE: CB (MA, PA, YA, CB, PY, PP) INQ YEAR: INQ MONTH: AGENCY BUDG AVAILABLE: AGENCY BUDG PERCENT AVAIL: BT TITLE AMOUNT BT TITLE AMOUNT F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Paths
Allowed Access Paths are:
- Agency, Appropriation Year, and Organization Code;
- Agency, Appropriation Year, and Program Code;
- Agency, Appropriation Year, and Appropriated Fund or Fund;
- Agency, Appropriation Year, and one of the following:
- Comptroller Source/Group
- Comptroller Object
- LBB Object
- Agency Object
- Agency Object Group; or
- Agency, Appropriation Year, Organization, Program, Appropriated Fund or Fund, and Object (Control Key).
Note: Which access paths are valid is dependent on how the agency chooses to set the Agency Budget Table posting indicators. Refer to the USAS User's Manual, Chapter 12-Understanding Financial Tables, for more information.
Note: The Agency Budget Record Inquiry must be accessed at the same program or organization level that the transaction was processed.
Calculated Balances
Calculated Balances are:
- Agency Budget Available;
- Agency Budget Percent Available.
Note: For more information, see the Calculated Balances section at the end of this chapter.
62 Appropriation Record Inquiry
The 62 Appropriation Record Inquiry screen displays financial balances for each line of the Appropriation.
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 03:04 PM LINK TO: APPROPRIATION RECORD INQUIRY PROD AGY: 999 APPN YEAR: 96 APPN #: 11111 SURVEY/CERTIFICATION APPR FUND: 0001 FUND: COMP SRCE/GRP: LBB/COMP OBJ: PRG CD: LVL: ORG CD: LVL: INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 09 NET CASH ACT: 1,990,806.26- REM CASH BASIS BUDG: 28,214,665.78 APPN CASH AVAIL: 7,560,241.74 REM ACCR BASIS BUDG: 28,214,665.78 APPN ACCR CSH AVAIL: 7,560,241.74 REM ENC BASIS BUDG: 28,214,665.78 APPN ENC CASH AVAIL: 7,560,241.74 BT TITLE AMOUNT BT TITLE AMOUNT 01 APPROP ORIGINAL B 30,568,881.00 03 APPROP TRSFRS OUT 363,180.00 11 EST COLLECTD REVE 20,654,653.00 15 CASH EXPENDITURES 17,390.41 16 CASH RSRVD - PAYR 1,973,644.81 20 CASH TRANSFERS IN 228.96 F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Paths
Allowed Access Paths are:
- Agency, Appropriation Year, and Appropriation Number; or
- Agency, Appropriation Year, Appropriation Number, and Appropriated Fund (Control Key).
Note: If Appropriation Year is left blank, the screen will default to the current year.
Note: There are other possible access paths; however, statewide policy results in their being invalid access paths because data is not stored in one or more fields of the access path. For example: Fund, Program Code, and Organization Code.
Calculated Balances
Calculated Balances are:
- Net Cash Activity;
- Remaining Cash Basis Budget;
- Remaining Accrued Basis Budget;
- Remaining Encumbered Basis Budget;
- Appropriation Cash Available;
- Appropriation Accrued Cash Available;
- Appropriation Encumbered Cash Available.
Note: For more information, see the Calculated Balances section at the end of this chapter.
62 Appropriation Record Inquiry Reconciliation
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 03:04 PM LINK TO: APPROPRIATION RECORD INQUIRY PROD AGY: 999 APPN YEAR: 96 APPN #: 11111 SURVEY/CERTIFICATION APPR FUND: 0001 FUND: COMP SRCE/GRP: LBB/COMP OBJ: PRG CD: LVL: ORG CD: LVL: INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 09 NET CASH ACT: 52,124,823.61- REM CASH BASIS BUDG: 44,238,753.74 APPN CASH AVAIL: 44,001,436.39 REM ACCR BASIS BUDG: 44,235,030.58 APPN ACCR CSH AVAIL: 43,997,713.23 REM ENC BASIS BUDG: 44,235,030.58 APPN ENC CASH AVAIL: 43,997,712.23 BT TITLE AMOUNT BT TITLE AMOUNT 02 APPROP REVISIONS 21,990,496.98 04 APPROP TRSFRS IN 137,228,371.00 11 EST COLLECTD REVE 63,092,607.98 12 CASH REVENUES 4,934,096.10 15 CASH EXPENDITURES 114,980,114.24 16 CASH RSRVD - PAYR .00 17 ACCRUED EXPENDITU 3,723.16 20 CASH TRANSFERS IN 58,576,172.49 16 CASH TRANSFERS IN 654,977.96 F1-HELP F3-END F4-INTERRUPT F8-FRWD
The following provides a sample reconciliation.
BT Rem Cash Basis Budg Appn Cash Avail Difference
+02 21,990,496.98 21,990,496.98 0.00
+04 137,228,371.00 137,228,371.00 0.00
-11 (63,092,607.98) 63,092,607.98
+12 4,934,096.10 (4,934,096.10)
-15 (114,980,114.24) 114,980,114.24) 0.00
+20 58,576,172.49 58,576,172.49
-21 (654,977.96) 654,977.96
----------------------------------------------------------------------
44,238,753.74 44,001,436.39 237,317.35
BT Rem Cash Basis Budg Appn Cash Avail Difference
Cash 44,238,753.74 44,001,436.39 237,317.35
Accr* 44,235,030.58 43,997,713.23 237,317.35
Enc 44,235,030.58 43,997,713.23 237,317.35
*BT 17 Accrued Expenditures of 3,723.16 is included in Accr and Enc balances only.
Note: Balance Types 11 and 12 are included where the Excess Revenue Indicator is set to Y and (-11+12+20-21) is greater than zero.
BT Appn Cash Avail
-11 (63,092,607.98)
+12 4,934,096.10
+20 58,576,172.49
-21 (654,977.96)
(237,317.35)
Since the total is less than zero, ($237,317.35) is not included in the calculation of Remaining Cash Basis Budget.
63 Cash Control Record Inquiry
The 63 Cash Control Record Inquiry screen displays financial balances for each line of the Fund or the Appropriated Fund with or without regard to the Grant.
A picture of the USAS Cash Control Record Inquiry screen
TEXAS S063 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 03:06 PM
LINK TO: CASH CONTROL RECORD INQUIRY PROD
AGENCY: AP YR: 96 APPR FUND: 0001 FUND: GRANT NO/PHASE:
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH: 09 AVAIL CASH BAL: 1,007,348,015.11-
FUND CASH BAL: 1,770,284,023.83
BT TITLE AMOUNT BT TITLE AMOUNT
12 CASH REVENUES 1,960,046,178.70
15 CASH EXPENDITURES 502,010,328.51
16 CASH RSRVD - PAYR 377,632,038.94
20 CASH TRANSFERS IN 2,533,719,246.75
21 CASH TRANSFERS OU 2,221,471,073.11
32 GR/INTERFD BORROW 2,400,000,000.00-
F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Path is:
- Appropriation Year and Appropriated Fund.
Note: There are other possible access paths; however, statewide policy results in their being invalid access paths because data is not stored in one or more fields of the access path. For example: Fund, Program Code, and Organization Code.
Note: If Appropriation Year is left blank, the screen will default to the current year.
Calculated Balances
Calculated Balances are:
- Available Cash Balance;
- Fund Cash Balance.
Note: Statewide policy controls whether or not data on the Cash Control table will be stored at an agency specific level or as statewide balances. Current policy dictates that data for this table is stored at a statewide level. Therefore, when inquiring on this screen, the amounts shown reflect totals for the state-not just a single state agency.
Note: For more information, see the Calculated Balances section at the end of this chapter.