USPS Reports Guide –
USPS Reports by Number –
Report 527 Employee History Out of Balance with Year-to-Date Totals
This report is a reconciliation between two USPS databases. It compares tax history from H0NT1 to the current year-to-date totals on H0ATB and H0ATC. This report is part of the period-end reporting structure, thus it can be set up on HPRPT as a month-end, quarter-end, or year-end report.
Be aware that if the report is requested ad hoc, timing issues could cause employees to show up on the discrepancy report erroneously. If the report is scheduled as part of the period-end process, H0N and H0A can be accurately compared without any timing issues to cause problems.
Report Criteria
Category | Payroll Administration | ||||
---|---|---|---|---|---|
Distribution | Agency | ||||
Frequency | Quarterly; Upon Request | ||||
Form | 111 | ||||
Sort Sequence |
|
||||
Page Break | |||||
Parameters | HNKPA – MTD END DATE / QTD END DATE / YTD END DATE | ||||
Databases Used | H0N, H0A, HNK, H0C, H0I, HID | ||||
Selection Criteria | All employees with a variance – between H0A and H0N for the year. | ||||
Produce Output? | Yes | ||||
Request Screen | HNKPA; HPRPT – Set up to run automatically with month-end reports. | ||||
Posting Report? | No | ||||
Additional Notes | Employees working in multiple states will be listed by state code. Call your USPS representative when ready to run Month-End reports. |
Report Headings
- FROM/THRU HNKPA
- Display the warrant date range used for the reporting period.
- EMPLOYEE NO H0H.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- TAX UNIT H0H.TAXUNIT
- Displays the employee's tax unit.
- STATE CODE H0N.STATECODE
- Displays the state code of the employee's primary work location.
- FIELD NAME H0A
- Displays the field name from the H0A database that has the discrepancy.
- H0A AMOUNT H0A
- Displays the amount in the H0A database.
- H0N AMOUNT H0NT1
- Displays the amount in the H0N database.
- DIFFERENCE DERIVED
- Displays the difference between the H0A amount and the H0N amount.
Sample Report
REPORT: 527 UNIFORM STATEWIDE PAYROLL/ PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX EMPLOYEE HISTORY OUT OF BALANCE WITH YEAR TO DATE TOTALS RUN TIME: 22:59:18 FROM 01/01/20XX THRU 08/04/20XX EMPLOYEE NO EMPLOYEE NAME TAX UNIT STATE CODE FIELD NAME H0A AMT H0N AMT DIFFERENCE ------------------------------------------------------------------------------------------------------------------------------------ XXX-XX-XXXX XXXX, XXXXXX X 1 44 CO OASDI .00 -22.58 22.58 COOASDITXB .00 -364.13 364.13 FIT TXBL .00 -364.13 364.13 GROSS PAY .00 -364.13 364.13 TOTAL EMPLOYEES OUT OF BALANCE = 1