USPS Reports Guide –
USPS Reports by Number –
Report 945 Reconciliation of Single Direct Deposit Transaction to USAS
This report displays addenda information for employees for whom:
- previously held negative-balance deductions are released (transactions are generated to USAS when the balance for the rollup key becomes non-negative) or
- deductions in the current document are "held" on the Addenda table (this includes transactions held because the balance for the rollup key is negative).
Note: This report relates only to child support payments processed to the Texas State Disbursement Unit (TxSDU).
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Produced with each successful final payroll with held or released addenda transactions |
| Form | N/A |
| Sort Sequence | By vendor, case identification (Case ID) and cause number (Cause No) |
| Page Break | Agency, Document, SSN |
| Parameters | N/A |
| Databases Used | HID, H0C, HQS |
| Selection Criteria | N/A |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Automatically runs with payrolls. |
| Produce Report? | No |
| Additional Notes |
Report Headings
- DOCUMENT NO
- Displays the payroll document number that caused the previously held negative transactions to be released and/or the payroll document where negative transactions were held.
Section 1
- DETAIL OF PREVIOUSLY HELD TRANSACTIONS RELEASED
- This section of the reconciliation report will list each employee for whom previously held transactions have been released from the addenda table to USAS suspense with the document number displayed at the top of the report.
Note: This section will only display when previously held transactions are released.
- UNPAID PRIOR TRANSACTIONS – USAS SUSPENSE PREVIOUSLY UPDATED
- Displays a list of all transactions that were sent to the USAS suspense file and are pending payment. These transactions in USPS represent payments with a status of P that are pending payment. This section will include the original document number, process date, INRECS document number, payment date and deduction amount.
Note: This section will only display when unpaid (status P) transactions for the rollup key exist. When no status P transactions are found, the TOTAL USAS SUSPENSE AMOUNT TO DATE will display with a zero amount in the TOTAL NET OFFSET/PAYBLE column.
- UNPAID PRIOR TRANSACTIONS – USAS SUSPENSE NOT YET UPDATED
- Displays a list of all previously processed transactions that have not yet updated USAS because they are negative. These transactions in USPS represent payments with a status of A that have not yet updated USAS. These transactions can be reviewed on the Addenda Record Vendor Summary – Held SDD Vendor Transactions – Status 'A' Only (HQVND) screen.
- CURRENT TRANSACTIONS
- Displays information for the employee that occurred on the most recent document processed. This detail is activity from the document number displayed at the top of the report. This section includes the original document number, process date, INREC document number, payment date and deduction amount.
- TOTAL OFFSET TO SUSPENSE FOR THIS ACCOUNT/DOCUMENT
- Displays the sum of the (Unpaid Prior Transactions – USAS Suspense Previously Updated) and Current Transactions.
- TOTAL AMOUNT PAYABLE TO VENDOR FOR THIS ACCOUNT
- Displays the sum of the (Total USAS Suspense Amount to Date) + (Total Offset to Suspense for this Account/Document).
Section 2 (Displays only when transactions from the current document are 'held')
- DETAIL OF NEGATIVE-BALANCE TRANSACTIONS NOT SENT TO USAS – AMOUNT DUE TO VENDOR IS NEGATIVE
- Displays information by employee where transactions have been written to the addenda record transaction list (HQEMP) with the current document that have not yet been sent to USAS suspense. This section will include the employee number (SSN), name, vendor number, vendor name, case identification and cause number.
- UNPAID PRIOR TRANSACTIONS – USAS SUSPENSE PREVIOUSLY UPDATED
- Displays information by employee for all transactions that have been sent to USAS for payments to be processed with the appropriate payment date.
Note: This section will only display when unpaid (status P) transactions for the rollup key exist. When no status P transactions are found, the TOTAL USAS SUSPENSE AMOUNT TO DATE will display with a zero amount in the TOTAL NET OFFSET/PAYBLE column.
- UNPAID PRIOR TRANSACTIONS – USAS NOT YET UPDATED
- Displays information by employee for all transactions where the document processing this group of transactions was accepted to USAS but the sum total of the transactions are negative and held on the addenda table. These can be viewed on the Addenda Record Vendor Summary – Held SDD Vendor Transactions – Status 'A' Only (HQVND) screen.
- CURRENT TRANSACTIONS
- Displays a list of all transactions from the current document where the USAS suspense transactions will not be generated due to a negative balance for the rollup key.
- TOTAL AMOUNT HELD FOR THIS ACCOUNT
- Displays the sum of the (Total Prior Held Amount To Date) + (the Total Current Amount Held for this Account/Document) under the column titled Total Net Offset/Payable.
- TOTAL AMOUNT PAYABLE TO VENDOR FOR THIS ACCOUNT
- Displays the sum of the (Total USAS Suspense Amount to Date) plus (the Total Amount Held for this Account) under the column titled Total Net Offset/Payable.
Section 3 (Displays each time the report is produced)
- SUMMARY OF USAS OFFSET ACTIVITY
- Displays the summary level detail for single direct deposit transaction activity for the final payroll processed by document number.
- TOTAL DEDUCTIONS PROCESSED/ADDED TO DETAIL :
- Display a total of all deductions that were successfully processed with the original document number and added to the USPS addenda table.
- LESS EXISTING NEGATIVE AMOUNTS RELEASED :
- Displays a total of all amounts previously held for negative balances that are being released to USAS suspense.
- PLUS CURRENT NEGATIVE AMOUNTS NOT SENT TO USAS :
- Displays the total amounts processed with the current document that will be held for negative balances on the USPS Addenda table.
- EQUALS OFFSET AMOUNT SENT TO USAS:
- Displays the sum: (total processed) minus (existing negative released transactions) plus (current negative not sent to USAS) plus or minus (manual cancellations processed through a Letter of Authorization process).
Sample Report
REPORT: 945 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
RECONCILIATION OF SINGLE DIRECT DEPOSIT TRANSACTIONS TO USAS RUN TIME: 15:24:18
DOCUMENT NO: 88116FFF
DETAIL OF NEGATIVE-BALANCE TRANSACTIONS NOT SENT TO USAS - AMOUNT DUE VENDOR IS NEGATIVE
EMPLOYEE NO NAME VENDOR NO VENDOR NAME CASE ID CAUSE NO
XXX-XX-XXXX XXXXXXX XX, XXXXXX X XXXXXXXXXXXXXX TXCSDU XXXXXXX XXXXXXXXXX
PAYABLE PRIOR DED DEDS HELD; TOTAL NET
TO VEND PREV SENT BAL DUE VN OFFSET/
TO SUSP IS NEGATIVE PAYABLE
UNPAID PRIOR TRANSACTIONS - USAS SUSPENSE PREVIOUSLY UPDATED
ORIG PROCESS DT INRECS PMT DATE
DOC NO DOC NO
88116DDD 11/16/20XX 88116DDD 12/19/20XX 10.00 10.00
TOTAL USAS SUSPENSE AMOUNT TO DATE 10.00
UNPAID PRIOR TRANSACTIONS - USAS SUSPENSE NOT YET UPDATED
ORIG PROCESS DT PMT DATE
DOC NO
88116EEE 11/16/20XX 12/19/20XX -20.00 -20.00
CURRENT TRANSACTIONS
ORIG PROCESS DT PMT DATE
DOC NO
88116FFF 11/18/20XX 12/19/20XX 5.00 5.00
TOTAL AMOUNT HELD FOR THIS ACCOUNT 5.00
TOTAL AMOUNT PAYABLE TO VENDOR FOR THIS ACCOUNT -5.00
REPORT: 945 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
RECONCILIATION OF SINGLE DIRECT DEPOSIT TRANSACTIONS TO USAS RUN TIME: 15:24:18
DOCUMENT NO: 88116FFF
SUMMARY OF USAS OFFSET ACTIVITY
TOTAL DEDUCTIONS PROCESSED/ADDED TO DETAIL : 11.00
LESS EXISTING NEGATIVE AMOUNTS RELEASED : 0.00
PLUS CURRENT NEGATIVE AMOUNTS NOT SENT TO USAS : -11.00
EQUALS OFFSET AMOUNT SENT TO USAS : 0.00