This chapter provides an overview of payroll tax tables and discusses how to:
(USA) View federal and state tax information.
(USA) Update local tax information.
(USA) Work with tax reciprocity.
(USA) Update the Taxable Gross Definition table.
(USA) Enter state marital status codes.
(CAN) View Canadian tax information.
(USA) Establish company state taxes.
(USA) Establish company local taxes.
(USF) Set up state and locality tax routing.
Establish tax types for accounts payable integration.
(USA) Define tax locations.
Define tax forms.
(E&G) Establish 1042 processing for non-resident aliens.
(USA) Establish UI report codes.
(USA) Establish standard occupational classifications for Alaska.
(USA) Specify voluntary disability insurance plan location and contact information.
(USA) Specify parameters for quarterly tax reporting.
(CAN) Define Canadian tax information.
(CAN) Define Canadian WCB assessment reporting.
This section discusses how to:
Find instructions on year-end processing.
Work with payroll tax tables.
(USA) Work with U.S. Tax tables.
(CAN) Work with Canadian Tax tables.
Since year-end processing information changes regularly, PeopleSoft posts the most up-to-date in the current year-end tax update documentation, posted on Customer Connection
See Accessing Year-End Processing Instructions.
The PeopleSoft Enterprise Payroll for North America tax tables store tax information that the system requires to calculate and report taxes. PeopleSoft provides and maintains most of the payroll tax tables.
PeopleSoft Payroll for North America delivers tax data for all federal and state or provincial taxing entities and almost all localities. Should you need a locality that PeopleSoft does not yet support, you can add and maintain entries using the tax pages. If you need to make a change or addition to the standard tax information delivered with the system, you are responsible for maintaining the change until it is incorporated into PeopleSoft-maintained tax tables. After you notify us of the missing locality, PeopleSoft will add it to our standard system and maintain it for you in subsequent versions.
You are responsible for completing the tax tables that contain data specific to your company.
Note. The pages for Federal/State Tax, Taxable Gross Definition, and Canadian Tax tables reference more than one table.
PeopleSoft Enterprise Payroll Interface does not calculate taxes. The third-party payroll system performs all gross-to-net calculations. However, you can use Payroll Interface to maintain tax withholding data and to export employee-level tax codes to the third-party payroll system.
See Setting Up Tax Data.
Some U.S. tax tables are maintained by PeopleSoft, others are maintained by the employers.
These are the PeopleSoft-maintained tables for U.S. employers:
Federal/State Tax and Local Tax tables, which contain rates and other constants used in the calculation of most forms of taxes for U.S. federal, state, and local taxing entities.
State and Local Tax Reciprocity tables, which define reciprocal taxing rules between states and localities, and other rules for determining tax liabilities for multiple jurisdictions.
Taxable Gross Definition table, which identifies differences between states or localities and the federal government in the definition of taxable wages.
SWT Marital Status table, which defines the valid tax marital status codes for each state.
U.S. employers must define and maintain the following tables:
Tax Location table, which contains the work locations for which you process payroll and taxes.
Company State Tax and Company Local Tax tables, which store tax identification numbers, unemployment and disability experience rates, and general ledger codes for the states and localities for which your company collects and pays taxes.
Tax Reporting Parameters table, which controls the execution of many of your quarterly and annual tax reports and specifies data needed for magnetic media filing.
Some Canadian. tax tables are maintained by PeopleSoft, others are maintained by the employers.
Canadian Tax tables, which contain rates and other constants used in the calculation of all forms of federal, provincial, and Quebec taxes.
Canadian employers must define and maintain the following tables:
The Canadian Wage Loss Plan table, which identifies your organization's valid wage loss replacement plans and general ledger account numbers.
The Canadian Company Tax table, which defines the Prescribed Interest rate, Provincial Premium Tax rate, and Health Insurance rate override.
Canadian Tax Reporting Parameters table, which controls the execution of many quarterly and annual tax reports and specifies data needed for magnetic media filing.
To view federal and state tax information, use the Tax Table component (STATE_TAX_TABLE).
This section provides overviews of federal and state tax information and supplemental tax calculations and discuss how to:
View standard deductions, allowance amounts, and supplemental taxes.
View special tax amounts.
View wage bracket tax rate information.
View additional wage rates information.
Use the Federal/State Tax Table pages to view the tax data PeopleSoft Payroll for North America uses to calculate U.S. federal, state, and certain local taxes. These pages supply the following information:
Identify the general type of withholding tax calculation employed by each jurisdiction and provide all the constants needed by the calculation routines for income tax withholding and unemployment and disability taxes.
Contain the wage bracket tax rate data used by the taxing authorities for implementing graduated taxes.
Special State Codes for Localities Using Graduated Tax Tables
In addition to the rules for state withholding, the rates for calculating federal withholding, FICA, and federal unemployment are defined on this table, primarily because the method of calculation is similar. Localities that use graduated tax tables are also included. These entries are identified by special state codes such as Z1 and Z2. Here are some of these special codes:
Code |
Description |
$E |
Earned income credit |
$U |
U.S. federal tax |
Z1 |
New York City local tax |
Z2 |
Yonkers local tax |
ZA |
Maryland 3.01% local tax |
ZB |
MD resident works in DE |
PeopleSoft Payroll for North America tax processing supports the various tax calculation methods required by some states for supplemental earnings, including the use of aggregate tax methods.
The methods used for calculating withholding tax on supplemental payments may differ depending on the following criteria specified on the Federal Tax Table — General page:
Paid With Regular Wages |
The employee receives a supplemental payment paid with regular wages. |
Separate Payment |
The employee receives a supplemental payment as a separate payment. |
PeopleSoft delivers the required value in these fields. The possible values are:
Aggregate − No Annualize
Aggregate
Aggregate − No Tax else Percent
Percent of Taxable Gross
Special Table with Exemptions
Special Table
Non-Resident Supplemental
This section provides an explanation and examples of each of these methods.
Note. PeopleSoft uses the term “normal wages” to mean the employee’s pay from regular (REG) earnings taxed using the annualized tax method.
This method is valid only for Delaware and is used only for supplemental wages paid separately from normal wages.
Normal wages are annualized, but supplemental wages are not annualized, as follows:
Annualize the employee’s normal wages and compute tax on this amount.
Annualize normal wages, add in the supplemental wages, and compute tax on the total.
Subtract the difference in the tax amounts. The remainder is the withholding on the supplemental wages.
Example:
A Delaware employee, single with one allowance, earning $500 per week, is paid a $5000 bonus as a separate check.
Without Bonus |
With Bonus |
|
$26,000.00 |
Annualize Gross Wages |
$31,000.00 |
1,104.55 |
Annual Delaware Tax |
1,426.15 |
Tax on Wages w/o Bonus |
(1,104.55) |
|
Tax to Withhold on Bonus |
321.60 |
For supplemental wages paid with normal wages, calculate withholding (using the annualized method) as if the aggregate of supplemental and normal wages were a single wage payment for the normal payroll period.
Example for Payment with Regular Wages:
A Maine employee, single with one allowance, is paid a $1000 bonus on the same paycheck as his normal weekly earnings of $500:
Normal Wages |
$500.00 |
Supplemental Wages |
1,000.00 |
Total Wages |
1,500.00 |
Annualized (x 52) |
$78,000.00 |
Annual Maine Tax |
5,720.75 |
Tax to Withhold (/52) |
110.01 |
For supplemental wages paid separately from normal wages, calculate withholding by aggregating supplemental wages with normal wages from the current payroll, if any, or from any preceding on-cycle confirmed payroll in the same calendar year. Using the annualized method, compute the tax on the combined total. Subtract the annualized tax on the normal wages. The deannualized remainder is the withholding on the supplemental wages.
Example for Separate Payment:
A Maine employee, single with one allowance, is paid a $1000 bonus as a separate check. No normal wages are paid in the current payroll. The employee’s last previous on-cycle confirmed paycheck in the current year was for normal weekly earnings of $500:
Normal Wage |
Reg + Bonus |
|
$26,000.00 |
Annualize Gross Wages |
$78,000.00 |
1,300.75 |
Annual Tax |
5,720.75 |
Annualized Tax on Normal Wages |
(1,300.75) |
|
Remainder |
4,420.00 |
|
Tax to Withhold on Bonus (/52) |
85.00 |
Aggregate − No Tax else Percent
When supplemental wages are paid separately from normal wages, withholding depends on whether tax was withheld on the employee’s current payment of normal wages, if any, or on previous on-cycle payments (in the same pay group).
If no tax was withheld on either condition, calculate tax on supplemental wages using the Aggregate Method described previously for supplemental wages paid separately.
If tax was withheld on either condition, calculate tax using a flat percent rate as specified by the state, without regard for marital status or allowances.
Example:
A Connecticut employee, single with one allowance, is paid a $1000 bonus as a separate check. The employee’s last previous on-cycle normal paycheck in the current year was for normal weekly earnings of $500, from which $10.92 Connecticut tax was withheld. Using the flat rate of 4.5 percent specified by Connecticut, calculate the Connecticut tax to be withheld on the bonus:
4.5% X $1000 = $45
Calculate the tax to be withheld on supplemental wages by using the special flat rate specified by the state, without regard for marital status or allowances. For some states such as Arizona, this method uses a Percent of Federal Tax Withheld instead of a Percent of Taxable Gross.
This method may apply both to supplemental wages paid with normal wages and to supplemental wages paid separately.
Examples:
An employee subject to Indiana withholding is to be paid a $4000 bonus. Using the flat rate of 3.4 percent specified by Indiana for supplemental wages, calculate the Indiana tax to be withheld on the bonus:
3.4% X $4000 = $136
As an example of a calculation using a Percent of Federal Tax Withheld instead of a Percent of Taxable Gross, an Arizona employee electing an Arizona withholding rate of 32 percent is paid a $3000 bonus on which $600 Federal tax is withheld. Calculate the Arizona tax to be withheld:
32% X $600 = $192
Note. For Arizona, the system uses Percent of FWT method, even though the value selected for Supplemental Method is Percent of Taxable Gross.
When supplemental wages are paid separately from normal wages to a non-resident employee, calculate tax using a flat percent rate specified for non-residents, without regard for marital status or allowances.
Example:
A non-resident of Yonkers employed in Yonkers and subject to Yonkers tax is to be paid a $2000 bonus as a separate payment. Using the flat rate of .5 percent specified by Yonkers for non-residents, calculate the Yonkers tax to be withheld on the bonus:
0.5% X $2000 = $10
For Georgia and West Virginia only. The system uses the annual rate computed from the job record.
Page Name |
Object Name |
Navigation |
Usage |
STATE_TAX_TABLE1 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Tax Table, General |
View standard deductions, allowance amounts, and supplemental rates. |
|
STATE_TAX_TABLE2 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Tax Table, Special Tax Amounts |
View information needed for tax calculations. The page for the Federal Tax Table differs from the one for specific states. |
|
STATE_TAX_TABLE3 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Tax Table, Rates |
View wage bracket information. |
|
STATE_TAX_TABLE4 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Tax Table, Additional Rates |
View wage limits for unemployment and disability taxes. |
|
PRCSRUNCNTRL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Federal/State Tax, Federal/State Tax Report |
Run TAX702 to print information from 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 |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, State Tax Rate, State Tax Rate Report |
Generate TAX707 that lists information from the State Tax Rate Table, which contains bracket rates needed for calculating state and federal taxes. |
Access the Federal/State Tax Table - General page.
Note. You shouldn’t need to modify this table, but if you must, you can make changes if you have the appropriate security authorization. This applies to all pages in this component.
State Tax Calculation Type |
Indicates the type of withholding tax calculation required by the state. |
FWT Credit |
This check box indicates whether credit is given for FWT during calculation of state income tax withholding. |
Non-Resident Declaration Required |
This check box indicates whether the state requires a Non-Resident Declaration for non-resident employees. |
Allow Withholding Reduction |
This check box indicates whether the state allows a reduction amount to be computed in the state withholding calculation. Currently, this only applies to Connecticut. |
FICA Credit |
This check box indicates whether credit is given for FICA during calculation of state income tax withholding. |
Supplemental Method
Details of the values available for selection in this group box and examples of calculations are provided in the overview of this section.
Paid With Regular Wages |
PeopleSoft delivers the required selection: Aggregate − No Annualize, Aggregate, Aggregate-No Tax else Percent, Non-Resident Supplemental, Not Applicable, Percent of Taxable Gross, Special Table with Exemptions, and Special Table. Note. For Arizona, the system uses Percent of FWT method, even though the value shown in this field is Percent of Taxable Gross. |
Separate Payment |
PeopleSoft delivers the required selection: Aggregate − No Annualize, Aggregate, Aggregate-No Tax else Percent, Non-Resident Supplemental, Not Applicable, Percent of Taxable Gross, Special Table with Exemptions, and Special Table. Note. For Arizona, the system uses Percent of FWT method, even though the value shown in this field is Percent of Taxable Gross. |
See Also
Understanding Supplemental Tax Calculations
Access the Federal/State Tax Table - Special Tax Amts page.
Special Tax Amount |
This field is used to store parameters or values used in state withholding tax calculations. |
State Statutory Minimum Hourly |
The system uses this field to calculate tip credit to pay overtime for tipped employees. The minimum hourly rate required by that state appears here. |
Report Neg Wages |
Options are include or separate. |
State Tips W/H Threshold |
This field appears if the value in the State field is $U. This field is used in conjunction with state regulations for delaying the withholding of taxes on tips until the employee reports monthly tips in the amount equal to the threshold amount. This field displays the monthly threshold amount from the federal regulations and as of now all states use that threshold amount. For states that allow you to delay withholding on tips, you can specify by Pay Group whether you delay withholding on tips. |
Tax Reporting |
Options include Annual, Monthly, or Quarterly. |
Delay Withholding for Tips |
On this page, this check box refers to state income tax. For each state, PeopleSoft selects or clears this check box, depending on whether the state allows employers to delay withholding on tip income until the monthly threshold amount is reached. For states that allow you to delay withholding on tips, you can specify by Pay Group whether you'll delay withholding on tips. |
Employee Detail Required |
This field is informational only and indicates whether a state requires the quarterly reporting of individual employee wage data. All states currently require such reporting. |
Use Common PayMaster for SUI |
This check box is selected if the state recognizes common paymaster status between companies for purposes of state unemployment insurance taxes. |
Access the Federal/State Tax Table - Rates page.
Tax Status |
The appropriate Federal/State tax status (Married, Single, and so on). |
Low Gross |
The minimum taxable gross for the bracket. |
Low Tax |
The tax to be withheld on the corresponding minimum gross. |
Tax Rate |
The rate to be applied until the next bracket is reached. |
Credit Amount |
Not currently used by PeopleSoft Payroll for North America. |
Access the Federal/State Tax Table - Additional Rates page.
Tax Class |
Tax classes identify different taxes that share certain characteristics. Occ Priv represents Occupational Privilege Tax (OPT) for Pennsylvania employees. |
Calculation Type |
Options are % Tax Grs, %ER Wage, and N/A. |
Tax Base |
Options are Disability, Unemployment, and Withholding. |
Tax Rate |
The tax rate for employer unemployment or disability contributions is blank on this page. The rate used during payroll calculations comes from the Company State Tax table. |
Max Gross |
If a tax applies only to a portion of an employee’s annual wages up to a specified limit, such as employer unemployment taxes, that limit amount appears in this field. An entry of all 9s, as with Medicare taxes, indicates a tax without limit. |
Period Maximum |
If selected, this option indicates that the tax is calculated for a period other than annual. Two examples of this are SDI in New York and Hawaii, both of which have weekly maximums. |
Delay W/H for Tips |
On this page, this check box is selected or cleared for each additional tax the state may impose. For each state, PeopleSoft selects or clears this check box, depending on whether the state allows employers to delay withholding on tip income until the monthly threshold amount is reached. For states that allow you to delay withholding on tips, you can specify by Pay Group whether you'll delay withholding on tips. |
Self Adjust (self-adjusting) |
This check box is for information only. |
Max Tax (maximum tax) |
If there is an annual limit on a particular type of tax, such as Pennsylvania’s occupational privilege taxes, enter that limit amount here. |
EE/ER Both |
This field indicates whether a tax is paid by the employee, paid by the employer, or paid in equal matching amounts by both. |
Pennsylvania Limit on Occupational Privilege Tax
On the Federal/State Tax Table - Additional Rates page, the Tax Class Occ Priv represents Occupational Privilege Tax (OPT) for Pennsylvania employees. The state of Pennsylvania requires an employer to deduct this tax class only one time annually. If an employee moves from one locality to another midyear, the employee should not be taxed an additional OPT tax amount in the new locality until the next year. To keep track of how much Pennsylvania OPT tax an employee has paid, there exists a state level Pennsylvania OPT Memo tax record. The sole purpose of this tax record is to keep track of how much Pennsylvania tax an employee has paid for the year regardless of the Pennsylvania locality. During the OPT tax calculation, a check is made against this state Memo tax balance before the local OPT tax is computed.
Note. Pennsylvania’s OPT is withheld as an annual fixed amount. When you hire an employee who has already paid OPT for the current
tax year, you should adjust the employee’s tax balance for the tax year. This prevents the system from withholding OPT from
that employee’s pay twice in one year.
The Payroll calculation process determines the Pennsylvania OPT limit by Employee ID. Adjust an employee’s memo balance for
PA OPT, select on the Adjust Tax Balance pages.
See (USA) Reviewing and Adjusting U.S. Tax Balances.
Of the states that provide disability insurance plans (currently California, Hawaii, New Jersey, New York, Rhode Island, plus Puerto Rico) all but Rhode Island allow employers to provide voluntary disability plans in place of the state plan. PeopleSoft maintains the Tax Class rows on the Federal/State Tax Table - Additional Rates page for the Employer and Employee paid tax for voluntary disability plans for each of these states.
Note. If you implement a voluntary disability plan for California, Hawaii, New Jersey, New York, or Puerto Rico, you must set up the appropriate tax rates on the Company State Tax table and the VDI Administrator table.
State Unemployment Insurance (SUI) Tax
You must make sure that the unemployment insurance taxable gross and tax balances transferred during the conversion process are consistent with the unemployment tax rates that have been entered for each quarter on the Company State Tax Table page.
Warning! If these amounts are not consistent and in balance, the system will either charge or refund additional unemployment tax amounts to account for the difference in the quarterly unemployment insurance tax balances.
See Also
Defining States Where You Collect or Pay Taxes
To update local tax information, use the local Tax Table component (LOCAL_TAX_TABLE).
This section provides an overview of locality codes and discusses how to:
View local tax jurisdiction information associated with a locality code.
View the method used to calculate local withholding rates.
Enter a locality’s tax reporting requirements.
The local Tax Table component (LOCAL_TAX_TABLE) displays information used when the system calculates local withholding tax. In this table, each locality is assigned a code of up to ten characters. Typically this is how these codes are assigned:
For Pennsylvania municipalities and school districts: an eight or nine character code based on codes assigned in the official Pennsylvania local tax register.
For municipalities in states other than Pennsylvania: a five-character Federal Information Processing Standards (FIPS) code.
For counties: a three-digit county number.
For Ohio school districts: a four-digit district number.
The State of Pennsylvania provides a registry of tax rates for all cities, counties, political subdivisions, school districts, and so on located in Pennsylvania. For each municipality and overlying school district, the registry lists effective tax rates for both Earned Income Tax (EIT) and Occupational Privilege Tax (OPT) for residents and, where applicable, non-residents.
The following is the definition of the eight or nine character Pennsylvania code:
The letter in the first position refers to the type of tax:
I - income tax.
O - occupational privilege tax.
The next six digits are the numerical code assigned to the municipality by the state of Pennsylvania.
The alphabetic code in the eighth position signifies the tax rate:
C - combined municipality and school district tax rate.
M - municipality tax rate.
S - school district tax rate.
A numerical digit in the last position indicates that the municipality overlaps with all or portions of multiple school districts.
Refer to the School District Code field on the Local Tax Table 1 page to determine which locality code applies to which school district, and then choose the appropriate entry for the employee's location.
For each municipality and overlying school district, PeopleSoft delivers the following locality types:
Pennsylvania Locality Description |
Example |
Combined municipality and school district earned income tax |
I123456C |
Municipality earned Income tax |
I123456M |
School district earned income tax |
I123456S |
Combined municipality and school district occupational privilege tax |
O123456C |
Municipality occupational privilege tax |
O123456M |
School district occupational privilege tax |
O123456S |
For each locality that PeopleSoft supports, we maintain the entries for that locality in the following tables:
local Tax Table.
Local Tax Reciprocity table (if applicable).
Taxable Gross Definition table (GTL, 401k, 125, TIP, and DPB only) (if applicable).
Page Name |
Object Name |
Navigation |
Usage |
LOCAL_TAX_TABLE1 |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Tax Table |
View information about the geographic area associated with a locality code. |
|
LOCAL_TAX_TABLE2 |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Tax Table |
View the method used to calculate local withholding taxes, tax rates, and other constants. |
|
LOCAL_TAX_TABLE3 |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Tax Table |
Enter data on the locality’s tax reporting requirements. This information is used in quarterly and year end reporting. |
|
PRCSRUNCNTRL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Local Tax, Location Tax Report |
Run TAX703 to print information from the Local Tax Table, which contains calculations for local income taxes. |
Access the Local Tax Table 1 page.
Maintenance Responsibility |
All entries that we supply are marked as the maintenance responsibility of PeopleSoft. However, if you add a locality to this table, the system marks it as your maintenance responsibility. |
Local Jurisdiction |
Reserved for future use. |
Partial District Indicator (PA Only) |
This check box is selected to indicate a Pennsylvania municipality that is co-terminus with multiple school districts, meaning the boundary of the municipality overlaps the boundaries of multiple school districts. For example, in Westmoreland County, the City of Greensburg is co-terminus with both the Greensburg Salem School District and the Hempfield Area School District. Be sure to use the Local Tax Table entry that represents the correct municipality/school district combination. |
Locality Name |
The municipality name from the register (except for school district entries, which are school district name). Combined jurisdictions have the appendage M+SD. |
Other Locality Name |
For Pennsylvania localities, combined entries display the school district name. |
School District Code (PA Only) |
For Pennsylvanian localities, the appropriate school district code appears here. |
See Also
Access the Local Tax Table 2 page.
Local Tax Calculation Type |
Indicates the calculation method used to determine the amount of local income tax withheld. |
Withhold On Work Locality Only |
When this check box is selected for a locality, only wages earned in that locality are considered taxable for residents of the locality. No resident tax is withheld from wages paid for work performed outside of the locality. |
Graduated Tax Table Code |
This option takes effect if the locality requires that tax tables be referenced during calculation, as do New York City, Yonkers, and Maryland counties. In this case, the graduated tax table code entered here links the record to the appropriate entry in the PeopleSoft Federal/State Tax table where the graduated tax rates are stored. |
Tax Rate
Resident |
This field displays the tax rate for residents of the locality. |
Nonresident |
This field displays the tax rate for nonresidents in the locality. |
Access the Local Tax Table 3 page.
Tax Reporting |
Displays the interval required by the locality for tax reporting, Monthly, Quarterly, or Annual. |
Important! If you add a locality, you are responsible for maintaining the entries on these tables for the new locality until PeopleSoft incorporates it into a tax update. Contact your Global Support Center if you discover any localities not listed or any errors so we can include the addition or correction in the next PeopleSoft Payroll Tax Update.
See Also
Accessing Year-End Processing Instructions
To work with tax reciprocity, use the State Tax Reciprocity Table component (STATE_TX_RECIP_TBL), local Tax Reciprocity Table component (LOCL_TAX_RECIP_TBL), and the Work Locality Reciprocity component (LCLTX_WK_RECIP_TBL).
This section discusses how to:
View state tax reciprocity withholding liability rules.
View local tax reciprocity rules.
Define reciprocal agreements between work localities.
Page Name |
Object Name |
Navigation |
Usage |
STATE_TX_RECIP_TBL |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, State Tax Reciprocity Table |
Display the rules used during payroll calculation to determine withholding liability when an employee lives in one state and works in another. |
|
PRCSRUNCNTRL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, State Reciprocity Rules |
Run TAX708 to print a summary of the rules that determine where to withhold income taxes when an employee works in one state and lives in another. |
|
LOCL_TAX_RECIP_TBL |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Tax Reciprocity Table |
View reciprocal agreements between an employee’s state of residence and a locality of employment. |
|
PRCSRUNCNTRL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Local Reciprocity Rules |
Run TAX709 to print a list of the rules that determine where to withhold income taxes when an employee works in one locality and lives in another. |
|
LOCLWK_TXRCP_TABLE |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Work Locality Reciprocity |
Establish reciprocal agreements between work localities. |
|
PRCSRUNCNTL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Work Locality Reciprocity, Work Locality Reciprocity Rpt |
Run TAX713 to print 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. |
Access the State Tax Reciprocity Table page.
SUT Credit when employee transfers to residence state |
When selected, this check box indicates that, for unemployment tax purposes, the (residence) state allows credit against its state unemployment taxable wage base for wages paid to an employee in another state. |
Reciprocity Rule |
This field displays the rule applied to the residence/ employment state combination. Although the employee's residence state may require withholding on all wages paid to the employee, many states provide credit for taxes paid by their residents to another state. Many other examples of reciprocity agreements also exist between states. Under these agreements, wages earned in a work state that has an agreement with the residence state are taxed by, and taxes withheld are submitted to, the employee’s residence state. This table doesn’t identify every state-to-state combination individually because most states have a single rule for dealing with residents who earn taxable wages in other states. The default reciprocity rule between a state of residence and all other states of employment is the one in which the State of Employment field is blank. If you need to modify these table entries, consult the PeopleSoft Global Support Center. |
Note. If you’re a multi-state employer, review the rules in this table, particularly if you can be considered a non-resident employer for certain employees. For example, Alabama requires that resident employers withhold Alabama tax on wages earned both inside and outside the state by Alabama residents. Non-resident employers must withhold on only those wages earned in Alabama, regardless of where the employee resides. The entries in the State Tax Reciprocity table—as delivered by PeopleSoft—assume that you are a resident employer in each state.
Access the Local Tax Reciprocity Table page.
When the residence locality differs from the employment locality, the system calculates both taxes and applies the reciprocity rule from this table to produce the correct net withholding for the employee in each locality.
Res Loc (residence locality) |
The ID corresponding to the employee’s locality of residence. This table does not identify every residence/employment combination, because most localities in a given state follow the same rule. The table entry for the default value, $DFLT, is used when there is no individual entry. Any exceptions require separate entries and act as overrides. Entries that identify reciprocity agreements between a state of residence and employment localities are special cases. The residence state is specified as usual, but the value in this field is a special code: STATERC. |
Empl Loc (employment locality) |
The ID corresponding to the employee’s locality of employment. This table does not identify every residence/locality combination, because most localities in a given state follow the same rule. The table entry for the default value, $DFLT, is used when there is no individual entry. Any exceptions require separate entries and act as overrides. |
Reduce by x Percent |
The maximum portion of the work locality's tax rate which can qualify as a credit against the resident locality's withholding. |
Credit Limit Rate |
The maximum portion by which the resident locality's tax rate can be reduced by a credit for the work locality's withholding. |
Reciprocity Rule |
Displays the rule applied to the residence/ employment locality combination. |
Access the Local Work Reciprocity Table page.
State of Other Jurisdiction |
The state of other jurisdiction for each record represents the state of the primary local tax jurisdiction. That is, the state of the local tax jurisdiction whose tax must be withheld in full. |
Locality of Other Jurisdiction |
This represents the primary tax jurisdiction. That is, the jurisdiction whose tax must be withheld in full. |
Reduce Percent |
Where allowed, this represents a percent of other jurisdiction withholding to be credited toward the withholding amount required by the locality of employment. This is not always 100%. PeopleSoft displays the percent of credit reduction allowed. |
Reciprocity Rule |
This field displays the rule applied to the residence/ employment locality combination. |
See Also
To update the Taxable Gross Definition Table, use the Taxable Gross Definition Table component (TAXGR_DEFIN_TBL).
This section provides an overview of the Taxable Gross Definition table and discusses how to set up a taxable gross definition.
Taxing jurisdictions may have different rules as to whether a given type of earnings or deduction should be taxed, and whether or not the tax should be withheld at the time of payment. The Taxable Gross Definition table defines the taxability for specific earnings or deduction types that must be treated differently at the state or local level than at the federal tax level. It also enables you to specify whether the state and local income tax withholding follows the same rules as federal withholding.
This section discusses:
Taxability.
Withholding.
Delivered entries on the Taxable Gross Definition table.
Example of setting up an earning with state tax withholding but without federal tax withholding.
Reference table of taxability and withholding setup.
Taxability
PeopleSoft Payroll for North America tracks these differences in taxability by documenting where the taxable wage definition of a particular jurisdiction differs from a standard definition for the following basic payroll tax types:
Withholding
Unemployment
Disability
For each of these tax types, certain earnings and deductions are taxable at the state or local level, while others are not. What is taxable differs for each tax, so we have a separate standard definition for each type. Because most states and localities follow federal guidelines for taxing earnings, we use Federal income tax withholding, Federal unemployment, and FICA as the standard taxes from which to develop these rules.
The system automatically maintains federal taxable grosses, FWT, FICA, and FUT, based on entries in the Earnings table and Deduction table:
Deduction Table |
Earnings Table |
Deduction classification =Taxable |
Subject to FWT |
Effect on FICA gross |
Subject to FICA |
Effect on FUT gross |
Subject to FUT |
Normally, the system calculates state and local taxes using the following taxable grosses:
Calculation |
Taxable Gross Used |
State withholding taxes (SWT) |
FWT gross |
State unemployment taxes (SUT) |
FUT gross |
State disability insurance (SDI) |
FUT gross |
Local withholding taxes (LWT) |
FWT gross |
PeopleSoft uses the FUT gross as the starting point for SDI because most states do not publish any separate definition of subject wages for SDI. Instead, states treat the definition of wages for SDI purposes as the same as the definition of wages for SUI purposes. Since SUI wages are based on FUT wages, and SDI subject wages are the same as SUI wages, FUT is the starting point for determining both SUI and SDI wages.
You can override or establish exceptions to the federal definitions of taxable gross for the following taxable grosses:
State withholding
State unemployment
State disability
Local withholding
When a state or locality declares that taxability of a certain earnings or deduction is different from one of these federal standards, a rule must be placed in the Taxable Gross Definition table indicating the deviation. The system uses the rules stored in the Taxable Gross Definition table to adjust the taxable gross for the states and localities that deviate from the federal norm.
For each of these taxable gross definitions, identify a Taxable Gross Component ID and assign it to the various states or localities affected.
Withholding
When you set up earnings and taxable benefits that are federally taxable, you specify whether or not that amount should also be subject to federal income tax withholding using:
The Subject to FWT field on the Earnings Table - Taxes page.
The Withhold FWT field on the Deduction Table – Tax Effect page.
Use the Withholding Follows Fed Rules (withholding follows federal rules) field on the Taxable Gross Definition Tbl page (TAXGR_DEFIN_TBL) to specify whether the state and local income tax withholding follows the same rules as federal withholding.
Note. You must create a Taxable Gross Definition table entry when you want to stop state or local income tax withholding on a particular earnings or taxable benefit. This is true regardless of whether or not the state or locality follows the federal rule for including the amount in taxable income, and regardless of whether or not you have selected to withhold federal income tax on the earnings or taxable benefit.
Delivered Entries on the Taxable Gross Definition Table
PeopleSoft delivers sample entries on the Taxable Gross Definition table for 401(k), Section 125, TIP, DPB, and group-term life taxable gross definitions. These sample entries are intended as examples and are delivered with the Plan Type element blank and the Deduction Code set to $DFLT. You must review these entries and update them with the specific values for your implementation. You maintain any taxable gross definitions that you add.
For Section 125 cafeteria plans, the taxable gross definitions are for employee deductions only. You may have to set up your own entries to process specific parts of your plan. In some states, the taxability of deductions depends on whether the employee has the option of receiving cash.
Review the definitions in this table carefully with regard to your particular 125 plans.
How Taxable Gross Definitions Affect Earnings and Deductions
The standard definition of taxability of an earnings or deduction type is determined by entries on the Earnings and Deduction tables. When establishing an entry on these tables, you specify if the earning or deduction is to be taxed for FWT, FUT, and FICA. Any earnings and deductions you marked as taxable are totaled during payroll processing to determine an employee’s taxable gross for each of the standard tax types. For earnings or deduction types that increase or decrease the state or local taxable grosses compared to the federal taxable gross, enter a taxable gross component ID that identifies which rules on the Taxable Gross Definition table to use.
For example, Pennsylvania considers employee before-tax 401(k) contributions taxable for state withholding, whereas they are not taxed at the federal level. Therefore, you must have a Taxable Gross Definition for 401(k) deductions that indicate to the payroll calculation programs that when taxable gross for withholding is determined, 401(k) deductions should be included as earnings for Pennsylvania (but not for federal) withholding purposes.
Example of Setting Up an Earning with State Tax Withholding but Without Federal Tax Withholding
Take a hypothetical example of moving expenses in the state of Pennsylvania. This example assumes the following:
Certain types of moving expense reimbursement payments that you make to Pennsylvania employees are includable in taxable gross at both the federal and state level.
Federal regulations do not require that federal income tax be withheld from these moving expense reimbursement payments.
Pennsylvania regulations do require that Pennsylvania income tax be withheld from these amounts at the time of payment.
In this case, state withholding does not follow the federal rules.
The following table illustrates these assumptions:
Taxing Jurisdiction |
Include in Taxable Gross? |
Withholding Required? |
Federal |
Yes |
No |
Pennsylvania |
Yes |
Yes |
To define the moving expense earnings with the proper tax and withholding effects:
Define a Taxable Gross Component ID (here named MOV) to identify these moving expense reimbursement payments that require different tax treatments at the federal and state levels.
This table shows the relevant page elements and values on the Taxable Gross Definition Table page:
Page Element |
Value |
Explanation |
Taxable Gross |
Withholding |
|
Base Gross |
FWT |
|
Taxable Gross Component ID |
MOV |
|
Withholding Follows Fed Rules |
Clear the check box. |
You do not want state tax withholding to follow the selection you will make for the Subject to FWT check box on the Earnings Table - Taxes page for these moving expense reimbursement amounts. You do not want federal income tax withheld on this earnings type, but you do want Pennsylvania income tax withheld. |
Tax Gross Effect |
No Effect |
The earnings type is to be included in both the federal and Pennsylvania taxable grosses. |
Enter the Taxable Gross Component ID when you set up the earnings on the Earnings Table - Taxes page.
This table shows the relevant page elements and values for setting up this moving expense reimbursement earning on the Earnings Table - Taxes page:
Page Element |
Value |
Explanation |
Earnings Type |
MOV |
|
Earnings Description |
Mov Exp Reimb – No Fed W/H |
Moving expense reimbursement without federal withholding |
Tax Method |
Annualized |
|
Subject to FWT |
Selected |
|
Taxable Gross Component ID |
MOV |
You must set up the taxable gross component ID before you can select it on this page. |
Add to Gross Pay |
Selected |
|
Maintain Earnings Balances |
Selected |
Reference Table of Taxability and Withholding Setup
Use the table below to look up the table entries for any combination of federal and state/local taxing options that you might need for a particular earnings or taxable benefit. The table lists the correct values in the relevant fields on the Earnings table, Deduction table, and Taxable Gross Definition table.
|
Earnings Table - Taxes page: |
Deduction Table - Tax Effect page: |
State/local tax treatment you want: |
State/local withholding treatment you want: |
Taxable Gross Definition Table: |
Taxable Gross Definition Table: |
Taxable Gross Definition Table: |
Row |
Subject to FWT |
Withhold FWT |
Subject to state/local tax? |
Withhold SWT/LWT? |
Entry required? |
Tax Gross Effect |
Withholding Follows Federal Rules |
1 |
Yes |
Yes |
Yes |
Yes |
No |
NA |
NA |
2 |
Yes |
Yes |
Yes |
No |
Yes |
No effect |
No (clear) |
3 |
Yes |
Yes |
No |
No |
Yes |
Subtracts from |
NA (check box does not apply) |
4 |
Yes |
No |
Yes |
No |
Yes |
No effect |
Yes (select) |
5 |
Yes |
No |
No |
No |
Yes |
Subtracts from |
NA (check box does not apply) |
6 |
Yes |
No |
Yes |
Yes |
Yes |
No effect |
No (clear) |
7 |
No |
No |
Yes |
No |
Yes |
Adds to |
Yes (select) |
8 |
No |
No |
No |
No |
No |
NA |
NA |
9 |
No |
No |
Yes |
Yes |
Yes |
Adds to |
No (clear) |
Row 6 contains the setup values for the MOV earnings described in the example.
See Also
Defining Earnings Codes and Earnings Programs
Page Name |
Object Name |
Navigation |
Usage |
TAXGR_DEFIN_TBL |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Taxable Gross Definition |
Set up a taxable gross definition, which defines the taxability and withholding for specific earnings or deduction types that must be treated differently at the state or local level than at the federal tax level. |
|
PRCSRUNCNTRL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Taxable Gross Definition, Taxable Gross Definition Rpt |
Run TAX706 to print information from the Taxable Gross Definition Table, which contains definitions that the system uses during payroll calculation to determine state and local taxable grosses that deviate from the normal federal withholding. It specifies the base for taxable gross and indicates modifications to that base. |
Access the Taxable Gross Definition Tbl page.
Taxable Gross
Taxable Gross |
Select Disability, Unemployment, or Withholding to identify the type of taxable gross you’re defining. |
Base Gross |
Select either FUT (Federal Unemployment Tax) for unemployment and disability, or FWT (Federal Withholding Tax) for withholding. (FICA is not currently used as a base gross.) |
Adjustment to Base Gross
This scroll area lists the specific components for which adjustments are necessary.
Taxable Gross Component ID |
The taxable gross component ID you specify must be unique in what it represents (for example, 401K, GTL, 125, and so forth). If it is not unique, it can cause the taxable grosses to be incorrect. |
Withholding Follows Federal Rules |
This check box is selected by default. Clear it if the withholding associated with the taxable gross component ID does not follow the same rules as federal withholding. This check box appears only if you select Withholding in the Taxable Gross field. This check box applies only to earnings and taxable benefit amounts identified by a taxable gross component ID. It has no effect on the processing of any before-tax deductions (such as 401(k) and Sec 125 amounts) for which there may also be entries on the Taxable Gross Definition table. |
Tax Gross Effect |
This field controls the effect on the gross. It can either add to the gross, subtract from it, or have no effect. |
Plan Type and Deduction Code |
Some states do not recognize certain before-tax benefits deductions. They require specific before-tax deductions to be included in taxable gross wages. Use these fields to identify such plans to the system by plan type and deduction code on the Taxable Gross Definition record for the applicable states. |
See Also
To enter state marital status codes, use the SWT Marital Status Table component (SWT_MAR_STATUS_TBL).
This section discusses how to define a state's marital status codes.
Page Name |
Object Name |
Navigation |
Usage |
SWT_MAR_STATUS_TBL |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, SWT Marital Status Table |
Enter a state’s marital status codes. |
|
PRCSRUNCNTRL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, SWT Marital Status Codes |
Print information from the Marital Codes Status Table, which contains all valid marital status codes, sorted by state. |
Access the SWT Marital Status Table page.
SWT Marital/Tax Status |
The State Withholding tax marital tax status. It is used in the employee’s state tax data. |
To view Canadian tax information, use the Canadian Tax Table component (CAN_TAX_TABLE).
This section provides an overview Canadian tax tables and discusses how to:
View the wage thresholds and rates for calculating Canadian federal surtax.
View the rates, thresholds, and constants to determine withholding of Canadian provincial taxes.
The Canadian Tax tables are used during payroll calculation to compute all federal, provincial, and Quebec taxes. Because these tables are maintained largely by PeopleSoft and updated based on the standards outlined in the Canada Revenue Agency (CRA) publication Payroll Deductions Formulas for Computer Programs and the Revenu Quebec publication Guide for Employers: Source Deductions and Contributions, you shouldn’t need to modify them. However, you can make changes using the Canadian Tax Table pages if you have the appropriate security authorization.
Page Name |
Object Name |
Navigation |
Usage |
CAN_TAX_TABLE1 |
Set Up HRMS, Product Related, Payroll for North America, Canadian Taxes, Tax Table, CPP/QPP and EI |
Display the constant values required for calculation of contributions to Canada and Quebec Pension Plans and premiums for Employment Insurance. PeopleSoft maintains this table for you. |
|
CAN_TAX_TABLE4 |
Set Up HRMS, Product Related, Payroll for North America, Canadian Taxes, Tax Table, Tax Rates, Credits, and Other |
Display the wage threshold and rates for calculating Canadian federal surtax. PeopleSoft maintains this page for you. |
|
CAN_TAX_TABLE2 |
Set Up HRMS, Product Related, Payroll for North America, Canadian Taxes, Tax Table, Provincial Rates |
Display rates, thresholds, and constants needed to determine withholding of Canadian provincial taxes, including withholding, health insurance, and sales taxes. PeopleSoft maintains this page for you. |
|
CAN_TAX_TABLE3 |
Set Up HRMS, Product Related, Payroll for North America, Canadian Taxes, Tax Table, Provincial Tax Thresholds |
Display by province the net claim amount threshold and tax reduction amount. Note that this page does not affect all provinces. PeopleSoft maintains this table for you. |
Access the Tax Credits, Rates, and Other page.
Other Rates
RRP/RRSP Limit (F factor) |
This field is used during the calculation of Canadian income taxes subject to the commission tax method. |
Maximum Credit |
This field displays the monetary amount to be applied to employee purchases of shares in Labour Sponsored Venture Capital Corporations (LSVCC). The federal tax credit is limited to the lesser of the maximum credit and the LCF Rate. The system applies this credit to each participating employee, according to the LCF Amount you enter on the employee’s Canadian Income Tax Data page. |
LCF Rate |
This field displays the percentage to be applied to employee purchases of shares in Labour Sponsored Venture Capital Corporations (LSVCC). The federal tax credit is limited to the lesser of the maximum credit and the LCF rate. The system applies this credit to each participating employee according to the LCF Amount you enter on the employee’s Canadian Income Tax Data page. |
Access the Provincial Rates page.
Maximum LCP Credit |
For provinces where provincial labor-sponsored venture tax credits are available, you maintain the maximum LCP credit amount to be applied for that province on this table. This applies to employee purchases of shares in Labour Sponsored Venture Capital Corporations (LSVCC). |
LCP Rate |
For provinces where provincial labor-sponsored venture tax credits are available, you maintain the LCP rate to be applied for that province on this table. This applies to employee purchases of shares in Labour Sponsored Venture Capital Corporations (LSVCC). |
Health Insurance Rate |
You override the default health insurance rate on the Canadian Company Tax table. |
See Also
Defining Canadian Company Tax Information
To establish company state taxes, use the Company State Tax Table component (CO_STATE_TAX_TBL) or Agency State Tax Table USF component (CO_STATE_TAX_TBL) and Tax Collector Table component (TAX_COLLECTOR_TBL).
This section discusses how to:
Define states where you collect or pay taxes.
Establish the voluntary disability plans.
Enter general ledger account numbers for state taxes.
Maintain the Tax Collector table for Pennsylvania.
Page Name |
Object Name |
Navigation |
Usage |
CO_STATE_TAX_TBL |
|
Set up an entry in the Company State Tax Table for each state where your organization collects or pays taxes. |
|
CO_STATE_TAX_TBL2 |
|
Establish the voluntary disability plans associated with the company. |
|
CO_STATE_TAX_TBL3 |
|
Enter your general ledger account numbers for state taxes. |
|
PRCSRUNCNTRL |
|
Run TAX704 to print information from the Company State Tax Table, which identifies the states in which your company collects and pays taxes. |
|
Vendor Information |
VNDR_ID1 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Tax Collector Table, Vendor Information |
Enter vendor data for tax collectors. |
Access the Company State Tax Table - General page.
The State field in State Tax Data 1 and Local Tax Data is edited against this table. You must create entries in this table before entering any state and local tax information for your employees.
State Withholding
Employer ID |
Enter your state employer ID for state withholding. |
Non-Resident Declaration Req |
This check box is selected or cleared by default according to the Federal/State Tax Table 1 record for the state. Indicates whether the state requires a Non-Resident Declaration for non-resident employees. |
Exempt From SUT |
Select this check box if the company is not required to pay SUT for this state. Use this option if you’ve specified, on the Company table, that the company as a whole is not exempt from SUT. If you select it here, Exempt from SUT becomes the default at the employee level; employees hired in this state have this check box selected on the State Tax Data page. See “Setting Up SUT Exemptions To Generate Data for the TAX002 and TAX810 Reports” at the end of this section. |
Employer ID |
Enter your state employer ID for state unemployment. |
Experience Rate |
The experience rate you enter in the State Unemployment group box should reflect the rate you receive from your state unemployment agency. Enter the year and quarter when the rate becomes effective in the Effective Yr/Qtr field. This enables you to have different rates within a single calendar year. |
Override |
(MA only.) The Massachusetts standard Health Ins Rate is set by default from the State Tax table. For Massachusetts, the Health Insurance Rate differs for newer employers. If you’re a Massachusetts employer to whom a lower rate applies, select this check box and enter the correct Massachusetts Health Ins Rate. |
Health Ins Rate (MA only) |
(MA only.) If you select Override, enter the correct Health Ins Rate. |
Branch Code |
This field is informational for Arizona. TAX810AZ.SQR and TAX860AZ.SQR append the branch code to the end of the state EIN. |
Exempt From ER Disability |
Select this check box if employees in this state are exempt from employer-paid state disability tax. This field is for informational purposes only and is not used by the system. |
Experience Rate |
The experience rate you enter in the State Disability group box should reflect the rate you receive from your state disability agency. Enter the year and quarter when the rate becomes effective in Effective Tax Yr/Qtr. This enables you to have different rates within a single calendar year. Note. You must set up a record for Quarter 1, because the system assumes a Quarter 1 record exists. A record for a subsequent quarter is required only if the rate changes mid-year. If you set up a Quarter 2 record, and you don’t have a Quarter 1 record, you receive the error “SUT rate not found on Company/State Tax table” during Pay Calculation. This error occurs regardless of the pay end date you are processing. |
Employer ID |
Enter the appropriate employer ID for the State Disability group. This is used for quarterly tax reporting for California when you specify to separately report UI, DI, and PIT wages. You can set this default on the Company table. |
Setting Up SUT Exemptions To Generate Data for the TAX002 and TAX810 Reports
The TAX002 and TAX810 reports are generated based on SUT wages. When you select the Exempt From SUT field on this page, the system does not generate taxable wages, and the TAX002 and TAX810 reports will contain no data.
Perform the following to generate taxable earnings, enabling the TAX002 and TAX810 reports to produce the required wage detail reporting data, while still remaining exempt from State Unemployment Taxes:
Ensure that the Company Exempt from SUT field on the Company Table-FICA/Tax Details page is cleared.
Leave the Exempt From SUT field on the Company State Tax Table - General page cleared.
These steps should ensure that the Exempt From SUT field on the State Tax Data page remains clear for each employee. Verify that the Exempt From SUT field is clear on all three pages.
Enter a dummy number in the State Unemployment Employer ID field on the Company State Tax Table – General page.
Enter a value of 0 (zero) in the State Unemployment Experience Rate.
After you do these steps, the system can track taxable wages without calculating SUT tax dollars. The TAX002 or TAX810 report can report the SUT subject wages.
Access the Company State Tax Table - VDI page.
Voluntary Disability Plan |
Select this check box to indicate that the plan you’re defining is a voluntary disability plan allowed by the state. |
Plan Number |
Enter the plan number of the voluntary disability plan. For New Jersey, this number appears on Form W-2. |
VDI Administrator Code |
Select the code that identifies the administrator of the voluntary disability plan. You maintain VDI Administrator Codes on the VDI Administrator table. |
Employee Rate |
Enter the employee-paid rate. |
Employer Rate |
Enter the employer-paid rate. |
To set up VDI with a rate of zero so that you can track the VDI wages, enter 99.99999 as the Employee Rate and Employer Rate on this page.
Access the Company State Tax Table - GL Accounts page.
Enter the general ledger account numbers, if applicable, for the following company liabilities:
SWT |
State Withholding liabilities. |
SUT (Employee) |
State Unemployment employee liabilities. |
SUT (Employer) |
State Unemployment employer liabilities. |
SDI (Employee) |
State Disability employee liabilities. |
SDI (Employer) |
State Disability employer liabilities. |
VDI (Employee) |
Voluntary Disability employee liabilities. |
VDI (Employer) |
Voluntary Disability employer liabilities. |
For each municipality and overlying school district, the State Tax Register lists the effective rates for both Earned Income and Occupational Privilege taxes for residents and, when applicable, non-residents. Earned income and occupational privilege tax collector information for each municipality and school district are also listed. In some instances, there are different tax collectors for the municipality and the school district. When this occurs, employers must remit the school district’s tax to its collector and the municipality’s tax to its collector.
Tax collectors are set up as vendors using the Tax Collector Table (TAX_COLLECTOR_TBL) component or the Vendor Table component (VNDR_ID). After entering information about the tax-collecting agency, enter the vendor code on the Local Tax Type-Classes page.
See Also
Establishing Tax Types for PeopleSoft Enterprise Accounts Payable Integration
To establish company local taxes, use the Company Local Tax Table component (COMP_LOCAL_TAX_TBL).
This section discusses how to set up company local tax table entries.
Note. You must complete the Company Local Tax table before local tax data for employees is entered because the locality field on the Local Tax Data page is edited against this table.
Page Name |
Object Name |
Navigation |
Usage |
COMP_LOCAL_TAX_TBL |
|
Set up an entry in the Company Local Tax Table page for each locality where the organization withholds or pays taxes. |
|
PRCSRUNCNTRL |
|
Run TAX705 to print information from the Company Local Tax Table, which identifies the localities for which your organization collects and pays taxes. |
Access the Comp Local Tax Tbl page.
Employer ID |
This field is used for local withholding tax for this locality. It is set by default to the Employer ID for state withholding taxes on the Company State Tax table. |
GL Account Number - Local Withholding Tax for Non Commitment Accounting
These accounts are General Ledger accounts for use with local withholding tax; they are only used by the PayGL01 process. Only GL information not subject to Commitment Accounting would use these accounts.
Employee and Employer |
If you have general ledger account numbers to which you post liability for local withholding tax for this locality, enter the employee and employer account numbers here. |
To set up state and locality tax routing, use the State Tax Routing USF component (GVT_STATE_TAX_ROUT) and the Locality Tax Routing USF component (GVT_LOC_TAX_ROUT).
This section lists the pages used to set up state and locality tax routing.
Page Name |
Object Name |
Navigation |
Usage |
GVT_ST_TAX_RT1 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, State Tax Routing USF, State Tax Routing 1 |
Identify the payment method for paying state taxes and provide details of the EFT method. |
|
GVT_ST_TAX_RT2 |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, State Tax Routing USF, State Tax Routing 2 |
Identify check address information if the payment method for paying state taxes is by check. |
|
GVT_LC_TAX_RT1 |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Locality Tax Routing USF, Locality Tax Routing 1 |
Identify the payment method for paying local taxes and provide details of the EFT method. |
|
GVT_LC_TAX_RT2 |
Set Up HRMS, Product Related, Payroll for North America, Local Taxes, Locality Tax Routing USF, Locality Tax Routing 2 |
Identify check address information if the payment method for paying local taxes is by check. |
|
GVT_ST_TAX_RT_DET |
Click the TXP Addendum Control button on the State Tax Routing 1 page or the Locality Tax Routing 1 page. |
Provide TXP addendum information and amount controls. |
To establish tax types for PeopleSoft Enterprise Accounts Payables integration, use the Tax Type Table USA component (TAX_TYPE_TBL), Tax Type Table USF component (TAX_TYPE_TBL), or Tax Type Table CAN component (CAN_TAX_TYPE), the State Tax Types/Classes USA component (STAT_TAX_TYPE_TBL) or State Tax Types/Classes USF component (STAT_TAX_TYPE_TBL), and the Local Tax Types/Classes USA component (LOCL_TAX_TYPE_TBL) or Local Tax Type/Classes USF component (LOCL_TAX_TYPE_TBL). Use the TAX_TYPE_TABLE component interface to load data into the tables for the Tax Type Table USA component and Tax Type Table USF component
This section provides an overview of tax types for accounts payable integration and discusses how to:
(CAN) Define Canadian federal and provincial tax types.
(USA) Link tax types to federal or state tax vendors and tax classes.
(USA) Link tax types to local tax vendors and tax classes.
See Also
Administering the Interface with PeopleSoft Payables
If you plan to use PeopleSoft Accounts Payable to send tax authorities the taxes deducted from employees’ paychecks, you must link the appropriate set of deductions to each tax vendor.
Tax types are used to link tax classes to vendors. A tax type represents a collection of tax classes, such as withholding, earned income credit, and so on, specific to a particular tax jurisdiction (federal, state, local, provincial).
Setting up tax types and linking them to vendors is done differently for the U.S. and Canada.
Canada
Use the Canadian Tax Types page to name the tax type and link it to tax classes and vendors.
U.S.A.
Define tax types on the Tax Type Table page.
Link tax types to tax classes and vendors on the State Tax Type Table page or the Local Tax Type Table page.
Example
In the state of California, employees are subject to two taxes for short-term disability: SDI (paid to the state) and OASDI (paid to the federal government). Each tax is comprised of a different set of tax classes. In this case, you might create a tax type named Short-Term disability. You would then access the Fed/State Tax Type/Classes page and define what Short-Term Disability represents at the federal level: For the vendor, you select the Internal Revenue Service; for the tax classes you select only those included in OASDI. You then repeat the process to define Short-Term Disability at the state level. This time, you select the Franchise Tax Board as the vendor and just those tax classes that contribute to SDI.
Page Name |
Object Name |
Navigation |
Usage |
TAX_TYPE_TBL |
|
Define the names of the tax types you want to use. |
|
CAN_TAX_TYPE |
Set Up HRMS, Product Related, Payroll for North America, AP - Tax Types/Classes, Tax Type Table CAN, Tax Type Table |
Define Canadian federal and provincial tax types and link them to vendors and tax classes. |
|
STAT_TAX_TYPE_PNL |
|
Link a tax type to a federal or state tax authority and set of tax classes. |
|
LOCL_TAX_TYPE_PNL |
|
Link a tax type to the local tax authority and the applicable set of tax classes. |
Access the Canadian Tax Type Table page.
Source |
Select the type of tax transaction from the options available. Values include Goods and Services Tax, Health and Payroll Taxes, Provincial Sales Tax, or Statutory Deductions. |
Province |
If you chose Provincial Sales Tax in the Source field, select the Province in this field. |
Tax Class |
Select the tax class you want to associate with this tax type and vendor from the options available. Add all applicable tax classes. The Source field determines which tax classes are available for selection.
|
See Also
Access the State Tax Type Table page.
Note. Enter $U in the search page to enter federal tax type information.
Tax Type |
Select the tax type you want to define. The prompt table displays the names of the tax types you set up on the Tax Type Table page. |
SetID |
Select the setID for the tax type. This determines which set of vendors (tax authorities) you can select in the Vendor ID field. |
Vendor ID |
Select the tax authority (vendor) to which you want the taxes for this tax type paid. The prompt table displays only those vendors associated with the setID you selected. |
Class Name |
Select the tax classes associated with this tax type and vendor. Add all applicable tax classes. |
Access the Local Tax Type Table page.
The fields on this page are the same as those on the State Tax Type Table page.
See (USA)(USF) Linking Tax Types to Federal or State Vendors and Tax Classes.
To define tax locations, use the Tax Location Table component (TAX_LOCATION_TBL). Use the TAX_LOCATION_TBL component interface to load data into the tables for this component.
This section provides an overview of tax locations and discusses how to:
Establish the locations for which you process payroll and taxes.
Associate states and localities with the tax location code.
The system establishes federal, state, and local employee tax data and tax distribution data according to the information you establish in the Tax Location table. In this table, you establish each of your locations with a Tax Location ID and identify the work states, provinces, and localities associated with each tax location.
Note. If you’ve selected Automatic Employee Tax Data on the Installation table, the system automatically sets up tax data for each work and resident state and locality of each of your employees. Tax distribution records are created for the work state/locality if the tax location represents a single state/locality.
Page Name |
Object Name |
Navigation |
Usage |
TAX_LOCATION_TBL1 |
|
Establish the locations for which you process payroll and taxes. |
|
TAX_LOCATION_TBL2 |
|
Associate any number of states, localities, and linked localities with the tax location code. |
|
PRCSRUNCNTL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Tax Location, Tax Location Report |
Generate PAY718 that lists information from the Tax Location Table. |
Access the Tax Location Table - Address page.
Tax Location Code |
Establish a tax location code for each location for which you process payroll and tax data. You can associate any number of states and localities with each code. |
Alaska Area Code |
If applicable, select an Alaskan area code. |
Note. If you select Automatic Employee Tax Data on Installation table 1 and assign a Tax Location ID to each employee on the Job Data table, each employee’s tax data is set by default to the Employee Tax Data page and the Employee Tax Distribution page.
Access the Tax Location Table − State/Province/Locality page.
State |
Use to identify each state that is associated with the tax location code. You can associate any number of states with a single tax location. For each state, identify each taxing locality, if any. The states you associate with this tax location code must be defined on the Company State Tax table and the Company Local Tax table. This value is set by default to the Employee Tax Data pages and the Employee Tax Distribution page for employees you assign to this tax location. |
Locality |
The localities you associate with this tax location code must be defined on the Company State Tax table and the Company Local Tax table. This value is set by default to the Employee Tax Data pages and the Employee Tax Distribution page for employees you assign to this tax location. |
Other Work Locality |
Use this field only where multiple local taxes apply in one location, such as:
Note. You should never attempt to enter multiple Indiana localities. Regardless of the number of Indiana locations in which an employee may work, either simultaneously or over the course of the year, the employee is liable for Indiana county tax for only one Indiana county per calendar year. This is the Indiana county of residence as of January 1, if that county imposes a tax, or the Indiana county of principal work activity as of January 1, if the residence county does not impose a tax. |
Note. Locality and Other Work Locality are not required in Canada, because a Canadian employee can be taxed in only one Province at a time, and there are no locality taxes in Canada.
See Also
Setting Up Organization Foundation Tables
Understanding Split Local Tax Distribution for KY, AL, and OR
To establish 1042 processing for non-resident aliens, use the Treaty/NR Alien Table component (TREATY_NR_ALIEN_TA).
This section provides an overview of tax treaties and discusses how to set up 1042 processing for non-resident aliens.
The U.S. government has entered into tax treaties with nearly 40 foreign jurisdictions. Income tax treaties coordinate the tax systems of the United States and other countries that are parties to treaties. Treaty provisions affect the taxation of non-resident aliens working in the U.S. While tax treaties are generally based on a standard model, each treaty might have slightly different provisions.
To claim benefits of a treaty, an employee must have a visa and be a resident of one of the treaty countries. An employee can claim benefits of only one treaty at any given time. Employees who want to claim benefits under a tax treaty must submit a written statement and applicable forms (W-4, Form 8233, Form 1001) to their employer.
As an employer, you must apply the specific treaty rules when calculating federal withholding tax. These rules often include time limits and earnings caps. Different types of earnings, such as scholarships, grants, and fellowships, might be subject to different taxation rates. You must produce a Form 1042-S and a 1042 summary form for each non-resident alien employee affected by the special withholding rates. If you file 250 or more 1042-S forms, you must report on magnetic media. Earnings reported on a 1042-S are not reported on a W2; so, an employee may need both a W2 and a 1042-S if some earnings are covered by the special tax treaty rates and some are not.
In addition to employees covered by tax treaties, some non-resident alien employees, such as those with specific types of earnings such as scholarships, fellowships, and grants, must also have those earnings reported on a 1042-S.
Use the Treaty/NR Alien Table page to capture the tax rates specified in tax treaties (including exempt earnings, which are recorded with a 0% tax rate). This table identifies those earnings subject to a 30% flat withholding tax.
Page Name |
Object Name |
Navigation |
Usage |
TREATY_NRA_TABLE |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, Treaty/NR Alien Table |
Set up the rules associated with the treaties required for each country with which the U.S. has an agreement. |
|
PRCSRUNCNTL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, Treaty/Non Resident Alien, Treat/Non Resident Alien Rpt |
Report on information from the Tax Treaty Table using Tax Treaty Table report (TAX720.SQR) |
Access the Treaty NR Alien Table page.
Country |
If you want to establish entries on the Tax Treaty NR Alien table that are applicable to more than one country (for example, to use for all scholarship income that is to be taxed at 30%), you can use any value prefixed by a $ in the country code (for example, Country = $S). |
Allowances Permitted |
For each tax treaty record you establish, specify the number of allowances permitted by the treaty. |
Income Code (for 1042-S) |
Select each type of earnings subject to special tax treatment under the treaty. |
Max Earnings Eligible Per Year |
Specify the earnings caps that apply for each earnings type. |
Tax Rate (after form) |
Specify the taxation rates that apply for each earnings type. |
Tax Rate (before form received) |
Specify the taxation rates that apply for each earnings type. |
Note. PeopleSoft re-delivers the tax treaty table with each major version and, if required, with the year-end Tax Update. If interim changes are required, you must track and apply the changes in your environment.
See Also
To establish UI report codes, use the UI Report Code Table component (CO_UI_RPTCD_TBL).
This section discusses how to set up UI report codes.
Page Name |
Object Name |
Navigation |
Usage |
CO_UI_RPTCD_TBL |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, UI Report Code Table |
Establish UI report codes in PeopleSoft Payroll for North America for multiple work sites. |
Access the UI Report Code Table page.
Information you enter here works with the Multiple Worksite Report (SQR TAX004) to link a Tax Location Code to a UI Report Code. When you add an entry to the UI Report Code table, the system prompts you to enter the company code and the location code of the site you want to establish for reporting worksite information to the U.S. Bureau of Labor Statistics.
Company UI Information
UI Report Code |
Enter the code you have received from the state for this site. |
Employer ID Ext (employer ID extension) |
(E&G) This field is for employers that need to report the quarterly tax report for multiple account numbers for different locations (MN/MI) or multiple categories (CA). The MN/MI tax report programs (both tax report and create magnetic tape) append the extension ID to Employer SUT ID (from the Company State Tax table) as a unique ID for reporting purposes. |
To establish standard occupational classifications for Alaska, use the U.S. SOC Table component (US_SOC_TBL). Use the US_SOC_TABLE component interface to load data into the tables for this component.
This section discusses how to set up U.S. standard occupation classifications for Alaska.
Note. If your company has no operations in Alaska, ignore the U.S. Standard Occupational Classification (SOC) table.
Page Name |
Object Name |
Navigation |
Usage |
US_SOC_TABLE |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, U.S. SOC Table |
Set up the U.S. Standard Occupational Classification (SOC) Table page in quarterly unemployment insurance reporting for the state of Alaska. |
Access the U.S. SOC Table page.
Standard Occupational Classification Code |
The codes established here are used in the reports Quarterly State Employee Wage Listing for Alaska (TAX002AK) and Quarterly UI Wage Tape for Alaska (TAX810AK). These reports correspond to Alaska’s quarterly Employer’s Report of Wages for Each Employee form. |
Note. Use the Job Code table to link Standard Occupational Classification codes with particular job codes in your organization.
To specify voluntary disability insurance plan location and contact information, use the VDI Administrator Table component (VDI_ADMINISTRATOR).
This section lists the pages used to enter voluntary disability insurance plan location and contact information.
Page Name |
Object Name |
Navigation |
Usage |
VDI_ADMIN_TABLE |
Set Up HRMS, Product Related, Payroll for North America, Federal/State Taxes, VDI Administrator Table |
Enter location and contact information about the administrators of employee voluntary disability plans. After you’ve established your VDI Administrators, assign administrators to their voluntary disability plans on the Company State Tax Table 2 page. |
|
PRCSRUNCNTL |
Set Up HRMS, Product Related, Payroll for North America, Tax Table Reports, VDI Administrator |
Report on information from the VDI Administrator Table using the VDI Administrator report (TAX715.SQR). |
To specify parameters for quarterly tax reporting, use the Tax Reporting Parameters component (TAX_RPT_PARAMETERS).
This section discusses how to define parameters for quarterly tax reporting:
Page Name |
Object Name |
Navigation |
Usage |
TAX_RPT_PARAMETERS |
Payroll for North America, U.S. Quarterly Processing, Define Quarterly Tax Reporting, Tax Reporting Parameters, Quarterly Tax Reporting Parms |
Set up parameters for quarterly tax reporting. |
Access the Quarterly Tax Reporting Parms page.
Balances for Year |
The value you enter here defines the reporting period. |
Balances for Quarter |
The value you enter here defines the reporting period. |
Electronic Mag Media Rpt Parms
Transmitter ID |
Enter the Company ID of the company transmitting W-2s for tax reporting. This is used in a multi-company environment when a single company acts as the transmitter for all companies in the organization. |
Computer Manufacturer |
Enter the name of the manufacturer, such as IBM, Compaq, or Digital that makes the computer you use to create the magnetic media (such as diskette or tape) for tax reporting. |
Organization Type |
Select Government or Other. |
Type of Employment |
Select Agriculture, Federal, Medicare Qualified Government Employee, Military, Railroad, or Regular (All Others). |
Recording Code |
Select ASCII or EBCDIC. |
Tape Label |
Select the type of tape label. |
Tape Density |
Select the tape density. |
Blocking Factor |
Enter the blocking factor. |
To define Canadian tax information, use the Canadian Company Tax Table component (CO_CAN_TAX_TABLE) and the Wage Loss Plan Table component (WAGELS_PLN_TBL).
This section discusses how to:
Define Canadian company tax information.
Define Canadian wage loss plans.
Define Canadian yearly tax reporting parameters.
Access the Canadian Company Tax Table page.
Company Tax Information
Prescribed Interest Percent |
If your company processes low interest loans, enter the current prescribed interest percent. This rate is updated quarterly by the Canadian federal government. |
Company Tax Rates
Province |
Enter all applicable provinces in which the company operates and needs to process PPT tax or override a Health Insurance Rate. |
Provincial Premium Tax Percent |
Enter the provincial premium tax percent applicable to group life and health insurance benefit plan premiums, if your company is responsible for withholding and submitting the tax. |
Health Insurance Rate Override |
Enter the health insurance rate override to specify the premium rate that applies to your company, if that rate is different from the rate defined on the Canadian Tax Table Provincial Rates page. This field applies to companies operating in provinces, such as Ontario and Manitoba, where variable rates apply based upon total gross payroll figures. |
Note. It is your responsibility to update all rates on the Canadian Company Tax table.
Warning! It is your responsibility to update the Prescribed Interest Percent field according to the rate set each quarter by the Canadian federal government. PeopleSoft does not update this field in its tax updates; PeopleSoft leaves the field blank.
Access the Wage Loss Plan Liability Accts page.
The Canadian Wage Loss Plan table identifies valid Canadian wage loss replacement plans. The Wage Loss Replacement Plan field in the Canadian Income Tax Data table at the employee level is edited against this table. You must create entries on this table before you enter any Canadian tax data for your employees. You must set up at least one entry on the Wage Loss Plan table for each company. Typically, you create this entry using the default EI Employer Rate and corresponding Quebec EI Employer Rate. You must define additional entries for each wage loss plan your company has registered with CRA.
Wage Loss Plan Information
Business Number |
For each plan you set up, enter your company’s unique CRA Taxation account number in this field. Because a company can have more than one wage loss replacement plan, you can set up any number of plans on this table. |
EI Employer Rate |
This is the rate of your contribution to Employment Insurance. The default rate (which comes from the Employer EI Premium Rate on the Canadian Tax table) may be overridden with your specific plan rate. |
RCT Acct # |
This field is hidden on the page for all entries with an Effective Date of 01/01/1997 or later. The field will be displays and is available for use for all entries dated prior to 01/01/1997 for historical purposes only. |
Quebec EI Employer Rate |
This is the rate of your contribution to Employment Insurance. You can override the default rate (which comes from the Quebec Employer EI Premium Rate on the Canadian Tax table) by entering your specific plan rate. |
To define Canadian WCB assessment reporting, use the WCB classifications Component (CAN_WCB_CU_RATES). Use the CAN_WCB_CU_RATES component interface to load data into the tables for this component.
This section provides an overview of Canadian WCB assessment reporting and discusses how to:
Define WCB assessable earnings.
Define WCB classifications, rate groups, and assessment rates.
PeopleSoft Payroll for North America enables employers registered with the Workers’ Compensation Boards (WCB) in Canada to report and pay assessments based on the total assessable earnings of their workers. The system accommodates the assessment reporting structures of all provinces. This functionality enables the reporting of assessments by rate groups and classification units.
Page Name |
Object Name |
Navigation |
Usage |
CAN_WCB_CU_RATES |
Set Up HRMS, Product Related, Payroll for North America, Canadian Taxes, WCB Classifications |
Define WCB classifications, rate groups, and assessment rates. |
To define WCB assessable earnings, you need to establish a new Tax Form ID—WCB Assessable Earnings—and the associated tax form Boxes for each province on the Tax Form Definition page. The Boxes reflect the two-letter province code, preceded by a W.
You also must define and associate the assessable Earnings and Deduction Codes for each province with the WCB Assessable Earnings Tax Form ID. The Earnings Codes defined as Regular Hours and Overtime Hours on the Pay Group table are automatically accumulated by the system as assessable earnings without defining them on the Tax Form Definitions page.
Select the applicable provinces and define the assessable earnings.
Associate the WCB Assessable Earnings tax form ID with the appropriate Plan Type, Deduction Code, Ded (Deduction) Class, Sales Tax, and Earnings Code.
Note. The earnings codes defined as Regular Hours and Overtime Hours on the Pay Group table are automatically accumulated by the system as assessable earnings without defining them on the Tax Form Definitions page.
See Also
Accessing Year-End Processing Instructions
Access the WCB Classifications page.
This page can accommodate both a single classification assigned to a single province and multiple Rate Groups associated with multiple classifications (or CUs) for a single province.
WCB Firm Number |
Enter the WCB firm number. If a single rate group and/or classification and assessment rate applies to all covered employees in the province, select Single Classification Firm. |
Single Classification Firm |
If this check box is selected, the Workers Compensation report (PAY102CN) uses the entry on this page as the source for reporting assessment information for all covered employees in the province. If this check box is cleared, the information defined on the Job Code table (WCB Classifications page) 4 is used as the source for reporting. |
Rate Group |
When adding the original entry for a province, this is set by default to N/A . If rate groups are applicable to the specified province, override the default by entering the rate group. |
Default Assessment Rate |
If you enter a default assessment rate, that rate populates into the Assessment Rate for each Classification assigned to the Rate Group. |
Description (for Rate Group) |
Enter the rate group description, if applicable. Similar to the Rate Group field, the description is set by default to Not Applicable when adding the original entry for a province. |
Classification |
Define a classification or classification unit (CU). |
Assessment Rate |
Enter the assessment rate applicable to the classification. |