USPS Reports Guide –
USPS Reports by Number –
Report 010 Payroll and Deduction Register
This report displays detailed pay and deduction (gross to net) information on each employee scheduled to be paid on the current payroll along with their current year-to-date values. An employee count is also included.
Report Criteria
| Category | Payroll Administration | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Distribution | Agency | ||||||||||||
| Frequency | Runs with payroll. | ||||||||||||
| Form | 111 | ||||||||||||
| Sort Sequence |
|
||||||||||||
| Page Break | |||||||||||||
| Parameters | |||||||||||||
| Databases Used | H0C, H0H, H0B, H0W, H0M, H0Z, H0V, H10 | ||||||||||||
| Selection Criteria | Regular payroll:
Supplemental payroll: all employees on payroll. |
||||||||||||
| Produce Output? | Yes | ||||||||||||
| Request Screen | HPRPT – Set up to run automatically with each payroll.
HNKPA – To request a summary only. |
||||||||||||
| Posting Report? | No | ||||||||||||
| Additional Notes | ** EDIT/REPORT RUN ** will display in the top left corner 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 hand corner.
YTD TOTALS are only impacted by final payrolls. This report will produce company totals only (no employee detail) if the Report 010 summary field on HNKPA contains a value of Y. |
Report Headings
- DIV OFC SEC SEC HNP.ORGCODE
- Displays the organization code as defined by the employee's position. The title of this field can be renamed by using the short break NAME field on H0CCN.
- RATE/AMT HMP.SALARY/HMP.HRLSALRATE
- Displays the employee's pay period salary or hourly rate.
- CUR REG H0H.REG
- Displays the employee's amount of regular pay for the payroll.
- CUR O/T H0H.OTIME1, H0H.OTIME2
- Displays the amount of overtime pay for the payroll.
- CUR GROSS H0H.GROSS
- Displays the gross pay for this payroll. Includes all cash and non-cash pays.
- CUR FED TAX H0H.FITTAX
- Displays federal withholding tax.
- CUR OASDI TAX H0H.OASDITAX
- Displays OASDI (Old Age, Survivors, Disability Insurance) tax.
- CUR HI TAX H0H.HITAX
- Displays Medicare tax.
- CUR TOT DED H0H.VOLDED
- Displays total other deductions (not including tax).
- NET PAY H0H.NET
- Displays the employee's take-home pay after all deductions have been taken. A direct deposit to a checking account is considered net pay.
Note: Zero Net will print if the employee has a savings deduction taking 100 percent of the net pay or when there is no pay being paid (for example, an adjustment).
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- YTD REG H0B.YREGPAY
- Displays the year-to-date regular salary.
- YTD O/T H0B.YOT1PAY, H0B.YOT2PAY
- Displays the year-to-date overtime pay.
- YTD GROSS H0B.YGROSSPAY
- Displays the year-to-date gross pay including all cash and non-cash pays.
- YTD FED TAX H0B.YFIT
- Displays the year-to-date federal withholding tax.
- YTD OASDI TAX H0B.YOASDI
- Displays the year-to-date OASDI tax.
- YTD HI TAX H0B.YHITAX
- Displays the year-to-date Medicare tax.
- YTD TOT DED H0B.YVOLDED
- Displays the year-to-date total employee deductions.
- CHECK DT H0H.CHKDATE
- Displays the issue date of the payment.
- EMP NUMBER H0B.EMPLOYEENO
- Displays the employee's SSN.
- SSN H0B.EMPLOYEENO
- Displays the employee's SSN.
- ES H0B.EMPSTATUS
- Displays the employment status for this employee.
- CUR REG HOURS H0H.REGULARHRS
- Displays the regular hours for the payroll.
- CUR O/T HOURS H0H.OT1HRS, H0H.OT2HRS
- Displays the number of actual O/T hours for the payroll.
- FS H0B.MSTATUS
- Displays the employee's filing status code for FIT calculation purposes.
- RESIDENT EX H0B.FITNOEXPEMP
- Displays the employee's number of exemptions for FIT calculation purposes.
- RESIDENT ST H0B.RESSTATE
- Displays the state tax code of the employee's residence.
- RESIDENT LOC H0B.RESLOCAL
- Displays the local tax code of the employee's residence if needed.
- WORK ST H0B.STATE01
- Displays the state tax code of the employee's work.
- WORK LOC H0B.LOCAL01
- Displays the local tax code of the employee's work.
- TD SICK – VAC
- Not used.
- NET CHECK DERIVED
- Displays net amount of the warrant.
Note: For employees with a savings deduction taking 100 percent of the net, this amount will be ZERO.
- CHECK NO H0H.CHECKNO
- Displays the warrant or direct deposit advice number.
Note: Trial and edit payroll runs will display all 8's instead of a warrant or direct deposit number.
- GRAND-TOTALS DERIVED
- The remainder of the fields display current and year-to-date information for specific deduction, taxes and special pays. The last two pages reflect summary information by totals.
Sample Report
REPORT: 10 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAYROLL AND DEDUCTION REGISTER RUN TIME: 14:12:45
DIV OFC SEC SEC RATE/AMT CUR REG O/T GROSS FED TAX OASDI TAX HI TAX TOT DED NET PAY
EMPLOYEE NAME YTD RESIDENT WORK CHECK DT
EMP NUMBER SSN ES ----HOURS---- FS EX ST LOC ST LOC (TD SICK - VAC) NET CHECK CHECK NO
------------------------------------------------------------------------------------------------------------------------------------
NON PD UPDT
000 041 100 00 4619.37 1000.00 .00 1000.00 600.00 .00 .00 400.00 ZERO NET
XXXXXX,XXX 5619.37 .00 5767.00 955.05 195.11 67.36 1377.50 0 1/03/20XX
742667 1 XXX-XX-XXXX 01 .00 .00 2 1 44 0 44 0 .00 .00 .00 110555489
1000.00 REGULAR
ST OASDI ST HI TAX STATE TAX LOCAL TAX DI LONGEVTY IMPUTED ERS RET STRETIRE ADD FLEX
CUR 62.00 14.50 .00 .00 .00 .00 .00 400.00 .00 .00
YTD 350.03 81.86 .00 .00 .00 60.00 87.63 704.16 325.22 4.00
OPTLFLEX DEP LIFE 401K CHARITYS CHECKING
CUR .00 .00 .00 .00 .00
YTD 117.42 1.38 535.54 15.00 3084.35
------------------------------------------------------------------------------------------------------------------------------------
REPORT: 10 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 2
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAYROLL AND DEDUCTION REGISTER RUN TIME: 14:12:45
GRAND-TOTALS
GROSS PAY REGULAR PAY REGULAR HOURS OVERTIME PAY FEDERAL TAX OASDI TAX HI TAX STATE TAX
CUR 3000.00 3000.00 .00 .00 1800.00 42.00 14.50 .00
YTD 7767.00 7619.37 184.00 .00 2155.05 237.11 81.86 .00
NET PAY DI TOTAL DEDUCT LOCAL TAX OVERTIME HR VACATION BONUS PAY PENSION PAY
CUR .00 .00 1143.50 .00 .00 .00 .00 .00
YTD 3084.35 .00 2121.00 .00 .00 .00 .00 .00
SICK PAY ST OASDI ST HI TAX LONGEVTY IMPUTED ERS RET STRETIRE ADD FLEX
CUR .00 186.00 43.50 .00 .00 1143.50 .00 .00
YTD .00 474.03 110.86 60.00 87.63 1447.66 325.22 4.00
OPTLFLEX DEP LIFE 401K CHARITYS CHECKING
CUR .00 .00 .00 .00 .00
YTD 117.42 1.38 535.54 15.00 3084.35
EMPLOYEE COUNT 2