Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 058 Form 941 Worksheet

This report displays tax and taxable wages for the prior quarter needed to aid in the completion of Federal Form 941. A detailed listing of OASDI and Medicare tax adjustments will generate, if applicable.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Quarterly
Form 111
Sort Sequence
Options H0XCR Sort
Tax Unit, Employee Number 58
Page Break
Options H0XCR Break
Tax Unit, Agency Totals 2000
Parameters HNKPA – QTD END DATE; H0A – PRIOR QUARTER fields.
Databases Used H0C, H0B, H0A, HID, HNP, H01
Selection Criteria All employees with values in the PRIOR QUARTER fields.
Produce Output? Yes
Request Screen HPRPT – Set up to run automatically with Quarter-End Reports.
Posting Report? No
Additional Notes

Line 1 (number of employees) on this report will be calculated when the report is generated for each quarter. This number is derived from the number of employees with a figure in the prior quarter gross field on H0ATB (H0A.PQGROSS). Lines 5a, 5b, 5c, 5d, 5e and 6 are calculated values based on the Social Security and Medicare wages. These values are not necessarily the same as your tax deposits. Differences can be attributed to reversals, reissues, and rounding.

HP6TX can help with reconciliation after a final payroll has processed rather than waiting until the end of the quarter to reconcile.

Report Headings

TAX UNIT H0A.TAXUNIT
Displays the tax unit.
QUARTER ENDING HNK.QTDEDT
Displays the ending date of the quarter.
FEDERAL ID H01.FEDID
Displays the federal tax identification number.
WORKSHEET ENTRIES
Displays lines 1 through 15 of Form 941 and the associated dollars and numbers that apply to each line.

Supporting Detail for Line 7

SOC SEC NO H0B.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
REASON FOR ADJUSTMENT DERIVED
Displays the reason for the adjustment. Most are due to imputed income being posted without taxes being paid.
TAXABLE AMOUNT
Displays zero.
FICA RATE
Displays zero.
ADJUSTMENT AMOUNT DERIVED
Displays the amount of the adjustment.

Sample Report

  REPORT:    58                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
  AGENCY:   XXX                                     XXXXXXXXXXXXXXXXXXXXXXXXX                                  RUN DATE: MM/DD/YYYY
                                                        FORM 941 WORKSHEET                                     RUN TIME: 08:47:51  
                                                                                                                                   
   TAX UNIT 001                                     QUARTER ENDING 09/30/20XX                                                      
   FEDERAL ID  XX-XXXXXXX                                                                                                          
                                                                                                                                   
    LINE 1   NUMBER OF EMPLOYEES                                                                                   317
    LINE 2   TOTAL WAGES, TIPS, AND OTHER COMPENSATION          (FIT TAXABLE ONLY)                        4,468,989.75
    LINE 3   FEDERAL INCOME TAX WITHHELD                                                                    602,078.08
    LINE 4   IF NO WAGES, TIPS AND OTHER COMPENSATION ARE SUBJECT TO SOCIAL SECURITY OR MEDICARE TAX
                 CHECK THE BOX ON 941 AND SKIP TO LINE 6
    LINE 5A    TAXABLE SOCIAL SECURITY WAGES     4,600,126.24    X  .124                                    570,415.65
    LINE 5B    TAXABLE SOCIAL SECURITY TIPS                      X  .124
    LINE 5C    TAXABLE MEDICARE WAGES & TIPS     5,103,320.59    X  .029                                    147,996.30	
    LINE 5D    TAXABLE WAGES & TIPS SUBJECT TO
               ADDL MEDICARE TAX W/H                             X  .009
    LINE 5E      ADD COLUMN 2 FROM LINES 5A, 5B, 5C, AND 5D                                                 718,411.95
    LINE 5F    SECTION 3121(Q) NOTICE AND DEMAND-TAX DUE ON UNREPORTED TIPS
    LINE 6          TOTAL TAXES BEFORE ADJUSTMENTS. ADD LINES 3, 5E, AND 5F                               1,320,490.03
    LINE 7     CURRENT QUARTER'S ADJUSTMENTS FOR FRACTION OF CENTS
    LINE 8     CURRENT QUARTER'S ADJUSTMENTS FOR SICK PAY
    LINE 9     CURRENT QUARTER'S ADJUSTMENTS FOR TIPS AND GROUP-TERM LIFE INSURANCE
    LINE 10         TOTAL TAXES AFTER ADJUSTMENTS. COMBINE LINES 6 THROUGH 9
    LINE 11  QUALIFIED SMALL BUSINESS PAYROLL TAX CREDIT FOR INCREASING RESEARCH ACTIVITIES
    LINE 12  TOTAL TAXES AFTER ADJUSTMENTS AND CREDITS. SUBTRACT LINE 11 FROM LINE 10	
    LINE 13  TOTAL DEPOSITS FOR THIS QUARTER INCLUDING OVERPAYMENTS FROM PRIOR QUARTER
    LINE 14    BALANCE DUE. IF LINE 12 IS MORE THAN 13, ENTER THE DIFFERENCE
    LINE 15    OVERPAYMENT. IF LINE 13 IS MORE THAN LINE 12, ENTER THE DIFFERENCE