This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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.

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:

1. 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
2. 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

Hire Date: 15-Aug-2005

Group	Federal Number	Pay Component	Amount
Part-Time-Secretary	Fed#: 111122222	PC 1000 Gross	$3000

Employment (2) has been paid with three groups

Hire Date: 01-Jan-2009

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 Multiple 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)

Hire Date

15-Aug-2005:

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)

Hire Date

01-Jan-2009:

Group	Federal Number	Pay Component	Amount
Part-Time-Teacher	IDGV Fed# = 111122222	PC 1000	Gross YTD amount = $3000 + $1000 + $4000 = $8000.

When paying for Employment (2) Hire Date: 01-Jan-2009

Group	Federal Number	Pay Component	Amount
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 Multiple 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) Hire Date: 15-Aug-2005

Group	Federal Number	Pay Component	Amount
Part-Time-Secretary	IDGV Fed# = 111122222	PC 1000 Gross YTD amount = $3000

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 = $1000 + $4000 = $5000.

When paying for Employment (2) Hire Date: 01-Jan-2009

Group	Federal Number	Pay Component	Amount
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 Groups YTD values are combined together

When paying for Employment (1) Hire Date: 15-Aug-2005, Group: Part-Time-Secretary IDGV Fed# = 111122222 PC 1000 Gross YTD amount = $3000

When paying for Employment (2) Hire Date: 01-Jan-2009

Group	Federal Number	Pay Component	Amount

Group: Part-Time-Teacher IDGV Fed# = 111122222 PC 1000 Gross YTD amount = $1000 + $5555 + $4000 = $10555.

When paying for Employment (2) Hire Date: 01-Jan-2009

Group	Federal Number	Pay Component	Amount
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) Hire Date: 15-Aug-2005, Group: 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: Part-Time-Teacher IDGV Fed# = 111122222 PC 1000 Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555.

When paying for Employment (2) Hire Date: 01-Jan-2009, Group: Part-Time-Driver IDGV Fed# = 999988888 PC 1000 Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555.

When paying for Employment (2) Hire Date: 01-Jan-2009, Group: Part-Time-Music IDGV Fed# = 111122222 PC 1000 Gross YTD amount = $3000 + $1000 + $5555 + $4000 = $13555.

This is useful for Companies who only report 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 YTD

---

When to Define a New Employment#

- at Site Level (IMST screen), during installation time when defining rules for the Payroll system, the user should define how they would start a new Employment for their employees

- 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#

- the user must evaluate how they should report multiple groups by Fed#, how to report one or multiple Employments

- most users should use the default GOVT REGIST RULE 01 for taxation purpose

- 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 this employee is working for a different Company, therefore they must set up IMST ‘GOVT REGIST RULE’ to handle the taxation according to their needs

- the definition of a new Employment, a new Group, or a new Entity is dependent upon the user’s nature of business

- by default, UPCALC will accumulate and withheld 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, the user may need to do manual YTD adjustment

- 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-contributed or under-contributed

---

Notes #

Click to create a new notes page