Multiple Assignment Processing for Social Insurance and Taxation

Oracle Payroll for the Netherlands enables you to carry out multiple assignment processing for both Social Insurance and Taxation, enabling processing to take place for employees who have more than one assignment within a payroll.

Multiple Assignment Processing with Social Insurance

Social Insurance Aggregation

Oracle Payroll aggregates Social Insurance in the order of Primary Assignment, followed by Secondary Assignments in order of Assignment ID. If the payroll is the same, the application ensures the total SI days used for the assignments processed so far does not exceed the maximum SI days for the current assignment being processed. Assignments process in sequence, with the SI days totalled as each assignment is processed. This system determines the number of SI days available for the next assignment. The Threshold and Max SI Salary are also calculated, with the values not used carried over to subsequent assignments.

Examples of Multiple Assignment Processing in Social Insurance

Processing the first assignment.

Using Oracle Payroll to process multiple assignments enables you to carry over the Threshold and the Max SI Salary values not used in the first assignment, over to the next one. In this example in the table below, the SI Income (1000) is subtracted from the Total Threshold (1500) and the Max SI Salary (3000). This results in values not used - Threshold (500) and Max SI Salary (2000). These values carry over to Assignment 2, and are added to the Total Threshold and Max SI Salary, where the same deductions as in Assignment 1 take place.

Assignment 1:

Values Amount
   
SI Income 1000
SI Days 15
Threshold/day 100
Max Day Salary 200
Total Threshold (Threshold/day*SI Days) 100 * 15 = 1500
Max SI Salary (Max Day Salary * SI Days) 200 * 15 = 3000
SI Base (minimum of SI Income and Max SI Salary) 1000
Actual SI Base (SI Base - Threshold) 0
Threshold not used 500
Max SI Salary not used 2000

Subtract the SI days used for the first assignment from the maximum SI days derived for the second assignment. This provides the available SI days for the second assignment. Carry any remaining threshold or maximum SI salary from previous assignments to the next assignment. See the table below.

Assignment 2:

Values Amount
   
SI Income 1500
SI Days 5
Threshold/day 100
Max Day Salary 200
Total Threshold (plus the amount not used in assignment 1) (100 * 5) + 500 = 1000
Max SI Salary (plus the amount not used in assignment 1) (200 * 5) + 2000 = 3000
SI Base (minimum of SI Income and Max SI Salary) 1500
Actual SI Base (SI Base - Threshold) 500
Threshold not used 0
Max SI Salary not used 1500

Continue the same process from Assignment 2, until there are no more SI days available. See the table below.

Assignment 3:

Values Amount
   
SI Income 2000
SI Days 0
Threshold/day 100
Max Day Salary 200
Total Threshold (plus the amount not used in assignment 2) (100 * 0) + 0 = 0
Max SI Salary (plus the amount not used in assignment 2) (200 * 0) + 1500 = 1500
SI Base (minimum of SI Income and Max SI Salary) 1500
Actual SI Base (SI Base - Threshold) 1500
Threshold not used 0
Max SI Salary not used 0

Multiple Assignment Processing with Taxation

Note: If an employee has multiple assignments with differing tax codes it is likely that aggregation of those assignments will return incorrect values. Multiple assignments affect the automatic calculation for previous years taxable income, meaning you must enter manual override values in such situations.

Taxation Aggregation

Processing Student Taxation
Processing the Beneficial Rule

IZA Private Health Insurance Multiple Assignment Processing

Ensuring Reporting Information is Correct When You Adjust Multiple Assignments with the Same Employer.

This table explains what happens when:

IZA Multiple Assignments

Corrective Action Effect on First Assignment Effect on Second Assignment Effect at Person Level
Correct the second assignment to counter the adjustment made to the first. The income and contribution of the first assignment higher than it should be. The income and contribution of the second assignment lower than it should be. The total income and contributions will be correct for both assignments at the person level, therefore correct for IZA reporting.

Note: For multiple assignments with different employers, it is the users responsibility to add the income from the 'non paying' assignment to the income balances of the assignment, where the IZA contribution is to be calculated.