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
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]
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
5 What is Average Monthly Wage
6 How to determine Daily Salary? for Monthly, Daily, Hourly Rate Employees