This page (revision-42) 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
42 26-Nov-2021 10:22 17 KB mmcfarland to previous
41 26-Nov-2021 10:22 17 KB mmcfarland to previous | to last

Page References

Incoming links Outgoing links
US Federal Tax Calculation
US Federal Tax Calculation

Version management

Difference between version and

At line 2 changed one line
!!!US AUDIT PAY RULES
!!!US FEDERAL TAX CALCULATION
At line 5 changed one line
This page describes the [UPRLU] process.
Intent
At line 7 changed 3 lines
The function has two purposes:
# To convert the Vertex U.S pay rule data to the Symmetry tax parameters
# To audit the U.S pay rules to ensure there are no missing tax parameters.
This document describes the US Federal Tax Calculation using the Symmetry Tax Engine (STE) Software.
At line 11 removed one line
!!UPRLU – Selection Criteria
At line 13 changed one line
!!!UPRLU – Audit US Tax Filing Information
Audience
At line 15 changed one line
[US_Audit_Pay_Rules_01.JPG]
All users who are responsible to do the Payroll Tax Calculation in the Pay cycle process.
Prerequisites
All users must have a thorough understanding of the Payroll Pay Cycle UPCALC process.
2 Federal Tax Calculation
2.1 General Set Up
UDGNIS - this is the process to load all US Tax Jurisdictions into IDCO, IDSP, IDCN, IDCI, IDMN, IDSD, IDZR, IDTX
UPUTR - this is the process to load all US Tax Rates and States Miscellaneous Parameters, after UPUTR is run, user can go into IPUTR and IPUTP screen to view the applicable Tax Rates and Miscellaneous Parameters by State
IPUTR - user may view US Tax Rates by States and enter the Overridden Rates and Wage Base
- user may suppress some SUTA Surcharge Calculation for some States by checking the ‘Do not Calculate’ toggle
IPUTP - user may view US Tax Miscellaneous Parameters by States that are applicable for IPRLU screen
IDGV - this screen may optionally contain specific override Rates and Wage Bases by Government Registration for each Registration from 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 - allows user to enter applicable Tax Jurisdictions that are paid by employees
- on IPPH / IEPI, IEAS, IDLN screens etc that requires a Tax Jurisdiction, the user can pop into the ‘Tax Jurisdiction Editor Utility’ Dialog Box to enter the Jurisdiction on IDTX screen
IPRLU / IPRULS - each employee must be set up with the applicable Tax Methods
- Miscellaneous Tax Parameters must be set up by 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 - PAY HEADER Tab must specify the default Work Jurisdiction and Home Jurisdiction
- PAY LINES Tab Jurisdiction field must specify the Work Jurisdiction of this Pay Line
- after Trial Calc or UPCALC, PAY AMOUNTS Tab contains all US Taxation amounts in summary that are used for the calculation of net pay
- PAY JURISDICTION Tab contains the default Work Jurisdiction and Home Jurisdiction
- after Trial Calc or UPCALC, PAY JURISDICTION Tab contains all US Taxation amounts by Jurisdictions in detail
At line 17 removed one line
[{InsertPage page='UPRLU' section=2}]
At line 19 changed one line
[{InsertPage page='UPRLU' section=3}]
2.2 IPUTP – Federal Tax Parameters
At line 21 changed one line
!!UPRLU Processing
When UPUTR is run, it loads in a list of Federal Tax Parameters for Symmetry Federal Tax Calculation.
At line 23 changed one line
!!!Purpose
At line 25 removed one line
The UPRLU is a dual purpose function.
At line 27 changed 2 lines
#Vertex to Symmetry Conversion\\ \\The initial purpose of the UPRLU function is to populate the state’s Miscellaneous Tax parameters in [IPRLU] based on the fields used by Vertex. The UPRLU will read the custom table ‘UPRLU Mapping’ in the [IMCT] screen to determine which field in IPRLU should be used to populate the Miscellaneous Tax parameter.\\ \\For example, the UPRLU will take the value stored in Filing Status (UST_FILING_STATUS column) and will populate the Tax parameter FILINGSTATUS.\\ \\The vertex mapping would only occur when the parameter Vertex Conversion is set to <Yes>.\\ \\
#Audit IPRLU Data\\ \\TBD - UPRLU has not been programmed for this as of yet.\\ \\The intent on this second purpose is to audit the date in IPRLU on a regular basis to ensure that employee records are kept up to date with new tax parameters etc.
On IPUTP screen, the following Federal tax parameters are available to be used on IPRLU / IPRLUS screen.
At line 30 changed 2 lines
!!!IPRLU Tax Filing Conversion
In order for [UPCALC] to calculate state tax correctly using the Symmetry Tax Engine (STE), the IPRLU state information (tax parameters) must be set up for each applicable state the employee lives and works in.
 401K_CATCHUP
 IRS_MAX_EXEMPTIONS
