USPS Reports Guide –
USPS Reports by Number –
Report 995 USAS/USPS Balancing Report
This report displays payroll data from USAS and USPS by document and fund so any variances between amounts processed through the two systems can be researched.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Produced with each successful final payroll |
| Form | N/A |
| Sort Sequence | Agency, Document, Fund |
| Page Break | Agency Fund |
| Parameters | N/A |
| Databases Used | N/A |
| Selection Criteria | N/A |
| Produce Output? | Yes |
| Request Screen | Not requestable by agencies, runs automatically with payroll |
| Posting Report? | No |
| Additional Notes |
Report Headings
- DOCUMENT
- Displays the payroll document number.
- AGENCY FUND
- Displays the agency fund number.
- USAS TOTALS
- Section displaying totals for payroll transactions processed through USAS.
- USPS TOTALS
- Section displaying totals for transactions processed through USPS.
- VARIANCE
- Section displaying total variances (differences) between transactions processed through USPS and USAS.
- FUND IMPACT FOR WARRANTS ISSUED
- Displays the net effect (fund impact) of warrants issued and canceled for USAS and USPS.
- CANCELLATIONS
- Displays vendor and amount for each warrant cancellation.
- DIFFERENCE BETWEEN NET WARRANT ISSUES AND THE TREASURY EXTRACT
- Displays amount of USPS cancellations required to reconcile USPS payroll history to Treasury warrant issues.
- TOTAL USPS WARRANTS ISSUED/WARRANTS ISSUED
- Displays the sum of warrants issued based on USAS and USPS data.
- DIRECT DEPOSIT
- Displays total amount of payments by direct deposit for the document and fund.
- CALLBACKS OR RETURNED MONEY
- Displays vendor number and amount for each callback or employee returned money transaction from USAS and USPS.
- TRANSACTIONS HELD ON IT
- Displays vendor number and amount for each transaction from this document that has been suspended on the USAS IT file, with a total of held transactions. These transactions have not been written to USAS history.
- TRANSACTIONS HELD ON ADDENDA TABLE
- Displays the sum of all transactions per vendor from this document that have been held on the Addenda table for negative balances for an employee.
- TRANSACTIONS RELEASED FROM ADDENDA TABLE (CURRENT DOCUMENT)
- Displays the sum by vendor of all previously held addenda records being released to USAS with this document.
- DED NET OF HELD IT TRANS/DED NET HLD/RLS
- Row displaying total USAS charges recorded to history and total USPS deductions; note that employee net pay is included as a deduction for the purposes of this total. Since deductions plus employee net pay equals total charges from the payroll, the amounts reported for USAS and USPS should agree when all the payroll transactions post to USAS history.
- GROSS
- Displays gross payroll charges for this document and fund for USAS and USPS.
- DEDUCTION TRANSACTIONS RELEASED FOR AGENCY XXX
- A separate section, by agency, displaying each previously held deduction transaction being written to USAS history. These are amounts affecting payment to deduction vendors that were previously suspended to the USAS IT file because the amount payable to the vendor was negative. Positive amounts for these vendors were included with the current payroll, creating an amount payable to the vendor greater than or equal to zero. The previously held negative amounts will reduce the expected payments to these vendors from the current payroll document.
Sample Report
REPORT: 995 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
USAS / USPS BALANCING REPORT RUN TIME: 13:27:40
DOCUMENT 89016RPT
AGENCY FUND 0001
USAS TOTALS USPS TOTALS VARIANCE
----------------------------------------------------------- ----------------------------------- ------------------
FUND IMPACT FOR WARRANTS ISSUED 0.00 FUND IMPACT 0.00 0.00
CANCELLATIONS DIFFERENCE BETWEEN
USPS NET WARRANT ISSUES
----VENDOR----- WARR. NO. REF DOC. AMOUNT AND THE TREASURY EXTRACT
-----------------
TOTAL 0.00 0.00 0.00
TOTAL USPS WARRANTS ISSUED 0.00 WARRANTS ISSUED 0.00
(TREASURY EXTRACT)
DIRECT DEPOSIT 622.89 DIRECT DEPOSIT 622.89 0.00
CALLBACKS OR RETURNED MONEY CALLBACKS OR RETURNED MONEY
----VENDOR----- AMOUNT
XXXXXXXXXXX PR1 1,199.21-
-----------------
TOTAL 1,199.21- 1,199.21- 0.00
TRANSACTIONS HELD ON IT
----VENDOR----- AMOUNT
XXXXXXXXXXX X01 130.32-
XXXXXXXXXXX X01 157.31-
XXXXXXXXXXX 001 49.20-
XXXXXXXXXXX 002 3.22-
XXXXXXXXXXX 023 52.89-
-----------------
TOTAL 392.94-
TRANSACTIONS HELD ON ADDENDA TABLE
----VENDOR----- AMOUNT
XXXXXXXXXXX 001 200.00
-----------------
TOTAL 200.00
TRANSACTIONS RELEASED FROM ADDENDA TABLE (CURRENT DOCUMENT)
----VENDOR----- AMOUNT
XXXXXXXXXXX 001 22.00-
XXXXXXXXXXX 002 200.00-
-----------------
TOTAL 222.00-
DED NET OF HELD IT TRANS 383.73- DED NET HLD/RLS 383.73- 0.00
G R O S S ----> 960.05- G R O S S ----> 960.05-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DEDUCT TRANSACTIONS RELEASED FOR AGENCY XXX
-------------------------------------------
(THESE VENDORS HAD THEIR PAYMENTS REDUCED)
DOCUMENT ----VENDOR----- AMOUNT
88046FS2 XXXXXXXXXXX X01 246.58-
88046FS2 XXXXXXXXXXX 001 482.95-
88046FS2 XXXXXXXXXXX X01 84.70-
88046FS2 XXXXXXXXXXX 001 56.25-
88046FS2 XXXXXXXXXXX 023 60.46-
-----------------
TOTAL 930.94-