USAS User’s Manual –
Chapter 7 – Transaction Entry (continued)
Reports
Users can request reports to view information about their agency’s ITVs. Control and requestable reports showing ITV activity are available.
Control Reports
Control reports are automatically produced from nightly payment processing and batch (IEU) cycles. Control report IDs are usually in the range DAFR2000 to DAFR3999. Agencies can receive the following control reports:
DAFR2151 Batch Agency Error Report
Note: The DAFR2151 Batch Agency Error Report is still available and includes ITVs as well as all other batches in error.
A picture of the DAFR2151 report
DAFR2151 USAS 01 AGENCY NUMBER:.......................... AGENCY BATCH ERROR REPORT AGCY PAGE: 1 11/09/93 (00.55 CYCLE 0449...............................................RUN PAGE: 0620 BATCH AGY DATE TYPE NUMBER SEQ USER ID DOC DATE EFF DT DUE DT SERV DT CUR DOC/SFX REF DOC/SFX M R DMI AGY TC AY INDEX PCC PCA TRANSACTION AMT REQUISITION # COMP/AGY OBJ NSFND IRS FO PDT DOC AGY C/I PROPERTY # INVOICE NO INV DT CONT # WARR NO ERRORS VENDOR NO/MC VENDOR NAME APPN NO FUND GL/AGY GL GRANT #/PH SUB GRANTEE PROJ #/PH MULTI CODE - AGY CD 1 2 3- D/1 NO RTI PT BANK NUMBER DISC DT TRM PEN DT TRM INT PENALTY AMOUNT XXX 11/08/63 2 XXX 00001 XXXXXXX 11/08/93 11/08/93 D1108301 001 XXX 95 94 XXXXX 222.00 3505 1100 XXX 00000 0284 EJI
DAFR2261 Daily History Detail Report
The batch agency receives the DAFR2261 Daily History Detail Report. It provides a list of posted, approved and if applicable, paid transactions. The transactions appear in batch agency order.
This report can be used to reconcile transactions and verify super security deleted transactions.
If the Transaction ID field displays SSTD (super security transaction delete) or SSDD (super security document delete), the transaction or document was super security deleted.
A picture of the DAFR2261 report
DAFR2261 USAS 01 JKNI RJE AGENCY NUMBER:...................... DAILY HISTORY DETAIL REPORT AGCY PAGE: 1 11/09/93 (00.47) CYCLE 0449.......................................................RUN PAGE: 3,859 --TRANS ID-- USER ID TID EFF DT AY DMI C/I TC M R AGY RTI INDEX AAPN# FUND PCA COBJ AOBJ TRANSACTION AMOUNT PROJ #/PH GRANT #/PH SUB GRANTEE --AGY CD 1 2 3-- GL/AGY GL MULTI CODE PCC REQUISITION # VENDOR NO/MC VENDOR NAME IRS INVOICE NO NACUBO SUBFUND INV DT DOC DATE DOC AGY CUR DOC/SFX REF DOC/SFX DUE DT SERV DT WARR NO PDT PROPERTY # D/I NO FO CONT # PT BANK NUMBER DISC DT TRM PEN DT TRMS INT PENALTY AMOUNT XXX 11/08/93 4 001 00001 XXXXXXX USGE 11/08/93 94 R 222 00000 0573 XXXXX 3711 3000 10.00 XXXXXXXXXXX000 001 10/11/93 101450482 R
Buying agencies can receive the following control reports:
DAFR3331 Error Transaction Aging Report
The DAFR3331 Error Transaction Aging Report displays transactions with errors detected by the nightly batch IEU cycles. It includes funding errors and data element errors. Also included on the report are documents requiring approval or correction.
The transactions appearing on this report have fatal data errors (E-fatal data) and fatal funding errors (F-fatal funding). Additional errors that may appear are B-batch error and Z-system error.
The DAFR3331 lists up to six error codes per transaction. Users can recall these codes using error code help in USAS. Batches containing errors appear on the View Batch Header (530) screen as Edit Mode 3 transactions with a status of H (Hold). This report will list all rejected transactions for an agency, including those in other batch agencies.
Rejected generated transfers will appear on this report under Batch Agency 005. These transactions can be corrected online under User Class 65.
A picture of the DAFR3331 report
DAFR3331 USAS 01 USAS RJE AGENCY NUMBER: USAS TRANSACTION AGING REPORT AGCY PAGE: 315 07/22/95 (08.45) CYCLE ( 881) PAGE: 0315 ---------------BATCH AGY DATE TYPE BNUM EFF DATE STAT DAYS ON IT BATCH AMOUNT 06/14/95 4 505 06/13/95 H 38 115.00 --------------DOCUMENT AGY DOC NO FF REMAINING APPROVAL CODES REJECT CODES 9F345296 95 ------------TRANSACTION SEQ 6 AGY CUR DOC/SFX REF DOC/SFX EFF DATE PROC DTE ACID TCD AY APPM FUND COBJ AOBJ TRANSAMOUNT ERROR CODES 00097 XXX 9F345296/001 06/13/950 7/22/95 TAP225 95 0001 7203 115.00 ERS E81 *BATCH DETAIL TRANSACTIONS IN ERROR 01-15 16-30 31-60 OVER 61 DAYS 1 0 0 0
DAFR3701 Warrant Register by Warrant Number
The DAFR3701 Warrant Register by Warrant Number Report provides a listing of warrants sorted by agency, warrant type, appropriated fund, document, fiscal year, and warrant number.
A picture of the DAFR3701 report
DAFR3701 USAS 01 JKNI RJE AGENCY NUMBER: WARRANT REGISTER BY WARRANT NO REPORT AGCY PAGE: 315 11/08/93 (21.48) CYCLE0449 ............................................................RUN PAGE: 15 WARRANT TYPE 060 BILLS WARR NO WARR DT APFDFUND DOC NO FY ESN VENDOR NO/ M C ----VENDOR NAME/ADDRESS------ WARR AMT 101450473 11/08/93 0001 XXXXXXXX94 XXXXXXXXXXX 000 46.45
DAFR3631 Fund Control Errors Occurring During Payment Processing
The DAFR3631 Fund Control Errors Occurring During Payment Processing Report is a daily report that lists payment transactions with funding problems. This report Processing should be viewed daily by the buying agency.A picture of the DAFR3631 report
DAFR3631 USAS 01 AGENCY NUMBER: FUND CONTROL ERRORS OCCURRING DURING PAYMENT PROCESSING AGCY PAGE: 1 11/08/93 19:57 CYCLE 0449...........................................................RUN PAGE: 89 DOC CURR DOC VENDOR MAIL APPN LBB NO of AGY NUMBER FY NO CODE AGY AY NO AFUND FUND ORG PROG COBJ OBJ AMOUNT TRANS ERROR MESSAGE XXX 20050205 94 XXXXXXXXXXX 028 VENDOR FAILED XXX 93 01170 0001 321.20 0001 REMAINING FREE BUDGET EXCEEDED AVAILABLE CASH EXCEEDED
DAFR3651 Warrant Register by Agency
The DAFR3651 Warrant Register by Agency Report lists the Warrant initiating transactions of the buying agency.
A picture of the DAFR3651 report
DAFR3651 USAS 01 JKNI RJE AGENCY NUMBER:.......... WARRANT REGISTER BY AGENCY REPORT AGCY PAGE: 1 11/08/93 (21.45) CYCLE 0449 RUN PAGE: 16 WARRANT TYPE 060 BILLS APFD FUND DOC NO FY ESN VENDOR NO/MC VENDOR NAME/ADDRESS - PDT/C WARR NO WARR DT WARR AMT 0001 XXXXXXXX 94 XXXXXXXXXXX000 R 101450473 11/08/93 46.45
DAFR3751 ITV Recurring Transaction Error Report for ITVs
The DAFR3751 ITV Recurring Transaction Error Report lists RTI processing errors for ITV transactions. This report is received by the initiating agency (the paying/disbursing agency).
A picture of the DAFR3751 report
DAFR3751 111 USAS 01 RECREATIONAL SAFETY BOARD *****************AGCY NUMBER 111 RECURRING TRANSACTION ERROR REPORT FOR ITVS AGCY PAGE 1 03/11/97 (21.18) CYCLE 1293 ************************************************************************************RUN PAGE 1 AGENCY 111 RECREATIONAL SAFETY BOARD ***************************************************************************************************** ******************************* DOCNO SFX RTI RTI TRANS ERROR MESSAGE AGY NO NO ***************************************************************************************************** ******************************* T71P3189 001 222 222222 000001 RTI TRANS NOT ACTIVE OR DATE NOT IN RANGE -- RTI TRANSACTION GENERATED T71P3189 001 222 222222 000002 RTI TRANS NOT ACTIVE OR DATE NOT IN RANGE -- RTI TRANSACTION GENERATED
DAFR3761 ITV Recurring Transaction Error Report for ITVs
The DAFR3761 ITV Recurring Transaction Error Report lists RTI processing errors for Due to/Due from transactions which occur during the generation of the transfer document. This report is received by the initiating agency.
A picture of the DAFR3761 report
DAFR3761 111 USAS 01 RECREATIONAL SAFETY BOARD *****************AGCY NUMBER 111 RECURRING TRANSACTION ERROR REPORT FOR ITVS AGCY PAGE 1 03/11/97 (21.18) CYCLE 1293 ************************************************************************************RUN PAGE 1 AGENCY 111 RECREATIONAL SAFETY BOARD ***************************************************************************************************** ******************************* DOCNO SFX RTI RTI TRANS ERROR MESSAGE AGY NO NO ***************************************************************************************************** ******************************* T9970101 001 222 222222 000001 NO ACTIVE TRANS FOR RTI FORND --NO TRANSACTIONS GENERATED T9970106 001 222 222222 000002 NO ACTIVE TRANS FOR RTI FORND --NO TRANSACTIONS GENERATED
DAFR3762 ITV Generated Transactions
This report shows the system-generated transactions for all RTI transactions. Both the initiating and receiving agency get copies of this report. This report is generated based on the IN records generated. The other agency’s number and fund are shown in the Interfund Agy and Fund fields.
Note: The originating document number is provided in the REF
DOC
field.
A picture of the DAFR3762 report
DAFR3762 999 USAS 01 B13 COMMISSION *****************AGCY NUMBER 999 ITV GENERATED TRANSACTIONS AGCY PAGE 1 03/15/97 (02.35) CYCLE 1296 ************************************************************************************RUN PAGE 1 BATCH EFFECT -INTERFUND- AGY DATE TYPE CUR DOC/ SFX REF DOC/ SFX TC REV DATE AGY FUND AMOUNT ***************************************************************************************************** ******************************* 999 19970314 W GT195017/999 T7101140/333 970 19970314 333 0001 63.76
A picture of the DAFR3762 report
DAFR3762 333 USAS 01 STATE GOLDEN BOARD
*****************AGCY NUMBER 333
ITV GENERATED TRANSACTIONS
AGCY PAGE 1
03/15/97 (02.35) CYCLE 1296
************************************************************************************RUN PAGE
25
BATCH EFFECT -INTERFUND-
AGY DATE TYPE CUR DOC/ SFX REF DOC/ SFX TC REV DATE AGY FUND
AMOUNT
*****************************************************************************************************
*******************************
333 19970314 W GT195017/999 T7101140/333 960 19970314 999 0001 63.76
333 19970314 W GT195034/333 TF540127/555 971 19970314 555 0001
236.25
971 19970314 555 0001
236.25
971 19970314 555 0001
435.34
971 19970314 555 0273
236.25
971 19970314 555 0001
217.66
971 19970314 555 0001
236.25
333 19970314 W GT195062/333 T3125550/777 971 19970314 777 0001
1,035.00
Requestable Reports
Users have a variety of options when requesting reports. The Report Request Profile (91) enables users to customize reports based on the options available on the Report Control Profile (D64), by using the following features:
- Time Frame—enables the user to select the appropriation year, fiscal year, the period, and the frequency of reports.
- Classification Level—enables users to request reports at various levels of detail. Depending on the report, options may be available to select the level of detail for the organization, strategic program structure, object, fund, NACUBO fund, grant and project, and general ledger account.
- Data Selection—allows the user to select specific values or ranges of values to be reflected on the requestable report. Also allows users to limit reports to specific agencies, organization codes, program codes, NACUBO funds, appropriated funds, funds, comptroller objects, agency objects, general ledger accounts, agency general ledger accounts, grants, and projects.
Note: Valid customizing options available for a specific requestable report are controlled by the options on the Centrally defined and maintained Report Control Profile (D64).
If the data selected does not match the information in the financial tables, the requested report will not be generated. However, an exception report explaining why the requested report was not generated will be produced.
DAFR8190 Daily Document Activity Report
The DAFR8190 Daily Document Activity Report lists all posted transactions for the current day.
- Special Select 1—Allows the user to enter a document type or range of document types. If this field is left blank, all document type transactions will be generated.
- Special Select 2—In the first position, if the user chooses:
D the report will sort by document number. I the report will sort by invoice number.
A the report will sort by document number. N the report will include only documents created by the financial agency. For the generated transaction, this will be when the financial agency and document agency are the same. Blank data for financial agency. Recommended values:
First position Second position D N I N
Note: Recommended values will list all documents not created by the financial agency. This includes the generated transfer-in for the selling agency and Treasury-generated documents.
A picture of the DAFR8190 report
DAFR8190 MJB01RDOE RJE R303 ( )( )( )( )( )( ) RUN DATE: 08/04/94 TIME: 06:42 25 USAS CYCLE: 08/04/95 06:27 0890 CFY: 95 CFM: 12 LCV: 94 LCM: 09 FICHE: DAILY DOCUMENT ACTIVITY REPORT REPORT PERIOD = 08/03/95 FY=95 PAGE 4 DOCUMENT AGENCY XXX APPN YEAR 95 INVOICE # INV DATE CURR DOC/SFX (BAT AGY DATE TP NO SEQ NO) REF DOC/SFX EFF DATE SRVC DATE CONTRCT # RTI STATUS TC DESCRIPTION APPN# APFND FUND GRANT/PHASE NACSUB PCA INDEX COBJ AOBJ REQ # PAYEE # MC PAYEE NAME TRANSACTION DESCRIPTION TRANS AMOUNT REV 1250337 GTXXX215/000 (005 19950803 W 617 00002) T7524570 08/03/95 04/30/95 960 INTERAGENCY PAYMENT - SYSTEM GEN XXXXX 0001 XXXX 12101 7266 303303 653.49 1250337 GTXXX215/000 (005 19950803 W 617 00001) T7524570 08/03/95 04/30/95 971 RECEIPT of INTERAGENCY PAYMENT XXXXX 0900 XXXX 00902 3790 303303 653.49 * DOC TOTAL 1,306.98 * INVOICE TOTAL 1,306.98
DAFR8200 Daily Transaction Register
The DAFR8200 Daily Transaction Register Requestable Report lists all transactions posted to the requesting agency during the day. It prints in five registers. The system sorts each register by document agency, document type based on the first character of the current document number, and current document number. The T-Code determines the register in which a transaction appears. The register number for each T-Code can be seen on the T-Code Profile (28A). For ITVs, the two important registers are: Register 2 Pre-Enc/Enc/Expend Transaction Register for the buying agency’s payment; and Register 3 Revenue/Receipts Transaction Register for the selling agency’s receipt of payment.
A picture of the DAFR8200 report
DAFR8200 RDOE 01 RDOE RJE R303( )( ) ( ) ( ) ( )( ) RUN DATE: 08/04/95 TIME: 06:45 40 USAS CYCLE: 08/04/95 06:27 0890 CFY: 95 CFM: 12 LCY: 94 LCM: 09 FICHE: 303 DAILY PRE-ENC/ENC/EXPEND TRANSACTION REGISTER (2) PERCENT of YEAR ELAPSED: 100% REPORT PERIOD = 08/04/95 PAGE:--------------------------------------------------------9428 CURR DOC /SFX/AGY/DATE EFF DATE DUE DATE SERV DATE REF DOC/SFX TC INDEX PCA AY C/AGY OBJ DISC FO AMOUNT R PD C PROP #1099 INV # DATE DESCRIPTIONV-------EEND/MAIL CODE-----------NAME------------------------- CONRACT 3 WARR # APPN# FUND AFUND GL ACCT/AGENCY GRNT #/PH SUB GRANTEE PROJ #/PH MPCODE ---AGCY 1 2 3--- RTI AGY YYYYMMDD T BATCH SEQ GTXXX215 000 XXX 08/03/95 04/30/95 T7524570 960 XXXXX 95 7266 0.00 653.49 1250337 XXXXX0001 0001 005 19950803 W 617 00002
A picture of the DAFR8200 report
DAFR8200 RDOE 0 RDOE RJE R303 ( ) ( ) ( ) ( ) ( ) ( ) RUN DATE: 08/04/95 TIME:06:45 40 USAS CYCLE: 08/04/95 06:27 0890 CFY: 95 CFM: 12 LCY: 94 LCM: 09 FICHE: 303 DAILY REVENUE/RECEIPTS TRANSACTION REGISTER (3) PERCENT of YEAR ELAPSED: 100% REPORT PERIOD = 08/04/95 PAGE: 9450 CURR DOC /SFX/AGY/DATE EFF DATE DUE DATE SERV DATE REF DOC/SFX TC INDEX PCA AY C/AGY OBJ FO AMOUNT R DESCRIPTION VEND/MAIL CODE NAME INT TRMS PMT TYPE BANK DISC DATE TM PEN DATE TM PENALTY AMT APPN# FUND AFUND GL ACCT/AGY GRNT #/PH SUB GRANTEE PROJ #/PH MPCODE ---AGCY 1 2 3--- RTI AGY YYYYMMDD T BATCH SEQ GTXXX215 000 XXX 07/25/95 08/03/95 06/01/95 99501684 103 971 XXXXX95 3790 770.13 6/95 CONSTR & ABATEMENT 303303 00 00900 0900 0902 005 19950803 W 612 00001
DAFR8240 Monthly Transaction Register
The DAFR8240 Monthly Transaction Register Requestable lists all transactions posted to the requesting agency with an effective date within the requested month. It prints in five registers. The system sorts each register by document agency, document type based on the first character of the current document number, and current document number. The T-Code determines the register in which a transaction appears; the T-Code also appears on the T-Code Profile (28A). For ITVs, the two important registers are: Register 2 Pre-Enc/Enc/Expend Transaction Register for the buying agency’s payment; and Register 3 Revenue/Receipts Transaction Register for the selling agency’s receipt of payment.
A picture of the DAFR8240 report
DAFR8240 077 TEAM 01 04( )( )( )( )( )( ) RUN DATE: 01/22/93 TIME: 19:31 12 USAS CYCLE: 01/22/93 18:17 0222 CFY: 93 CFM: 04 LCV: 91 LCM: 01 FICHE: 077 VITAMIN & NUTRIENT COMMISSION (077) MONTHLY PRE-ENC/ENC/EXPEND TRANSACTION REGISTER (2) PERCENT of YEAR ELAPSED: 33% REPORT PERIOD: DECEMBER FY: 93 TEST SYSTEM PAGE:-----------------------------------------------------------10 CURR DOC /SFX/AGY/DATEEFF DATE DUE DATE SERV DATE REF DOC/SFX M TC INDEX PCA AY C/AGY OBJ DISC PO AMOUNT RPC C PROP #1099 INV # DATE DESCRIPTION--------VEND/MAIL CODE-----------------NAME----------------- CONRACT # WARR # APPN# FUND AFUND GL ACCT/AGENCY GRNT#/PH SUB GRANTEE PROJ #/PH MPCODE --AGCY 1 2 3--- RTI AGY YYYYMMDD T BATCH SEQ POOOOOO1 OO4 O77 12/17/92 200 01103 11031 93 73845 .00 4000.00 01012 0010 1001 077 19921217 3 001 00004
Note: USAS generates monthly reports each weekend.
Interagency Transaction Voucher Corrections/Adjusting Entries
ITV corrections require a journal voucher using Document Type J.
Note: Expenditure Transfer Vouchers (ETVs) are not used to adjust ITVs. ETVs are used to adjust transactions which generate warrants in USAS.
Use one of two T-Code combinations to adjust ITVs:
- 921 and 921R for adjustments made to the seller’s side of the transaction.
- 931 and 931R for adjustments made to the buyer’s side of the transaction.
Note: Do not use T-Codes 405/406 and 407/408 to adjust ITVs. Users can, however, use them for ETVs.
Travel
Agencies must process Travel transactions in USAS in any Edit Mode or through INs and submit the travel voucher to the Comptroller’s office. These transactions are processed by agencies using Document Type 1. Depending on the agreement between each agency and the Fiscal Management Division, the voucher can be audited after payment (post-audited).
Non-Payroll Travel Reimbursement
Non-Payroll Travel Reimbursement transactions are reimbursement travel vouchers. For example, reimbursement of direct airfare billing or travel advance. Travel transactions are entered in any edit mode online or through tape submission. The appropriate Document Type is 1. Depending on the agreement between each agency and the Fiscal Management Division, the voucher can be audited after payment.
Non-payroll reimbursements are entered using a T-Code combination of:
- 247 V/P Non-payroll Reimbursement Detail; and
- 904 Payment Reimbursement Vendor.
Reimbursement documents may have several detail transactions (247), but only one summary transaction (904). The 904 transaction amount will be the total of all the detail transactions within that document. The purpose of the 904 summary transaction is to supply the payee/vendor number for the agency being reimbursed.
The recommended payment distribution type is “DC.’ Use of this PDT will allow payments to documents.
Purchase Voucher — Documentation Post-Audit by the TBPC3
Agencies can submit Purchase Voucher-Documentation Post-Audit by the Texas Building and Procurement Commission (TBPC) transactions in any edit mode or through tape submission. These transactions are processed by agencies using Document Type 2 and must include appropriate Purchase Category Code (PCC) and Requisition Number. Neither a purchase voucher nor supporting document is required to be submitted. These transactions will be post-audited by the TBPC and the Comptroller’s office if the agency has signed the post-audit contract and the object code is a post-audit code.
Purchase Voucher — Preaudited by TBPC
Agencies will submit supporting documentation for Purchase Vouchers Preaudited by TBPC directly to the Texas Building and Procurement Commission (TBPC). These transactions are processed by agencies in any edit mode or through tape submission using Document Type 3 and must include appropriate PCC and Requisition Number. Both the TBPC and the Comptroller’s office, if the object code is a preaudit code or the agency has not signed the post-audit contract, must approve these transactions for a warrant to be generated.
Purchase Voucher — Not Audited by TBPC
Agencies can submit Purchase Voucher-Not Audited by TBPC transactions to USAS in any edit mode or through tape submission. These transactions are identified as Document Type 9 transactions. The selection criteria for this document type is that legislation (legal citation) exists that exempts an agency from purchasing rules found in Tex Government Code, Title 10, subtitle D, Chapter 2161. Neither a purchase voucher nor supporting documentation is required to be submitted. These transactions will be post-audited by the TBPC and the Comptroller’s office if the agency has signed a post-audit contract and the object code is post-audit.
Non-Payroll Purchase Reimbursement
Non-Payroll Purchase Reimbursement transactions are reimbursement purchase vouchers. For example, Reimbursement reimbursement of petty cash. The appropriate Document Type is 1, 2, 3, or 9.
Non-payroll reimbursements are entered using a T-Code combination of:
- 247 V/P Non-payroll Reimbursement Detail; and
- 904 Payment Reimbursement Vendor.
Reimbursement documents may have several detail transactions (247), but only one summary transaction (904). The 904 transaction amount will be the total of all the detail transactions within that document. The purpose of the 904 summary transaction is to supply the payee/vendor number for the agency being reimbursed.
The recommended payment distribution type is ‘DC.’ Use of this PDT will allow payments to documents.
Expenditure Transfer Voucher
Expenditure Transfer Voucher transactions are used to correct transactions that produce warrants. For Batch Type 4, agencies can process these transactions in Edit Mode 0 or 1 online or through tape submission. The expenditure transfer voucher is not required to be submitted to the Comptroller’s office. The valid Document Type is K.
Batch Type 5 — Journal Vouchers
All Batch Type 5 transactions are processed on the 501 Journal Voucher Transaction Entry screen.
A picture of the Journal Voucher Transaction Entry screen
TEXAS S501 UNIFORM STATEWIDE ACCOUNTING SYSTEM 04/08/95 12:01 PM LINK TO: JOURNAL VOUCHER TRANSACTION ENTRY BATCH: AGENCY 550 DATE 040893 TYPE 5 NO 001 SEQ NO 00001 MODE EDIT AND POST DOC DATE : EFF DATE: DUE DATE: SERV DATE: CUR DOC/SFX: REF DOC/SFX: AGENCY: TRANS CODE: INDEX: PCA: AY: COMP/AGY OBJ: NACUBO SUBFUND: AMOUNT: RVS: FUND OVRD: DOC COUNT: DOC AMT: DOC AGY: 550 GL ACCT/AGY: DESCRIPTION: DEBT/INVEST ISSUE #: APPN NO: FUND: GRANT NO/PH: PROJ NO/PH: RTI: F1-HELP F3-END F4-INT F5-EDIT F6-PROCESS F7-TEXT F9-BALANCING F10-RTI
The following are appropriate Transaction Types for Batch Type 5:
- Journal Vouchers/Transfers Between Agencies
- Journal Vouchers/Transfers Within An Agency
- Accounts Payable
- Statistical Data
Journal Vouchers — Transfers Between Agencies
Agencies submit journal vouchers to the Comptroller’s office for Central entry. These transactions are processed with Document Type J.
Journal Vouchers — Transfers Within An Agency
Agencies enter journal vouchers within an agency in any edit mode or through tape using Document Type J. These transactions do not require a journal voucher to be submitted to the Comptroller’s office.
Accounts Payable
Accounts Payable transactions are processed by the agency using Document Type U. While agencies can submit the transactions in any edit mode online or through tape submission, a paper document is not required to be submitted to the Comptroller’s office. Accounts Payable transactions can also be entered using Batch Type 4-Expenditures/Disbursement.
Statistical Data
Statistical Data transactions are processed by the agency using Document Type U. While agencies can submit the transactions in any edit mode online or through tape submission, a paper document is not required to be submitted to the Comptroller’s office. Statistical Data transactions can also be entered using Batch Type 4-Expenditures/Disbursements.
Batch Type 6 — Payroll
All Batch Type 6 transactions are processed on the 505 Pre-Enc/Enc/Expend Transaction Entry screen.
A picture of the Pre-Enc/Enc/Expend Transaction Entry screen
TEXAS S505 UNIFORM STATEWIDE ACCOUNTING SYSTEM 01/18/95 02:22 PM LINK TO: PRE-ENC/ENC/EXPEND TRANSACTION ENTRY BATCH: AGENCY 258 DATE 090195 TYPE 6 NO 010 SEQ NO 00001 MODE EDIT AND POST DOC DATE: EFF DATE: DUE DATE: SERV DATE: DOC/SFX: REF DOC/SFX: MOD: AGENCY: TRAN CODE: AY: INDEX: PCC: PCA: REQ NO: COMP/AGY OBJ: AMOUNT: RVS: DISC: 1099: FO: PDT: DOC COUNT: DOC AMT: DOC AGY: CI: PROP #: INV NO: DT: DESC: VEND/MC: NM: CONT NO: ADDR 1: WARR NO: ADDR 2: APPN NO: ADDR 3: FUND: ADDR 4: GL AC/AGY: CITY: ST: ZIP: GRANT NO/PH: SUB GRANTEE: PROJ NO/PH: MPCD: AGY CD-1: 2: 3: DI: RTI: TRANSACTION SUCCESSFULLY WRITTEN F1-HELP F3-END F4-INT F5-EDIT F6-PROCESS F9-BALANCING F10-RTI
The following are appropriate Transaction Types for Batch Type 6:
- Payroll Document
- Annuitant Payroll
- Reimbursement Payroll Document
Note: Payroll reimbursements are entered using a T-Code combination of:
- 246 V/P Payroll Reimbursement Payee Detail; and
- 903 Payroll Reimbursement Vendor.
Reimbursement documents may have several detail transactions (246), but only one summary transaction (903). The 903 transaction amount will be the total of all the detail transactions within that document. The purpose of the 903/Summary transaction is to supply the payee/vendor number for the agency being reimbursed.
The recommended payment distribution type is ‘DC.’ Use of this PDT will allow payments to documents.
Note:Batch Type S is used for USPS payrolls.
Elements Related to Payroll Processing
A brief overview of elements used by the Payroll Processing Subsystem include:
- Transaction Codes
- Batch Type
- Document Types
- PCAs and Program Codes
Transaction Codes
Transaction Codes are three-digit codes used to identify accounting events associated with a transaction.
Batch Type
The valid Batch Type for Payroll processing is 6. This will engage the confidentiality settings for payroll.
Document Types
The valid Document Types for payroll processing are:
4 | Payroll Documents (USAS) |
---|---|
5 | Reimbursement of Payroll (USPS, Special Adjustments) |
7 | Annuitant Payroll |
8 | Payroll Documents (USPS, System-Generated) |
PCAs and Program Codes
PCAs and Program Codes are needed for the Other Activity section of the Strategic Structure to capture payroll activity. For each PCA that will be used in payroll processing, a fund and appropriation number must be inferred. Additionally, PCAs must be established to infer NACUBO function, NACUBO subfund, index, grant number, project number, and any other multipurpose or agency codes that apply. The program codes for this payroll activity should be at least at Level 3 to avoid problems with the levels used for report requests. The required PCA numbering scheme is:
U.S. Savings Bonds | 32 + agency number | |
---|---|---|
Direct Deposit for Transmittal | 33 + agency number | |
Direct Deposit-401K Deferred Compensation | 34 + agency number |
PCAs related to direct deposits and savings bonds are not required to be in the D37 Other System Cost Center Profile.
The PCA titled U.S. Savings Bonds should be established to infer Appropriation Number 00000 and an agency fund that infers Appropriated Fund 0901.
The PCA titled Direct Deposit for Transmittal should be established to infer Appropriation Number 07732 and an agency fund that infers Appropriated Fund 0979.
The PCA titled Direct Deposit-401K Deferred Compensation should be established to infer Appropriation Number 00632 and an agency fund that infers Appropriated Fund 0942.
In addition to these, OASI State Matching, OASI State Share, and Withdrawals (federal withholding, FICA, Retirement, Insurance, TEXFLEX Reimbursement Account, Non-401K Deferred Compensation, and other withdrawals) will need to have PCAs established in the D37 profile for the payroll conversion program to utilize.
The PCA that is established for OASI Matching Estimated must infer Appropriation Number 01142. The PCA that is established for State Share-OASI must infer Appropriation Number 06687.
Note:State-paid FICA will be discontinued as of January 1996.
Note: For agencies using USPS, PCAs are used to infer appropriation number, fund number, and agency codes. USPS allows an agency to select either PCA or Index as a reporting element. If an agency selects Index, then the Index must infer PCA. PCAs are required on all USAS transactions to ensure updating of an agency’s Strategic Budget Structure.
Payroll Processing Errors
There are four groups of errors that can be received when processing payrolls:- Conversion Errors (applicable if the payroll is submitted in the FACTS tape or paper format)
- Batch and Document Level Errors
- Transaction Data or Funding Errors
- Payment Processing Errors
Note: Payroll Document Type 4 is subject to ‘pay-in-full’ edits; therefore, USAS will not allow these payroll documents with errors to produce payments.
Refer to Chapter 8, Error Correction, in this manual for additional details concerning the detection and correction of errors.
When an agency processes a payroll voucher containing invalid Payee Identification Numbers (PINs) of PINs for which there is no mail code, the PIN will appear on the Texas Identification Number System /Uniform Statewide Accounting System ‘suspense file’ until it is corrected or a mail code established. All agencies who are productional on the Human Resources Information System (HRIS), except higher education, must first ensure the correct SSN or new hire set up has been reported to HRIS. If the employee is correctly established on HRIS and TINS and error is limited to a ‘typo’ on the voucher, then the agency takes corrective measures per USAS procedures. If the employee has not been established on the HRIS or has been set up with a wrong SSN, the agency must send corrective transactions to HRIS.