Table of Contents
- UPCALC - HOW TO COMBINE OR SEPARATE MULTIPLE EMPLOYMENTS FOR TAX CALCULATION
- Overview
- Set Up
- IMST – Site Preference – GOVT REGIST RULE
- Govt Regist Rules
- Multiple Employments and Multiple Groups
- Employee Example
- UPCALC - GOVT REGIST RULE = ‘01’ (Default Rule)
- UPCALC - GOVT REGIST RULE = ‘02’
- UPCALC - GOVT REGIST RULE = ‘03’
- UPCALC - GOVT REGIST RULE = ‘04’
- UPCALC – Additional Scenarios
- When to Define a New Employment
- Notes
UPCALC - HOW TO COMBINE OR SEPARATE MULTIPLE EMPLOYMENTS FOR TAX CALCULATION #
Overview#
This section illustrates the option to handle multiple federal government registrations and multiple employments for legislative purpose. This is mostly for capping or restarting of annual wage base maximums, annual maximum deductions and limits.Set Up#
IMST – Site Preference – GOVT REGIST RULE#
On IMST Preferences tab, a site preference for ‘GOVT REGIST RULE’ may be added.Report Parameters & Filters#
| Report Parameters | |
|---|---|
| Entity | Mandatory, LOV available This field limits the process to the entity specified. |
| TMRS Gross Element | Mandatory, LOV available |
| TMRS Contribution Element | Mandatory, LOV available |
| Reporting Period | Mandatory, Text YYYYMM The ‘Reporting Period’ date will be used to determine which 'month' the report falls into. |
| Interface Code | Mandatory,LOV available This field lets you identify the interface code associated with the report. |
| Interface Directory | Mandatory, Text This field must indicate a directory on the data base server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used. |
| File Name | Mandatory, Text Enter the name of the file that will be created in the Interface Directory specified. |
| Write or Append | Mandatory, Write or Append lexicon available If the file already exists, this field lets you indicate if the current information overwritten or appended? |
| Exception Level | Optional, Exception Level lexicon available A ‘trace’ report of exception messages may be produced to assist in the testing phase. This field defines the exception level (report messages) required. |
| Report Filters | |
|---|---|
| People List | Optional, LOV Available This field is used to limit the report to the people lists indicated. |
| Person | Optional, LOV Available This field is used to limit the report to the persons indicated. |
The following values are used for ‘GOVT REGIST RULE’, if this is not set up, the default value ‘01’ is used.
| Null, 00 | Default (use Rule 01) |
| 01 | Across Multi Group and Multi EEM By federal registration across multiple groups and employments This rule means regardless if the employee has worked for multiple groups or employments, as long as the Group Federal Registration numbers are the same on IDGV, the YTD amounts are combined. |
| 02 | Across Multi Group, Each EEM By federal registration across multiple groups for one employment at a time This rule means if the employee has worked for multiple groups within one employment, as long as the Group Federal Registration numbers are the same on IDGV, the YTD amounts are combined. If the employee has worked for a different employment, each employment will be evaluated on its own. |
| 03 | Combine Group, Each EEM Combine federal registration for multiple groups for one employments at a time. This is same as Rule 02 except the groups are combined under each employment. |
| 04 | Combine All Always combine federal registration across multiple employments and groups. |
Govt Regist Rules#
Multiple Employments and Multiple Groups#
Each company must be registered with the federal government. The company may receive one or multiple Government Registration Numbers depending on the nature of their business.An employee may work for one or multiple employments that must be reported under one or multiple Government Registration Numbers. The following situations may occur:
- An employee may work for two or more different assignments (IEAS) that point to a different group (IDGR), the group may be reporting to a different Federal Registration Number
- An employee may change employments with a new Hire Date, the new assignment may point to a different group (IDGR) that is reporting to a different Federal Registration Number
- When determining if the employee is reaching the annual maximum for government tax calculation (e.g. US FICA / Medicare maximums, Canada CPP / EI maximums), each company may apply different rules depending on their business scenarios.
- When retrieving the Period To Date (PTD), Month To Date (MTD), Quarter To Date (QTD) or Year To Date (YTD) amounts, it also has to be determined if there are pays in the same time frame across multiple employments or multiple groups.
- The processing for multiple employments and groups are performed within one entity. If the employee is changing entities, then the entity will start its own YTD / QTD / MTD / PTD accumulation.
Employee Example#
An employee has two employments with the following Hire Dates and is being paid with different groups.- Employment (1) has been paid with one group
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Secretary | Fed#: 111122222 | PC 1000 Gross | $3000 |
- Employment (2) has been paid with three groups
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Teacher | Fed#: 111122222 | PC 1000 Gross | $1000 |
| Part-Time-Driver | Fed#: 999988888 | PC 1000 Gross | $5555 |
| Part-Time-Music | Fed#: 111122222 | PC 1000 Gross | $4000 |
The employee will be paid under one of these employments via IPPH with each pay header pointing to one employment.
Below are results of the YTD values derived depending on the IMST ‘GOVT REGIST RULE’ setting.
UPCALC - GOVT REGIST RULE = ‘01’ (Default Rule)#
- IMST - GOVT REGIST RULE = 01
- Across Multi Group and Multi EEM
- By Federal Registration across multiple groups and employments
- This rule means regardless if the employee has worked for multiple groups or multiple employments, as long as the Group Federal Registration Numbers are the same on IDGV, the YTD amounts are combined.
For the example above:
- This rule deals with multiple employments
- It does not matter how many employments or how many groups the employee is being paid in, the IDGV Fed# is used to combine YTD values.
- When paying for Employment (1)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Secretary | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 + $1000 + $4000 = $8000 |
- When paying for Employment (2)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Teacher | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 + $1000 + $4000 = $8000. |
| Part-Time-Driver | IDGV Fed# = 999988888 | PC 1000 | Gross YTD amount = $5555 |
| Part-Time-Music IDGV | Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 + $1000 + $4000 = $8000. |
- In most situations, for taxation purposes, the Annual Maximum of a Wage Base and Annual Maximum Deduction should be applied to an employee under the same Federal Registration Number. This ensures that the employee will not be over deducted when the employee has worked for multiple employments or assignments that belong to multiple groups with the same Federal Registration Number.
- Canada Taxation
- For Canada taxation, the CPP/QPP and EI annual maximum deductions are respected which will help to avoid the employee being over-deducted and the company will not over pay their Employer portion of CPP/QPP, EI.
For Federal / Provincial / Quebec tax calculation, the employee’s YTD amounts are combined together such that the employee’s annual taxable income reflects the total income of the employee for the year for that Federal Registration number. This will avoid the employee’s tax being under deducted when the employee is filing their income tax return.
- US Taxation
- For US taxation, the FICA, MEDI, FUTA annual maximum wage base and deductions are respected, all other annual maximum amounts are respected.
UPCALC - GOVT REGIST RULE = ‘02’#
- IMST - GOVT REGIST RULE = 02
- Across Multi Group, each EEM
- By Federal Registration across multiple groups for one employment at a time.
- This rule means if the employee has worked for multiple groups within one employment, as long as the group Federal Registration Numbers are the same on IDGV, the YTD amounts are combined.
- If the employee has worked for a different employment, each employment will be evaluated on its own.
For the example above:
- This rule deals with one employment at a time
- Depending on the group’s IDGVFed#, the YTD values are combined for the same Fed#
- When paying for Employment (1)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Secretary | IDGV Fed# = 111122222 | PC 1000 Gross YTD amount = $3000 |
- When paying for Employment (2)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Teacher | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $1000 + $4000 = $5000. |
| Part-Time-Driver | IDGV Fed# = 999988888 | PC 1000 | Gross YTD amount = $5555 |
| Part-Time-Music | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $1000 + $4000 = $5000. |
This is useful for when a new employment is treated as a company on its own and within each employment, the employee can work for different groups that can be reported by different registrations.
The following business scenario is an example of a company who does not need to combine employments for taxation purpose.
Example: A Service Bureau company may set up one Headquarter Entity on IDEN and use a group IDGR to identity many different Federal Registrations (EIN numbers). In this way, each group may actually represent one legal company registration with the government.
- An employee may work several months for a group at the beginning of a year (i.e. one company), then transfer to another group (i.e. another company). A new employment record is created for the second company with different Position/Job and Pay Scale etc. In this case, the legislative YTD maximums should be re-started when an employee is working for a new company.
- If the employee is terminated and rehired under the same employment (i.e. the employee may not be officially transferred), the YTD amounts will be accumulated or re-started according to the group Fed#.
UPCALC - GOVT REGIST RULE = ‘03’#
- IMST - GOVT REGIST RULE = 03
- Combine Group, each EEM
- Combine federal registration for multiple groups for one employment at a time.
- This is same as Rule 02 except the groups are combined under each employment.
For the example above:
- This rule deals with one employment at a time.
- Does not matter how many groups are being paid, all the group's YTD values are combined together.
- When paying for Employment (1)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Secretary | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 |
- When paying for Employment (2)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Teacher | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $1000 + $5555 + $4000 = $10555. |
| Part-Time-Driver | IDGV Fed# = 999988888 | PC 1000 | Gross YTD amount = $1000 + $5555 + $4000 = $10555. |
| Part-Time-Music | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $1000 + $5555 + $4000 = $10555. |
UPCALC - GOVT REGIST RULE = ‘04’#
- IMST - GOVT REGIST RULE = 04
- Combine all
- Always combine federal registration across multiple employments and groups
For the example above:
- This rule deals with multiple employments
- Does not matter how many employments or groups are being paid, the YTD values are combined together
- When paying for Employment (1)
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Secretary | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555. |
When paying for Employment (2) Hire Date: 01-Jan-2009
| Group | Federal Number | Pay Component | Amount |
|---|---|---|---|
| Part-Time-Teacher | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555. |
| Part-Time-Driver | IDGV Fed# = 999988888 | PC 1000 | Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555. |
| Part-Time-Music | IDGV Fed# = 111122222 | PC 1000 | Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555. |
This is when only reporting under one Federal Government Registrations for one entity.
UPCALC – Additional Scenarios#
- If an employee belongs to one group (e.g. Part-Time Secretary with IDGV = 11112222) and this employee is terminated, then later on the employee is rehired in the same taxation year into the same group, the employee’s YTD should be accumulated for taxation purpose.
- In this case, if the employee is rehired into the same employment, then Rule 01, 02, 03, 04 would accumulate the YTD.
- In this case, if the employee is rehired under a new employment, then Rule 01, 04 would accumulate the YDT.
When to Define a New Employment#
- At Site Level IMST, during installation time when defining rules for the Payroll system, how to start a new employment for employees should be defined.
- A new employment should be for a new Hire Date, then the employee will be set up for the assignments under this employment, each assignment will point to a group that reports to a Fed#.
- There must be an evaluation of how to report multiple groups by Fed# and how to report one or multiple employments.
- For most users, the default GOVT REGIST RULE 01 for taxation purpose should be used.
- For some common Payroll Masters, Service Bureau or Agencies, each entity on IDEN or each group on IDGR may represent a different company or a client of their own. Sometimes one employment of an employee may represent that this employee is working for a different company, therefore they must set up the IMST ‘GOVT REGIST RULE’ to handle the taxation according to their needs.
- The definition of a new employment, group, or entity is dependent upon the nature of the user's business.
- By default, UPCALC will accumulate and withhold according to the legislative requirement. If the client would like to switch the rule during one taxation year, the YTD amounts that have already been updated so far may not reflect the correct YTD amounts according to the rule. A manual YTD adjustment may need to be done.
- However, in most cases, at the end of the year when the employee is filing their income tax return, the employee will be refunded with any excess contribution.
- For the company portion contribution, the company may do manual YTD adjustment depending on if the company is over or under-contributed.
