USPS Reports Guide –
USPS Reports by Number –
Report 185 Pay Period Summary Totals
This report displays payroll summary totals by document number within fund number. A cancellation is identified by the Backout Flag on H0HHP being greater than zero.
Report Criteria
| Category | Payroll Administration | ||||
|---|---|---|---|---|---|
| Distribution | Agency | ||||
| Frequency | Upon Request. Runs with payroll. | ||||
| Form | 111 | ||||
| Sort Sequence |
|
||||
| Page Break | |||||
| Parameters | HNKPA – START DATE, END DATE HSRPQ – WARRANT DATES |
||||
| Databases Used | H0C, HNK, H0H, H0M, HID, H0B, HN1, HMS | ||||
| Selection Criteria | All records on the current payroll or all records with warrant dates within the range specified on HSRPQ and pay period dates within the range specified HNKPA. | ||||
| Produce Output? | Yes | ||||
| Request Screen | HSRPQ; HPRPT – Set up to run automatically with each payroll and with Quarter-End Reports. | ||||
| Posting Report? | No | ||||
| Additional Notes | Call your USPS representative when ready to run Quarter-End Reports. This report can be very useful in quarterly reconciliations (Form 941), as well as annual W-2 reconciliations. The amount in EMP MED reflects the total 1.45 percent Medicare Tax and the .9 percent Additional Medicare Tax that was deducted from the employee’s payroll. HP6TX separates the tax amounts and can be useful for reconciling after a final payroll has processed. ** EDIT/REPORT RUN ** will display in the top left corner of the report if the report was produced from a trial/edit payroll. This report will generate twice only when a final payroll is rejected. Use the latest RUN TIME/DATE, which is found in the top right corner of the report. |
Report Headings
- PAY PERIOD DATES FROM/THRU HNK.RPTSDT/HNK.RPTEDT
- Displays the pay period date ranges selected.
- FUND H0H.ALPHACONS2
- Displays the USAS fund number from which the payment is being posted.
- GROSS PAY DERIVED FROM H1TZZ (TABLE 978) AND H0H.GROSS
- Displays the total amount of all the employee's gross wages. Imputed income and non-cash items are not included in this figure.
- FIT TXBL H0H.FEDTXBL
- Displays the amount of payroll wages that were taxable for federal income tax (FIT).
- FIT NTXBL H0H.GROSS – H0H.FEDTXBL
- Displays the amount of payroll wages that were not taxable for FIT.
- FIT TAX H0H.FITTAX
- Displays the FIT tax that was deducted.
- ERS H0M.DEDAMT(5.6)
- Displays the retirement contribution for Employee's Retirement System (ERS) that was deducted.
- EMP INS H0M.DEDAMT(44-46)
- Displays the sum of short-term and long-term disability and dependent life deducted.
- FSA HLTH CARE H0M.DEDAMT(36)
- Displays the amount of TexFlex FSA health care reimbursement that was deducted.
- 401(K) H0M.DEDAMT(53)
- Displays the 401(k) contribution that was deducted.
- DOCUMENT H0H.ALPHACONS1
- Displays the USAS document number assigned to the payroll.
- OASDI TXBL H0H.OASDITXBL
- Displays the amount of payroll wages that were taxable for OASDI tax.
- OASDI NTXBL H0H.GROSS – H0H.OASDITXBL
- Displays the amount of payroll wages that were not taxable for OASDI tax.
- EMP OASDI H0H.OASDITAX
- Displays the Employee OASDI tax that was deducted.
- RET FEE H0M.DEDAMT(4)
- Displays the annual retirement fee that was posted.
- PREM CONV H0M.DEDAMT(30-35)
- Displays the sum total of all AD&D, dental, employee health insurance, optional life, tobacco and vision that was deducted.
- FSA DAY CARE H0M.DEDAMT(37)
- Displays the amount of the FSA day care reimbursement that was deducted.
- 457 H0M.DEDAMT(54)
- Displays the 457 contribution that was deducted.
- WARRANT DATE H0H.CHKDATE
- Displays the payment date.
- MED TXBL H0H.HITXBL
- Displays the amount of payroll wages that were taxable for HI/Medicare tax.
- MED NTXBL H0H.GROSS - H0H.HITXBL
- Displays the amount of payroll wages that were not taxable for HI/Medicare tax.
- EMP MED H0H.HITAX
- Displays the Employee HI/Medicare tax that was deducted.
- ST PD RET H0M.DEDAMT(25)
- Displays the amount of state-paid retirement that was posted.
- ST PD INS H0M.DEDAMT(26)
- Displays the amount of state-paid health insurance and state-paid health savings account that was posted.
- LIMITED FLEX H0M.DEDAMT(40)
- Displays the amount of the Limited Flexible Spending account that was deducted.
- 403(B) H0M.DEDAMT(55)
- Displays the amount of 403(b) contribution that was deducted.
- # EMP PAID DERIVED
- Displays the total number of pay records included in the document, fund, or agency record listed.
- ST PHC H0M.DEDAMT(23)
- Displays the amount of agency paid payroll health insurance contribution that was posted.
- TRS/JR2 H0M.DEDAMT(7)/H0M.DEDAMT(9)
- Displays the retirement contribution for Teacher Retirement System (TRS) and Judicial Retirement System (JRS) Plan II that was deducted.
- ST OASDI H0H.OASDICOTAX
- Displays the state-paid OASDI tax.
- ST PD FEE H0M.DEDAMT(24)
- Displays the amount of state-paid annual retirement fee that was posted.
- IMP INC H0M.SPECPAY(10)
- Displays the taxable amount of life insurance over $50,000 that was posted.
- EMPLOYEE HSA H0M.DEDAMT(42)
- Displays the amount of employee health savings account that was deducted.
- OTHER DEDS DERIVED
- Displays the sum of all other deductions excluding savings.
- OOS TAX H0H.SITTAX + H0H.LOCALTAX + H0H.SPLOCTAX
- Displays the sum of all out-of-state taxes and local taxes.
- JR1/ORP/LEC H0M.DEDAMT(8)/H0M.DEDAMT(10)
- Displays the deduction amount of the retirement contribution for Judicial Retirement System (JRS) Plan I, Optional Retirement Plan (ORP) and Law Enforcement and Custodial Officer Supplemental (LECOS) Retirement that was deducted.
- ST MED H0H.HICOTAX
- Displays the state-paid HI/Medicare tax.
- ST LECOS H0M.DEDAMT(29)
- Displays the amount of state-paid LECOS.
- ST PRC H0M.DEDAMT (22)
- Displays the amount of agency paid retirement contributions that was posted.
- OPT-OUT H0M.DEDAMT(28)
- Displays the state credit for opt-out.
- TOTAL DERIVED
- Displays the total of each field for each document, fund, and agency record listed.
Sample Report
REPORT: 185 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAY PERIOD SUMMARY TOTALS RUN TIME: 11:49:26
PAY PERIOD DATES FROM 07/01/20XX THRU 07/31/20XX
------------------------------------------------------------------------------------------------------------------------------------
FUND GROSS PAY FIT TXBL FIT NTXBL FIT TAX ERS EMP INS FSA HLTH CARE 401(K)
DOCUMENT OASDI TXBL OASDI NTXBL EMP OASDI RET FEE PREM CONV FSA DAY CARE 457
WARRANT DATE MED TXBL MED NTXBL EMP MED ST PD RET ST PD INS LIMITED FLEX 403(B)
# EMP PAID ST PHC TRS / JR2 ST OASDI ST PD FEE IMP INC EMPLOYEE HSA OTHER DEDS
OOS TAX JR1/ORP/LEC ST MED ST LECOS ST PRC OPT OUT
------------------------------------------------------------------------------------------------------------------------------------
0001 21,008.00 18,079.08 2,928.92 3,653.12 1,365.52 5.52 400.00 982.12
XXXXXXXX 20,426.72 581.28 857.93 0.00 181.28 0.00 0.00
07/15/20XX 20,426.72 581.28 296.19 1,460.04 0.00 0.00 0.00
1 207.68 0.00 1,266.46 0.00 0.00 0.00 0.00
0.00 0.00 296.19 0.00 0.00 32.32
0001 TOTAL 21,008.00 18,079.08 2,928.92 3,653.12 1,365.52 5.52 400.00 982.12
20,426.72 581.28 857.93 0.00 181.28 0.00 0.00
20,426.72 581.28 296.19 1,460.04 0.00 0.00 0.00
1 207.68 0.00 1,266.46 0.00 0.00 0.00 0.00
0.00 0.00 296.19 0.00 0.00 32.32
====================================================================================================================================
5025 88,221.41 79,753.24 8,468.17 14,459.49 3,355.61 70.20 500.00 0.00
XXXXXXXX 56,376.37 31,845.04 2,367.81 0.00 1,967.16 0.00 2,645.40
07/15/20XX 85,754.25 2,467.16 1,243.44 3,587.93 5,662.11 0.00 0.00
3 205.05 0.00 3,495.33 0.00 0.00 0.00 30.00
0.00 0.00 1,243.44 0.00 0.00 0.00
5025 TOTAL 88,221.41 79,753.24 8,468.17 14,459.49 3,355.61 70.20 500.00 0.00
56,376.37 31,845.04 2,367.81 0.00 1,967.16 0.00 2,645.40
85,754.25 2,467.16 1,243.44 3,587.93 5,662.11 0.00 0.00
3 205.05 0.00 3,495.33 0.00 0.00 0.00 30.00
0.00 0.00 1,243.44 0.00 0.00 0.00
====================================================================================================================================
AGENCY TOTAL 109,229.41 97,832.32 11,397.09 18,112.61 4,721.13 75.72 900.00 982.12
76,803.09 32,426.32 3,225.74 0.00 2,148.44 0.00 2,645.40
106,180.97 3,048.44 1,539.63 5,047.97 5,662.11 0.00 0.00
4 412.73 0.00 4,761.79 0.00 0.00 0.00 30.00
0.00 0.00 1,539.63 0.00 0.00 32.32