Tax Reports (TAX)
The table in this topic lists and describes PeopleSoft Payroll for North America tax reports.
| Report ID and Report Name | Description | Navigation | Run Control Page |
|---|---|---|---|
|
TAX001 Tax Deposit Summary |
Produces pay period details of federal, state, and local taxes that are withheld from employees, and liabilities incurred for employer-paid taxes. Also shows the FUTA (Federal Unemployment Tax Act) Credit Reduction amounts by company and by state. |
|
RUNCTL_PAYINIT2 |
|
TAX002LC Quarterly Local Tax Summary - Employee Detail |
Produces a summary report of employee QTD local wages and withholding. This report lists employees by SSN and name. |
|
PRCSRUNCNTRL |
|
TAX003CN Tax Submission Summary |
Produces a report that summarizes tax submission data, sorted by payroll account number. |
|
RUNCTL_PAYINIT |
|
TAX004 Multiple Worksite |
Produces a listing of each tax location, that is used to calculate the employees work taxes. The tax location is considered a worksite when completing the information on the federally mandated Multiple Worksite report (BLS-3020) or state variations. |
|
RUNCTL_QTR_YR_PAY |
|
TAX004ST Employee Count |
Produces a report of employment count totals, sorted by gender, as of the 12th of each month in the quarter for the states of Connecticut, Maine, New Jersey, and Vermont. |
|
RUNCTL_TAX004ST |
|
TAX007 Quarterly Federal Tax Summary |
Produces a report by employee, quarter-to-date (QTD), federal withholding, Federal Insurance Contributions Act (FICA), and unemployment taxes, and includes state-specific FUTA (Federal Unemployment Tax Act) Credit Reduction gross and tax amounts. It lists employees by social security number (SSN) and name, and it provides page and company totals. |
|
PRCSRUNCNTRL |
|
TAX008 Quarterly State Tax Summary |
Produces a summary report of employee QTD state withholding, disability, and unemployment taxes. It lists employees by SSN and name, and it provides page and company totals. |
|
PRCSRUNCNTRL |
|
TAX009 Local Tax Deposit Summary |
Provides a tax summary report of local taxes withheld, and provides more detail than TAX001. This pay period report lists total taxes withheld for residents and nonresidents separately for each locality. It lists the number of employees in each category and counts only once those employees who receive more than one check. |
|
RUNCTL_PAYINIT2 |
|
TAX010AL Alabama Exempt Overtime Report |
Produces a report listing total dollar amounts of overtime paid during the period which was exempt from Alabama taxation, and total number of full-time hourly employees who received such overtime pay. Run the report monthly or quarterly. |
|
RUNCTL_TAX010AL |
|
TAX010FD Tax Summary - Federal |
Produces a summary report of period-to-date federal income tax, Advance EIC payments, OASDI, OASDI tips, Medicare, Medicare tips, Additional Medicare, Federal Unemployment Insurance and Non Resident Alien Tax 1042. Run the report monthly or quarterly. |
|
RUNCTL_TAX010FD |
|
TAX010FT Quarterly Federal Unemployment Tax Summary Report |
Produces a Federal Tax Summary Report for both Federal unemployment tax and state-specific FUTA credit reduction amounts. Run the report monthly or quarterly. |
|
RUNCTL_PAYINIT2 |
|
TAX010HA Tax Summary - HIRE Act |
Produces a summary report with negative dollar amounts for employer OASDI taxes on wages and tips. Run the report monthly or quarterly. |
|
RUNCTL_TAX010FD |
|
TAX010HB Tax Summary - EE Offset |
Produces a summary report negative dollar amounts for employee OASDI taxes on wages and tips. Run the report monthly or quarterly. |
|
RUNCTL_TAX010FD |
|
TAX010ST Tax Summary - State |
Produces a summary report of period-to-date income tax withheld, disability, and unemployment taxes at the state and local levels. Run the report monthly or quarterly. |
|
RUNCTL_TAX010ST |
|
TAX010PA PA Local Services Tax Report |
Produces a summary report of period-to-date local services taxes deducted for Pennsylvania. |
|
RUNCTL_TAX010PA |
|
TAX011PA PA Earned Income Tax Report |
Produces a summary report of period-to-date earned income taxes deducted for Pennsylvania. A tax balance record. |
|
RUNCTL_TAX011PA |
|
TAX012 Ohio Local Tax Reconciliation |
Provides the information for completing the Ohio Form W-3 and local variations. |
|
RUNCTL_MO_QTR_YR |
|
TAX014 Federal Liability by State |
Produces a report of federal withholding and liability (ER and EE FICA plus withholding) for each state. Use this report to determine when to deposit state withholding in those states that associate the frequency of state deposits with the employer's schedule for federal tax deposits. Run TAX014 after each pay period. It inserts a grand total and totals for company, pay period, and check date. |
|
RUNCTL_PAYINIT2 |
|
TAX015 Quarterly Tax Balances Audit |
Produces a report that compares the employee QTD tax balance with the sum of Tax Detail records from each payroll run for each tax class and tax jurisdiction, making it possible to verify that system computations are correct for these balances. (E&G) 1042 balances appear if the Include 1042 Balances check box is selected on the Tax Balance Audit run control page. |
|
RUNCTL_QTR_YR_PAY |
|
TAX016 Employees Default Tax Data Report - U.S. |
Produces a listing of the auto-generated data created by the system, such as the employee's hire date, federal tax status, state tax status and allowances, and local allowances and residence locality for U.S. employees. |
|
RUNCTL_FRMTHRU_PAY |
|
TAX016A 1099-R Payees Default Tax Data |
Produces a list of auto-generated tax data created by the system, such as the federal tax status, state tax status and allowances, and local allowances and residence locality for U.S. payees in 1099-R companies. |
|
RUNCTL_FRMTHRU_PAY |
|
TAX016CN Default Tax Data Report - Canada |
Produces a listing of the auto-generated data by the system, such as the employee's hire date, default net claim amounts from the Canadian tax tables, and provincial tax credit amounts from the Canadian Income Tax Data record. |
|
RUNCTL_FRMTHRU_PAY |
|
TAX017 Quarterly State Unemployment Tax Verification |
Produces a report to verify that the appropriate employer unemployment tax for the quarter being reported has been calculated and posted to employees' Tax Balance records. |
|
RUNCTL_TAX017 |
|
TAX018 Employee Check Information |
Produces a listing of individual employee pay check information. |
|
RUNCTL_TAX018 |
|
TAX019 Tax Information |
(USA) Produces an individual listing of the tax withholding information for employees and payees (in 1099-R companies). (CAN and USF) Produces an individual listing of the tax withholding information for employees. |
|
RUNCTL_TAX019 |
|
TAX020 FUTA Credit Reduction Tax (Federal Unemployment Tax Act credit reduction |
Produces a report that lists all employee tax balance occurrences for the tax year where an adjustment is required to make YTD Tax = (YTD Taxable Gross x Credit Reduction Rate). You normally run this at year-end, but you can run it at other times to verify data. |
|
RUNCTL_TAX020 |
|
TAX030 Form 1042-S Tax Liability Data by Pay Period |
Produces tax liability 1042 data for a company and period that you specify. |
|
RUNCTL_TAX030 |
|
TAX100 W-4 Exemptions Report |
Produces a listing of all employees whose U.S. Tax Data records indicate that they are exempt from federal income tax withholding (W-4). |
|
RUNCTL_TAX100 |
|
TAX100CN Exemption Report |
Produces a listing of all employees whose Canadian or Quebec Tax Data records indicate that they are exempt from income tax withholding, exempt from unemployment insurance payments, exempt from Quebec Parental Insurance Plan premiums, or have fewer than 12 months subject to Canada or Quebec Pension Plan contributions. |
|
RUNCTL_TAX100CN |
|
TAX101CN EI Rebate (Employment Insurance rebate) |
Produces a listing of information for employers with private income replacement plans. |
|
RUNCTL_TAX101CN |
|
TAX102CN Health Insurance Premium |
Produces a report of calculated health insurance premiums for provinces with a health insurance tax levied as a percent of payroll: Manitoba, Newfoundland, Ontario, and Quebec. |
|
RUNCTL_TAX102CN |
|
TAX103 Reset W-4 Exempt List |
Produces a listing of employees who have not yet filed a new Form W-4 by the due date to continue their tax exemption status. If the report is run in update mode, it will insert a new tax record to reset the special withholding tax status and tax status. |
|
RUNCTL_TAX103 |
|
TAX103CN Update Source Deductions |
Produces a listing of employees who have not yet filed a new form. It updates federal, Quebec, and provincial basic source deductions for employees by generating a new Canadian Income Tax Data record for each employee who is active as of the effective date specified. |
|
RUNCTL_TAX103CN |
|
TAX105CN Employer Contribution to CNT (employer contribution to Commission des Normes du Travail) |
Produces a report of the calculated annual payment of the contribution to the financing of the CNT by employers with employees working in the province of Quebec. |
|
PRCSRUNCNTL |
|
TAX107 W-4 Audit Report |
Produces a listing of all employees who either created or updated their W-4 information through self-service. |
|
RUNCTL_TAX107 |
|
TAX108 W-4 Print Self-Service |
Produces a printed version of the electronic Form W-4 information submitted by the employee in the PeopleSoft ePay self-service transaction. |
|
RUNCTL_TAX108 |
|
TAX109 SSN Verification (social security number verification) |
Creates an electronic file that you can use to submit employee name and SSN information to the Social Security Administration for verification. |
|
RUNCTL_TAX109 |
|
TAX516AZ Arizona Tax Percentage Update |
Updates Arizona employees' tax percentages. |
|
RUN_MASS_EE_UPD |
|
TAX516OK Oklahoma Marital Status Update |
Change Oklahoma state tax status from B to the employee's federal tax status value. Note: TAX516OK.SQR was delivered specifically for Oklahoma withholding tax effective January 1, 2006. It has no general purpose. |
|
RUN_MASS_EE_UPD |
|
TAX5162T 2 Tiered Suppl Adj Pgm (two-tiered supplemental adjustment program) |
Update the special accumulator that tracks taxable wages to calculate taxes when the employee is paid over 1 million USD. See (USA) TAX5162T – Two-Tiered Supplemental Adjustment Program. |
|
RUNCTL_MASS_UPD2 |
|
TAX702 Federal/State Tax Table |
Produces a report of the State Tax table and the State Other Tax table, which store the most current tax rates and other parameters used in calculating state and federal withholding, disability, and unemployment taxes. |
|
PRCSRUNCNTRL |
|
TAX703 Local Tax Table |
Produces a report of the Local Tax table, which contains calculations for local income taxes. |
|
PRCSRUNCNTRL |
|
TAX704 Company State Tax Table |
Produces a report of information from the Company State Tax table, which identifies the states in which your company collects and pays taxes. |
|
PRCSRUNCNTRL |
|
TAX705 Company Local Tax Table |
Produces a report of information from the Company Local Tax table, which identifies the localities for which your company collects and pays taxes. |
|
PRCSRUNCNTRL |
|
TAX706 Taxable Gross Definition Table |
Produces a report of the Taxable Gross Definition table, which contains definitions that the system uses during payroll calculation to determine state and local taxable grosses and/or income taxes that deviate from the normal federal withholding. It specifies the base for taxable gross and indicates modifications to that base. |
|
PRCSRUNCNTRL |
|
TAX707 State Tax Rate Table |
Produces a report of the State Tax Rate table, which contains bracket rates that are needed for calculating state and federal taxes. |
|
PRCSRUNCNTRL |
|
TAX708 State Reciprocity Rules Table |
Produces a report of the State Reciprocity Rules table, which contain the rules that determine where to withhold income taxes when an employee works in one state and lives in another. |
|
PRCSRUNCNTRL |
|
TAX709 Local Reciprocity Rules Table |
Produces a report of the Local Reciprocity Rules table, which contain the rules that determine where to withhold income taxes when an employee works in one locality and lives in another. |
|
PRCSRUNCNTRL |
|
TAX711 Marital Status Codes |
Produces a report of the Marital Codes Status table, which contains all valid tax status codes, sorted by state. |
|
PRCSRUNCNTRL |
|
TAX713 Work-Work Reciprocity Rules Table |
Produces a report of the Work-Work Reciprocity Rules table, where contain the reciprocal rules that determine local income tax withholding when an employee works in a location that has multiple taxing jurisdictions that share a reciprocal agreement. |
|
PRCSRUNCNTL |
|
TAX715 VDI/FLI Administrator Table (Voluntary Disability Insurance/Family Leave Insurance Administrator) |
Produces a report of the VDI/FLI Administrator table. |
|
PRCSRUNCNTL |
|
TAX720 Tax Treaty Table |
Produces a report of the Tax Treaty table. |
|
PRCSRUNCNTL |
|
TAX810XX Quarterly UI Wage File (quarterly unemployment insurance wage file) |
Creates a file for states that must submit quarterly state wage listings on electronic/magnetic media, not using the EFW2 format. The XX in the report ID is a two-character state abbreviation. |
|
RUNCTL_TAX810XX |
|
TAX860XX Quarterly UI Wage File (quarterly unemployment insurance wage file) |
Creates a file for states that must submit quarterly state wage listings on electronic/magnetic media using the EFW2 format. The XX in the report ID is a two-character state abbreviation. |
|
RUNCTL_TAX810XX |
|
TAX900 Annual Reporting Error Listing |
Lists employees who have negative tax balances or reportable wage amounts that would cause overflow in fields when the system writes W-2 data to magnetic media. It also checks for other error conditions. You normally run this report at year-end, but you can run it at other times to verify SSNs or to check for negative tax balances and other error conditions. |
|
PRCSRUNCNTRL |
|
TAX905CN NW Territories Payroll Tax (Northwest Territories payroll tax) |
Produces a report of the Northwest Territories Payroll Taxes table. |
|
RUNCTL_TAX905CN |
|
TAX906CN Nunavut Payroll Tax Annual |
Produces a report of the Nunavut payroll taxes. |
|
RUNCTL_TAX906CN |
|
TAX907CN British Columbia Annual Remuneration Report for Employer Health Tax |
Produces a report of annual total remuneration of B.C. employees. |
|
RUNCTL_TAX907CN |
|
TAX910AU YE Data Audit Report (Year end data audit report) |
Produces an audit listing of the data and amounts loaded in the year-end tables, as reported on the Form W-2s. Note: In some cases, the audit report may include user-defined W-2 box 14 items that were not actually printed on the W-2 form due to space limitations. Also, the box 14 descriptions are limited to 7 characters. If the Short Description on the Tax Form Definitions table exceeds 7 characters, the description on the audit report will be truncated. Run this report after year-end data is loaded (TAX910LD) to year-end tables. |
|
RUNCTL_TAX910AU |
|
TAX910ER YE Record Error Report (Year end record error report |
Produces a list of errors in the year-end records. It also provides an option on the run control to void all year-end forms if errors are found. Run this report after year-end data is loaded (TAX910LD) to year-end tables. |
|
RUNCTL_TAX10ER |
|
TAX911LD Distributing Year-End Other Earnings and Deductions |
Produces a report that shows the adjusted amounts that will be used for year-end processing of employees who are paid in multiple jurisdictions if the loaded year end amounts for any earnings or deductions do not match the total of the same earnings and deductions amounts from the employee's paycheck detail data. Run this report after year-end data is loaded (TAX910LD) to year-end tables. |
|
RUNCTL_TAX911LD |
|
TAX915 W-3/W-3SS Transmittal Totals Report |
Produces the W-3 Transmittal Totals report for U.S., American Samoa, Guam, and U.S. Virgin Islands. |
|
PRCSRUNCNTL |
|
TAX916LC Local and Federal W-2 Tax Totals Detail Report |
Produces a listing of local W-2 data used to reconcile the W-2s, and a listing of local W-2 data that is required by some local jurisdictions in lieu of receiving actual copies of individual W-2 forms. Run this report after year-end data is loaded (TAX910LD) to year-end tables. |
|
RUNCTL_TAX916LC |
|
TAX916PA PA Local EIT W-2 Tax Totals Report (Pennsylvania Local Earned Income W-2 tax totals report) |
Produces a report that lists Pennsylvania Local Earned Income Tax W-2 data for use in reporting to Tax Collection District tax collecting agencies. Run this report after year-end data is loaded (TAX910LD) to year-end tables. |
|
RUNCTL_TAX916PA |
|
TAX916ST State W-2 Tax Totals Summary Report |
Produces a report that lists state W-2 data that is used to reconcile the W-2s. Run this report after year-end data is loaded (TAX910LD) to year-end tables. |
|
RUNCTL_TAX916ST |
|
TAX918TL W-3PR Transmittal Totals Report |
Produces W-3PR Transmittal Totals report for Puerto Rico. |
|
PRCSRUNCNTL |
|
TAX930PM |
Produces a print file for reporting distribution and tax data on Form 1099-R for payees, and a file to report 1099-R data electronically to the IRS. |
|
|
|
TAX940 FUTA Wage Reconciliation Rpt (Federal Unemployment Tax Act wage reconciliation) |
Produces a report that provides federal unemployment tax wage data that is used to complete the Form 940. You normally run this at year-end, but you can run it at other times to verify data. |
|
PRCSRUNCNTL |
|
TAX940A FUTA Taxable Wages by UI State (Federal Unemployment Tax Act wage by state report) |
Produces a report that provides federal unemployment tax wage data by UI state which is required to complete the Form 940 Schedule A. You normally run this at year-end, but you can run it at other times to verify data. |
|
PY_RUNCTL_TAX940A |
|
TAX950 |
Produces a print file for reporting data on Form 1042-S, and a file to report 1042-S data electronically to the IRS. |
|
|
|
TAX960AS (W-2 AS Print File) TAX960GU (W-2 GU Print File) TAX960US (W-2 US Print File) TAX960VI (W-2 VI Print File) |
Reprints W-2 forms for American Samoa, Guam, Puerto Rico, the United States,or the U.S. Virgin Islands respectively for tax years 2001 through 2020 on preprinted forms. |
|
RUNCTL_TAX960UST |
|
TAX960AS (W-2 AS Print File) TAX960GU (W-2 GU Print File) TAX960US (W-2 US Print File) TAX960VI (W-2 VI Print File) |
Select to print all or selected W-2 Reporting Companies when reprinting W-2 forms for tax years 2001 through 2020 on preprinted forms. |
|
RUNCTL_TAX960_COMP |
|
TAX960FD Create Federal W-2 File |
Produces a file to submit federal W-2 data electronically to the Social Security Administration in the EFW2 format. |
|
RUNCTL_TAX960FD |
|
TAX960LC Create Local W-2 File |
Produces files to report W-2 wage and tax data to local tax agencies that accept submissions in the Social Security Administration’s EFW2 reporting format. |
|
RUNCTL_TAX960LC |
|
TAX960PD Create Puerto Rico W-2 File |
Produces a file to report W-2PR wage and tax data to Puerto Rico using the EFW2PR format. |
|
RUNCTL_TAX960PD |
|
TAX960PR (W-2 PR Print File) |
W-2PR Print File for printing annual wage and tax statements for reporting data to Puerto Rico. The file is printed on preprinted forms. |
|
RUNCTL_TAX960PR |
|
TAX960TP Create 8027 File |
Produces a report that provides tip allocation data required to report on the electronic IRS Form 8027 for large tip establishments. |
|
RUNCTL_TAX960TP |
|
TAX960ST Create State W-2 File |
Produces files to report W-2 wage and tax data for states using the Social Security Administration’s EFW2 format. |
|
RUNCTL_TAX960ST |
|
TAX960TI Create W-2 Import File |
Produces files that import W-2 or W-2c information into a tax preparation software provider for employees. |
|
RUNCTL_TAX960TI |
|
TAX960VD Create Virgin Islands W-2 File |
Produces a file to report W-2VI wage and tax data to the U.S. Virgin Islands Bureau of Revenue in the EFW2 format. |
|
RUNCTL_TAX960VD |
|
TAX962TP Form 8027 Audit Report |
Produces a report that provides audit data from the electronic IRS Form 8027 for large tip establishments. |
|
RUNCTL_TAX962TP |