FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
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 HØXCR Sort
Document Number, Warrant Date
900
Page Break Document
Parameters HNKPA – QTD START DATE, QTD END DATE
HSRPQ – WARRANT DATES
Databases Used HØB, HØH, HID, HØC, 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 HØH.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 HØH.EMPLOYEENO
Displays the employee's SSN.
FED TAXBL HØH.FEDTXBL
Displays taxable wages used to compute federal income tax.
OASDI TAXABLE HØH.OASDITXBL
Displays taxable wages used to compute OASDI (Old Age Survivor's Disability Insurance).
ER OASDI WHLD HØH.OASDICOTAX
Displays the employer-paid portion of OASDI. This amount is not used for tax deposits; it is used for employer liability.
MED TAXABLE HØH.HITXBL
Displays the taxable wages used to compute Medicare.
ER MED WITHHLD HØH.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 HØH
Displays the sum of all withholdings for that specific payment number.
PAYMENT NO. HØH.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 HØH.FITTAX
Displays the amount of federal income tax withheld.
EE OASDI WHLD HØH.OASDITAX
Displays the amount of OASDI taxes withheld from the employee.
EE MED WITHHLD HØH.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       
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy