Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 039 Tax Liability Report

This report displays the tax and tax liability payable to the federal government, broken down by individual documents. Cancellations will appear with the document where it was canceled and with the document where it was issued. Payments canceled from a prior document appear under PREVIOUS DOCUMENT ADJUSTMENTS with the cancellation date. Payments canceled on other documents appear under Document Adjustments with the cancellation date. This will result in a single cancellation appearing under both PREVIOUS DOCUMENT ADJUSTMENTS and DOCUMENT ADJUSTMENTS. Imputed income generated from Month-End Reports will also appear on this report. See Report 558 for details.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Quarterly
Form 111
Sort Sequence
Options H0XCR Sort
Document Number, Warrant Date 900
Page Break Document
Parameters HNKPA – QTD START DATE, QTD END DATE
HSRPQ – WARRANT DATES
Databases Used H0B, H0H, HID, H0C, HNK
Selection Criteria All payrolls with tax and tax liabilities within date range requested.
Produce Output? Yes
Request Screen HSRPQ; HPRPT – Set up to run automatically with Quarter-End Report.
Posting Report? No
Additional Notes Call your USPS representative when ready to run Quarter-End Reports.

Report Headings

FROM/THRU HNK.QTDSTDT/HNK.QTDEDT
Displays the reporting period's beginning and ending pay dates.
DOCUMENT H0H.ALPHACO1
Displays the USAS document number assigned to the payroll. The date of the document or cancellation will appear below the document number. History transactions built due to generated imputed income will display only an * in this field.
EMPLOYEE SSN H0H.EMPLOYEENO
Displays the employee's SSN.
FED TAXBL H0H.FEDTXBL
Displays taxable wages used to compute federal income tax.
OASDI TAXABLE H0H.OASDITXBL
Displays taxable wages used to compute OASDI (Old Age Survivor's Disability Insurance).
ER OASDI WHLD H0H.OASDICOTAX
Displays the employer-paid portion of OASDI. This amount is not used for tax deposits; it is used for employer liability.
MED TAXABLE H0H.HITXBL
Displays the taxable wages used to compute Medicare.
ER MED WITHHLD H0H.HICOTAX
Displays the employer-paid portion of Medicare. This amount is not used for tax deposits; it is used for employer liability.
TOTAL LIABILITY DERIVED FROM H0H
Displays the sum of all withholdings for that specific payment number.
PAYMENT NO. H0H.CHECKNO
Displays the term Payments, unless displaying a payment cancellation, then the warrant or direct deposit number assigned to the payment cancellation will appear.
FED WITHHELD H0H.FITTAX
Displays the amount of federal income tax withheld.
EE OASDI WHLD H0H.OASDITAX
Displays the amount of OASDI taxes withheld from the employee.
EE MED WITHHLD H0H.HITAX
Displays the amount of Medicare taxes withheld from the employee.
DOCUMENT ADJUSTMENTS DERIVED
Displays the adjustments from the current period.
PREVIOUS DOCUMENT ADJUSTMENTS DERIVED
Displays the adjustments for a prior period, processed on this document.
TOTAL DOC. ADJUSTMENTS DERIVED
Displays the total adjustments for the current period.
TOTAL ADJUSTED DOC DERIVED
Displays the total tax and tax liabilities, including any cancellations.

Note: Previous document adjustments reduce the document totals for the document that was used to process the adjustments. The document totals do not reflect subsequent adjustments because they occurred on a document processed after the original document was run.

Sample Report

REPORT:    39                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     6    
    AGENCY:   XXX                                   XXXXXXXXXXX XXXXXXXXX XXXXXXX                                RUN DATE: XX/XX/20XX
                                                         TAX LIABILITY REPORT                                    RUN TIME: 21:30:29 
                                                   FROM 01/01/20XX THRU 03/31/20XX
                                                  
  DOCUMENT   EMPLOYEE SSN  FED TAXBL        OASDI TAXABLE    ER OASDI WHLD    MED TAXABLE     ER MED WITHHLD   TOTAL LIABILITY     
             PAYMENT NO.   FED WITHHELD                      EE OASDI WHLD                    EE MED WITHHLD                       
                                                                                                                                    
  95024FR1   PAYMENTS           80,576.19        86,915.95         5,388.72        86,915.95         1,260.28                       
  03/01/20XX                     8,602.29                          5,388.72                          1,260.28        21,900.29