Reversal/Reclamation Reports
SWA6100A: Direct Deposit Funds Received
Overview
SWA6100A is a series of reports generated for each agency that receives funds from direct deposit payments that have been returned. Direct deposit funds are received due to successful reversal and reclamation requests and returned money items.
Purpose
The SWA6100A series of reports serves as notification to the agencies of direct deposit funds received and includes the following three subreports:
- SWA6100A-RCL – Accepted Reclamations Report. This report lists the funds received from successful reclamation requests for annuity payments.
- SWA6100A-RVS – Accepted Reversals Report. This report provides a breakdown of funds received from successful reversals for each of the following payment categories:
- Payroll payments.
- Annuity payments.
- Travel payments.
- Vendor payments.
- SWA6100A-RM – Returned Money Items Funding Report. This report provides a breakdown of funds received from returned money items for each of the following payment categories:
- Payroll payments.
- Annuity payments.
- Travel payments.
- Vendor payments.
Frequency
The reports are produced daily, on days the agency receives funds for returned direct deposit payments.
Sample
The following sample applies to all SWA6100A series of reports. With the exception of the report titles, each report displays the same columns.
SWA6100A-RM TEXAS COMPTROLLER OF PUBLIC ACCOUNTS 123 PAGE 1 DATE MM/DD/YYYY RETURNED MONEY ITEMS FUNDING REPORT PROCESS DATE 12/09/2022 AGENCY: 123 - STATE STORES COMMISSION OF TEXAS VENDOR PAYMENTS ------------------------------------------------------------------------------------------------------------------------------------ USAS BATCH AGY: 902 DATE: MM/DD/YYYY TYPE: P NBR: J DOCUMENT: J1234567 F DOCUMENT: F1234567 ------------------------------------------------------------------------------------------------------------------------------------ TIN PAYMENT ISSUE PAYMENT BATCH DOC COMP AGY TRANSACTION REV ERR NAME MC NUMBER DATE AMOUNT SEQ SEQ TC AY PCA INDEX OBJ OBJ FUND AMOUNT IND IND ------------------------------------------------------------------------------------------------------------------------------------ 1XXXXXXXXX3 001 1234567 MM/DD/YYYY $200.00 001 188 XX 12345 3790 0980 $200.00 VENDOR NAME 1 ------------------------------------------------------------------------------------------------------------------------------------ VENDOR PAYMENTS TOTAL: $200.00 NUMBER OF PAYMENTS: 1 USAS TRANSACTION COUNT: 1 ------------------------------------------------------------------------------------------------------------------------------------ GRAND TOTAL AMOUNT: $200.00 GRAND TOTAL COUNT: 1 GRAND TOTAL USAS COUNT: 1 ------------------------------------------------------------------------------------------------------------------------------------
Field Descriptions
- REPORT NUMBER
- Displays the unique report number as one of the following:
- SWA6100A-RCL
- SWA6100A-RVS
- SWA6100A-RM
- AGENCY NUMBER
- Displays the three-digit agency number.
- PAGE
- Displays the sequential number for each page.
- RUN DATE
- Displays the report process date in the MM/DD/YYYY format.
- REPORT TITLE
- Displays the name of the report.
- AGENCY NUMBER – AGENCY NAME
- Displays the three-digit agency number and agency name.
- PAYMENT TYPE
- Displays the category of the payment type with one of the following:
- Payroll payments.
- Annuity payments.
- Travel payments.
- Vendor payments.
- BATCH ID
- Displays the following batch information:
- Batch agency 902.
- Batch date in the MM/DD/YYYY format.
- Batch type P.
- J document: The system-generated journal voucher.
- F document: The treasury deposit voucher as the reference document number.
- TIN/NAME
- Displays the 11-digit Texas identification number (TIN) and the name of the payee.
- MC
- Displays the three-digit mail code paid.
- PAYMENT NUMBER
- Displays the original seven-digit direct deposit payment number.
- ISSUE DATE
- Displays the issue date of the direct deposit payment.
- BATCH SEQ
- Displays the batch ID sequence, if available.
- DOC SEQ
- Displays the document sequence number.
- TC
- Displays the Uniform Statewide Accounting System (USAS) transaction code.
- AY
- Displays the appropriation year.
- PCA
- Displays the program cost account.
- INDEX
- Displays the index, when available.
- COMP OBJ
- Displays the comptroller object code.
- AGY OBJ
- Displays the agency object code, when available.
- FUND
- Displays the USAS fund number where the agency’s funds were posted.
- TRANSACTION AMOUNT
- Displays the net amount of the direct deposit payment.
- REV IND
- Displays an R when available.
- ERR IND
- Displays a Y only if there was an error with the batch.
- REPORT SUMMARY
- Displays the following summary information:
- Payment total amount for each payment category.
- Number of payments on the report per payment category.
- USAS transaction count.
- Grand total amount of funds received for the agency.
- Grand total count of payments returned for the agency.
- Grand total USAS count.