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

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
35 26-Nov-2021 10:22 17 KB mmcfarland to previous
34 26-Nov-2021 10:22 17 KB mmcfarland to previous | to last
33 26-Nov-2021 10:22 17 KB mmcfarland to previous | to last
32 26-Nov-2021 10:22 17 KB rforbes to previous | to last PR_US_Federal_Tax_Calc ==> Taxation - US Federal
31 26-Nov-2021 10:22 17 KB jmyers to previous | to last
30 26-Nov-2021 10:22 17 KB jmyers to previous | to last
29 26-Nov-2021 10:22 17 KB jmyers to previous | to last
28 26-Nov-2021 10:22 17 KB jmyers to previous | to last
27 26-Nov-2021 10:22 17 KB jmyers to previous | to last
26 26-Nov-2021 10:22 17 KB jmyers to previous | to last
25 26-Nov-2021 10:22 18 KB jmyers to previous | to last
24 26-Nov-2021 10:22 18 KB jmyers to previous | to last
23 26-Nov-2021 10:22 18 KB jmyers to previous | to last
22 26-Nov-2021 10:22 18 KB jmyers to previous | to last
21 26-Nov-2021 10:22 18 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
Taxation - US Federal
Taxation - US Federal

Version management

Difference between version and

At line 4 changed one line
Overview
!Overview
At line 9 changed 10 lines
;[UDGNIS]:\\This is the process to load all US Tax jurisdictions into [IDCO], [IDSP], [IDCN], [IDCI], [IDMN], [IDSD], [IDZR], and [IDTX].
;[UPUTR]:This is the process to load all US Tax Rates and States Miscellaneous parameters.\\ \\After [UPUTR] is run, the applicable Tax Rates and Miscellaneous Parameters can be viewed by state in [IPUTR] and [IPUTP].
;[IPUTR]:US Tax Rates may be viewed by states and the Overridden Rates and Wage Base entered.\\ \\Some SUTA surcharge calculations for specific states may be suppressed by checking the '€˜Do not Calculate'€™ toggle
;[IPUTP]:The US Tax Miscellaneous parameters maybe be viewed by states that are applicable for [IPRLU].
;[IDGV]:This screen may optionally contain specific override rates and Wage Bases by Government Registration for each registration from the pay header'€™s group.\\ \\[IDGV] overridden amounts take precedence over the [IPUTR] overridden amounts.
;[IPPC]:Pay components must be set up with applicable [IPCU] PC Usages for US taxation.
;[IDTX]:Applicable Tax Jurisdictions that are paid by employees may be entered here.\\ \\On the [IPPH]/[IEPI], [IEAS], [IDLN], etc. screens that require a tax jurisdiction, the '€˜Tax Jurisdiction Editor Utility'€™ dialog box can be used to enter the jurisdiction on [IDTX].
;[IPRLU]/[IPRLUS]:Each employee must be set up with the applicable tax methods.\\ \\Miscellaneous Tax parameters must be set up by the states that need to be paid.
;[UPRLU]:This process audits the US Tax Filing Information and generates [IPRLU] Miscellaneous Tax Parameters information according to [IMCT] set up
;[IPPH]:The [Pay Header|IPPH#PayHeaderTab] tab must specify the default Work and Home jurisdictions.\\ \\The [Pay Lines|IPPH#PayLinesTab] tab, Jurisdiction field must specify the Work Jurisdiction of this pay line.\\ \\After the Trial Calc or [UPCALC], the [Pay Amounts|IPPH#PayAmountsTab] tab contains all US Taxation amounts in summary that are used for the calculation of net pay.\\ \\The [Pay Jurisdiction|IPPH#PayJurisdictionTab] tab contains the default Work and Home jurisdictions.\\ \\After Trial Calc or [UPCALC], the [Pay Jurisdiction|IPPH#PayJurisdictionTab] tab contains all US Taxation amounts by jurisdictions in detail.
[UDGNIS]: This is the process to load all US Tax jurisdictions into [IDCO], [IDSP], [IDCN], [IDCI], [IDMN], [IDSD], [IDZR], and [IDTX]. \\
[UPUTR]: This is the process to load all US Tax Rates and States Miscellaneous parameters.\\ After [UPUTR] is run, the applicable Tax Rates and Miscellaneous Parameters can be viewed by State in [IPUTR] and [IPUTP].\\ \\
[IPUTR]: US Tax Rates can be viewed by State and the Overridden Rates and Wage Base entered.\\ Some SUTA surcharge calculations for specific states can be suppressed by checking the 'Do not Calculate' toggle. \\ \\
[IPUTP]: The US Tax Miscellaneous parameters can be be viewed by the States that are applicable for [IPRLU]. \\ \\
[IDGV]: This form can optionally contain specific override rates and Wage Bases by Government Registration for each registration from the pay header's group.\\ [IDGV] overridden amounts take precedence over the [IPUTR] overridden amounts.\\ \\
[IPPC]: Pay components must be set up with applicable [IPCU] PC Usages for US taxation.\\ \\
[IDTX]: Applicable Tax Jurisdictions that are paid by employees are entered here.\\ On the [IPPH]/[IEPI], [IEAS], [IDLN], etc. forms that require a tax jurisdiction, the 'Tax Jurisdiction Editor Utility' dialog box can be used to enter the jurisdiction on [IDTX].\\ \\
[IPRLU]/[IPRLUS]: Each employee must be set up with the applicable tax methods.\\ Miscellaneous Tax parameters must be set up by the states that need to be paid.\\ \\
[UPRLU]: This process audits the US Tax Filing Information and generates [IPRLU] Miscellaneous Tax Parameters information according to [IMCT] set up.\\ \\
[IPPH]: The [Pay Header|IPPH#PayHeaderTab] tab must define the default Work and Home jurisdictions.\\ The [Pay Lines|IPPH#PayLinesTab] tab, Jurisdiction field must define the Work Jurisdiction of this pay line.\\ After the Trial Calc or [UPCALC], the [Pay Amounts|IPPH#PayAmountsTab] tab contains all US Taxation amounts, in summary, that are used for the calculation of net pay.\\ The [Pay Jurisdiction|IPPH#PayJurisdictionTab] tab contains the default Work and Home jurisdictions.\\ After Trial Calc or [UPCALC], the [Pay Jurisdiction|IPPH#PayJurisdictionTab] tab contains all US Taxation amounts, by jurisdictions, in detail.\\ \\
At line 20 changed one line
!IPUTP -€“ Federal Tax Parameters
!IPUTP - Federal Tax Parameters
At line 25 changed one line
%%information These parameters will not automatically be added to [IPRLU]/[IPRLUS] by the [UPRLU] process for all employees. [IPRLU]/[IPRLUS] are required to be manually added for employees who are eligible for each parameter.%%
%%information These parameters will not automatically be added to [IPRLU]/[IPRLUS] by the [UPRLU] process for all employees. [IPRLU]/[IPRLUS] information is required to be manually added for employees who are eligible for each parameter.%%
At line 28 changed 3 lines
*Optional, numeric, IRS maximum number of exemptions allowed
*Allows an employer to indicate on the employee'€™s [IPRLU]/[IPRLUS] screen the maximum number of exemptions allowed for this employee as indicated by the IRS in a '€˜lock-in-letter'.™
*[UPCALC] will cap the employee'€™s 'Federal €˜# of Exemptions'™ with the value from [IPRLU]/[IPRLUS] '€˜IRS_MAX_EXEMPTIONS'€™ parameter.
*IRS maximum number of exemptions allowed. Optional, numeric
*Allows an employer to define on the employee's [IPRLU]/[IPRLUS] form the maximum number of exemptions allowed for this employee as indicated by the IRS in a 'lock-in-letter'.
*[UPCALC] will cap the employee's 'Federal # of Exemptions' with the value from [IPRLU]/[IPRLUS] 'IRS_MAX_EXEMPTIONS' parameter.
At line 33 changed one line
\\ \\
At line 40 changed one line
*If the 401K Catch Up option is applicable to all employees, '€˜YES'€ can be entered™ in [IPUTP] Default Value, otherwise each employee can specify the value for this option on [IPRLU]/[IPRLUS].
*If the 401K Catch Up option is applicable to all employees, 'YES' can be entered in [IPUTP] Default Value, otherwise each employee can specify the value for this option on [IPRLU]/[IPRLUS].
At line 42 changed one line
!IPUTR -€“ Federal Tax Rates
!IPUTR - Federal Tax Rates
At line 45 changed 2 lines
*On [IPUTR],the State = '€˜Federal'€ can be selected in order™ to view the Federal Tax Rates.
*Each Tax Identifier may provide the default Tax Rates, Wage Base to be used for Federal tax calculation
*On [IPUTR], when the State is defined as 'Federal' the Federal Tax Rates can be viewed.
*Each Tax Identifier can provide the default Tax Rates and Wage Base to be used for Federal tax calculation.
At line 48 changed one line
%%warning IMPORTANT: For the ER_FUTA identifier, a user MUST enter their own Employer FUTA rate which is provided by the government on the '˜Override Tax Rate'€™ field. Symmetry requires this FUTA Rate to be passed into the Symmetry Tax Engine, otherwise ER FUTA will not be calculated.%%
%%warning IMPORTANT: For the ER_FUTA identifier, users MUST enter their own Employer FUTA rate (provided by the government) on the 'Override Tax Rate' field. Symmetry requires this FUTA Rate to be passed into the Symmetry Tax Engine, otherwise ER FUTA will not be calculated.%%
At line 50 changed 4 lines
!IPRLU -€“ US Tax Filing Information
Both [IPRLU] and [IPRLUS] can be used to Maintain US Tax Filing Information for an employee.
[IPRLU] - Contains all US Tax Filing Information for both Vertex and Symmetry Tax users
[IPRLUS] - Contains US Tax Filing Information for Symmetry Tax users only
!IPRLU - US Tax Filing Information
Both [IPRLU] and [IPRLUS] can be used to maintain US Tax Filing Information for an employee.
[IPRLU] contains all US Tax Filing Information for both Vertex and Symmetry Tax users. \\
[IPRLUS] contains the US Tax Filing Information for Symmetry Tax users only
At line 55 changed one line
*The [Federal|IPRLU#FederalTab], [State|IPRLU#StateTab] and [Local|IPRLU#LocalTab] tabs must specify all tax methods and eligible information
*The [Federal|IPRLU#FederalTab], [State|IPRLU#StateTab] and [Local|IPRLU#LocalTab] tabs must define all tax methods and eligibility information. \\
At line 57 changed one line
For Federal Tax Calculation, the '€˜# of Exemptions'€™ must be entered on the [Federal|IPRLU#FederalTab] tab, if the employee has an IRS letter to indicate the maximum number of exemptions allowed for this employee, then enter on either the [Miscellaneous|IPRLU#MiscellaneousTab] tab or the [State|IPRLU#StateTab] tab with the Misc. Identifier €˜IRS_MAX_EXEMPTIONS.€™
For Federal Tax Calculation, the '# of Exemptions' must be entered on the [Federal|IPRLU#FederalTab] tab, if an employee has an IRS letter that indicates the maximum number of exemptions allowed. Then, on either the [Miscellaneous|IPRLU#MiscellaneousTab] tab or the [State|IPRLU#StateTab] tab, the IRS_MAX_EXEMPTIONS Misc. Identifier must be defined.
At line 61 changed one line
!PC Usage -€“ Federal Tax
!PC Usage - Federal Tax
At line 63 changed one line
On [IPPC], set up pay components for these PC Usages for federal tax calculation
On [IPPC], set up the pay components for these PC Usages for federal tax calculation:
At line 79 removed one line
| |
At line 82 removed one line
| |
At line 83 added one line
\\
At line 87 changed one line
Federal Insurance Contributions Act Tax (FICA) is imposed by the federal government on both employees and employers. The FICA tax is calculated using Pay Component Usages 6201 -€“ 6261.
Federal Insurance Contributions Act Tax (FICA) is imposed by the federal government on both employees and employers. The FICA tax is calculated using Pay Component Usages 6201 - 6261.
At line 95 added one line
\\
At line 108 changed one line
!PC Usage -€“ Federal Unemployment Tax Act (FUTA)
!PC Usage - Federal Unemployment Tax Act (FUTA)
At line 110 changed one line
Federal Unemployment Tax Act (FUTA) is an employer paid tax. The FUTA tax is calculated using Pay Component Usages 6401 -€“ 6451.
Federal Unemployment Tax Act (FUTA) is an employer paid tax. The FUTA tax is calculated using Pay Component Usages 6401 - 6451.
At line 122 changed 2 lines
#*If there is a specific rate given by the government for a different Registration #, then enter by '€˜Reg Type' on [IDGV]€™, this overrides the [IPUTR] Rate
#*[UPCALC] retrieves [IDGV] by Government Registration from employee'€™s Pay Header group
#*If there is a specific rate provided by the government for a different Registration #, update the 'Reg Type' field on [IDGV]. This overrides the [IPUTR] Rate.
#*[UPCALC] retrieves [IDGV] by Government Registration from the employee's Pay Header group
\\ \\
At line 125 changed one line
If you do business in a state that has been given a FUTA Tax Credit reduction, the new FUTA tax rate for that particular state may be entered in [IDGV] for the state. In [IDGV], add a new entry for the specific state, select Registration Type '€˜US SUI Regist 1'; the Govt Rate Type should be '€˜US FUTA Rate'€™. This state specific FUTA rate will be picked up by the UPCALC program when an employee is being paid in that state.
If you do business in a State that has been given a FUTA Tax Credit reduction, the new FUTA tax rate for that specific State can be entered on [IDGV] for the State.
In [IDGV], add a new entry for the specific State, define the Registration Type as 'US SUI Regist 1', and define the Govt Rate Type as 'US FUTA Rate'. This State specific FUTA rate will be picked up by the UPCALC program when an employee is being paid in that State.
At line 127 changed 2 lines
!PC Usage -€“ Railroad Taxation
PC Usages 6301 -€“ 6356
!PC Usage - Railroad Taxation
Railroad taxation is calculated using Pay Component Usages 6301 - 6356.
At line 134 changed one line
|IPRLU Federal Filing Status|= Single
|IPRLU Federal Filing Status:|= Single
At line 139 added one line
\\ \\
At line 138 changed one line
;Pre-Tax Benefits:
__Pre-Tax Benefits:__
At line 148 added one line
\\ \\
At line 146 changed one line
;Prorate Pre-Tax Benefits to Regular and Supplemental Earnings:
__Prorate Pre-Tax Benefits to Regular and Supplemental Earnings:__
At line 153 added one line
\\ \\
At line 150 changed one line
;FIT Withholding:
__FIT Withholding:__
At line 152 changed one line
|PC 8015 FSP Earn|= 100.00 -€“ 15.34|= 84.66
|PC 8015 FSP Earn|= 100.00 - 15.34|= 84.66
At line 162 changed one line
Employee works for Regular Employment and Railroad Employment. FICA YTD and RRTA YTD are both used in FICA calculation.
Employee works for Regular Employment and Railroad Employment. FICA YTD and RRTA YTD are both used in the FICA calculation.
At line 171 added one line
\\ \\
At line 167 changed 2 lines
|PC 8005 FIT Earn|= FIT_Wages -€“ 125 - 401K|= 6676.24 -€“ 200.33 -€“ 239.57|= 6236.34
|PC 8039 FICA ER Earn|= FICA_Wages -€“ 125|= 6596.13 -€“ 200.33|= 6395.80
|PC 8005 FIT Earn|= FIT_Wages - 125 - 401K|= 6676.24 - 200.33 - 239.57|= 6236.34
|PC 8039 FICA ER Earn|= FICA_Wages - 125|= 6596.13 - 200.33|= 6395.80
\\ \\
At line 174 changed 2 lines
This employee uses '€˜Self-Adjust Method'€™.
\\ \\
\\ \\
This employee uses the 'Self-Adjust Method'.
\\
At line 184 changed 2 lines
If FICA Earnings (FICA_Wages.ctd) is different than FIT Earnings (FIT_Wages.ctd), then calculate the difference between the Wages for FICA and FIT (i.e. Usage 6261 -€“ Usage 6051), called this 'Additional FICA Wages'.
\\ \\
If FICA Earnings (FICA_Wages.ctd) is different than FIT Earnings (FIT_Wages.ctd), then calculate the difference between the Wages for FICA and FIT (such as Usage 6261 - Usage 6051). This is called 'Additional FICA Wages'.
At line 187 changed 7 lines
|CTD Usage 6051 Pre FWT Earnings| |- 6676.24
|CTD Addn FICA Wages:|6596.13 -€“ 6676.24|= -80.11 (negative means FICA Earn < Pre-FWT Earn)
|YTD Usage 6261 Pre-FICA Employer Earnings| |51057.92
|YTD Usage 6051 Pre FWT Earnings| |51747.29
|YTD Addn FICA Wages|51057.92 -€“ 51747.29|= -689.37 (negative means FICA Earn < Pre-FWT Earn)
|CTD Usage 6051 Pre FWT Earnings:| |- 6676.24
|CTD Addn FICA Wages:|6596.13 - 6676.24|= -80.11 (negative means FICA Earn < Pre-FWT Earn)
\\
|YTD Usage 6261 Pre-FICA Employer Earnings:| |51057.92
|YTD Usage 6051 Pre FWT Earnings:| |51747.29
|YTD Addn FICA Wages:|51057.92 - 51747.29|= -689.37 (negative means FICA Earn < Pre-FWT Earn)
\\
At line 196 changed 8 lines
|YTD 125 Total (from YTD)|= 1649.91 (prorate to YTD FIT / FSP Wages, i.e. 51747.29 and 5700)
|YTD 401K Total (from YTD)|= 2026.80 (prorate to YTD FIT / FSP Wages, i.e. 51747.29 and 5700)
|FIT_ben_125.ctd|= 200.83|FSP_ben_125.ctd|= 0|
|FIT_ben_125.ytd|= 1486.20|FSP_ben_125.ytd|= 163.71|(1486.20 + 163.71 = 1649.91)
|FIT_ben_401K.ctd|= 239.57|FSP_ben_401K.ctd|= 0|
|FIT_ben_401K.ytd|= 1825.70|FSP_ben_401K.ytd|= 201.1|(1825.70 + 201.1 = 2026.80)
\\
|YTD 125 Total (from YTD):|= 1649.91 (prorate to YTD FIT / FSP Wages, such as 51747.29 and 5700)
|YTD 401K Total (from YTD):|= 2026.80 (prorate to YTD FIT / FSP Wages, such as 51747.29 and 5700)
\\
|FIT_ben_125.ctd:|= 200.83|FSP_ben_125.ctd:|= 0|
|FIT_ben_125.ytd:|= 1486.20|FSP_ben_125.ytd:|= 163.71|(1486.20 + 163.71 = 1649.91)
|FIT_ben_401K.ctd:|= 239.57|FSP_ben_401K.ctd:|= 0|
|FIT_ben_401K.ytd:|= 1825.70|FSP_ben_401K.ytd:|= 201.1|(1825.70 + 201.1 = 2026.80)
At line 219 added one line
\\
At line 227 changed one line
|FICA_125_Total|-€“ 1850.74
|FICA_125_Total|- 1850.74
At line 238 added one line
\\
At line 243 added one line
\\
At line 248 added one line
\\
At line 241 changed one line
\\
\\
At line 259 added one line
\\
At line 264 added one line
\\
At line 253 changed one line
|__MEDI ER This Pay__|= 82.74 (RPREGC Slight Rounding 82.75)
|__MEDI ER This Pay__|= 82.74 (RPREGC Slight Rounding = 82.75)
At line 277 added one line
\\
At line 263 changed 2 lines
|PC 8005 FIT Earn|= FIT Wages - 125 - 401K|= 6153.82 - €“194.22 -€“ 225.31|= 5734.29
|PC 8201 RR Tier1 Soc ER Earn|= RRTA Wages -€“ 125|= 6079.97 - €“194.22|= 5885.75
|PC 8005 FIT Earn|= FIT Wages - 125 - 401K|= 6153.82 - 194.22 - 225.31|= 5734.29
|PC 8201 RR Tier1 Soc ER Earn|= RRTA Wages - 125|= 6079.97 - 194.22|= 5885.75
\\
At line 266 changed one line
__RRTA - €“ No Self Adjust Method__
__RRTA - No Self Adjust Method__
At line 271 changed one line
For Railroad Taxation, if an employee has FICA contribution during the year, this means the employee works between the Railroad and Non-Railroad Assignments. In this case, please check if the '€˜RR Self-Adjust' method should be used for this employee or not.
For Railroad Taxation, if an employee has FICA contribution during the year, this means the employee works between the Railroad and Non-Railroad Assignments. In this case, please check if the 'RR Self-Adjust' method should be used for this employee or not.
At line 273 changed one line
The reason is, if '€˜RR Self-Adjust'€™ method is defined on [IPRLU], this method is applicable for both RR Tier1 and Tier2 calculation. However, since Regular FICA does not have a Tier2 calculation, the '€˜RR Self-Adjust'€™ method will automatically re-adjust all earnings that include YTD FICA Earnings that are not subject to Tier2 calculation; this would cause the entire YTD Earnings to subject to Tier2 tax.
The reason is, if 'RR Self-Adjust' method is defined on [IPRLU], this method is applicable for both RR Tier1 and Tier2 calculations. However, since Regular FICA does not have a Tier2 calculation, the 'RR Self-Adjust' method will automatically re-adjust all earnings that include YTD FICA Earnings that are not subject to Tier2 calculation. This would cause the entire YTD Earnings to subject to Tier2 tax.
At line 275 changed 5 lines
Since employee should only pay Tier2 tax for the earnings that are earned for Railroad employment, if employee has FICA contribution, it should be verified if this employee should use the 'Self-Adjust'€™ method to re-calculate all Tier2 tax or just to use '€˜RR No Self-Adjust'€™ method.
Next page example shows the '€˜RR Self-Adjust' method€™ and should be used when the employee does not have FICA employment.
\\ \\
__RRTA -€“ Self Adjust Method__
Since employees should only pay Tier2 tax for the earnings that are earned for Railroad employment, if employee has FICA contribution, it should be verified if this employee should use the 'Self-Adjust' method to re-calculate all Tier2 tax or just use 'RR No Self-Adjust' method.
\\ \\
The next example shows the 'RR Self-Adjust' method and should be used when the employee does not have FICA employment.
\\
__RRTA - Self Adjust Method__
At line 303 added one line
\\
At line 287 changed one line
If RRTA Earnings (RRTA_Wages.ctd) is different than FIT Earnings (FIT_Wages.ctd), then calculate the difference between the wages for RRTA and FIT (i.e. Usage 6306 -€“ Usage 6051). This is called Additional RRTA Wages
If RRTA Earnings (RRTA_Wages.ctd) is different than FIT Earnings (FIT_Wages.ctd), then calculate the difference between the wages for RRTA and FIT (such as Usage 6306 - Usage 6051). This is called Additional RRTA Wages.
At line 309 added one line
\\
At line 314 added one line
\\
At line 318 added one line
\\
At line 322 added one line
\\
At line 328 added one line
\\ \\
At line 342 added one line
\\ \\
At line 350 added one line
\\ \\
At line 329 changed one line
|RRTA_125_Total|-€“ 2044.46
|RRTA_125_Total|- 2044.46
At line 360 added one line
\\ \\
This page (revision-35) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop