User Guide‎ > ‎

User Defined Formula

You can define User Defined Formula for 

e.g. 
  • [BasicSalary]  /  [DaysInMonth]  /  8
  • [BasicSalary] * 13 / [DaysInYear] / 9 * 1.5
  • [12MthsAverageDailyRate] / 8 / 60 * 2

1. Examples for OT Type
  • 150
  • [CurrentMonthHourlyRate]*1.5
  • [BasicSalary] / [DaysInMonth] / 8 * 1.5
  • [BasicSalary] * 13 / [DaysInYear] / 9 * 1.5

2. Examples for Late Deduction Type
  • 50
  • [BasicSalary] / 30 / 9 / 60 * 10

3. Examples for Final Payment for Annual Leave Balance based on
  • [12MthsAverageDailyRate]                                  (Recommended)
  • [BasicSalary]/[DaysInMonth]
  • [BasicSalary]/[WorkdaysInMonth]
  • [BasicSalary]/30

4. Examples for Auto Bonus 
  • [BonusAverageRegardedWages] 
  • [BonusLastBasicWages] 
  • [BonusAverageBasicWages]
  • ([BasicSalary]+[Allowance]) * 2
  • [BonusLastBasicWages] * [BonusEmploymentDays] / [BonusElapseDays]

The following characters/variables are acceptable in User Defined Formula

0-9   numbers
+ plus
- minus
*     multiply
/ divide
() brackets
[BasicSalary] Basic Salary1
[Allowance] Allowance 11
[Allowance2] Allowance 21
[CurrentMonthDailyRate] Current Month Daily Rate2
[CurrentMonthHourlyRate] Current Month Hourly Rate3
[12MthsAverageDailyRate] 12 Months Average Daily Rate
[HourlyRate1] Hourly Rate 1 for Salary by Hourly Employee in Employee Master
[HourlyRate2] Hourly Rate 2 for Salary by Hourly Employee in Employee Master
[HourlyRate3] Hourly Rate 3 for Salary by Hourly Employee in Employee Master
[HourlyRate4] Hourly Rate 4 for Salary by Hourly Employee in Employee Master
[HourlyRate5] Hourly Rate 5 for Salary by Hourly Employee in Employee Master
[HourlyRate6] Hourly Rate 6 for Salary by Hourly Employee in Employee Master
[DailyRate1] Daily Rate 1 for Salary by Daily Employee in Employee Master
[DailyRate2] Daily Rate 2 for Salary by Daily Employee in Employee Master
[DailyRate3] Daily Rate 3 for Salary by Daily Employee in Employee Master
[DailyRate4] Daily Rate 4 for Salary by Daily Employee in Employee Master
[DailyRate5] Daily Rate 5 for Salary by Daily Employee in Employee Master
[DailyRate6] Daily Rate 6 for Salary by Daily Employee in Employee Master
[PAY_TYPE1_AMT] to [PAY_TYPE15_AMT] Pay Type 1 to 15 Amount in Employee Master
[User06] User Defined Field 6 in Employee Master
[User07] User Defined Field 7 in Employee Master
[User08] User Defined Field 8 in Employee Master
[User09] User Defined Field 9 in Employee Master
[User10] User Defined Field 10 in Employee Master
[DaysInMonth] Number of Days of Current Month    
[DaysInPreviousMonth] Number of Days of Previous Month    
[DaysInYear] Number of Days of Current Year (consider leap year)    
[WorkdaysInMonth] Number of Working Days of Current Month 4
[BonusAverageRegardedWages] Using the statutory Average Monthly Wage5 to calculate the bonus. The Regarded Month is based on  Auto Bonus Cover Period.
[BonusLastBasicWages] Read the Basic Salary in Salary Info or Appointment History1. If it is considered Appointment History, it read the Last Salary before the End of Bonus Cover Period.
[BonusAverageBasicWages] Read all Basic Salary figures in Position History tab within the Auto Bonus Cover Period, average and return the result.
[BonusEmploymentDays]Number of Employment Days within the Cover Period
[BonusElapseDays]Number of Calendar Days within the Cover Period (usually it is 365 except when the Bonus Cover Period covered Feb 29 of leap year, then it is 366)



1Depending on the settings Payroll Considers Appointment History
2Depending on the settings Daily Salary based on