Controlling Agency

The controlling agency is the agency required to reconcile the entire cash activity for the shared fund and report the CIST balance on its AFR. The amount reported is also reconciled to the State of Texas Annual Cash Report.

To determine the controlling agency for a shared fund, refer to the Texas Comptroller Manual of Accounts or the REPORT ROUTE AGENCY field on the USAS Appropriated Fund Profile (D22) screen.

Non-Controlling Agency

A non-controlling agency is any other state agency authorized to spend money from a shared fund but is not the controlling agency. The non-controlling agency does not report the shared CIST balance on its AFR. The net balance between CIST and shared cash must be zero for the non-controlling agency and may be offset by due from/due to the controlling agency for any accrued liabilities.

Note: Agencies with an existing CIST balance in appropriated fund 0325 (CARES Act) and appropriated fund 0369 (Federal American Recovery and Reinvestment Act Fund) have an exception to the above and are therefore responsible for reporting their own CIST balance. Do not offset the CIST balance in these appropriated funds 0325 and 0369 with shared cash (GL 0047).

The recording of transfers and due from/due to requires coordination between the controlling agency and each of the non-controlling agencies and are subject to the interfund activities entered in USAS deadline. This coordination ensures transfers in are equal to transfers out and due from/due to accounts are equal. This includes the fiscal year-end accruals. The coordination for recording purposes can be done on a regular basis as determined by the controlling agency but must be coordinated at least annually during the preparation of its AFR.

Note: When shared fund activity occurs within the same GAAP Fund and GAAP Fund Type, a due from/due to does not need to be recorded. Recording of this activity results in an overstatement of the balances at a statewide level and requires elimination during the state ACFR preparation.

Statement of Revenues and Expenditures

The controlling agency must account for the non-controlling agencies’ activities by reporting them as transfers out to non-controlling agencies. This amount equals the CIST activity plus any fiscal year-end accruals of the non-controlling agency. However, some agencies report the non-controlling agencies’ activities as state pass-throughs or other operating revenue.

Balance Sheet

The controlling agency is the agency responsible for reporting the entire Aug. 31 (USAS) CIST balance. The total presented in the controlling agency’s AFR is the Aug. 31 USAS balance on the USAS Cash Control Summary Inquiry (57) screen. For more information, see Reporting Cash in State Treasury. Other balance sheet accounts only reflect the accounts of the controlling agency. Do not attempt to account for any balance sheet accounts of non-controlling agencies.

The controlling agency accounts for the fiscal year-end accruals recorded by the non-controlling agency by reporting them as a due to.

Statement of Revenues and Expenditures

The non-controlling agencies must report activities out of shared funds as actual revenues and expenditures. The actual revenues and expenditures include fiscal year-end accruals and deferrals (such as receivables, unearned revenues and payables).

Transfers in are reported in the amount of cash and accrued transactions incurred by the agency. The transfer in equals the amount reported as a transfer out by the controlling agency. However, depending on the COBJ used, the amount can be a transfer, a state pass-through or other operating revenue.

Balance Sheet

Cash balances are not reported by the non-controlling agencies since the controlling agency reports the entire cash balance for the shared fund. Any cash balance is reclassified with a shared cash adjustment (see example below). The non-controlling agency accounts for the fiscal year-end accruals reported as payables by offsetting them with a due from.

In the balance sheet, there are no fund cash balances after the shared cash and transfer out adjustment. A due from accrual must offset any remaining accounts payable. The due from must match the due to amount reported by the controlling agency.

During the year, the non-controlling agency received a cash transfer in of $45,000, had cash expenditures of $40,000 and, at fiscal year-end, accrued expenditures of $10,000.

1. First step is to adjust cash for the shared fund.

   The non-controlling agency has a positive cash balance of $5,000 after expenditures at fiscal year-end. The non-controlling agency records a transfer out of $5,000 to the controlling agency and offsets the transfer out with shared cash. The controlling agency records a transfer in of $5,000 and offsets the transfer in with shared cash.

2. Second step is to adjust for accruals.

   The non-controlling agency recorded accruals for expenditures of $10,000 at fiscal year-end. The non-controlling agency records a transfer in and a due from of $10,000. The controlling agency records a transfer out and a due to of $10,000.

Note: If the non-controlling agency did not receive cash transfers greater than actual cash expenditures, the CIST balance before adjustment is negative. With a negative balance, the non-controlling agency’s adjustment for cash activity is to record a transfer in and an increase to shared cash to eliminate the negative balance.

Use shared cash adjustments to ensure the controlling agency accurately reports the total appropriated fund CIST. The controlling agency reports the entire cash balance in the appropriated fund and the non-controlling agency reports a zero cash balance.

