[{TableOfContents }]
!!!US TAX SCREENS
!!Overview
This page describes the screens that are used for US Taxation in the Payroll Calculation Process.
!!Geographic Screens
[UDGNIS] process loads in the "US Geographic Names Information System (GNIS)" information from the Symmetry Tax Server into the [{$applicationname}] system. The process will load in all Counties, Cities, Schools, Municipalities, and Zip Codes for each state selected in the parameters. Please refer to the document [PR_US_Load_GNIS|US Load GNIS Locations] page for more detailed information as to how the UDGNIS function works.
The following describes the geographic screens that are updated by the UDGNIS function.
!IDCO - Define Countries
[US_Tax_Screens_2.1.JPG]
*ISO Alpha 2 and ISO Alpha 3 may be defined for each Country
*These fields contain the 2 or 3 character ISO Country code
*Some government reporting requires to report a two character ISO Country code while some government reporting requires to report a three character ISO Country code
*For Annual Wage W-2 or Quarterly reporting, if an employer deals with Foreign Country Addresses, then the ISO Country codes need to be set up.
*Website for 2 Alpha or 3 Alpha ISO Country Code: [http://www.unc.edu/~rowlett/units/codes/country.htm]
!IDSP - Define States and Provinces
[US_Tax_Screens_2.2.JPG]
*State Code "00" is used for Federal Level Taxation
*[FIPS] code is stored at State level, this field contains the FIPS Numeric code for each state
*UDGNIS process will load in the states and FIPS codes if these do not already exist
!IDCN - Define Counties
[US_Tax_Screens_2.3.JPG]
*Symmetry County code format is: 99-999
*Vertex County code format: 99-999-0000
*During UDGNIS Vertex conversion, if the Vertex County Code has been used in the system, the Vertex County Code will be stored as Alternate County code for reference with format: 99-999-0000, if the Vertex County Code has not been used, this County code will be removed
*UDGNIS process will load in all Counties for each State, you do not need to enter manually on this screen
!IDCI - Define Cities
[US_Tax_Screens_2.4.JPG]
*City code format: Variable length, 4 digits to 7 digits
*For each County from [IDCN], UDGNIS retrieves all City codes that are for this County
*This helps you to enter the correct combination of City with the related County for tax calculations
*At the City Level, the entire combination of State-County-City codes will form a valid GNIS code for Symmetry Taxation, e.g. 06-001-1655980 is for Dublin, Alameda, California
*UDGNIS process will load in all cities for each state, you do not need to enter manually on this screen
!IDSD - Define School Districts
[US_Tax_Screens_2.5.JPG]
*School District Code Format: Variable length, 5 to 6 digits
*For each County from IDCN, UDGNIS retrieves all School District Codes that are for this County
*This helps you to enter the correct combination of School with the related County for tax calculations
*During UDGNIS Vertex conversion, if a Vertex School code has not been used in the system, this Vertex School code will be removed
*During UDGNIS Vertex conversion, if a Vertex School code has been used in the system, UDGNIS will look for a match for the School District and the Vertex School code will be stored in Alternate School Code for reference purposes
*UDGNIS process will load in all schools for Ohio and Pennsylvania only, you do not need to enter manually on this screen. However, you must associate the School District Code to the appropriate Tax Jurisdiction in [IDTX].
!IDMN - Define Municipalities
[US_Tax_Screens_2.6.JPG]
*Municipality code format: 7 digits
*For each County from IDCN, UDGNIS retrieves all Municipality codes that are for this County
*This helps the user to enter the correct combination of Municipality with the related County for tax calculations
*State of Pennsylvania requires Municipality Code to calculate City taxes, other States do not require Municipality Codes
*UDGNIS process will load in all Municipalities for Pennsylvania only, you do not need to enter manually on this screen. however, you must associate the Municipality to the appropriate Tax Jurisdiction in [IDTX].
!IDZR - Maintain ZIP Ranges
__[IDZR] - COUNTY_ZIP RANGES Tab - Used by Symmetry Taxation__
[US_Tax_Screens_2.7.1.JPG]
*For Symmetry Taxation, the County Zip Ranges tab is used
*ZIP Code Format: 5 digits
*For each County from IDCN, UDGNIS retrieves all ZIP Codes that are for this County and Cities
*UDGNIS loads in all ZIP codes for each State, users do not need to enter manually on this screen
*The user can drag the applicable column to the first column to sort the data\\Example:
**Drag Zip Code to the first column to show all Cities for the same Zip Code
**Drag City to the first column to show all Zip Codes for the same City
__IDZR - JURISDICTION ZIP RANGES Tab - Used by Vertex Taxation Only__
[US_Tax_Screens_2.7.2.JPG]
*For Vertex Taxation, please use the Jurisdiction Zip Ranges tab
*To view the list of ZIP codes by Vertex GEO codes, please click GEO Code entries with GEO Type = City
*During UDGNIS Vertex conversion, the unused Vertex ZIP ranges are removed, the new ZIP ranges are loaded by County and City, therefore after conversion, there may be no ZIP entries on the Jurisdiction Zip Ranges tab, you should use the County Zip Ranges tab after conversion
!!Tax Jurisdiction Feature
!IDTX - Tax Jurisdiction Concepts
*UDGNIS is the process which loads in all "US Geographic Names Information System (GNIS)" Location codes into the system
*Before entering Tax Jurisdictions on IDTX screen, user must run UDGNIS to load in all the [IDCO], [IDSP], [IDCN], [IDCI], [IDMN], [IDSD], [IDZR] entries so that [IDTX] can be defined using the GNIS information.
*UDGNIS may also be run to Create tax jurisdictions in IDTX for the state selected in the report parameters.
*GNIS code is also known as GEO code in the system
*GNIS Code Format is: SS-CCC-FFFFFFF, where:
|SS|State FIPS Numeric Code|2 digits
|CCC|County Code|3 digits
|FFFFFFF|City Feature ID|Variable Length, 4 to 7 digits
*IDTX screen stores a unique combination of State, County, City, Municipality and School Districts that will be used in the system.
*Each combination of State, County, City, Municipality and School Districts will form a tax jurisdiction that is eligible for tax calculation when an employee is being paid under this tax jurisdiction.
*After a tax jurisdiction has been paid in a pay for an employee, this tax jurisdiction wil then become the pay jurisdiction of this pay.
*You can view the pay jurisdiction information of a pay on the [IPPH] and [IPVT] screens with its associated tax amounts.
!IDTX - Tax Jurisdiction Screen Layout
[US_Tax_Screens_3.2.1.JPG]
*GNIS Code 00-000-0000 is used for Federal Level Taxation, UDGNIS automatically loads in this entry
*Each IDTX entry is for a unique combination of State, County, City, Municipality, School
*If the same GNIS Code displays multiple entries on the left side, please note that these are not duplicate entries, these entries must be defined for different Municipalities or Schools, please refer to the right side to show the detail of this screen
*In order for School District tax to calculate for Ohio and Pennsylvania, the School District must be specified in IDTX for the appropriate Tax Jurisdictions.
*For [IDLN], [IEPI], [IEAS], [IPTR], [IPPH] screens that need the Jurisdiction code, these screens will pop into 'Tax Jurisdiction Editor Utility' with the GNIS Code icon [US_Tax_Screens_geocode_icon.JPG] to enter Jurisdiction Information
*There are 2 options to create new Tax Jurisdictions in IDTX
*#you can manually enter the Tax Jurisdiction combination on the right side of the IDTX screen\\i.e. enter each State, County, City, Municipality, School code
*#you can click the GNIS Code icon [US_Tax_Screens_geocode_icon.JPG] to pop into the 'Tax Jurisdiction Editor Utility' dialog box
*To manually convert an existing Vertex GEO Code to a Symmetry GNIS code please read the section Manually Converting Tax Jurisdictions in the following pages.
To manually create NEW tax jurisdictions:
__Option (1)__
*Enter manually on the right side of the IDTX screen
**i.e. State will default in, select a County, City, Municipality, School Code
*The new GNIS Code will be automatically built with the selected State-County-City Code
*If the user is unsure of the County the City belongs to, they may select the City and the system will default the associated County.
[US_Tax_Screens_3.2.2.JPG]
__Option (2)__
*Click GNIS Code [US_Tax_Screens_geocode_icon.JPG] icon to pop into the 'Tax Jurisdiction Editor Utility' dialog box
*On IDTX, select a State, then click the Add [US_Tax_Screens_add_icon.JPG] icon , then click the GNIS Code [US_Tax_Screens_geocode_icon.JPG] icon to pop into the Tax Jurisdiction Editor Utility dialog box.
[US_Tax_Screens_3.2.3.JPG]
__Manually Converting Tax Jurisdictions__
There may be cases where the UDGNIS could not convert a tax jurisdiction. This could be a result of a spelling error or the jurisdiction is not classified as a real city by the US Postal Service and therefore the UDGNIS could not find the correct GNIS code to use.
To manually change a Vertex GEO Code to the Symmetry GNIS format follow the steps below:
#Copy the GEO CODE into the Alt Geo Code field. This is needed so that when [UPCALC] is run using Vertex, UPCALC knows which Vertex GEO Code to use.
#Using the fields on the right hand side, select the correct County and City. This will create the appropriate GNIS Geo Code. The name defined in the Jurisdiction field will be replaced with the City name.
!!Tax Jurisdiction Editor Utility
!IDTX - Tax Jurisdiction Dialog Box
When IDTX, IDLN, IEPI, IEAS, IPTR, IPPH screen requires a Jurisdiction code, the user can click the [US_Tax_Screens_geocode_icon.JPG] icon beside the GNIS Code field which will pop up the 'Tax Jurisdiction Editor Utility' dialog box.
[US_Tax_Screens_4.1.JPG]
In the Tax Jurisdiction Editor Dialog there are two sections to enter information, you can enter information in either one:\\ \\
__1. Enter Selection or Jurisdiction Details__
;GEO Code:
*you may click the GNIS Code lookup icon and select from the list of existing GNIS Codes
*after a GNIS Code entry is selected from lookup the valid State, County, City, Municipality, School will be displayed
;ZIP Code:
*you may click the lookup of the ZIP Code and select from the list
*or you may manually enter a ZIP code
*if a ZIP Code is selected from lookup, the valid State, County, City, Municipality, School will be displayed, e.g. ZIP 17815 for PA
*if a ZIP Code is manually entered and if this ZIP code is unique, then the valid combination will be displayed
;Location:
*you may click the lookup for Location Code and select from the list
*after a Location code is selected from lookup, this Location code is used to go into IDLN to retrieve the Jurisdiction if it exists and display the State, County, City, Municipality, School of the IDLN Jurisdiction
After the selection of GNIS Code, ZIP Code or Location Code is specified, the user can modify the Jurisdiction Details if these combinations are not correct or click OK.\\ \\
__2) Jurisdiction Details__
;State:
*the state will default in, however you may select a different state from the list
;County:
*you may click the lookup for County Code and select from the list.
;City:
*you may click the lookup for City Code and select from the list.
*if you do not know the County the City belongs to, you may not provide the County information and just select a City, the County will default in according to the selected City
;Municipality:
*you may click the lookup for Municipality Code and select from the list.
*only the State of Pennsylvania will display Municipalities
;School:
*you may click the lookup for School and select from the list
*only Ohio and Pennsylvania States will display Schools to select from
%%information When doing lookup for County, City, Municipality or School, if you do not know the code of the County or City, you may use '%'to look up the column, e.g. %Ph will display the list that contains 'Ph'%%
The Message Box will display the DTX_00001 to DTX_00007 messages, depending on the selections made above.
The Return GNIS Code will display the generated GNIS Code based on the selections made above.
!List of Screens that use Tax Jurisdiction Dialog Box
The following is a list of screens that contain the tax jurisdiction:
*IDLN - Define Locations
*IDTX - Define Tax Jurisdictions
*IEPI - Maintain Personal Information
*IEAS - Maintain Assignments
*IEHR - Establish Personnel Profiles
*IEQH - Quick Hire Employees
*IPTR - Maintain Pay Transactions
*IPPH - Maintain Employee Pays
!!Definition Screens
!IDGV - Maintain Government Registrations
[US_Tax_Screens_5.1.JPG]
*IDGV Government Registrations must be set up by "Registration Type" for Federal, State, Local Level
*The user may also define IDGV Government Registration by County or City if necessary
*The Year End document describes the reporting requirement of the Government Registration
*Any Government Rates defined in IDGV for a specific Government Registration will override those defined in IPUTR.
!IPUTR - Maintain US Tax Rates
[US_Tax_Screens_5.2.JPG]
*The user MUST run [UPUTR] to load the US Tax Rates by Effective Date into the [IPUTR] screen
*Please read the [US Load Tax Rates and State Parameters] documentation for detail
*The user may 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 consecutive 4 digit number
*The State Code for Federal Level is 00
*Tax Identifier is retrieved from Symmetry, the format is pre-defined by Symmetry and contains the Tax Type
*The Tax Rate, Wage Base information are provided by Symmetry or may contain zero to indicate this Tax Type will be calculated
*To sort by Effective Date, user may drag the Effective Date column to the left side of the State Column
!IPUTR - Override Tax Rates
[US_Tax_Screens_5.3.JPG]
*To calculate ER FUTA / SUTA, Symmetry requires clients to define an override tax rate for both FUTA and SUTA as these are typically different for each client.
*The users have 2 options to set up ER FUTA / SUTA override rates:
*#On IDGV for FUTA set up Reg Type 'US FUTA Regist n' with 'US FUTA Rate' for every IDGV registration . For SUTA for the appropriate state/registration set up Govt Rate Type 'US SUI ER'.
*#On IPUTR, enter the appropriate tax rate in the Override Tax Rate field for the necessary Tax Identifier, e.g. 00-000-0000-ER_FUTA-000 under Federal.
*The IDGV Rate will be used if one exists, otherwise the IPUTR Rate will be used
!IPUTP - Maintain US Tax Parameters
[US_Tax_Screens_5.4.JPG]
*The user MUST run UPUTR to load in US Miscellaneous Tax Parameters for Federal and State taxation
*Please read the [US Load Tax Rates and State Parameters] documentation for specific detail on how to run UPUTR
*The user may select the applicable State from the find block to view the State Miscellaneous Parameters by Misc. Tax Parm.
*Miscellaneous Identifiers are retrieved from Symmetry during the UPUTR process. These will be passed to the Symmetry Tax Server for tax calculations in UPCALC, e.g. FILINGSTATUS
*The [IPUTP] screen information will be used by the IPRLU Miscellaneous tab for each employee to enter their filing information by State
*The Reference Text field contains the editing information for the Miscellaneous Identifier
*‘Federal’ taxation 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’ taxation level means the Miscellaneous Identifier will be generated 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.
*The Miscellaneous Identifiers are given a usage to indicate where the Identifier is used within the application and who provided the Identifier.\\There are three types of Identifier usages:
**01 - Employee Level (STE)
**02 - Employee Level
**03 - Legislative Level
*The Identifiers with a usage of ‘Employee Level (STE)’ are provided by the Symmetry Tax Engine and will be available in the IPRLU / IPRLUS screen for employees to provide their tax filing information. These parameters will be directly passed to the Symmetry Tax Engine for calculation.
*The Identifiers with a usage of ‘Employee Level’ are system provided and will be interpreted by UPCALC prior to being passed to the Symmetry Tax Engine. These Identifiers will be available in the IPRLU / IPRLUS screens to select.
*The Identifiers with a usage of ‘Legislative Level’ are system provided and will be interpreted by UPCALC prior to being passed to the Symmetry Tax Engine. These Identifiers are Government Legislative type requirements allowing employers to provide/override tax requirements. These identifiers will not be available to the employee in IPRLU/IPRLUS.
*The following table provides examples of each of the different usages and whether they allow an override on the IPRLU / IPRLUS screens.
||Tax Level||Miscellaneous Identifier||Identifier Usage||Allow IPRLU Override
|Federal|IRS_MAXIMUM_EXEMPTIONS|Employee Level|Yes
|Federal|IRS_LOCK_IN_FILING_STATUS|Employee Level|Yes
|Federal|APPLY_BENEFIT_WAGE_LIMIT|Legislative|No
|State|FILINGSTATUS|Employee Level (STE)|Yes
|State|STATE_ROUNDING|Legislative Level|No
|State|STATE_NEXUS|Legislative Level|No
|State|SUP_PAID_WITH_REG|Employee Level|Yes
|State|SUP_PAID_WITHOUT_REG|Employee Level|Yes
!IPCU - Define Pay Component Usages
[US_Tax_Screens_5.5.JPG]
*All US PC Usages are delivered and loaded into the system during each release of US Taxation
*The user should go into IPPC screen to set up Pay Components for the PC Usage Codes that are to be used by UPCALC
*For a list of US PC Usages, please read the document PR_US_PC_Usages.doc
*The Associated Pay Components section shows a list of Pay Components that are defined for the PC Usage Code\\e.g. IPPC PC 6962 NY-MCTMT Commuter Tax is set up with Usage 7452
*UPCALC will store the Tax Result forNew York Metropolitan Commuter Transportation Mobility Tax in PC Usage 7452, i.e. store in PC 6962
!IPPC - Define Pay Components
[US_Tax_Screens_5.6.JPG]
*The user should go into the IPPC screen to set up Pay Components for the PC Usage Codes that will be used in UPCALC
!!Employee Screens
!IPRLU - Miscellaneous tab
[US_Tax_Screens_6.1.JPG]
*IPRLU is the original Tax Filing screen where employees must have defined their Tax Filing information. The IPRLU contains all of the original fields used by Vertex. A new tab has been added for the Misc Tax Parameters needed for Symmetry.
*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 without a State code, this entry will be used for multiple States, then if the specific State IPRLU entry is set up, this overrides the generic State IPRLU entry
*When IPRLU is set up without a State, the Misc. Tax Seq can be entered for many States, the Reference Text will help the user to enter the correct information in the Field Variable
*If the Misc. Tax Seq Field Type is Char and the Reference Text specifies a list of values, the Field Variable will be edited with this list of values, e.g. 000001 FILINGSTATUS only allows S or M or MH or NRA
*When IPRLU is set up with a State, the Misc. Tax Seq must be entered for that specific State only, this IPRLU entry contains pertaining information to be used for this State only
!IPRLUS - New Tax Filing Screen
[US_Tax_Screens_6.2.JPG]
*IPRLUS is a new trimmed down version of the IPRLU used for Symmetry taxation. The fields that were solely used by Vertex have been removed from this new screen, therefore this screen should only be used for Symmetry.
*The Misc Tax Parameters have been added to the State tab as there is now more room in the tab to house this information.
*The functionality of the screen remains the same as the original IPRLU as noted in the previous section.
!IPPH - Pay Jurisdiction Tab
[US_Tax_Screens_6.3.JPG]
*If the Pay Stage is prior to Calculated / Paid, the Work Jurisdiction and Home Jurisdiction Area can be used to enter the Home Tax Jurisdiction and Work Tax Jurisdiction, note that these can also be entered on the PAY HEADER Tab
*The user can click the Jurisdiction Name icon to look up or to pop into the Tax Jurisdiction Editor dialog box to enter State, County, City, Municipality and School
*The Tax Jurisdiction is returned by Lookup or the Tax Jurisdiction Editor dialog box and becomes the Pay Jurisdiction of this pay
*On the Pay Lines tab, each Pay Line Jurisdiction may specify the Work Jurisdiction of this line so that the Hours and Earnings are allocated to the specified Work Jurisdiction of this line
*After this Pay is calculated by Trial Calc or UPCALC, the Tax Audit Information will be displayed for the list of Jurisdictions, and the summary of all Pay Components are displayed on Pay Amounts tab.
!IPVT - View Employee Pay Totals
[US_Tax_Screens_6.4.JPG]
*After UPCLOZ the Pay Header's Work Jurisdictions and Home Jurisdiction will be updated into IPVT YTD / QTD
!IPGH - Manage Government Report Details
[US_Tax_Screens_6.5.JPG]
*RPYEU will generate IPGH information by Jurisdictions
*IPGH Pay Jurisdiction tab allows the user to view the Jurisdiction information
!!Site Preference - US Taxation
!IMST - Site Preference
[US_Tax_Screens_7.1.JPG]
*For each database server, the above IMST Site Preferences should be set up during the installation of US Symmetry taxation
__US TAX PREFERENCES__
|[US TAX SERIES|US TAX SERIES(System_Preference)]|specifies the US Tax Series to be used in UPCALC; field size: char(1)
| |0, N - N/A, client is not using US Taxation, UPCALC is used for BE/AT purposes only
| |1 - Main US tax module, the Symmetry Tax Engine (STE) is used
| |L - Legacy Series, the Vertex COBOL version tax module is used
| |Q - Quantum Q Series Tax Calculation, not supported, will remove later
|[US TAX HOST NAME|US TAX HOST NAME(System_Preference)]|specifies the Database Host Name of the SymmetryTaxServer that is installed
|[US TAX PORT NUM|US TAX PORT NUM(System_Preference)]|specifies the Port Number of the SymmetryTaxServer that will be listening for incoming Tax Server requests, this must be the same as serverConfig.txt PORT_NUMBER
__SYMMETRY PREFERENCES__
|[US STE LOG DIR|US STE LOG DIR(System_Preference)]|optional, specifies the Output Directory for Symmetry Log File
| |this directory should be the same Output Directory that is used to generate Interface Files for the Application Server, e.g. \\Tantus\output . If the full location is not specified (ie. C:\Output), the directory will be relative to the server where the SymmetryTaxEngine is specified.
| |IMPORTANT: please specify a valid Directory Name with Path Name, the Database Object for Output Files MUST NOT be used e.g. OUTPUT object cannot be used
|[US STE LOG LEVEL|US STE LOG LEVEL(System_Preference)]|optional, specifies the Symmetry Logging Level that will be passed in STE_LOGGING_LEVEL
| |user may specify one of the following LOG LEVEL:
| |DEBUG, INFO, WARN, ERROR, FATAL, OFF, NULL
| |this should be set to DEBUG as default, when Trail Calc or UPCALC is run in Utility Trace, this Log Level will be used
| |when STE_LOGGING_LEVEL is passed to Symmetry, Symmetry will display information pertaining to the Level specified, e.g. if WARN, it will show only WARN info
| |please set to DEBUG to see all information when running in Trace
|[US STE LOG FILE|US STE LOG FILE(System_Preference)]|optional, may specify an overridden Symmetry Log File name (future, not used yet)
----
![Notes|Edit:Internal.US Tax Screens]
[{InsertPage page='Internal.US Tax Screens' default='Click to create a new notes page'}]