Table of Contents
- US LOAD TAX RATES AND STATE PARAMETERS
- Overview
- UPUTR - Selection Criteria
- UPUTR - Load US Tax Rates and State Misc Parameters
- UPUTR Processing
- UPUTR â Processing
- Tax Rates Processing (IPUTR)
- State Miscellaneous Tax Parameters Processing (IPUTP)
- Internal Miscellaneous Tax Identifiers (IPUTP)
- UPUTR Sample
- UPUTR â Sample Run
- UPUTR â Screens updated
- IPUTR â Maintain US Tax Rates
- IPUTP â Maintain US Tax Parameters
- IPRLU â Miscellaneous Tab
- Notes
US LOAD TAX RATES AND STATE PARAMETERS#
Overview#
This page describes the process to load US Tax Rates and US State Miscellaneous Parameters from the Symmetry Server that calls the Symmetry Tax Engine (STE).UPUTR - Selection Criteria#
UPUTR - Load US Tax Rates and State Misc Parameters#
| Effective Date | Mandatory,Date, LOV Available You must enter an Effective date for the tax rates. |
| Remove Old Tax Rates | Optional,Yes or No lexicon available If <YES>, the report will remove old IPUTR Tax Rates that match the specified Effective date. You may run UPUTR to remove old tax rates without loading new rates, which allows you to clean up historical tax rates. |
| Load Tax Rates | Optional,Yes or No lexicon available If <YES>, the report load IPUTR Tax Rates for the specified Effective date and selected states If this toggle is set to <<Yes>>, you do not need to set the 'Remove Old Tax Rates' toggle to <<Yes>>. UPUTR will automatically match or create new entries with the same Effective date. This is because UPUTR needs to retain the Overridden User Rates and therefore cannot remove Old Rates of the same Effective Date before loading. |
| Load State Misc Parms | Optional,Yes or No lexicon available If <YES>, the report will load IPUTP Tax Parameters for selected states. |
| Country | Mandatory You must enter the Country code in order to filter the list of states. |
| State | Optional You may enter list of states to be processed. If no states are entered in this field, then all states will be processed. If you wish to load Federal rates, you must select 'Federal' from the list of states. If you wish to load County or City rates, you MUST enter a list of states and then enter the Jurisdictions parameters below. |
| Load All Jurisdiction | Optional,Yes or No lexicon available By default, this toggle is set to <<No>>, which means that the Jurisdiction Tax Rates will not be automatically loaded for each jurisdiction. This is because the volume of information would affect the performance of UPUTR. Some users may pay into jurisdictions that have taxes while others do not. If you wish to view the Tax Rates by Jurisdictions on IPUTR, you may: (1) either select <<Yes>> for this toggle to load all Jurisdiction Tax Rates into IPUTR for all IDTX entries for the state, (2) or enter a list of jurisdictions in the following field. Note: IPUTR Jurisdiction entries are for information only. The tax calculation will actually be calculated directly from the Symmetry Tax Server; the rates (except for Overridden rates) are not picked up from IPUTR. |
| Load Only Jurisdiction | Optional, user may enter list of Jurisdictions to load in the County or City Rates |
if âLoad All Jurisdictionâ prompt = Yes, then this prompt will not be used
| Trial | Optional, to allow user to run in Trial or Update mode this allows user to review the Run Log report prior to Update in Non-Trial mode, IPMT, IPUTR screens are updated |
| Print Detail | Optional, to show detail dump of the Tax Rates and State Misc Tax Parameter information if âPrint Detailâ is Yes, the report size may be quite large, user should run with âPrint Detailâ = No unless for Tracing by default, users should not Print in Detail |
| Exception Level | user should run with Exception Level except for Tracing in âUtility Traceâ, the report may be over several hundred pages |
| User Comment | enter User Comments to be printed on the Parameter page |
UPUTR Processing#
UPUTR â Processing#
- At the Federal and State Level, UPUTR loads in the US Tax Rates and Miscellaneous Tax Parameters for the list of States selected
- In order for Federal rates to be loaded, Federal must be selected from the State parameter
- If users are paying County or City taxes, user may optionally load in the County or City rates by entering âYesâ to the prompt âLoad All Jurisdictionâ or to enter a list of Jurisdictions to be included e.g. City of Yonkers for New York State
- After UPUTR is run, user should go into IPUTR and IPUTP screen to view the newly loaded Tax Rates and State Miscellaneous Tax Parameters
- The frequency of UPUTR run should be as follows in order to load in the latest Tax Rates and State Miscellaneous Tax Parameters
o When Symmetry Tax Engine is upgraded ï§ when Symmetry Tax Engine is delivered due to Software upgrade or Tax Rate changes, user should run UPUTR to pick up any new rates or State Miscellaneous Tax Parameters
o At User Request ï§ if user starts to pay in s new State, user may run UPUTR ï§ user may run at any time to load in the County or City Rates
- If âPrint Detailâ = Yes, UPUTR will list the detail entries that are processed for each Tax Rate level and each State Miscellaneous Tax Parameter
- IPUTR US Tax Rates are for information purposes only (except the overridden SUTA / FUTA rates). The tax rates are not passed to Symmetry for tax calculation, rather Symmetry retrieves the tax rates directly within their tax engine (SymmetryTaxServer).
- UPCALC will read IPUTR for SUTA / FUTA Overridden amounts and will pass these overridden amounts to Symmetry for the tax calculations.
- There are 2 options to set up Overridden Rate, Overridden Wage Base or Overridden Tax Limit
(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 State - rate overrides are only applicable for FUTA, SUTA, SUTA SC, SUI EE and SDI EE tax identifiers, overrides entered for other tax rates will not be read
(2) IDGV - if there is a specific rate given by the government for different State 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
- The Effective date in IPUTR is not used by Symmetry. The UPUTR will load in all tax rates, regardless of when they become effective. During the tax calculation UPCALC will pass to the SymmetryTaxServer the pay period issue date to determine which tax rates to use for the period being paid.
- The Effective date in IPUTR is used by UPCALC to determine which record to read for any overridden tax rate for the pay period being paid.
- If the user needs to add in a new effective date entry for a change to an overridden tax rate (ie: new government supplied SUTA rate) the user would run UPUTR for the new effective date.
- When UPUTR is generating new sets of Effective Date entries, the Overridden Rates and Amounts will be copied into the new Effective Date entries
- If an old Tax Rate entry is not used by Symmetry in the current load, this old Tax Rate will not be copied into the new Effective Date set, however, if the user is reloading with an existing Effective date, then this old Tax Rate will remain unchanged for historical purposes
Tax Rates Processing (IPUTR)#
- If the parameter âRemove Old Tax Ratesâ = âYesâ, UPUTR removes IPUTR Tax Rates entries that are prior to the specified Effective Date for the selected States
- If âLoad Tax Ratesâ = âYesâ, UPUTR retrieves the US Tax Rates for the selected list of States and loads into IPUTR for the specified Effective Date
- If IPUTR has Tax Rate entries that are with Effective Date PRIOR to UPUTR specified Effective Date and the Expiry Date = â31-Dec-3999â, these Effective Date entries will be expired with 1 day prior to the newly selected Effective Date, UPUTR will generate a new set of IPUTR entries with the newly specified Effective Date, with Expiry date = âDec-31-3999â
- If IPUTR has Tax Rate entries that are with Effective Date MATCH to UPUTR specified Effective Date and the Expiry Date = â31-Dec-3999â, these Effective Date entries will be checked and updated if values are different
- If IPUTR has Tax Rate entries that are with Effective Date GREATER than UPUTR specified 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 Overridden amounts
State Miscellaneous Tax Parameters Processing (IPUTP)#
- If the parameter âLoad State Misc. Paramsâ = âYesâ, UPUTR loads in IPUTP Miscellaneous Tax Parameters for list of selected States
- Effective Date is not required for IPUTP, the most recent State Tax Miscellaneous Parameters are always loaded
- If an old Miscellaneous Tax Parameter is not used in the current load, this Parameter will be marked with â-OBSOLETEâ in the Miscellaneous Identifier field
- In IPRLU on the MISCELLANEOUS Tab, the values for the Obsolete Miscellaneous Identifier will not be used in UPCALC. These Obsolete Miscellaneous Identifiers are for historical purposes only.
- UPUTR will default values for a few state tax parameters, mainly those that require a value of True or False. For the true false tax parameters the UPUTR will default a value of âFALSEâ as this value would make the most sense for the general public. A few examples would be the parameters âLOWINCOMETAXRATESâ and âTEXARKANARESIDENTâ for the state of Arkansas.
- Clients may provide their own entity wide defaults for the Misc Tax Parameters in IPUTP. Any value entered in IPRLU would override the defaults defined in the IPUTP.
Internal Miscellaneous Tax Identifiers (IPUTP)#
- At Federal or State level, UPUTR automatically loads in a list of internal Miscellaneous Identifiers to provide the Default Method to be used
Level Miscellaneous Identifier Provided By Allow IPRLU Override
Federal 401K_CATCHUP Internal Yes State STATE_NEXUS Legislative No State STATE_ROUNDING Legislative No State SUP_PAID_WITH_REG Internal Yes State SUP_PAID_WITHOUT_REG Internal Yes Oregon TRANSIT_CANBY_TAX Internal Yes Oregon TRANSIT_LANE_TAX Internal Yes Oregon TRANSIT_TRIMET_EXCISE_TAX Internal Yes Oregon TRANSIT_SANDY_TAX Internal Yes Oregon TRANSIT_WILSONVILLE_TAX Internal Yes Oregon TRANSIT_SOUTH_CLACKAMAS_TAX Internal Yes
- âFederalâ level means the Miscellaneous Identifier will be generated with State Name = âFederalâ and will be used at the Federal Level 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 = UPUTR selected list of States and will be used at the State Level taxation, these State Identifiers are specific to the defined State only
- If Level = specific State name (e.g. âOregonâ), this means these Miscellaneous Identifies will be generated for State of Oregon if UPUTR selected list of States contains âOregonâ
- These Miscellaneous Identifiers are used internally by UPCALC and will not be passed to the Symmetry Tax Engine
- Certain Identifiers are defined according to Government Legislative Requirement which allows the Employer to override on IPUTP but however do not allow the employee to override at the employee level, these Identifiers are defined with âProvided Byâ = âLegislativeâ, e.g. STATE_ROUNDING
- For the âInternalâ Identifiers, the employee may optionally add this Identifier on IPRLLU MISC Tab to override the default value of IPUTP, e.g. SUP_PAID_WITH_REG
- For State Supplemental Tax calculation, please read PR_US_IPRLU_Sup_Pay_v1.0.doc for detail for the usage of SUP_PAID_WITH_REG and SUP_PAID_WITHOUT_REG
UPUTR Sample#
UPUTR â Sample Run#
(1) Print Detail = âNoâ
(2) Print Detail = âYesâ
UPUTR â Screens updated#
If UPUTR is run in Non-Trial mode, the following list of Screens are updated:
IPUTR â Maintain US Tax Rates#
- The user should click the applicable State to view the Tax Rates
- Tax Rate Seq is in 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 the UPUTR function. The sequence of the tax parameters mentioned in the documentation may not match exactly to the sequence you have in your environment. The sequence is used to order the parameters and to distinguish them at the state level in IPRLU.
- The State Code for Federal Level is 00
- Tax Identifier format is pre-defined by Symmetry with the Location Code and Tax Type
- The Tax Rate, Wage Base information may be provided or it may be zero to indicate this Tax Type will be calculated
- In order to Sort by Effective Date or to Sort by State, user may drag the applicable column to the left side at the scroll block
- This screen is loaded by UPUTR, user does not need to enter information on this screen except to enter the Override Amounts
IPUTP â Maintain US Tax Parameters #
- User may select the applicable State to view the State Miscellaneous Tax Parameters
- Misc Tax Parm is in Format of âXXnnnnâ, where XX is the State code and nnnn is a sequential 4 digit number
- Miscellaneous Identifier is retrieved from Symmetry and will be passed to Symmetry Tax Engine with this exact Name for Tax Calculation by UPCALC, e.g. FILINGSTATUS
- This screen is loaded by UPUTR, user does not need to enter information on this screen other than to provide default values if desired
- The Reference Text field contains the editing information for the Miscellaneous Identifier
- IPUTP information will be used on IPRLU screen Miscellaneous Tab
IPRLU â Miscellaneous Tab#
- All employees MUST be set up on 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 the user to enter the correct information in the Field Variable
- When IPRLU is set up with a State, the Misc. Tax Parm must be entered for that specific State only, this IPRLU entry contains pertaining information to be used for this State, e.g. 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, i.e a new hire, the 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, ie: 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.