CIST (GL 0045) cannot be adjusted after Aug. 31, 20CY for fiscal 20CY. Therefore, use shared cash (GL 0047) for adjustments to CIST. Netting the balances in shared cash and CIST achieves the desired results. Shared cash can be either a positive or negative amount.

The CIST balance in the appropriated fund can be found by inquiring on the Cash Control Summary Inquiry (57) screen. The FUND CASH BAL is the amount reported by the controlling agency. To obtain the balance:

• Leave the AGENCY field blank.
• Enter the appropriated fund number.
• Leave the AY field blank to recall the balance for all appropriation years (AYs).
• Enter the last two digits of the current year in the INQ YEAR field.

The AVAIL CASH BAL has been reduced by cash reserved for payroll, but these funds are still in the state treasury and therefore are still included in the fund cash balance. The inquiry month represents the calendar month; therefore, an inquiry month of 08 equals August. The DAFR8660 Fund Cash History by Agency Including Shared Funds report can be requested to provide complete detail of the activity in a fund for the controlling agency. For more information on cleaning up cash in state treasury, see the USAS Profile Review and Cleanup Procedures — Cash in the State Treasury in USAS (FPP A.031).

         TEXAS S057           UNIFORM STATEWIDE ACCOUNTING SYSTEM    MM/DD/YY 03:19 PM
         LINK TO:                CASH CONTROL SUMMARY INQUIRY                     PROD

           AGENCY:    APPR FUND: 0200   FUND:      AY:
         INQ TYPE: CB    (MA, PA, YA, CB, PY, PP)
         INQ YEAR: CY    INQ MONTH: 08    AVAIL CASH BAL: 4,112,061.50
                                           FUND CASH BAL: 4,140,192.22

         BT    TITLE               AMOUNT             BT      TITLE             AMOUNT
         12    CASH REVENUES       26,878,860.94                                      
         15    CASH EXPEND         22,737,906.79                                      
         16    CASH RSRVD – PAYR       28,130.72
         21    CASH TRNSFR OUT            761.93                                      
  

The General Ledger Summary Inquiry (56) screen represents the amount for CIST associated with a particular agency’s APPR FUND. This amount can also be obtained from the DAFR8920 General Ledger Fund Detail Trial Balance report. Identify CIST and shared cash balances to determine fiscal year-end shared cash adjustments in USAS.

The following screen samples are for the same appropriated fund. The first is for the controlling agency and the second is for agency 902. Note that the FUND fields are blank and therefore reflect the balance for all D23 funds in the appropriated fund.

  TEXAS  S056           UNIFORM STATEWIDE ACCOUNTING SYSTEM    MM/DD/YY 03:31 PM 
  LINK TO:                 GENERAL LEDGER SUMMARY INQUIRY                   PROD 

    AGY: 700 FY: CY APPD FUND: 0200 FUND:        COMP/AGY GL: 0045              
    GL TITLE: CASH IN STATE TREASURY                                              
    COMP/AGY OBJ:           AY:    APPN:         NAC SUBFUND:                     
                  DEBIT                   CREDIT                  ENDING BALANCE   
  PY BAL                                                           7,069,426.93 
  SEP         2,778,523.10              3,282,160.74-              6,565,789.29 
  OCT            16,399.65                 75,883.98-              6,506,304.96 
  NOV           495,502.80                469,055.23-              6,532,752.53 
  DEC           872,456.88                      0.00               7,405,209.41 
  JAN           793,439.32                      0.00               8,198,648.73 
  FEB           132,618.70                      0.00               8,331,267.43 
  MAR           267,070.51              3,469,195.72-              5,129,142.22 
  APR           207,708.36                      0.00               5,336,850.58 
  MAY           226,329.65-             1,087,468.57-              4,478,711.66-
  JUN            88,033.23                      0.00               4,566,744.89 
  JUL            24,367.31                      0.00               4,591,112.20 
  AUG         3,013,953.89              2,973,514.71-              4,631,551.38-
  ADJ                 0.00-                     0.00               4,631,551.38 

  

  TEXAS  S056           UNIFORM STATEWIDE ACCOUNTING SYSTEM    MM/DD/YY 03:33 PM 
  LINK TO:                 GENERAL LEDGER SUMMARY INQUIRY                   PROD 

    AGY: 902 FY: CY APPD FUND: 0200 FUND:        COMP/AGY GL: 0045              
    GL TITLE: CASH IN STATE TREASURY                                              
    COMP/AGY OBJ:           AY:    APPN:         NAC SUBFUND:                     
                  DEBIT                   CREDIT                 ENDING BALANCE   
  PY BAL                                                            367,159.16-
  SEP                 0.00                      0.00                367,159.16-
  OCT                 0.00                124,200.00-               491,359.16-
  NOV                 0.00                      0.00                491,359.16-
  DEC               134.68                      0.00                491,224.48-
  JAN            18,499.63                      0.00                472,724.85-
  FEB               763.71                      0.00                471,961.14-
  MAR                00.00                      0.00                471,961.14-
  APR             8,908.34                      0.00                463,052.80-
  MAY                 0.00                      0.00                463,052.80-
  JUN                 0.00                 28,306.36-               491,359.16-
  JUL                 0.00                      0.00                491,359.16-
  AUG                 0.00                      0.00                491,359.16-
  ADJ                 0.00                      0.00                491,359.16-
  

