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 10 KB jmyers to previous
9 26-Nov-2021 10:22 10 KB jmyers to previous | to last
8 26-Nov-2021 10:22 11 KB jmyers to previous | to last
7 26-Nov-2021 10:22 11 KB jmyers to previous | to last
6 26-Nov-2021 10:22 11 KB jmyers to previous | to last
5 26-Nov-2021 10:22 11 KB jmyers to previous | to last
4 26-Nov-2021 10:22 11 KB jmyers to previous | to last
3 26-Nov-2021 10:22 11 KB jmyers to previous | to last
2 26-Nov-2021 10:22 11 KB jmyers to previous | to last
1 26-Nov-2021 10:22 11 KB jmyers to last

Page References

Incoming links Outgoing links
Symmetry Set Up - OR
Symmetry Set Up - OR

Version management

Difference between version and

At line 4 removed 40 lines
!!Oklahoma State Tax Calculation
On [IPUTR], there is a list of applicable taxes to be calculated for State of Oklahoma:
|40-000-0000-SIT-000|Oklahoma State Tax
|40-000-0000-ER_SUTA-000|Oklahoma State Unemployment Tax
\\ \\
----
!OK – IPRLU Set Up
The Miscellaneous Tax parameters must be set up for the following Miscellaneous Identifiers.
||Miscellaneous Identifiers||Description
|FILINGSTATUS|Mandatory\\'S'-single, 'M'-married, or 'MH'-married but w/h at higher single rate.
|TOTALALLOWANCES|Optional\\Enter the total number of allowances.
\\ \\
----
!OK – ER SUTA
ER SUTA may be bypassed on [IPUTR] with ‘Do not Calculate’ or [IPRLU] ‘SUI ER Method’ = ‘Do not Calculate’.
There are two options to set up the ER SUTA rate by state:
#IPUTR
#*Enter the SUTA ER rate that is given by the government on the Override Tax Rate field.
#*This rate is applicable for the entire company within the State of Oklahoma.
#IDGV
#*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.
\\ \\
----
!OK – Trial Calc Example
Work GEO: OK 40-149-2144230 - New Cordell, Oklahoma
[Symmetry Set Up - OK_01.jpg]
|PC 8046 Res SIT Earn|= 1729.97
|PC 8056 Res SSP Earn|= 899.58
| |
|PC 6042 Res SIT|= 74.00
|PC 6052 Res SIT Sup|= 49.00
| |
|PC 6703 SUI ER Contr|= 2766.66 x IPUTR 40-000-0000-ER_SUTA-000 Overridden Rate 0.092
| |= 254.53
----
![Notes|Edit:Internal.Symmetry Set Up - OR]
[{InsertPage page='Internal.Symmetry Set Up - OR' default='Click to create a new notes page'}]
At line 64 changed one line
*In order to calculate Transit Tax for certain employees, enter YES to the Transit Tax on PRLU.
*In order to calculate Transit Tax for certain employees, enter YES to the Transit Tax on [IPRLU].
At line 140 changed 2 lines
On IPUTR, there are 6 entries for Transit Tax
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
At line 108 added 10 lines
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.
\\ \\
----
!OR – UPCALC – Symmetry Result
[Symmetry Set Up - OR_01.jpg]\\
[IPRLU Miscellaneous Tab|IPRLU#MiscellaneousTab]\\
FILINGSTATUS = S\\
TOTALALLOWANCES = 0\\
TRANSIT_SANDY_TAX = YES
At line 144 changed 2 lines
If Employer requires to calculate Transit Tax for all employees, enter YES to the Transit Tax on IPUTP.
If Employer requires to calculate Transit Tax for certain employee, enter YES to the Transit Tax on IPRLU for each employee.
|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
\\ \\
----
!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.
At line 144 added 19 lines
|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)
\\ \\
----
!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]\\
At line 164 added 5 lines
__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
At line 149 changed one line
40.7 OR – UPCALC – Symmetry Result
__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
At line 151 changed one line
__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
At line 181 added 5 lines
__State Tax for the period__
|WH|= 4431.47 / 26 = 170.44
----
![Notes|Edit:Internal.Symmetry Set Up - OR]
[{InsertPage page='Internal.Symmetry Set Up - OR' default='Click to create a new notes page'}]
At line 154 removed 85 lines
IPRLU
FILINGSTATUS = S
TOTALALLOWANCES = 0
TRANSIT_SANDY_TAX = YES
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
40.8 OR – UPCALC – Vertex Result
For Vertex Calculation, user must set up IPRLU State Tab Vtx. Alt Tax Method = ‘01’ in order to re-calculate State Tax using the Federal Tax based on State parameters. Also the State 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)
40.9 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
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: Vertex user must set up Vtx Exemption 1 = 1,
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
This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyersTop