[{TableOfContents }] \\ This page describes the process to load the US Tax Rates and the US State Miscellaneous Parameters from the Symmetry Server that calls the Symmetry Tax Engine (STE). [{InsertPage page='UPUTR'}] !Tax Rates Processing (IPUTR) If the 'Remove Old Tax Rates' toggle is set to YES, the UPUTR process removes IPUTR Tax Rate entries that match the defined effective date, for the selected States. Consequently, users need to clean up historical rates, one effective date at a time, to prevent accidentally removing all records when loading. \\ \\ If the 'Load Tax Rates' toggle is set to YES, UPUTR retrieves the US Tax Rates for the selected list of States and loads into them IPUTR for the defined effective date. \\ \\ If IPUTR has Tax Rate entries that have an effective date PRIOR to the UPUTR defned effective date, and an expiry date of '31-Dec-3999', these Effective Date entries will expire within one day prior to the newly defined effective date. UPUTR will generate a new set of IPUTR entries with the newly defined effective date and expiry date of 'Dec-31-3999'. \\ \\ If IPUTR has Tax Rate entries that have an effective date MATCHING the UPUTR defined effective date, and an expiry date of '31-Dec-3999', these Effective Date entries will be checked and updated if values are different. \\ \\ If IPUTR has Tax Rate entries that have an effective date GREATER than the UPUTR defined effective date, these Effective Date entries will be consolidated with the selected Effective Date entries. The latest Effective Date entries will be used in order to retain the latest user defined Overridden amounts. !State Miscellaneous Tax Parameters Processing (IPUTP) If the 'Load State Misc. Params' field is set to YES, UPUTR loads in IPUTP Miscellaneous Tax Parameters for the list of selected States. \\ \\ An Effective Date entry is not required for IPUTP, as the most recent State Tax Miscellaneous Parameters are always loaded.\\ \\ If an old Miscellaneous Tax entry is not used in the current load, this parameter will be marked as 'OBSOLETE' in the Miscellaneous Identifier field. \\ \\ In [IPRLU], on the 'Miscellaneous' tab, the values for the Obsolete Miscellaneous Identifier will not be used by UPCALC. These Obsolete Miscellaneous Identifiers are for historical purposes only.\\ \\ UPUTR will default in the values for a few State tax parameters, mainly those that require a value of TRUE or FALSE. For the True/False tax parameters, UPUTR will default to a value of FALSE, as this value would make the most sense for the general public. An example would be the 'LOWINCOMETAXRATES' and 'TEXARKANARESIDENT' parameters for the state of Arkansas. \\ \\ Organizations can define their own entity wide defaults for the Miscellaneous Tax Parameters on IPUTP. Any value entered in IPRLU would override the defaults defined on IPUTP. !Internal Miscellaneous Tax Identifiers Usage(IPUTP) At the Federal or State level, UPUTR will load in a list of Miscellaneous Identifiers to define the default method to be used.\\ \\ The Miscellaneous Identifiers are given a 'Usage' to define where the Identifier is used within the application, and who defined the Identifier. \\ \\ There are three types of Identifier Usages: *01 - Employee Level (STE) *02 - Employee Level *03 - Legislative Level \\ \\ 01: The Identifiers with a usage of 'Employee Level (STE)' are provided by the Symmetry Tax Engine and will be available in the IPRLU and IPRLUS forms for employees to provide their tax filing information. These parameters will be directly passed to the Symmetry Tax Engine for calculation. \\ 02: The Identifiers with a usage of 'Employee Level' are system provided and will be interpreted by the UPCALC process prior to being passed to the Symmetry Tax Engine. These Identifiers will be available on the IPRLU and IPRLUS forms to select. \\ 03: The Identifiers with a usage of 'Legislative Level' are provided by the system and will be interpreted by the UPCALC process prior to being passed to the Symmetry Tax Engine. These Identifiers are Government Legislative type requirements allowing Employers to define/override tax requirements. These identifiers are not available to the employee on the IPRLU and IPRLUS forms.\\ \\ The following table provides examples of each of the different Usages and whether they allow an override on the IPRLU and IPRLUS forms: ||Level||Miscellaneous Identifier||Provided By||Allow IPRLU Override |Federal|IRS_LOCK_IN_FILING_STATUS|Employee Level|Yes |Federal|APPLY_BENEFIT_WAGE_LIMIT|Legislative|No |Federal|IRS_MAX_EXEMPTIONS|Employee Level|Yes |State|FILINGSTATUS|Employee Level (STE)|Yes |State|STATE_NEXUS|Legislative Level|No |State|STATE_ROUNDING|Legislative Level|No |State|SUP_PAID_WITH_REG|Employee Level|Yes |State|SUP_PAID_WITHOUT_REG|Employee Level|Yes |Oregon|TRANSIT_CANBY_TAX|Employee Level|Yes |Oregon|TRANSIT_LANE_TAX|Employee Level|Yes |Oregon|TRANSIT_TRIMET_EXCISE_TAX|Employee Level|Yes |Oregon|TRANSIT_SANDY_TAX|Employee Level|Yes |Oregon|TRANSIT_WILSONVILLE_TAX|Employee Level|Yes |Oregon|TRANSIT_SOUTH_CLACKAMAS_TAX|Employee Level|Yes 'Federal' level means the Miscellaneous Identifier will be generated with the State Name field set to 'Federal', and will be used at the Federal level of taxation. Certain Federal Identifiers are applicable to all States of the same pay.\\ 'State' level means the Miscellaneous Identifier will be generated for all States with State Name field set to a UPUTR selected list of States (LOV) and will be used at the State level of taxation. These State Identifiers are specific to the defined State only.\\ If the 'Level' field is defined with a specific State name, such as Oregon, the Miscellaneous Identifies will be generated for that State if the UPUTR selected list of States contains the specific State name. !!Printing of IPUTR / IPUTP The UPUTR process prints the Tax Rates and Miscellaneous Tax Parameters information for auditing and archival of tax rates purposes. \\ If the 'Print IPUTR Tax Rates' and/or 'Print IPUTP Misc Parms' fields are set to YES, UPUTR will print the IPUTR/IPUTP information for the list of defined States with basic information such as Tax Rate Code, Tax Identifier, Tax Rate, Wage Base and Override Information. \\ If the 'Create File' field is set to YES, users must define a valid Directory name and a File name with extension of .csv. UPUTR will generate a comma delimited file with the IPUTR/IPUTP Detail Information. \\ The 'Print From Date' can be earlier than the 'Load Effective Date' to print historical information. \\ If the 'Print From Date' is not defined, the 'Load Effective Date' will be used. \\ Users can run UPUTR at any time to print the IPUTR/IPUTR information without loading the tax rates. !!UPUTR Sample !UPUTR - Sample Run #Print Detail = NO\\[US_Load _Tax_ Rates_ and_ State_ Parameters_02.JPG] #Print Detail = YES\\[US_Load _Tax_ Rates_ and_ State_ Parameters_03.JPG] !!UPUTR - Forms Updated If UPUTR is run in Non-Trial mode, the following forms are updated: !IPUTR - Maintain US Tax Rates *Users can click on the applicable State to view the tax rates. *The 'Tax Rate Seq' field is in the format of 'XXnnnn', where XX is the State code and nnnn is a sequential 4 digit number. The sequence is not pre-determined, it is simply the order in which the parameter was loaded in by UPUTR. The sequence of the tax parameters mentioned in the documentation may not exactly match the sequence in your organization. The sequence is used to order the parameters and to distinguish them at the State level in IPRLU. *The State code for the Federal level is "00". *The Tax Identifier format is pre-defined by Symmetry with the Location code and Tax type. *The Tax Rate and Wage Base information can be defined, or it can be set to zero to indicate this Tax type will be calculated. *In order to sort either by Effective Date or by State, users can drag the applicable column to the left side of the form. *This form is loaded by the UPUTR process. Users do not need to enter information on this form, except to enter the Override amounts. !IPUTP - Maintain US Tax Parameters Users can click on the applicable State to view the State Miscellaneous Tax Parameters. \\ The 'Misc Tax Parm' field is in the format of 'XXnnnn', where XX is the State code and nnnn is a sequential 4 digit number. \\ The Miscellaneous Identifier is retrieved from Symmetry and is passed to STE with the exact name for tax calculations by the UPCALC process. Example: FILINGSTATUS. \\ This form is loaded by the UPUTR process. Users do not need to enter information on this form, other than to provide default values, if required. \\ The Reference Text field contains the editing information for the Miscellaneous Identifier. \\ The IPUTP information will be used on IPRLU - 'Miscellaneous' tab. !IPRLU - Miscellaneous Tab *All employees __MUST__ be set up on the IPRLU 'Miscellaneous' tab prior to running UPCALC to calculate US Taxation by Symmetry. *IPRLU can be set up with or without a State code. *UPCALC will pick up the State record first. If no matching state record can be found, UPCALC will then look for a jurisdiction record matching the jurisdiction on the employee's IPPH. If UPCALC cannot locate a matching jurisdiction record, it will then read the default IPRLU record. *When IPRLU is set up without a State, the Misc. Tax Parm can be entered for all States. The Reference Text will help users to enter the correct Field Variable information. *When IPRLU is set up with a State, the Misc. Tax Parm must be entered for that specific State only. This IPRLU entry contains information to be used for this State. Example: A different tax method can be defined for this State. *When UPCALC creates the default IPRLU record for an employee who does not have a record, such as a new hire, UPCALC will read IPUTP for any default values that may be defined. If none are found the system will use the first option available in the reference text, such as 0 for Total Allowances. For the Filing Status tax parameters, UPCALC will derive the Filing Status from the Vertex Filing Status in the State tab, and if null, will then use the Federal Filing Status. ---- ![Notes|Edit:Internal.US Taxation Processing - US Load Tax Rates and State Parameters] [{InsertPage page='Internal.US Taxation Processing - US Load Tax Rates and State Parameters' default='Click to create a new notes page'}]