The 56 screen for the controlling agency 700, appropriated fund 0200 equals $4,631,551.38. The 56 screen for the non-controlling agency 902 shows a balance of ($491,359.16) in this fund. This reconciles to the preceding Cash Control Summary Inquiry (57) screen amount as follows:

Agency	Amounts	Screen Relation
agency 700 (controlling)	4,631,551.38
agency 902 (non-controlling)	(491,359.16)
net activity for all agencies	4,140,192.22	agrees to 57 screen

The DAFR8660 is available to agencies and reflects the same activity on a monthly basis at the document level.

USAS Tip: The General Ledger Summary Inquiry (56) screen is only updated during the batch overnight cycle — not when a transaction is entered in USAS using edit mode 2.

Agencies vary in the reporting of shared cash on their AFR and in USAS. The reason for the various methods is due to legislative requirements, daily operations and internal policy at a particular agency. This section is not designed to address all shared cash scenarios — it is designed to give agencies an idea of the most common shared cash entries.

There are scenarios in which an agency cannot enter a shared cash transaction in USAS because the entry uses a balancing T-code (such as 654 and 655) and is between two agencies. These entries are written up and submitted to the agency’s financial reporting analyst before the interfund activities entered in USAS deadline by the controlling agency. Submit the entries to the Comptroller’s office allowing time for the financial reporting analyst to enter the transaction and for the agency to rerun reports to ensure the entry had the desired effect. If your agency has questions about the reporting of its fund, contact your agency’s financial reporting analyst.

Effective fiscal 2024, non-balancing T-codes 460 and 461 were introduced enabling agencies to enter their own activity for shared funds. This alternative entry method achieves the same desired results when netting the balances in shared cash and CIST. T-code determination depends on whether the non-controlling agency’s CIST balance is positive or negative.

The controlling agency is responsible for determining the shared cash entry method. The controlling agency must confirm the decision in writing to the non-controlling agency and the non-controlling agency must record the transactions as determined by the controlling agency. Coordination amongst agencies is critical, regardless of entry method selected. This coordination ensures USAS entries are recorded accurately to achieve the desired results, including use of the correct agency general ledger account (AGL). For more information, see AGL on Interfund Activity.

The following scenarios are typical for shared cash:

1. The non-controlling agency spends money out of a shared fund and reports expenditures, transfers and any collected revenue. If the net of the balances in GL 0045 and GL 0047 is negative, the non-controlling agency uses T-code 655 to debit GL 0047 (input GL) and credit transfers in. The controlling agency uses T-code 654 to debit transfers out and credit GL 0047 (input GL).

   Alternatively: The non-controlling agency uses T-code 461 to debit GL 0047 and credit transfers in. The controlling agency uses T-code 460 to debit transfers out and credit GL 0047.

2. Same scenario as described above, except the net of the balances in GL 0045 and GL 0047 is positive. The non-controlling agency uses T-code 654 to debit transfers out and credit GL 0047 (input GL). The controlling agency uses T-code 655 to debit GL 0047 (input GL) and credit transfers in.

   Alternatively: The non-controlling agency uses T-code 460 to debit transfers out and credit GL 0047. The controlling agency uses T-code 461 to debit GL 0047 and credit transfers in.

3. The non-controlling agency incurs expenditures after cash is balanced for both agencies. The non-controlling agency needs to accrue the expenditures as a payable. The non-controlling agency records a transfer in offset with a due from, and the controlling agency records a transfer out offset with a due to. This can be accomplished with one of the following:
   • Cash liquidation using RTI T-codes:
     • T-codes 475 and 476. For more information, see RTI Table 5.
   • No cash liquidation using RTI T-codes:
     • T-codes 478 and 479. For more information, see RTI Table 6.
   • Cash liquidation using non-RTI T-codes:
     • T-codes 450 and 451 to process the accrual transactions.
     • T-codes 403 and 404 in the following year to reverse the accrual transactions and post to CIST.
   • No cash liquidation using non-RTI T-codes:
     • T-codes 450 and 451
