USAS User’s Manual –
Chapter 9 – Financial Inquiry (continued)
Financial Inquiry Screens
Note: Financial Inquiry screens in this chapter are arranged in numerical order.
49A Appropriation/Object Revenue Detail Inquiry
The 49A Appropriation/Object Revenue Detail Inquiry screen lists appropriation information by Object and Appropriated Fund. The user must request balances for either Revenue (49A) or Expenditure (49B) initially, but may link between these two categories by using the F9 key.
Revenue = Active Comptroller Objects with an Object Type of R (Revenue) on the D10 Comptroller Object Profile.
The following Comptroller General Ledger accounts are used for data on this screen:
- 5000 Revenue Control-Cash
- 6010 Operating Transfers In
- 6080 Residual Equity Transfers In
- 9010 Estimated Revenue
A picture of the USAS Appropriation/Object Revenue Detail Inquiry screen
TEXAS S049 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 02:11 PM
LINK TO: APPROPRIATION/OBJECT REVENUE DETAIL INQUIRY PROD
AGY: 999 FY: 96 AY: 96 APPN: 11111 APPD FUND: 0001 REV/EXP: R
APPROP COMPT ADJ BUD UNBUDGETED
FUND OBJECT BY OBJECT REVENUE REVENUE
0001 3000 20,654,653.00 .00 20,654,653.00
3972 .00 228.96 228.96-
TOTAL REV 20,654,653.00 228.96 20,654,424.04
F1-HELP F3-END F4-INTERRUPT F7-BACKWARD F8-FORWARD F9-EXPENDITURE
Allowed Access Paths
Allowed Access Paths are:
Appn Appd Agy AY No Fund FY x x x x x x x x x x x x x x x x x x x x x x x
Calculated Balance
Calculated Balance: None.
49B Appropriation/Object Expenditure Detail Inquiry
The 49B Appropriation/Object Expenditure Detail Inquiry screen lists appropriation information by Object and Appropriated Fund. The user must request balances for either Expenditure (49B) or Revenue (49A) initially, but may link between these two categories by using the F9 key.
Expenditures = Active Comptroller Objects with an Object Type of E (Expenditures) on the D10 Comptroller Object Profile.
The following Comptroller General Ledger accounts are used for data on this screen:
- 5500 Expenditure Control-Cash
- 6050 Operating Transfers Out
- 6085 Residual Equity Transfers Out
- 9060 Appropriation
A picture of the USAS Appropriation/Object Expenditure Detail Inquiry screen
TEXAS S049 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 01:29 PM
LINK TO: APPROPRIATION/OBJECT EXPENDITURE DETAIL INQUIRY PROD
AGY: 999 FY: 96 AY: 96 APPN: 11111 APPD FUND: 0001 REV/EXP: E
APPROP COMPT ADJ BUD REMAINING FREE
FUND OBJECT BY OBJECT EXPENDITURE BUDGET
0001 7000 30,205,701.00 .00 30,205,701.00
7002 .00 5,059.31- 5,059.31
7101 .00 793.00 793.00-
7260 .00 15,019.00 15,019.00-
7274 .00 1,200.26 1,200.26-
7286 .00 124.76 124.76-
7330 .00 19.05 19.05-
7514 .00 70.00 70.00-
7522 .00 164.34 164.34-
TOTAL EXP 30,205,701.00 12,331.10 30,193,369.90
NO MORE RECORDS FOR THIS KEY
F1-HELP F3-END F4-INTERRUPT F7-BACKWARD F8-FORWARD F9-REVENUE
Allowed Access Paths
Allowed Access Paths are:
Appn Appd Agy AY No Fund FY x x x x x x x x x x x x x x x x x x x x x x x
Calculated Balance
Calculated Balance: None.
56 General Ledger Summary Inquiry
The 56 General Ledger Summary Inquiry screen provides inquiry into the General Ledger Summary table, which is created after Batch IEU processing is complete. The inquiry displays data of the previous night’s Batch IEU run.
A picture of the USAS General Ledger Summary Inquiry screen
TEXAS S056 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 02:41 PM
LINK TO: GENERAL LEDGER SUMMARY INQUIRY PROD
AGY: 999 FY: 96 APPD FUND: 0001 FUND: COMP/AGY GL: 5501
GL TITLE: EXPENDITURE CONTROL - ACCRUED
COMP/AGY OBJ: AY: APPN: NAC SUBFUND:
BEG BALANCE DR CR END BALANCE
SEP 0.00 13,759,585.39 13,728,795.11- 30,790.28
OCT 30,790.28 0.00 0.00 30,790.28
NOV 30,790.28 0.00 0.00 30,790.28
DEC 30,790.28 0.00 0.00 30,790.28
JAN 30,790.28 0.00 0.00 30,790.28
FEB 30,790.28 0.00 0.00 30,790.28
MAR 30,790.28 0.00 0.00 30,790.28
APR 30,790.28 0.00 0.00 30,790.28
MAY 30,790.28 0.00 0.00 30,790.28
JUN 30,790.28 0.00 0.00 30,790.28
JUL 30,790.28 0.00 0.00 30,790.28
AUG 30,790.28 0.00 0.00 30,790.28
ADJ 30,790.28 0.00 0.00 30,790.28
F1-HELP F3-END F4-INTERRUPT
Allowed Access Paths
Allowed Access Paths are:
- Agency, Fiscal Year, Appropriated Fund, Comptroller General Ledger;
- Agency, Fiscal Year, Fund, Comptroller General Ledger; or
- Agency, Fiscal Year, Appropriated Fund, Fund, and Comptroller/Agency General Ledger (Control Key).
Calculated Balance
Calculated Balance: None.
57 Cash Control Inquiry
The 57 Cash Control Summary Inquiry screen displays Summary financial balances for many cash control accounts, which are summarized across Appropriation Year and Grant/Phase.
A picture of the USAS Cash Control Summary Inquiry screen
TEXAS S057 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 02:43 PM
LINK TO: CASH CONTROL SUMMARY INQUIRY PROD
AGENCY: APPR FUND: 0001 FUND: AY:
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH: 09 AVAIL CASH BAL: 1,007,356,249.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,640,272.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
Allowed Access Paths
Allowed Access Paths are:
- Appropriated Fund; or
- Appropriated Fund and Appropriation Year (Control Key).
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.
58 Agency/Fund Summary Inquiry
The 58 Agency/Fund Summary Inquiry screen displays Appropriation balances, which are further summarized across the Appropriation Year at the Agency and Appropriated Fund/Fund levels. This is the highest-level summary for Appropriation information.
A picture of the USAS Agency/Fund Summary Inquiry screen
TEXAS S058 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 02:45 PM
LINK TO: AGENCY/FUND SUMMARY INQUIRY PROD
AGENCY: 999 AP YEAR: 96 APPR FUND: 0001 FUND:
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH:
NET CASH ACT: 57,839,006.11- APPN CASH AVAIL: 1,247,785,942.89
APPN ACCR CSH AVAIL: 1,247,755,152.61 APPN ENC CASH AVAIL: 1,247,755,152.61
BT TITLE AMOUNT BT TITLE AMOUNT
01 APPROP ORIGINAL B 3,446,664,798.00
02 APPROP REVISIONS 10,581,402.90
03 APPROP TRSFRS OUT 62,417,733.00
04 APPROP TRSFRS IN 101,017,733.00
11 EST COLLECTD REVE 2,190,221,251.90
12 CASH REVENUES 8,921.63
15 CASH EXPENDITURES 54,522,742.95
16 CASH RSRVD - PAYR 38,322,659.30
17 ACCRUED EXPENDITU 30,790.28
20 CASH TRANSFERS IN 40,711,585.53
21 CASH TRANSFERS OU 5,714,111.02
F1-HELP F3-END F4-INTERRUPT
Allowed Access Paths
Allowed Access Paths are:
- Agency and Fund;
- Agency and Appropriated Fund; or
- Agency, Appropriation Year, Appropriated Fund OR Fund (Control Key).
Note: If Appropriation Year is left blank, the screen will default to the current year.
Calculated Balances
Calculated Balances are:
- Net Cash Activity;
- Appropriation Cash Available;
- Appropriation Accrued Cash Available;
- Appropriation Encumbered Cash Available.
Note: Users can select Appd Fund or Fund (not both)-or leave both fields blank.
Note: For more information, see the Calculated Balances section at the end of this chapter.
59 Appropriation Summary Inquiry
The 59 Appropriation Summary Inquiry screen displays Appropriation information which is summarized with or without regard to Appropriated Fund, Fund, Program, or Organization.
A picture of the USAS Appropriation Summary Inquiry screen
TEXAS S059 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 03:01 PM LINK TO: APPROPRIATION SUMMARY INQUIRY PROD AGY: 999 AY: 96 APPN #: 11111 SURVEY/CERTIFICATION APPR FUND: 0001 FUND: PROG: LEVEL: ORG: LEVEL: 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
Allowed Access Paths
Allowed Access Paths are:
- Agency, Appropriation Year, and Appropriation Number; or
- Agency, Appropriation Year, Appropriation Number, and Appropriated Fund.
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.