At line 33 changed one line
The UPRLU will insert and populate the appropriate tax parameters for any state the employee lives and works in. The function will use the data in the original Vertex fields in IPRLU to populate the new tax parameters.
These parameters will not automatically be added to IPRLU / IPRLUS by UPRLU process for all employees. Users are required to manually add to IPRLU / IPRLUS for employees who are eligible for each parameter.
At line 35 removed one line
Using the As Of date provided in the report parameters, UPRLU will read [IEAS] and [IEPI] effective records where this date falls between the effective start and end dates. Any records whose effective start date is greater than the As Of date used will also be read, this is so that the UPRLU picks up any future changes in work or residence locations.
At line 37 changed one line
The Work State is retrieved from IEAS using the Jurisdiction field. If there is no Jurisdiction defined then the UPRLU will look at the Works in Location field in IEAS to retrieve the Jurisdiction defined for the location.
401K_CATCHUP
- Optional, character, 401K Limit Catch Up Option
- indicates to Symmetry if the employee is enrolled in a 401k Catch up plan
- the annual regular 401k contribution limit is defined by the IRS, e.g. $16,500. if the user is enrolled in 401k plan with annual contribution limit greater than this regular limit, this parameter allows the 401k maximum contribution to exceed the IRS limit for Benefit Pre-tax calculation
- 'DEFAULT'-Catch Up is not allowed, 'YES'-Catch Up is allowed, 'NO'-Catch Up is not allowed.
- If 401K Catch up option is applicable to all employees, user can enter ‘YES’ in IPUTP Default Value, otherwise each employee can specify the value for this option on IPRLU /IPRLUS screen
At line 39 removed one line
Since Symmetry calculates taxes based on Residence state the UPRLU will create Misc Tax Parameters for the home state if the home state differs from the state defined in the IEAS Jurisdiction field. The home state is retrieved from the employee’s personal information defined in IEPI.
At line 41 changed one line
Once UPRLU has determined an employee’s work and resident state, it will then read [IMCT] ‘UPRLU Mapping’ to retrieve the necessary Misc Tax parameters for the employee’s states. UPRLU will then populate the employee’s IPRLU with the appropriate tax parameters. Using the mapping indicated in IMCT, UPRLU will retrieve the data stored in the fields used by Vertex to populate the values for the tax parameters.
IRS_MAX_EXEMPTIONS
- 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
At line 43 changed one line
If the employee does not have an IPRLU record and a Default Pay Rule has been defined in the site preference ‘DFLT PAYRULE’, then UPRLU will create a default IPRLU record. The default record will be populated with the Misc Tax parameters from the employee’s prime assignment ‘Jurisdiction Code’.
At line 45 changed one line
If the employee does not have an IPRLU record and the ‘DFLT PAYRULE’ site preference has not been defined, the UPRLU will not create a default IPRLU record for the employee.
2.3 IPUTR – Federal Tax Rates
At line 47 changed one line
If there are multiple effective records in IPRLU, the UPRLU will insert the appropriate tax parameters for these records with the information that was effective within those records. If there are effective records in IPRLU that are greater than the date the UPRLU is run, these will also be updated. For example:
When UPUTR is run, it loads in a list of Federal Tax Rates for Symmetry Federal Tax Calculation.
At line 49 changed one line
;In IPRLU an employee has three effective records:01 Jan 0000 – 31 Dec 1999 (no information as EE was hired Jan 1 2000)\\01 Jan 2000 – 31 Jan 2010, EE claimed Single, 1 exemption\\01 Feb 2010 – 31 Dec 3999, EE claimed Married, two exemptions\\ \\The UPRLU is run for 1 Jan 2010 – it will update the employee's 01 Jan 2000 record with the appropriate tax parameters with a Single filing status. The 01 Feb 2010 record will also be updated with the appropriate tax parameters with a Married filing status and two exemptions.
At line 51 removed one line
!!!IMCT – Custom Table
At line 53 changed one line
In order for UPRLU to convert the Vertex information to the Symmetry Tax Parameters, mapping had to be laid out for each individual state.
- on IPUTR screen, user can select the State = ‘Federal’ to view the Federal Tax Rates.
At line 55 changed one line
The mapping has been provided in the custom table ‘UPRLU Mapping’ within the IMCT screen.
- each Tax Identifier may provide the default Tax Rates, Wage Base to be used for Federal Tax calculation
At line 57 removed one line
[US_Audit_Pay_Rules_02.JPG]
At line 59 changed one line
In IMCT, the Custom Key field holds the state code and the state’s Misc Tax parameter.
IMPORTANT:
- for ER_FUTA Identifier, user MUST enter their own Employer FUTA rate that 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
At line 61 removed one line
Custom Subkey displays the IPRLU field UPRLU will read in order to retrieve the data. This data will be printed in the output file.
At line 63 removed one line
The Custom Data holds the necessary coding and mapping for that Custom Key. This field tells UPRLU how to decode the lexicon fields to match the values supported for the tax parameter.
At line 65 removed one line
In the above example, the UPRLU will read the UST_FILING_STATUS field in IPRLU to populate the tax parameter ‘FILINGSTATUS’ for California. This decode statement tells UPRLU that the lexicon value of '01' is the equivalent of 'S' for this tax parameter, a value of '02' is equal to 'M' and a value of '03' is equal to 'H'.
At line 67 removed one line
IMCT has been defined with Tax Parameters from the Symmetry Tax Engine. It does not include Tax Parameters that have been system created. (i.e. Those that have a Provided By = Internal or Legislative).
At line 69 removed one line
If clients need to edit the mapping or add Internal tax parameters we advise you to request Client Services for assistance.
At line 71 changed one line
The internally provided Tax Parameters may be manually added to an employee’s IPRLU record, or added to IMCT and the UPRLU run for those few employees.
At line 73 changed 2 lines
;Symmetry Tax Parameters Not Included in IMCT
There are a number of tax parameters that are provided by Symmetry which were not added to IMCT. The following were not included as it was not able to determine a valid value based on the information currently provided in the IPRLU.
2.4 IPRLU – US Tax Filing Information
At line 76 changed one line
If you have employees who live and/or work in the following states please review these and determine if they are required for your employees. The document PR_US_State_Tax_Calc.doc provides more details on the parameters.
Both IPRLU and IPRLUS screens can be used to Maintain US Tax Filing Information for an employee.
At line 78 changed one line
If it is determined these parameters are needed for some employees they may be manually added to the employee’s IPRLU record. Alternatively the parameters may be manually added to the IMCT using valid values as determined by the client, and the UPRLU run for the specific employees these parameters are valid for.
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
At line 80 changed 2 lines
Nebraska
*NONRESPERCENTAGE
At line 83 changed 7 lines
Oregon
*TRANSIT_CANBY_TAX
*TRANSIT_LANE_TAX
*TRANSIT_TRIMET_EXCISE_TAX
*TRANSIT_SANDY_TAX
*TRANSIT_WILSONVILLE_TAX
*TRANSIT_SOUTH_CLACKAMAS_TAX
At line 91 removed one line
!!!UPRLU - Audit Tax Filing Information
At line 93 changed one line
TBD – the UPRLU has not yet been programmed for this purpose.
- the FEDERAL tab, STATE tab and LOCAL Tab must specify all Tax Methods and eligible information
At line 95 changed one line
!!!Output File
- for Federal Tax Calculation, the ‘# of Exemptions’ must be entered on the FEDERAL Tab, if the employee has an IRS letter to indicate the maximum number of exemptions allowed for this employee, then enter on IPRLU MISCELLANEOUS Tab or IPRLUS STATE Tab with Misc. Identifier ‘IRS_MAX_EXEMPTIONS’
At line 97 changed one line
The UPRLU function provides the option of creating an output file. This output file displays what IPRLU records the UPRLU has updated. The file also shows what the values were in the Vertex fields as well as the new values inserted in the Tax Parameters.
- if the employee is eligible for 401K Catch up option, enter with Misc. Identifier ‘401K_CATCHUP’
At line 146 added 318 lines
- if the 401K Catch up option is applicable to all Employees for the entire company, there is no need to enter on IPRLLU / IPRLUS for every employee, the user can specify the Default Value of ‘YES’ on IPUTP to indicate the Catch Up Option default for all employees
3 Federal PC Usages
3.1 PC Usage – Federal Tax
On IPPC screen, please set up Pay Components for these PC Usages for Federal tax Calculation
Usage Description
6001 FWT Deduction - Regular Tax
6002 FWT Deduction - Additional Tax
6003 FWT Deduction - Supplemental Tax
6004 FWT Earnings - Regular Tax
6005 FWT Earnings - Regular Tax
6051 Pre-FWT Earnings - Reg Tax Table Method (PPE)
6052 Pre-FWT Earnings - Reg Tax % Method (PPE)
6053 Pre-FWT 125 Exemption - Reg Tax (PPE)
6054 Pre-FWT 401K Exemption - Reg Tax (PPE)
6055 Pre-FWT Earnings - Supplemental Tax (PPE)
6056 Pre-FWT 125 Exemption - Supplemental Tax (PPE)
6057 Pre-FWT 401K Exemption - Supplemental Tax (PPE)
6058 Pre-FIT Hours - Total Hours worked (PPE)
7901 to Pre-FWT 125 Exemption - Reg Tax (PPE)
7928 Pre-FWT HSA Exemption -Suppl Tax (PPE)
7801 to Pre-Reg Custom Benefit 01 - Reg Tax (PPE)
7830 Pre-Sup Custom Benefit 10 - Suppl Tax (PPE)
3.2 PC Usage – Federal Insurance Contribution Act (FICA) Tax
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.
Usage Description
6201 FICA Employee Deduction
6202 FICA Employee Earnings
6210 FICA Employer Contribution
6211 FICA Employer Earnings
6251 Pre-FICA Employee Earnings (PPE)
6261 Pre-FICA Employer Earnings (PPE)
3.3 PC Usage – Medicare Tax
Medicare Tax is an employer and employee paid tax. The Medicare tax is calculated using Pay Component Usages 6501 – 6552.
Usage Description
6501 Medicare Employee Deduction
6502 Medicare Employee Earnings
6503 Medicare Employer Contribution
6504 Medicare Employer Earnings
6551 Pre- Medicare Employee Earnings (PPE)
6552 Pre- Medicare Employer Earnings (PPE)
3.4 PC Usage – Federal Unemployment Tax Act (FUTA)
Federal Unemployment Tax Act (FUTA) is an employer paid tax. The FUTA tax is calculated using Pay Component Usages 6401 – 6451.
Usage Description
6401 FUTA Employer Contribution
6402 FUTA Employer Earnings
6451 Pre-FUTA Employer Earnings (PPE)
There are two ways of providing the FUTA tax rate:
(1) IPUTR - enter the Rate or Wage Base provided by the Government on the Override fields
- these Overrides are applicable for the entire company for the Federal calculations
(2) IDGV - if there is a specific rate given by the government for different Registration #,
- then enter on IDGV by ‘Reg Type’, this overrides the IPUTR Rate
- UPCALC retrieves IDGV by Government Registration from Employee’s Pay Header Group
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.
3.5 PC Usage – Railroad Taxation
PC Usages 6301 – 6356
4 Federal Tax Calculation
4.1 UPCALC Example - Federal Withholdings
IPRLU Federal Filing Status = Single
Regular Earnings: = 1923.08
Supplemental Earnings: = 100.00
Pre-Tax Benefits:
125 Plan + 401K Plan + 403B Plan + 457 Plan + Simple IRA Plan
145.89 + 112.54 + 20.84 + 16.18 + 14.97 = 310.42
Prorate Pre-Tax Benefits to Regular and Supplemental Earnings:
Reg Earn Pre-Tax Benefit = 1923.08 / 2023.08 * 310.42 = 295.08
Sup Earn Pre-Tax Benefit = 100 / 2023.08 * 310.42 = 15.34
FIT Withholding:
PC 8005 FIT Earn = 1923.08 – 295.08 = 1628.00
PC 8015 FSP Earn = 100.00 – 15.34 = 84.66
PC 6000 FIT Tax = Based on PC 8005 $1628.00 = 237.77
PC 6010 FSP Tax = Based on PC 8015 $84.66 x 25% = 21.17
5 FICA / MEDICARE
4.1 FICA Wage < FIT Wage Example
Employee works for Regular Employment and Railroad Employment. FICA YTD and RRTA YTD are both used in FICA Calculation.
FIT_Wages Usage 6051 Pre FWT Earnings 6676.24
FICA_Wages Usage 6261 Pre-FICA Employer Earnings 6596.13
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
(1) FICA ER – No Self Adjust Method
PC 7031 FICA ER = FICA ER Earn x 0.062 = 6395.80 x 0.062 = 396.54
PC 7030 Medicare ER = Med ER Earn x 0.0145 = 6395.80 x 0.0145 = 92.74
This employee uses ‘Self-Adjust method’, please see next page.
(2) FICA ER – Self Adjust Method
FIT_Wages.ctd Usage 6051 Pre FWT Earnings = 6676.24
FIT_Wages.ytd Usage 6051 Pre FWT Earnings = 51747.29
FSP_Wages.ctd Usage 6055 Pre-FIT Suppl Earns = 0
FSP_Wages.ytd Usage 6055 Pre-FIT Suppl Earns = 5700
FICA_Wages.ctd Usage 6261 Pre-FICA Employer Earnings = 6596.13
FICA_Wages.ytd Usage 6261 Pre-FICA Employer Earnings = 51057.92
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
CTD Usage 6261 Pre-FICA Employer Earnings: 6596.13
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)
Addn FICA_Wages.ctd = -80.11 FICA.ytdEE = 3459.44 (dedn so far) MEDI.ytd = 809.06 (dedn so far)
Addn FICA_Wages.ytd = -689.37 FICA.ytdER = 3459.44 (dedn so far)
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)
Calculate FICA Wages for the Year:
FIT_Wages.ctd + Addn FICA_Wages.ctd + FIT_Wages.ytd + Addn FICA_Wages.ytd
6676.24 + (-80.11) + 51747.29 + (-689.37) = 57654.05
FSP_Wages.ctd + FSP_Wages.ytd
0 + 5700 = 5700
FICA_Wages_Total = 57654.05 + 5700 = 63354.05
Calculate 125 Exemption for the Year:
FICA_125_Total = FIT_ben_125.ctd + FSP_ben_125.ctd + FIT_ben_125.ytd + FSP_ben_125.ytd
FICA_125_Total = 200.83 + 0 + 1486.20 + 163.71 = 1850.74
FICA ER Calculation:
FICA Taxable Earnings = FICA_Wages_Total – FICA_125_Total
FICA Taxable Earnings = 63354.05 – 1850.74 = 61503.31
FICA ER Contribution = FICA Taxable Earnings x FICA Rate
FICA ER Contribution = 61503.31 x 0.062 = 3813.21
FICA ER YTD so far = YTD PC 7031 FICA ER + PC 7033 RR Tier1 Soc ER
FICA ER YTD so far = 1810.19 + 1649.25 = 3459.44 (FICA.ytdER so far)
FICA ER this pay = FICA ER Contribution – FICA ER YTD so far
FICA ER this pay = 3813.21 – 3459.44 = 353.77 (RPREGC slight rounding 353.80)
Medicare ER Calculation
MEDI ER Contribution =: FICA Taxable Earnings x FICA Rate
MEDI ER Contribution =: 61503.31 x 0.0145 = 891.80
MEDI ER YTD so far = YTD PC 7030 Medicare ER + PC 7034 RR Tier1 Med ER
MEDI ER YTD so far = 423.35 + 385.71 = 809.06 (MEDI.ytd so far)
MEDI ER this pay = MEDI ER Contribution – MEDI ER YTD so far
MEDI ER this pay = 891.80 – 809.06 = 82.74 (RPREGC slight rounding 82.75)
6 Railroad Tax Calculation
5.1 Railroad – Tier1 Tax Example
FIT_Wages Usage 6051 Pre FWT Earnings 6153.82
RRTA_Wages Usage 6306 Pre-RR Tier1 SOC ER Earnings 6079.97
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
(1) RRTA – No Self Adjust Method
PC 7033 RR Tier1 Soc ER = RR Tier1 Earn x 0.062 = 5885.75 x 0.062 = 364.92
PC 7034 RR Tier1 Med ER = RR Tier1 Earn x 0.0145 = 5885.75x 0.0145 = 85.34
- 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.
- The reason is, if ‘RR Self-Adjust’ method is defined on IPRLU, this method is applicable for both RR Tier1 and Tier2 calculation, but 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
- since employee should only pay Tier2 tax for the Earnings that are earned for Railroad employment, if employee has FICA contribution, the user should verify 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 Employee does not have FICA employment
(2) RRTA – Self Adjust Method
FIT_Wages.ctd Usage 6051 Pre FWT Earnings = 6153.82
FIT_Wages.ytd Usage 6051 Pre FWT Earnings = 58423.53
FSP_Wages.ctd Usage 6055 Pre-FIT Suppl Earns = 0
FSP_Wages.ytd Usage 6055 Pre-FIT Suppl Earns = 5700
RRTA_Wages.ctd Usage 6306 Pre-Tier1 Soc ER Earn = 6079.97
RRTA_Wages.ytd Usage 6306 Pre-Tier1 Soc ER Earn = 57654.05
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), called this Additional RRTA Wages
CTD Usage 6306 Pre-Tier1 Soc ER Earn : 6079.97
CTD Usage 6051 Pre FWT Earnings 6153.82
CTD Addn FICA Wages: 6079.97 – 6153.82 = -73.85 (negative means RRTA Earn < Pre-FWT Earn)
YTD Usage 6306 Pre-Tier1 Soc ER Earn : 57654.05
YTD Usage 6051 Pre FWT Earnings 58423.53
YTD Addn FICA Wages: 57654.05 – 58423.53 = -769.48 (negative means RRTA Earn < Pre-FWT Earn)
Addn RRTA_Wages.ctd = -73.85 RRTA.ytd_Tier1_ER = 3813.24 (dedn so far)
Addn RRTA_Wages.ytd = -769.48
YTD 125 Total (from YTD) = 1850.24 (prorate to YTD FIT / FSP Wages, i.e. 58423.53 and 5700)
YTD 401K Total (from YTD) = 2266.37 (prorate to YTD FIT / FSP Wages, i.e. 58423.53 and 5700)
FIT_ben_125.ctd = 194.22 FSP_ben_125.ctd = 0
FIT_ben_125.ytd = 1685.77 FSP_ben_125.ytd = 164.47 (1685.77 + 164.47 = 1850.24)
FIT_ben_401K.ctd = 225.31 FSP_ben_401K.ctd = 0
FIT_ben_401K.ytd = 2064.91 FSP_ben_401K.ytd = 204.46 (2064.91 + 204.46 = 2269.37)
Calculate RRTA Wages for the Year:
FIT_Wages.ctd + Addn RRTA_Wages.ctd + FIT_Wages.ytd + Addn RRTA_Wages.ytd
6153.82 + (-73.85) + 58423.53 + (-769.48) = 63734.02
FSP_Wages.ctd + FSP_Wages.ytd
0 + 5700 = 5700
RRTA_Wages_Total = 63734.02 + 5700 = 69434.02
Calculate 125 Exemption for the Year:
RRTA_125_Total = FIT_ben_125.ctd + FSP_ben_125.ctd + FIT_ben_125.ytd + FSP_ben_125.ytd
RRTA_125_Total = 194.22 + 0 + 1685.77 + 164.47 = 2044.46
RRTA Tier1 ER Calculation:
RRTA Taxable Earnings = RRTA_Wages_Total – RRTA_125_Total
RRTA Taxable Earnings = 69434.02 – 2044.46 = 67389.56
RRTA Tier1 ER Contribution =: RRTA Taxable Earnings x RRTA Tier1 ER Rate
RRTA Tier1 ER Contribution =: 67389.56 x 0.062 = 4178.15
RRTA ER YTD so far = YTD PC 7031 FICA ER + PC 7033 RR Tier1 Soc ER
RRTA ER YTD so far = 2163.99 + 1649.25 = 3813.24 (RRTA.ytdER so far)
RRTA Tier1 ER this pay = RRTA ER Contribution – RRTA ER YTD so far
RRTA Tier1 ER this pay = 4178.15 – 3813.24 = 364.81
For Customer Support
Any questions, comments, or suggestions for High Line may be entered on-line at:
http://www.highlinecorp.com//ccare/login.htm
Please contact your Application Administrator if you are not a registered user.
This page (revision-42) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop