Skip to content

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
Options H0XCR
Sort
Employee Number, Tax Unit, State Code, Local Code O
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