Skip to content

USPS Reports Guide
USPS Reports by Number

Report 024 Statement of Earnings

This report produces the employee's statement of earnings. It includes both current and year-to-date totals for gross pay, net pay, certain special pays, deductions and adjustments to net pay.

This report MUST be set up on HPRPT, H0XCR and HPDES for payroll processing.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with final payrolls.
Form 333
Sort Sequence
Options (H0XCR Sort): H0XCR Break 80 Sort 90 Sort
Organization Code, Employee Name (849) 0000 930 849
Organization Code, Employee Name (849) 1000 930 849
Payment Number, Organization Code, Employee Name (849) 4000 930 849
Location Code, Employee Name (934) 0000 932 934
Location Code, Payment Number, Employee Name (934) 2000 932 934
Payment Number, Location Code, Employee Name (934) 4000 932 934
Location Code, Organization Code, Employee Name (935) 0000 933 935
Location Code, Organization Code, Payment Number, Employee Name (935) 3000 933 935
Payment Number, Location Code, Organization Code, Employee Name (935) 4000 933 935

Notes: To display sub-deduction except buybacks (050) and savings bond detail, a 1 must be in the 4th position of the H0XCR Break field. This option could result in two-page earnings statements. See Report 666, after each payroll, for a list of employees this pertains to.

The sort code on H0XCR for Reports 80, and 90 must correlate with the start code for Report 24. See table for details.

Page Break Employee Number
Parameters  
Databases Used H0H, H0B, H0C, HNP, HID, HMP, H7O, H10, HNJ, HO0, H0N, HNH, H0V, H0W, H0Z, H0M, HNO
Selection Criteria All employees who received a warrant or direct deposit on the current final payroll being run.
Produce Output? Yes
Request Screen HPRPT – Set up to run automatically with each final payroll.
Posting Report? No

Report Headings

PAYROLL PERIOD H0H.PERIODEND, H0H.BEGINDATE
Displays the dates the payroll period covers.
PAYMENT NUMBER H0H.CHECKNO
Displays the warrant or direct deposit number. Warrant numbers start with the number 17 and are nine-digit numbers. Direct deposits are identified by seven-digit numbers.
PAYMENT DATE H0H.CHKDATE
Displays the date the funds will be made available to the employee.
ORGANIZATION CODE HNP.ORGCODE
Displays the organization code as defined by the employee's primary position.

Note: The organization code will be the most recent organization code for the position being paid and not necessarily the organization code valid for the pay period. For an employee paid in multiple jobs, the primary position and organization code will be indicated based on the payroll transaction dates.

PAYROLL DOC NO H0H.ALPHACONS1
Displays the USAS document number assigned to the payroll.
LOC/EXT LOC HNP.PLANTLOC/HNP.EXLOCCD
Displays the agency defined code used to identify the agency's physical location and extended location, if applicable.
EMPLOYEE'S NAME HID.FIRSTNAME, HID.MIDDLENAME, HID.LASTNAME
Displays the employee's name. (Only the initial of the middle name is intended.)
EMPLOYEE'S SOCIAL SECURITY NUMBER H0B.EMPLOYEENO
Displays the last four digits of the employee's SSN.
EMPLOYEE'S ADDRESS HIDU1
Displays the employee's address.
SINGLE/MARRIED/HEAD OF HOUSEHOLD H0B.MSTATUS
Displays the employee's filing status for federal income tax (FIT) purposes.
NO. EXEMPTIONS H0B.FITNOEXEMP
Displays the employee's number of personal exemptions for FIT calculation purposes.
ADDITIONAL AMOUNT H0B.FITEXTAMT
Displays additional FIT deducted from the employee's pay, if applicable. This field does not display if extra FIT is not requested.
STATE SVC H0B.ADJEMPLDAT (PROJECTED)
Displays the employee's total state service in years, months and days as of the end of the pay period. This is the current employment plus prior state service minus leave without pay.

Note: For employees in agency 241, this field will not display.

HAZDTY SVC H0B.SCAN, DATE01 (PROJECTED)
Displays the employee's total hazardous duty service in years, months and days as of the end of the pay period. Hazardous duty service will only display when the hazardous duty indicator at the end of the pay period is a Y or 8. When displayed, this is the current hazardous duty date plus prior hazardous duty service minus leave without pay.
ORG TITLE HNO.ORGNAME
Displays the organization title as defined by the organization code.

Note: The organization title will be the most recent organization title and not necessarily the organization title valid for the period.

