Reversal/Reclamation Reports
SWA6100B: Rejected Reversals/Reclamations, Returned Money Items
Overview
SWA6100B is a series of reports generated for each agency that receives funds due to rejected direct deposit reversal and reclamation requests and returned money items.
Purpose
The SWA6100B series of reports serves as notification to the agencies of their direct deposit reversal and reclamation requests that are rejected, as well as payments that are automatically returned by the payees’ financial institutions. This series of reports includes the following two subreports:
- SWA6100B-REJ – Rejected Reversal/Reclamation Report provides the payment detail and the reasons the reversal and reclamation requests were rejected.
- SWA6100B-RM – Returned Money Items Detail Report provides the payment details and reasons the payees’ financial institutions returned the payment. The report provides a breakdown by 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 rejected direct deposit reversal and reclamation requests and returned money items.
Sample of SWA6100B-REJ
SWA6100B-REJ TEXAS COMPTROLLER OF PUBLIC ACCOUNTS 123 PAGE 1 DATE MM/DD/YYYY REJECTED REVERSAL/RECLAMATION REPORT PROCESS DATE MM/DD/YYYY AGENCY: 123 – STATE STORES COMMISSION OF TEXAS REJECTED REVERSALS/RECLAMATIONS ------------------------------------------------------------------------------------------------------------------------------------ TIN MC PAYMENT ISSUE ORIGINAL ISS ROUTING ACCOUNT ACCT NAME NUMBER DATE DOCUMENT AMOUNT AGY NUMBER NUMBER TYPE RETURN REASON ------------------------------------------------------------------------------------------------------------------------------------ 7XXXXXXXX1 001 1234567 MM/DD/YYYY $200.00 123 1XXXXXXX9 XXXXXXXX1234 CHK R01 INSUFFICIENT FUNDS PAYEE NAME 1 ------------------------------------------------------------------------------------------------------------------------------------ PAYMENTS TOTAL: $200.00 NUMBER OF PAYMENTS: 1 ------------------------------------------------------------------------------------------------------------------------------------ GRAND TOTAL AMOUNT: $200.00 GRAND TOTAL COUNT: 1 ----------------------------------------------------------------------
Field Descriptions
- REPORT NUMBER
- Displays the unique report number, SWA6100B-REJ.
- 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.
- REPORT SUBTITLE
- Displays the subtitle name of the report, Rejected Reversals/Reclamations.
- TIN/NAME
- Displays the 11-digit 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.
- ORIGINAL DOCUMENT
- Not applicable.
- AMOUNT
- Displays the amount of the direct deposit payment.
- ISS AGY
- Displays the three-digit agency number.
- ROUTING NUMBER
- Displays the payee’s routing number from the financial institution that returned the payment.
- ACCOUNT NUMBER
- Displays the payee’s account number when the payment was transmitted.
- ACCOUNT TYPE
- Displays the account type as either:
- CHK = Checking.
- SAV = Savings.
- RETURN REASON
- Displays the return reason code and description.
- REPORT SUMMARY
- Displays the following summary information:
- Payment total amount.
- Number of payments on the report.
- Grand total amount.
- Grand total count.
Sample of SWA6100B-RM
SWA6100B-RM TEXAS COMPTROLLER OF PUBLIC ACCOUNTS 123 PAGE 1 DATE MM/DD/YYYY RETURNED MONEY ITEMS DETIAL 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 BATCH NOT FOUND ------------------------------------------------------------------------------------------------------------------------------------ TIN MC PAYMENT ISSUE ORIGINAL ISS ROUTING ACCOUNT ACCT NAME NUMBER DATE DOCUMENT AMOUNT AGY NUMBER NUMBER TYPE RETURN REASON ------------------------------------------------------------------------------------------------------------------------------------ 1XXXXXXXXX6 001 1234567 MM/DD/YYYY 91234567 $200.00 123 1XXXXXX8 XXXXXX1234 CHK R23 CREDIT REFUSED BY RECEIVER VENDOR NAME 1 ------------------------------------------------------------------------------------------------------------------------------------ VENDOR PAYMENTS TOTAL: $200.00 NUMBER OF PAYMENTS: 1 ------------------------------------------------------------------------------------------------------------------------------------ GRAND TOTAL AMOUNT: $200.00 GRAND TOTAL COUNT: 1 ------------------------------------------------------------------------------------------------------------------------------------
Field Descriptions
- REPORT NUMBER
- Displays the unique report number, SWA6100B.
- 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.
- SUBREPORT TITLE
- Displays the payment category type with one of the following:
- Payroll payments.
- Annuity payments.
- Travel payments.
- Vendor payments.
- USAS 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 TIN and the name of the payee.
- MC
- Displays the three-digit mail code paid on the returned direct deposit payment.
- PAYMENT NUMBER
- Displays the original seven-digit direct deposit payment number.
- ISSUE DATE
- Displays the issue date of the direct deposit payment.
- ORIGINAL DOCUMENT
- Displays the original payment document number.
- AMOUNT
- Displays the amount of the direct deposit payment.
- ISS AGY
- Displays the three-digit agency number.
- ROUTING NUMBER
- Displays the payee’s routing number from the financial institution that returned the payment.
- ACCOUNT NUMBER
- Displays the payee’s account number when the payment was transmitted.
- ACCOUNT TYPE
- Displays the account type as either:
- CHK = Checking.
- SAV = Savings.
- RETURN REASON
- Displays the return reason code and description.
- REPORT SUMMARY
- Displays the following summary information:
- Payment total amount.
- Number of payments.
- Grand total amount.
- Grand total count.