This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 4 KB jmyers to previous
9 26-Nov-2021 10:22 4 KB jmyers to previous | to last
8 26-Nov-2021 10:22 4 KB jmyers to previous | to last
7 26-Nov-2021 10:22 14 KB jmyers to previous | to last
6 26-Nov-2021 10:22 14 KB jmyers to previous | to last
5 26-Nov-2021 10:22 14 KB jmyers to previous | to last
4 26-Nov-2021 10:22 14 KB jmyers to previous | to last
3 26-Nov-2021 10:22 15 KB jmyers to previous | to last
2 26-Nov-2021 10:22 14 KB jmyers to previous | to last
1 26-Nov-2021 10:22 10 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 2 changed one line
!!!OREGON STATE TAX CALCULATION
!!!PENNSYLVANIA STATE TAX CALCULATION
At line 4 changed 6 lines
!!Oregon State Tax Calculation
On [IPUTR], there is a list of applicable taxes to be calculated for State of Oregon:
|41-000-0000-SIT-000|Oregon State Tax
|41-000-0000-ER_SUTA-000|Oregon State Unemployment Tax
|41-000-0000-WC-000|Oregon Worker's Compensation
|41-000-0000-ER_WC-000|Oregon Worker's Compensation - Employer
!!Pennsylvania State Tax Calculation
On [IPUTR], there is a list of applicable taxes to be calculated for State of Pennsylvania:
|42-000-0000-SIT-000|Pennsylvania State Tax
|42-000-0000-ER_SUTA-000|Pennsylvania State Unemployment Tax
|42-000-0000-SUI-000|Pennsylvania SUI
At line 11 changed 7 lines
If [UPUTR] is run with list of Jurisdictions, the following entries may exist:
|41-000-0000-ER_TRANS-001|Canby Transit Tax
|41-000-0000-ER_TRANS-002|Lane Transit Tax
|41-000-0000-ER_TRANS-003|Trimet Excise Tax
|41-000-0000-ER_TRANS-004|Sandy Transit Tax
|41-000-0000-ER_TRANS-005|Wilsonville Transit Tax
|41-000-0000-ER_TRANS-006|South Clackamas Transit Tax
If [UPUTR] is run with list of Pennsylvania Jurisdiction, the following entries may exist:
|42-000-1209052-CITY-000|Philadelphia City Tax
|42-000-1213644-ER_POP-000|Pittsburgh Payroll Tax
At line 19 removed 7 lines
On [IPUTP], there is a list of applicable US Miscellaneous Tax Parameters for State of Oregon. If these Miscellaneous identifiers do not exist, run [UPUTR] for State of Oregon to generate them.
||Miscellaneous Identifiers||Description
|STATE_ROUNDING|State Rounding Rule\\ \\The default value is always set to DEFAULT when this identifier is first created by [UPUTR].\\ \\For State of Oregon, the Default Rounding Rule used by Symmetry is to ROUND the State Tax result.\\ \\If rounding the state tax is not desired, enter NO in this field.
*In order to calculate the Transit tax for all employees, enter 'YES' to the applicable Transit Tax on [IPUTP].
*In order to calculate Transit Tax for certain employees, enter YES to the Transit Tax on [IPRLU].
\\ \\
At line 27 changed 2 lines
!OR – IPRLU Set Up
The Miscellaneous Tax parameters must be set up for the following Miscellaneous Identifiers, if these identifiers do not exist, [UPCALC] will generate the default entries for them.
!PA – IPRLU Set Up
There is no State Miscellaneous Parameters for Pennsylvania, however [IPRLU] Miscellaneous Tax Parameters may be required to be set up for additional information.\\ \\
If these Identifiers do not exist, [UPCALC] will generate the default entries for the identifiers
At line 30 changed 2 lines
|FILINGSTATUS|Mandatory\\'S'-single, 'M'-married, or 'MH'-married but w/h at higher single rate.
|TOTALALLOWANCES|Optional\\Enter the total number of allowances.
|LOC_COURTESY_PA_EIT|Optional//Pennsylvania EIT Local Courtesy Option
At line 33 removed 16 lines
The following optional Miscellaneous Identifiers may be manually entered on [IPRLU]:
||Miscellaneous Identifiers||Description
|SUP_PAID_WITH_REG|Optional\\Supplemental Paid with Regular Wages
|SUP_PAID_WITHOUT_REG|Optional\\Supplemental Paid without Regular Wages
| |
|TRANSIT_CANBY_TAX|Oregon Canby Transit Tax
|TRANSIT_LANE_TAX|Oregon Lane Transit Tax
|TRANSIT_TRIMET_EXCISE_TAX|Oregon Trimet Excise Tax
|TRANSIT_SANDY_TAX|Oregon Sandy Transit Tax
|TRANSIT_WILSONVILLE_TAX|Oregon Wilsonville Transit Tax
|TRANSIT_SOUTH_CLACKAMAS_TAX|Oregon South Clackamas Transit Tax
\\ \\
*If the Workers Compensation Fund is to be calculated for an employee, the ‘WC Method’ in the [IPRLU State|IPRLU#StateTab] tab must be set to ‘Calc by US Taxation’ or ‘Both by IPWC and US Taxation’.
*WC Method ‘Calc by IPWC Class’ will use the rates defined by class in [IPWC] to calculate the Workers Compensation
*If the [IPRLU] WC Method is not set up, then the [IPPGU] Pay Category WC Method will be used
\\ \\
At line 50 changed one line
!OR – ER SUTA
!PA – ER SUTA, EE SUI
At line 56 changed one line
#*This rate is applicable for the entire company within the State of Oregon.
#*This rate is applicable for the entire company within the State of Pennsylvania.
#*The SUI Rate and Wage Base are supplied and will be used as default
#*This SUI Rate or Wage Base may be overridden, if necessary
At line 58 changed one line
#*If there is a specific rate given by the government for a different State Registration #, then enter the rate on [IDGV] by ‘Reg Type’; this overrides the [IPUTR] rate.
#*If there is a specific rate given by the government for a different State Registration #, then enter the rate on [IDGV] by ‘Reg Type’; this overrides the [IPUTR] rate.\\ \\
For SUI, the [IPUTR] SUI built-in rate and SUI wage base may be overridden by one of the options above.
It is recommended that if the SUI rate is overridden, the SUI overridden wage base should also be entered. This is to ensure that with the overridden SUI rate, the SUI is able to stop at the proper maximum wage base with the new rate.
At line 61 changed one line
!OR – IPPC / PC Usages
!PA – IPPC / PC Usages
At line 64 changed one line
In order to calculate the following taxes, set up [IPPC] for these PC Usages:
In order to calculate the following taxes, a pay component must be set up in [IPPC] for these PC Usages:
At line 67 changed 9 lines
|6058|Pre-FWT Hours - Total Hours worked, this is used for WC calculation
|7006|Workers Comp Employee Tax
|7007|Workers Comp Employer Tax
|7480|OR-Canby Transit Tax
|7481|OR- Lane Transit Tax
|7482|OR-Trimet Excise Tax
|7483|OR-Sandy Transit Tax
|7484|OR-Wilsonville Transit Tax
|7485|OR-S Clackamas Transit Tax
|7501|PA-EMST / LST Local Service Tax
EMST (Emergency Service Tax) and LST (Local Service Tax) are the same tax, the tax has had a few different names over the past few years.
At line 77 changed 3 lines
----
!OR – County Tax
On May 20, 2003, Multnomah county residents (GNIS Code 41-051-1135861) passed Measure 26-48, which established a temporary three year personal income tax on county residents. The tax was effective January 1, 2003 and is 1.25% of Oregon taxable income after an exemption deduction ($5,000 for joint filers and $2,500 for a single filer). The Multnomah County Tax was discontinued beginning January 1, 2006, thus STE will return zero for this County tax.
Pennsylvania EIT (Earned Income Tax) is treated and stored as City and School District tax. Pay components will need to be defined for PC Usage 6901 (City Work Tax pay components) to PC Usage 6933 (City Res Tax pay components).
At line 82 changed 8 lines
!OR– Workers Comp Employee and Employer
The Oregon Employee Workers Compensation Fund is computed as a dollar amount multiplied by the number of hours worked by the employee with no limit on the amount withheld. For 2011, the dollar amount is $0.014 and [IPPC] must be set up for PC Usage 6058 Pre-FWT Hours for Workers Comp.
*The Oregon Employer Workers Compensation tax is computed on the hours worked by employees.
*If the Workers Compensation Fund is to be calculated for an employee, the ‘WC Method’ in the [IPRLU State|IPRLU#StateTab] tab) must be set to ‘Calc by US Taxation’ or ‘Both by IPWC and US Taxation’.
*If the method is ‘Calc by US Taxation’, only the WC Fund will be calculated for the employee using the rate in [IPUTR].
*If the method is ‘Both by IPWC and US Taxation’, WC will be calculated using the rates defined in [IPWC] for Workers Compensation Class, as well as the WC fund rate defined in [IPUTR]. The WC amounts will be stored in separate pay components.
*The ‘Do Not Calculate’ toggle may be checked on [IPUTR] to bypass WC Calculation if desired.
*If [IPRLU] WC Method is not set up, then the [IPPGU] Pay Category WC Method will be used.
!PA – EIT
At line 91 changed 4 lines
%%information Note: For Oregon Workers Compensation, in order to override the employee WC portion and move to the employer WC portion, then this employee WC portion becomes taxable and subject to SIT and SUTA tax.\\ \\In this case, WC should be calculated via Usercalc instead of by Symmetry.
*In Usercalc, calculate the employee and employer WC portion and store in the pay component before US Taxation Pay point.
*Then include this employee WC pay component into the Elements of Pre-State Earnings (Usage 6651) and Pre-SUI Employer Earnings (Usage 6752).
This approach truly reflects the Employee WC portion in the Pre-Tax Earnings pay components and will carry through the system for the use of Self-Adjust method etc.%%
The Pennsylvania Earned Income Tax (EIT) is a tax levied as a percent of earned income at the City, Municipality or School District level. Therefore the jurisdiction must be set up with State, County, City, Municipality and School district.
At line 53 added 2 lines
Pennsylvania EIT will be calculated based on State Regular and Supplemental Earnings. The tax results are stored at the City and School District level taxation.
\\ \\
At line 97 changed 2 lines
!OR – Transit Tax
Oregon has levied a transit tax upon employers doing business within certain transit areas. There are six areas which have Transit tax which tax is upon regular and supplemental wages.
!PA – OPT / EMST / LST
At line 100 changed 11 lines
On [IPUTR], there are six entries for Transit Tax
*OR-Canby Transit Tax
*OR- Lane Transit Tax
*OR-Trimet Excise Tax
*OR-Sandy Transit Tax
*OR-Wilsonville Transit Tax
*OR-S Clackamas Transit Tax
In order to calculate the Transit Tax for all employees, enter 'YES' for Transit Tax on [IPUTP].\\
In order to calculate the Transit Tax for certain employee, enter 'YES' to the Transit Tax on [IPRLU] for each employee.
\\ \\
This tax has had three different names over the past few years, OPT / EMST / LST. The tax will be calculated based on the GNIS Code.
\\ \\
At line 112 changed 6 lines
!OR – UPCALC – Symmetry Result
[Symmetry Set Up - OR_01.jpg]\\
[IPRLU Miscellaneous Tab|IPRLU#MiscellaneousTab]\\
FILINGSTATUS = S\\
TOTALALLOWANCES = 0\\
TRANSIT_SANDY_TAX = YES
!PA – Towanda – LST, EIT, School Tax Example
[Symmetry Set Up - PA_01.jpg]
[Symmetry Set Up - PA_02.jpg]
\\ \\
Work GEO: 42-015-1213646 Towanda
At line 119 changed 19 lines
|PC 8046 Res SIT Earn|= 2291.31
|PC 8056 Res SSP Earn|= 89.36
|PC 6042 Res SIT|= 170.44 (IPUTP STATE_ROUNDING = NO)
|PC 6052 Res Supp Tax|= 89.36 x 0.09 = 8.04
|PC 6703 SUI ER Contr|= 2510.71 x IPUTR 41-000-0000-ER_SUTA-000 Override Tax Rate 0.054
| |= 135.58
| |
|PC 8110 RCNTY Earn|= 2291.31
|PC 8111 RCNTY SupEarn|= 89.36
|PC 6831 Res CNTY Tax|= 0 (County Tax discontinued)
|PC 6850 Res CNTY Sup Tax|= 0 (County Tax discontinued)
| |
|PC 5331 Workers Comp EE|= (PC Usage 6058 Pre-FWT Hours) 80 hours x 0.014 = 1.12
|PC 5332 Workers Comp ER|= (PC Usage 6058 Pre-FWT Hours) 80 hours x 0.014 = 1.12
| |
|PC 5383 OR-Sandy Transit Tax|= Reg 2291.31 x IPUTR 41-000-0000-ER_TRANS-004 Tax Rate 0.006
| |= 13.75
| |= Sup 89.36 x IPUTR 41-000-0000-ER_TRANS-004 Tax Rate 0.006 = 0.54
| |= 13.75 + 0.54 = 14.29
|PC 5402 PA-EMST / LST Tax|This will be calculated by the GNIS code, therefore, there is no need to set up\\ \\Applicable once per period
| |
|PC 6931 RCITY Sup Tax|PA EIT is treated as City and School District tax
|PC 6932 RCITY Schl Sup Tax|
|PC 6951 Res CITY Tax|
|PC 6953 RCITY Schl Reg Tax|
\\
----
!PA – Philadelphia – City Tax Example
[Symmetry Set Up - PA_03.jpg]
\\
Work GEO: 42-101-1209052 Philadelphia
At line 80 added 2 lines
The City of Philadelphia tax is a percentage of gross wages; no school district tax.
\\ \\
At line 140 changed 16 lines
!OR – UPCALC – Vertex Result
[Symmetry Set Up - OR_02.jpg]\\
For Vertex Calculation, the [IPRLU State|IPRLU#StateTab] tab Vtx. Alt Tax Method = ‘01’ must be set up in order to re-calculate State Tax using the Federal Tax based on State parameters. Also the [IPRLU State|IPRLU#StateTab] tab Vtx # of Exemption 1 should = 1 in order to for Vertex to apply the ‘Standard Deduction in the tax formula’ to match the Symmetry Oregon State tax result as above.
|PC 8045 Work SIT Earn|= 2291.31
|PC 8055 Work SSP Earn|= 89.36
| |
|PC 6040 Work SIT|= 170.44 (Rounding = NO)
|PC 6042 Work SIT Sup|= 89.36 x 0.09 = 8.04
| |
|PC 6703 SUI ER Contr|= 2510.71 x SUI ER Tax Rate 0.054
| |= 135.58
| |
|PC 8100 WCNTY Earn|= 2291.31
|PC 8101 WCNTY SupEarn|= 89.36
|PC 6811 WCNTY Sup Tax|= 0 (County Tax discontinued)
!PA – Pittsburgh Payroll Expense Tax Example
[Symmetry Set Up - PA_04.jpg]
\\
Work GEO: 42-003-1214818 Pittsburgh
At line 88 added one line
The Pittsburgh Payroll Expense tax is calculated.
At line 158 removed 26 lines
!OR – Manual Calculation
Oregon Manual Tax Calculation from:\\
[http://www.oregon.gov/DOR/BUS/payroll_updates.shtml]\\
[http://www.oregon.gov/DOR/forms/business/withholding_formulas_150-206-436_2011.pdf]\\ \\
[Symmetry Set Up - OR_03.jpg]\\
__Using the formula from Annual wages of $50,000 or higher__
|Annual Wages 2291.31 x 26 |= 59574.06
|Federal Tax: 403.06 x 26 |= 10479.56
|Since Wages <= $125.000, use PHASE OUT|= 5950.00
|BASE Wages 59574.06 – 5950.00|= 53624.06
__Symmetry Calculation:__
|BASE Wages|= 53624.06
|Standard deduction $1980 for Single|= 1980\\ \\(Note:Vtx Exemption 1 = 1 must be set up for Vertex, otherwise the standard deduction will not be applied)
|53624.06 – 1980|= 51644.06
__Annual Tax Calculation:__
|WH|= 481 + [(BASE – 7750) x 0.09] – (179 x allowance)
|WH|= 481 + [(51644.06– 7750) x 0.09] – (179 x 0)
|WH|= 481 + 3950.47 – 0
|WH|= 4431.47
__State Tax for the period__
|WH|= 4431.47 / 26 = 170.44
----
At line 93 added one line