FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USAS Profile Review and Cleanup Procedures

USAS Profile Review and Cleanup Procedures – Internal Transaction (IT) File Cleanup

Background

Internal Transaction Types

The Internal Transaction (IT) file is a temporary file used to store transactions in the Uniform Statewide Accounting System (USAS) while they are being processed.

These transactions include those awaiting:

  • Release
  • Oversight approval
  • Error correction
  • Rebalancing
  • Future dates

Maintain your IT File Daily

Agencies and institutions are required to review their transactions on the USAS IT File daily and must complete the maintenance tasks necessary to keep the file current. Staff can refer to the USAS View Batch Headers (530) screen and to daily IT file control reports to find the appropriate actions for transactions needing attention. Some examples of IT file control reports are:

  • DAFR2021 — Batch/Document Processing Summary
  • DAFR2151 — Agency Batch Error Report
  • DAFR2221 — USAS Transaction Aging Report
  • DAFR3331 — USAS IT File Status Report

Keeping the IT file current makes for a smaller file that:

  • Improves online response time
  • Helps reduce nightly processing cycle time
  • Ensures transactions and payments entered by the cutoff time process the day they are entered

IT file cleanup becomes more important as transactions become older than 60 days. Transactions are more difficult to process when activity related to them crosses fiscal months and/or fiscal years due to fiscal periods being closed in USAS.

Every effort should be made to ensure all current year (CY) documents on the IT file are successfully processed and written to history before Aug. 31, 20CY. It is especially crucial that transactions posting to cash (GL 0045 – cash in state treasury) are successfully posted, processed and written to history prior to Aug. 31, 20CY.

back to top

Risk Areas

ABEST Reconciliation

After final information is transferred to the Automated Budget and Evaluation System for Texas (ABEST), the USAS database needs to remain constant for that accounting period for historical purposes. This historical data integrity will be disturbed if posted batches on the IT file are subsequently super security deleted.

Transactions in edit modes 2 or 4 are posted regardless of whether they have been released or require approvals and are therefore included in data transferred to ABEST. If you perform Super Security Deletes (SSDs) after a reconciliation period is closed on transactions that remain on the IT file and do not write to history, ABEST and USAS will no longer contain complementary data.

AFR Reconciliation

Transactions in edit mode 2 or 4 are posted and included in USAS financial reports used for reconciliation purposes, regardless of whether they have been released or require approvals. Therefore, an agency could reconcile to USAS based on balances including posted transactions remaining on the IT file that subsequently undergo SSDs.

This would usually also affect fund balance and create the need for a restatement in the following year. If a posted transaction must be deleted with an SSD after the AFR submission, contact your financial reporting analyst.

System Performance

System performance and the length of run time for the nightly IEU cycle is affected by the size of the IT file.

Debt Collection Responsibility (USPS Agencies)

Agencies continue to be responsible for collection of accounts receivable-type transactions left on the IT file.

Legislation was enacted to give the Office of the Attorney General authority to prescribe procedures for debt collection. Agencies must follow these guidelines with regard to receivables left on the IT file that are super security deleted. This applies specifically to payroll deduction-type transactions such as those processed with T-codes 865R, 874R, 875R, etc. These types of transactions would normally appear on a DAFR3913. Accounts receivable should be set up to replace these transactions.

For more information, see Accounting for Uncollectible Accounts (APS 027) (FPP C.001).

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