PAY TBL HNH.SALTBLTYP
Displays the employee's pay table.
1A Classified Table A
1B Classified Table B
1C Classified Table C
02 Unclassified
03 Exempt
PAY GROUP HNH.POSPAYGRP
Displays the employee's pay group.
STEP HNH.ACTUALSTEP
Displays the employee's pay step, if applicable.
POS NO H0H.POSITION
Displays the employee's primary position number.
CLASS NO HNH.JOBCLASS
Displays the employee's job classification code.
SALARY CHANGE DERIVED FROM HNH.HRISREASCD AND H1TZZ (TABLE 874)
Displays employee's last salary action, if it occurred during the current pay period.
TITLE H70.JCTITLE
Displays the title for the employee's primary position assignment.
EFFECTIVE DATE HNH.HLSTINCRDT
Displays the date of the employee's last salary change. This field does not display if HNH.HLSTINCRDT is blank.
EARNINGS/CURRENT/YR-TO-DT/DEDUCT/CURRENT/YR-TO-DT DERIVED FROM H0H, H0B, H0Z, H10
Display both the employee's current and year-to-date totals for all taxes, taxables, deductions, special pays, regular wages, gross pay and net pay for the current calendar year.

Note: MISC Deduct is the total of an employee's deductions after the first 23, not including taxes. This field only exists when the H0XCR Break option to print sub-deduction and savings bond detail is not required. Wages transferred in from another state agency are included in the year-to-date totals.

HRS H0H.REGULARHRS, H0H.OT1HRS, H0M.SPECHRS
Displays the hours the employee was paid in the current pay period.
EARNINGS DISBURSEMENT: WARRANT, CHECKING, SAVINGS DERIVED
Displays the employee earnings disbursement to warrant, checking and/or savings accounts. Year-to-date amounts only display for savings disbursements.

Note: If an employee receives multiple statements of earnings during a single pay cycle, the year-to-date totals will be carried forward to all statements of earnings.

Sample Report

AGENCY   XXX                         AGENCY NAME                                            
  REPORT:    24            *** STATEMENT OF EARNINGS ***                                          
                      PAYROLL PERIOD 08/01/20XX TO 08/31/20XX                                     
                                                                                                  
                                                                                                  
                                                                                                  
                                                                                                  
                                                                                                  
                                                                                                  
                                                   PAYMENT NUMBER:  0000XXXXXXX                   
                                                   PAYMENT DATE:    09/01/20XX                    
       XXX  XXX  XXX  XX                           PAYROLL DOC NO:  89084XXX                      
       00001                                                                                      
       XXXXXXXX XXXXXXXXXXXX                       XXX-XX-XXXX                                    
       ADDRESS LINE 101                            SINGLE    NO. EXEMPTIONS:   1                  
       AUSTIN TX XXXXX                                                                            
                                                   STATE SVC:  1 YR  7 MO  0 DY                   
                                                   HZDTY SVC:  0 YR  2 MO  0 DY                   
                                                                                                  
                                                                                                  
                                                                                                  
  ORG TITLE:  ORG NAME                         PAY TBL: 1B PAY GROUP: 06 STEP:                    
  POS NO:  01234567    CLASS NO: 7464                                                             
  TITLE: ACCOUNTANT I                                                                             
                                                                                                  
  EARNINGS      HRS     CURRENT   YR-TO-DT   DEDUCT          CURRENT    YR-TO-DT                  
                                                                                                  
  REGULAR PAY  168:00   2567.16   27886.45   FED W/H TAX      357.42     3387.48                  
  1XMERIT                  0.00     400.00   OASDI TAX        222.38     1912.15                  
  LEGBONUS                 0.00    1600.00   MEDICARE TAX      52.01      447.20                  
  BRP                   1026.86    1026.86   DENTFLEX           7.22       72.20                  
  SALARY GROSS          3594.02   30913.31   ERS RET          215.64     1281.77                  
    - PREM CONV            7.22      72.20   LECOS             17.97       17.97                  
  SOC SEC GROSS         3586.80   30841.11   401K               0.00       25.16                  
  MEDICARE GROSS        3586.80   30841.11                                                        
    - RETIREMENT         233.61    1299.74                                                        
    - 401K AMT             0.00      25.16   TOT DEDUCTS      872.64     7143.93                  
  FED W/H GROSS         3353.19   29516.21                                                        
                                                                                                  
                                             EARNINGS DISBURSEMENT:                               
  TOTAL GROSS           3594.02   30913.31   CHECKING        2721.38                              
  TOTAL DEDUCTS-         872.64    7143.93                                                        
                                                                                                  
  TOTAL NET PAY         2721.38   23769.38