User Defined Formula

You can define User Defined Formula for 

• • Other Pay Type Amount for Regular Payment in Employee Master, Salary Info tab 

  • Other Pay Type Amount for Regular Payment in Employee Class

  • Rate Factor based on for OT Type

  • Rate Factor based on for Late Deduction Type 

  • Final Payment for Annual Leave Balance Daily Rate in Payroll Module Setup, Payroll tab

  • Payment in Lieu of Notice Daily Rate in Payroll Module Setup, Payroll tab

  • Referral Bonus in  Payroll Module Setup, Payroll tab

  • Attendance Allowance in Global Working Hours / Shift Code 

  • No Pay Leave Rate Formula in Employee Class

  • Auto Bonus Formula in Employee Class

  • Annual Leave Daily Rate Formula in Employee Class

  • Final Payment for Annual Leave Balance Daily Rate in Employee Class

e.g. 

• • [BasicSalary]  /  [DaysInMonth]  /  8

  • [BasicSalary] * 13 / [DaysInYear] / 9 * 1.5

  • [12MthsAverageDailyRate] / 8 / 60 * 2

1. Examples for Regular Payments in Employee Master or Employee Class

• • Working years Subsidy: IIF([YearsOfService]>=4,400,IIF([YearsOfService]>=3,300,IIF([YearsOfService]>=2,200,IIF([YearsOfService]>=1,100,0))))

  • Mid-Month Prepaid Allowance: IIF([IsMidMonthPayroll], 2000, 0)

  • Service-End Gratuities: IIF([IsFinalPayment], 20000,0)

  • Probation-End Bonus: IIF([IsProbationEndPayment], 500,0)

  • Travel Allowance (prorata on Join and Termination period): 1000 * [ProratedFactor]

  • Travel Allowance (prorata on Join and Termination period, consider No Pay Leave Deduction ): 1000*[ProratedFactor]-1000/[DaysInMonth]*[NoPayLeaveDays]

  • Bonus after Probation: IIF([IsProbationPayment], 0,1000)

  • Attendance Bonus / Monthly Attendance Allowance: IIF([IsFullAttendance],800,0)

  • Attendance Bonus / Monthly Attendance Allowance (prorata on Join and Termination period): IIF([IsFullAttendance],800,0) * [ProratedFactor]

  • Contract End Bonus: IIF([IsContractEndPayment],[BasicSalary],0)

  • Per Job wages (assumed With Unit Rate is turned on for this Pay Type) : UnitRate: 500 

  • Birthday Bonus: IIF([IsBirthdayMonth],500,0)

  • Statutory Holiday Overtime Allowance: [OTDays4] * 50

2. Examples for Rate Factor in OT Type

• • 150

  • [CurrentMonthHourlyRate]*1.5

  • [CurrentMonthDailyRate] / 8

  • [BasicSalary] * 13 / [DaysInYear] / 9 * 1.5

  • IIF([CurrentMonthHourlyRate]*1.5>80,[CurrentMonthHourlyRate]*1.5,80)

3. Examples for Rate Factor in Late Deduction Type

• • 50

  • [BasicSalary] / 30 / 9 / 60 * 10

4. Examples for Final Payment for Annual Leave Balance based on

• • [12MthsAverageDailyRate]                                  (Statutory)

  • [AnnualLeaveDailyWages]

  • [CurrentMonthDailyRate]

  • [BasicSalary]/[DaysInMonth]

  • [BasicSalary]/[WorkdaysInMonth]

  • [BasicSalary]/30

  • IIF([IsEAO2007], [12MthsAverageDailyRate], [CurrentMonthDailyRate])

5. Examples for Payment in Lieu of Notice Daily Rate

• • [12MthsAverageDailyRate]                                  (Statutory)

  • [CurrentMonthDailyRate]

  • [BasicSalary]/[DaysInMonth]

  • [BasicSalary]/[WorkdaysInMonth]

  • [BasicSalary]/30

6. Examples for Auto Bonus 

• • [BonusAverageRegardedWages] 

  • [BonusLastBasicWages] 

  • [BonusAverageBasicWages]

  • ([BasicSalary]+[Allowance]) * 2

  • [BonusLastBasicWages] * [BonusEmploymentDays] / [BonusElapseDays]

The following characters/variables are acceptable in User Defined Formula

Internal 

Numeric Variables (Wage related)

Numeric Variables (Statistical Information)

Numeric Variables (Bonus related)

Boolean Variables (for boolean_expression in IIF)

Keyword

1 Depending on the settings Payroll Considers Appointment History

2 Depending on the settings Daily Salary based on and works for Monthly, Daily, Hourly Rate Employees

3 Depending on the settings Daily Salary based on and How to calculate Hourly Rate from Daily Rate

4 "Working Days" definition

5 What is Average Monthly Wage

6 How to determine Daily Salary? for Monthly, Daily, Hourly Rate Employees

7 How to enable USD Employee Salary Package