4. Agency 327, the Employees Retirement System of Texas (ERS), processes payments on behalf of the controlling agency for payroll-related costs using a fund controlled by another agency (not appropriated fund 0001). At fiscal year-end, agency 327 enters a generic entry in USAS to zero out the cash balance and negate the amount posted to COBJ 7041. Effective fiscal 2020, the Comptroller’s office assumed responsibility for processing an entry in USAS by mid-September each year to record the expenditures originally paid by agency 327 offset by GL 0047. This entry allows for the expenditures and related cash impact to be reported by the controlling agency. The amount can be obtained by inquiring on the General Ledger Summary Inquiry (56) screen for agency 327, fiscal year 20CY, appropriated fund XXXX, GL account 0045 and COBJ 7041. The agency will continue to record this entry in its own internal accounting system.

   Calculate the payroll-related cost for the year by deducting the prior year’s beginning balance from the final adjusted ending balance. Process the shared cash entry using T-code 632 with an input GL of 0047 and COBJ 7041.

   ERS provides payroll-related cost reports for your agency’s financial reporting purposes. For more information, see the ERS Payroll Related Cost Reports.

Scenario

At fiscal year-end, the controlling agency for appropriated fund 0006 determines the shared cash transactions will be recorded in USAS using T-codes 460 and 461. (This method allows each agency to enter their side of the transaction without need of the Comptroller’s office involvement.) Note that only the controlling agency receives the CR_101 ad hoc review report. For more information, see AFR Ad Hoc Review Reports. Non-controlling agencies must use the DAFR8580 or FMQuery–SIRS Balance Sheet to verify their net balance for CIST and shared cash.

• Per the CR_101 report and confirmed by the Cash Control Summary Inquiry (57) screen:
  • The FUND CASH BAL is $3,606,000. This balance is presented on the controlling agency’s AFR.
• Per the CR_101 report and confirmed by the various agencies’ Balance Sheet:
  • Non-controlling agency 327 has a negative cash balance of ($300,000).
  • Controlling agency 601 has a positive cash balance of $2,500,000.
  • Non-controlling agency 608 has a positive cash balance of $1,400,000.
  • Non-controlling agency 902 has a positive cash balance of $6,000.
• Per the non-controlling agencies’ Balance Sheet:
  • Non-controlling agency 608 has accrued revenue (accounts receivable) of $1,000.
  • Non-controlling agency 902 has accrued expenditures (accounts payable) of $500

Step 1: Adjust Cash Balance

Summary view of the shared cash (GL 0047) adjustment needed per CR_101 presentation:

Controlling agency 601 must enter an equal and offsetting entry for each of the non-controlling agencies’ transactions. Final CIST balance must match the Cash Control Summary Inquiry (57) screen.

• Non-controlling agency 327 has a negative net cash balance. They use T-code 461 to debit GL 0047 and credit transfers in. The controlling agency uses T-code 460 to debit transfers out and credit GL 0047.
• Non-controlling agencies 608 and 902 have a positive net cash balance. They use T-code 460 to debit transfers out and credit GL 0047. The controlling agency uses T-code 461 to debit GL 0047 and credit transfers in.

Step 2: Adjust for Accruals

Non-controlling agencies 608 and 902 have accruals to record at fiscal year-end. Again, the controlling agency must enter an equal and offsetting entry for each of the non-controlling agencies’ transactions.

• Non-controlling agency 608 has accrued revenue (accounts receivable) of $1,000. They use T-code 654 to record a transfer out and T-code 663 to record a due to. The controlling agency records a transfer in with T-code 655 and a due from with T-code 662.
• Non-controlling agency 902 has accrued expenditures (accounts payable) of $500. They use T-code 655 to record a transfer in and T-code 662 to record a due from. The controlling agency records a transfer out with T-code 654 and a due to with T-code 663.

Input GL 9999 on T-code 662/663 transaction lines to offset the GL 9999 impact from the T-code 654/655 transaction lines.

Note: T-codes 662 and 663 automatically reverse in the following fiscal year.

Both sets of T-codes for this accrual example are balancing T-codes. Submit the transaction lines to the Comptroller’s office for entry. Agencies are able to enter lines with T-codes 460 and 461 without assistance.

Accounting effect of above entries

Agency 327 (non-controlling)

Agency 601 (controlling)

Agency 608 (non-controlling)

Agency 902 (non-controlling)

*Transactions with balancing T-codes require entry by the Comptroller’s office when the activity is between multiple agencies.

WARNING: System clearing must not have a balance after all transactions are entered.