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

Page References

Incoming links Outgoing links
Symmetry Set Up - KY
Symmetry Set Up - KY

Version management

Difference between version and

At line 5 added 43 lines
!!Kansas State Tax Calculation
On [IPUTR], there is a list of applicable taxes to be calculated for State of Kansas:
|20-000-0000-SIT-000|Kansas State Tax
|20-000-0000-ER_SUTA-000|Kansas State Unemployment Tax
\\
----
!KS – 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 the identifiers.
||Miscellaneous Identifiers||Description
|FILINGSTATUS|Mandatory\\The valid filing statuses are:'S'-single, 'M'-married, or 'MH'-married but w/h at higher single rate.
|TOTALALLOWANCES|Optional\\Enter the total number of allowances.
\\ \\
----
!KS – ER SUTA Rate
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 Kansas.
#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.
\\ \\
----
!KS – Trial Calc Example
[Symmetry Set Up - KS_01.jpg]\\ \\
[IPRLU Miscellaneous Tab|IPRLU#MiscellaneousTab]\\
KS0001 - FILINGSTATUS = S
|PC 8046 Res SIT Earn|= 1729.97
|PC 6042 Res SIT|= 86.00
| |
|PC 8056 Res SSP Earn|= 899.58 x 0.05
|PC 6052 Res Supp Tax|= 45.00
| |
|PC 6703 SUI ER Contr|= 2766.66 x IPUTR 20-000-0000-ER_SUTA-000 Override Tax Rate 0.074
| | = 204.73
----
![Notes|Edit:Internal.Symmetry Set Up - KY]
[{InsertPage page='Internal.Symmetry Set Up - KY' default='Click to create a new notes page'}]
At line 68 changed one line
In addition to the OLF, some counties levy a Mental Health tax, a Senior Citizen tax, an Educational School tax, or a Transportation tax.
In addition to the OLF, some counties levy a Mental Health tax, a Senior Citizen tax, an Educational School Tax, or a Transportation Tax.
At line 70 removed 20 lines
__For Example:__
GEO: 21-015-492266 Florence is for County 21-015 Boone County, for City 492266 Florence
\\ \\
On [IPUTR], there are three entries for County 21-015 Boone County, therefore these three taxes will be calculated.
|21-015-0000-OLF-000|Boone County - OLF|Showing County Tax Rate
|21-015-0000-MHT-000|Boone County - MHT|Showing County Mental Health Tax Rate
|21-015-0000-OLTS-000|Boone County - OLTS|Showing County Tax School Rate
*The OLF are defined with ’21-015’ County Level and this will be calculated and stored as County Tax.
*The OLFS are defined with ’21-015’ County Level and this will be calculated and stored as School District Tax.
*MHT will be calculated and stored with PC Usage 7271 - KY- Mental Health and Senior Citizen Tax.
School District Tax are calculated automatically according to the GNIS Code, there is no need to set up [IDSD] School District code for Kentucky, and therefore [IDTX] Jurisdiction entries for Kentucky also do not require to set up by School.
\\ \\
On [IPUTR], there is one entry for City 21-000-492266 Florence, therefore this tax will be calculated.
*The OLF are defined with ’21-000-492266’ City Level and this will be calculated and stored as City Tax.
\\ \\
----
!KY – UPCALC – Symmetry Result
[Symmetry Set Up - KY_01.jpg]\\ \\
[IPRLU Miscellaneous Tab|IPRLU#MiscellaneousTab]\\
KS0001 TOTALALLOWANCES = 0
At line 91 changed 28 lines
|PC 8046|Res SIT Earn|= 3095.73
|PC 8056|Res SSP Earn|= 919.87
|PC 6042|Res SIT|= 167.73
|PC 6052|Res Supp Tax|= 919.87 x 0.06 = 55.19
|PC 6703|SUI ER Contr|= 4365.39 x IPUTR 21-000-0000-ER_SUTA-000 Override Tax Rate 0.10
| | |= 436.54
| | |
|PC 8110|RCNTY Earn|= 3365.39
|PC 8111|RCNTY SupEarn|= 1000.00
|PC 6831|Res CNTY Tax|= 3365.39 x IPUTR 21-015-0000-OLF-000 Boone OLF Rate 0.008 = 26.92
|PC 6850|Res CNTY Sup Tax|= 1000.00 x IPUTR 21-015-0000-OLF-000 Boone OLF Rate 0.008 = 8.00
| | |
|PC 8130|RCITY Earn|= 3365.39
|PC 8131|RCITY SupEarn|= 1000.00
|PC 6951|Res CITY Reg Tax|= 3365.39 x IPUTR 21-000-492266-OLF-000 Florence Rate 0.020000= 67.31
|PC 6953|Res CITY Sup Tax|= 1000.00 x IPUTR 21-000-492266-OLF-000 Florence Rate 0.020000= 20.00
| | |
|PC 8132|RCITY Schl Reg Earn|= 3365.39
|PC 8135|RCITY Schl Sup Earn|= 1000.00
|PC 6954|RCITY Schl Reg Tax|= 3365.39 x IPUTR 21-015-0000-OLTS-000 Boone Rate 0.005000 = 16.83
|PC 6955|RCITY Schol Sup Tax|= 1000.00 x IPUTR 21-015-0000-OLTS-000 Boone Rate 0.005000 = 5.00
| | |
|PC 6471|KY-Mental Health Tax|= 4365.39 x IPUTR 21-015-0000-MHT-000 Tax Rate 0.001500 = 6.55
\\ \\
----
!KY – UPCALC – Vertex Result
[Symmetry Set Up - KY_01.jpg]\\ \\For Vertex Users, [IDSD] must be set up with Kentucky School District codes.
The [IPPH Pay Header|IPRLU#PayHeaderTab] tab School District must be entered for Kentucky: 000002, Boone County SD
For Example:
GEO: 21-015-492266 Florence is for County 21-015 Boone County, for City 492266 Florence
At line 120 removed 29 lines
|PC 8045|Work SIT Earn |= 3095.73|Same as STE PC 8046 Res SIT Earn
|PC 8055|Work SSP Earn |= 919.87|Same as STE PC 8056 Res SSP Earn
|PC 6040|Work SIT|= 222.92|Same as STE PC 6042 + PC 6052 =167.73 + 55.19 = 222.92
|PC 6703|SUI ER Contr|= 4365.39 x SUI ER Tax Rate 0.10|
| | |= 436.54|Same as STE PC 6703 SUI ER Contr
| | | |
|PC 8100|WCNTY Earn|= 3365.39|Same as STE PC 8110 RCNTY Earn
|PC 8111|WCNTY SupEarn|= 1000.00|Same as STE PC 8111 RCNTY SupEarn
| | | |
|PC 6800|Work CNTY Tax|= 3365.39 x Boone OLF Rate 0.008 = 26.92|
| |Mental Health Tax|= 3365.39 x Boone MHT Rate 0.001500 = 5.05|
| |RCNTY + MHT|= 26.92 + 5.02 = 31.97|
|PC 6811|WCNTY Sup Tax|= 1000.00 x Boone OLF Rate 0.008 = 8.00|
| |Mental Health Tax|= 1000.00x Boone MHT Rate 0.001500 = 1.50|
| |RCNTY Sup + MHT Sup|= 8.00 + 1.50 = 9.50|
\\
;Total Vertex County Tax:PC 6800 + PC 6811 = 31.97 + 9.50 = 41.47 (same as STE below)
;Total Symmetry County Tax:PC 6831 + PC 6850 + PC 6471 KY-Mental Health Tax = 26.92 + 8.00 + 6.55 = 41.47 (same as Vertex)
\\
|PC 8120|WCITY Earn|= 3365.39|Same as STE PC 8130 RCITY Earn
|PC 8121|WCITY SupEarn|= 1000.00|Same as STE PC 8131 RCITY SupEarn
|PC 6900|Work CITY Tax|= 3365.39 x Florence Rate 0.02= 67.31|Same as STE PC 6951 RCITY Reg
|PC 6902|Work CITY Sup Tax|= 1000.00 x Florence Rate 0.02= 20.00|Same as STE PC 6953 Res CITY Sup
| | | |
|PC 8102|WCNTY Schl Earn|= 4365.39|Same as STE PC 8132 + PC 8135 = 4365.39
|PC 6802|WCNTY Schl Tax|= 4365.39 x Boone Rate 0.005 = 21.83|Same as STE PC 6954 + PC 6955 = 204.73
----
![Notes|Edit:Internal.Symmetry Set Up - KY]
[{InsertPage page='Internal.Symmetry Set Up - KY' default='Click to create a new notes page'}]
At line 118 added one line
(1) On IPUTR, there are 3 entries for County 21-015 Boone County, therefore these 3 taxes will be calculated.
At line 120 added one line
At line 122 added 94 lines
21-015-0000-OLF-000 Boone County - OLF - showing County Tax Rate
21-015-0000-MHT-000 Boone County - MHT - showing County Mental Health Tax Rate
21-015-0000-OLTS-000 Boone County - OLTS - showing County Tax School Rate
The OLF are defined with ’21-015’ County Level and this will be calculated and stored as County Tax.
The OLFS are defined with ’21-015’ County Level and this will be calculated and stored as School District Tax.
MHT will be calculated and stored with PC Usage 7271 - KY- Mental Health and Senior Citizen Tax.
School District Tax are calculated automatically according to the GNIS Code, there is no need to set up IDSD School District code for Kentucky, and therefore IDTX Jurisdiction entries for Kentucky also do not require to set up by School.
(2) On IPUTR, there is 1 entry for City 21-000-492266 Florence, therefore this tax will be calculated.
The OLF are defined with ’21-000-492266’ City Level and this will be calculated and stored as City Tax.
20.5 KY – UPCALC – Symmetry Result
IPRLU - KS0001 TOTALALLOWANCES = 0
PC 8046 Res SIT Earn = 3095.73
PC 8056 Res SSP Earn = 919.87
PC 6042 Res SIT = 167.73
PC 6052 Res Supp Tax = 919.87 x 0.06 = 55.19
PC 6703 SUI ER Contr = 4365.39 x IPUTR 21-000-0000-ER_SUTA-000 Override Tax Rate 0.10
= 436.54
PC 8110 RCNTY Earn = 3365.39
PC 8111 RCNTY SupEarn = 1000.00
PC 6831 Res CNTY Tax = 3365.39 x IPUTR 21-015-0000-OLF-000 Boone OLF Rate 0.008 = 26.92
PC 6850 Res CNTY Sup Tax = 1000.00 x IPUTR 21-015-0000-OLF-000 Boone OLF Rate 0.008 = 8.00
PC 8130 RCITY Earn = 3365.39
PC 8131 RCITY SupEarn = 1000.00
PC 6951 Res CITY Reg Tax = 3365.39 x IPUTR 21-000-492266-OLF-000 Florence Rate 0.020000= 67.31
PC 6953 Res CITY Sup Tax = 1000.00 x IPUTR 21-000-492266-OLF-000 Florence Rate 0.020000= 20.00
PC 8132 RCITY Schl Reg Earn = 3365.39
PC 8135 RCITY Schl Sup Earn = 1000.00
PC 6954 RCITY Schl Reg Tax = 3365.39 x IPUTR 21-015-0000-OLTS-000 Boone Rate 0.005000 = 16.83
PC 6955 RCITY Schol Sup Tax = 1000.00 x IPUTR 21-015-0000-OLTS-000 Boone Rate 0.005000 = 5.00
PC 6471 KY-Mental Health Tax = 4365.39 x IPUTR 21-015-0000-MHT-000 Tax Rate 0.001500 = 6.55
20.5 KY – UPCALC – Vertex Result
For Vertex Users, user must set up IDSD with Kentucky School District codes.
IPPH ‘PAY HEADER’ Tab School District must be entered for Kentucky: 000002, Boone County SD
PC 8045 Work SIT Earn = 3095.73 - same as STE PC 8046 Res SIT Earn
PC 8055 Work SSP Earn = 919.87 - same as STE PC 8056 Res SSP Earn
PC 6040 Work SIT = 222.92 - same as STE PC 6042 + PC 6052 =167.73 + 55.19 = 222.92
PC 6703 SUI ER Contr = 4365.39 x SUI ER Tax Rate 0.10
= 436.54 - same as STE PC 6703 SUI ER Contr
PC 8100 WCNTY Earn = 3365.39 - same as STE PC 8110 RCNTY Earn
PC 8111 WCNTY SupEarn = 1000.00 - same as STE PC 8111 RCNTY SupEarn
PC 6800 Work CNTY Tax = 3365.39 x Boone OLF Rate 0.008 = 26.92
Mental Health Tax = 3365.39 x Boone MHT Rate 0.001500 = 5.05
RCNTY + MHT = 26.92 + 5.02 = 31.97
PC 6811 WCNTY Sup Tax = 1000.00 x Boone OLF Rate 0.008 = 8.00
Mental Health Tax = 1000.00x Boone MHT Rate 0.001500 = 1.50
RCNTY Sup + MHT Sup = 8.00 + 1.50 = 9.50
Total Vertex County Tax:
PC 6800 + PC 6811 = 31.97 + 9.50 = 41.47 (same as STE below)
Total Symmetry County Tax:
PC 6831 + PC 6850 + PC 6471 KY-Mental Health Tax = 26.92 + 8.00 + 6.55 = 41.47 (same as Vertex)
PC 8120 WCITY Earn = 3365.39 - same as STE PC 8130 RCITY Earn
PC 8121 WCITY SupEarn = 1000.00 - same as STE PC 8131 RCITY SupEarn
PC 6900 Work CITY Tax = 3365.39 x Florence Rate 0.02= 67.31 - same as STE PC 6951 RCITY Reg
PC 6902 Work CITY Sup Tax = 1000.00 x Florence Rate 0.02= 20.00 - same as STE PC 6953 Res CITY Sup
PC 8102 WCNTY Schl Earn = 4365.39 - same as STE PC 8132 + PC 8135 = 4365.39
PC 6802 WCNTY Schl Tax = 4365.39 x Boone Rate 0.005 = 21.83 - same as STE PC 6954 + PC 6955
This page (revision-11) was last changed on 26-Nov-2021 10:22 by jmyersTop