Calculated Salary Special Routine (CSLR)

The Calculated Salary Special Routine supports the ability to calculate deductions as a percentage of an employee's calculated salary. This special routine utilizes the monthly calculated salary to determine the employee’s salary instead of their base salary. This special routine uses the following fields:

Amount/Percent 1 is the multiplication factor, with default value of 1.
Amount/Percent 2 is the maximum calculated salary amount considered, with a default of no maximum amount.
Amount/Percent 3 is the exemption amount subtracted from the Calculated Salary for deduction calculations, with a default value of 0.
Calculated Salary Basis specifies a number that is used to divide the calculated annual salary that is initially returned by the Special Routine, determining pay for each period.

Note: This functionality is only available when utilizing the Next Generation Payroll service.
Example:
Deduction Plan Configuration

From: 01/01/2024
To: 12/31/9999
Deduction Plan: CLSR
Include / Exclude Pay ID: Include with Calculated Salary
Deduction Rate: 0.05
Special Routine ID: Calculated Salary Special Routine
Amount/Percent 1: 2 (multiplication factor)
Amount/Percent 2: $ 180000 (maximum calculated salary)
Amount/Percent 3: 20000 (exemption amount)
Calculated Salary Basis: 24

Include/Exclude Deduction Categories (DPDC) Configuration

From: 01/01/2024
To: 12/31/9999
Deduction Type: CLSR
Deduction Plan: CLSR
Deduction Category: BILGL

A semi-monthly employee has the following Pay Details:

Employee’s semi-monthly base salary = $4,000
Employee has one base rate bonus = 20%
Employee has one other base rate bonus = $200
Employee has one non base rate bonus BILGL = $25
Semi-Monthly Calculated Salary (Base Salary + Base Rate Bonus + Other base Rate Bonus) = (4000*1.2 + 200) = $5,000

The employee’s Annualized Salary is (5000*24) = $120000

Calculation for a Deduction within a pay period will be as follows:

Multiply salary by Amount/Percent 1: 120,000 X 2 = $240,000
Compare step 1 output to Amount/Percent 2: 180000, use $180,000.
Subtract Amount/Percent 3: 180,000 – 20000 = $160,000
Weight based on Calc Salary Factor: 160,000/24 = $6666.67 (rounded to nearest cent)
Add eligible pay in included categories to Calculated Salary: 6666.67 + 25 = $ 6691.67
Multiply new salary amount by deduction rate: 6691.67*0.05 = $334.58