USPS Reports Guide –
USPS Reports by Number –
Report 056 Quarterly Composite Tax Report
This report displays comprehensive tax information. It displays agency quarter totals and year-to-date totals. Because this report uses prior quarter accumulators, it can only be run for the most recent prior quarter.
This report breaks the information into two categories: in-state and out-of-state. The in-state category lists tax information (including federal) for employees working in the specific state. The out-of-state category lists state tax information for employees working in that state.
Report Criteria
Category | Payroll Administration | ||||
---|---|---|---|---|---|
Distribution | Agency | ||||
Frequency | Quarterly – HPRPT | ||||
Form | 111 | ||||
Sort Sequence |
|
||||
Page Break | Local Code, State Code, Country Code, Tax Unit | ||||
Parameters | HNKPA – QTD START DATE, QTD END DATE; H0A – PRIOR QUARTER fields, YEAR TO DATE fields | ||||
Databases Used | H0C, H0B, H0A, HNP, HNK, HLQ, HID | ||||
Selection Criteria | All employees with values in the PRIOR QUARTER and/or YEAR TO DATE fields on H0A. | ||||
Produce Output? | Yes | ||||
Request Screen | HPRPT – Set up to run automatically with Quarter-End Reports. | ||||
Posting Report? | No | ||||
Additional Notes | Call your USPS representative when ready to run Quarter-End Reports. |
Report Headings
- QUARTER BEGIN/TO QUARTER END HNK.QTDSTDT/HNK.QTDEDT
- Displays the pay period date ranges for the quarter.
- TAX UNIT H0A.TAXUNIT
- Displays the tax unit.
- COUNTRY CODE H0A.COUNTRY
- Displays the country code and name.
- STATE CODE H0A.STATECODE
- Displays the state code and name.
- LOCAL CODE H0A.LOCALCODE/H0A.LOCALNAME
- Displays the local code and name.
- DESCRIPTION DERIVED FROM H0A
- Displays the tax category headings broken up by Instate and Out of State.
- QUARTER ENDING DERIVED FROM H0A – PQ FIELDS
- Displays the quarter totals by tax heading.
- YEAR TO DATE DERIVED FROM H0A – Y FIELDS
- Displays the year-to-date totals by tax heading.
Note:
ADDITIONAL MEDICARE TAXABLE WAGES
is the amount over $200,000 that is taxable to the employee at the .9 percent rate.ADDITIONAL MEDICARE TAX
is the .9 percent the employee paid on taxable wages over $200,000.EMPLOYEE MEDICARE TAXABLE WAGES
is the total amount taxable to the employee at a rate of 1.45 percent.EMPLOYEE MEDICARE TAX
is the total tax the employee paid at the 1.45 percent and .9 percent rates.
Sample Report
REPORT: 56 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: MM/DD/YYYY QUARTERLY COMPOSITE TAX REPORT RUN TIME: 11:05:47 QUARTER BEGIN 01/01/20XX TO QUARTER END 03/31/20XX AGENCY TOTAL ----------DESCRIPTION------------- -------QUARTER ENDING----- --------YEAR TO DATE------ INSTATE GROSS 18,041,093.25 18,041,093.25 FIT TAXABLE WAGES 16,145,231.05 16,145,231.05 FIT NON TAXABLE WAGES 1,895,862.20 1,895,862.20 FIT TAX 3,076,404.41 3,076,404.41 EMPLOYEE OASDI TAXABLE WAGES 14,804,604.86 14,804,604.86 EMPLOYEE OASDI TAX 917,885.45 917,885.45 ADDITIONAL MEDICARE TAXABLE WAGES 761,899.56 761,899.56 ADDITIONAL MEDICARE TAX 6,857.08 6,857.08 EMPLOYEE MEDICARE TAXABLE WAGES 17,051,162.98 17,051,162.98 EMPLOYEE MEDICARE TAX 254,098.88 254,098.88 EARNED INCOME CREDIT PAYMENT .00 .00 AGENCY OASDI TAXABLE WAGES 14,804,604.86 14,804,604.86 AGENCY OASDI TAX - MATCHING 917,885.45 917,885.45 AGENCY MEDICARE TAXABLE WAGES 17,051,162.98 17,051,162.98 AGENCY MEDICARE TAX - MATCHING 247,241.80 247,241.80 OUT OF STATE FUTA TAXABLE .00 .00 FUTA TAX .00 .00 DISABILITY INSURANCE TAXABLE WAGES .00 .00 DISABILITY INSURANCE TAX .00 .00 LOCAL TAXABLE WAGES .00 .00 LOCAL TAX .00 .00 SPECIAL LOCAL TAXABLE WAGES .00 .00 SPECIAL LOCAL TAX .00 .00 STATE INCOME TAXABLE WAGES .00 .00 STATE INCOME TAX .00 .00 STATE UNEMPLOYMENT GROSS WAGES .00 .00 STATE UNEMPLOYMENT TAXABLE WAGES .00 .00 STATE UNEMPLOYMENT TAX .00 .00 EMPLOYEE OASDI TIPS .00 .00 EMPLOYEE MEDICARE TIPS .00 .00 AGENCY OASDI TIPS .00 .00 AGENCY MEDICARE TIPS .00 .00