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 |
|
||||
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