AutoCount Payroll
- Meal Allowance (RM 5 per day) with Import Time Attendance
- Meal Allowance (RM 5 per day) without Import Time Attendance
- Attendance Allowance (RM 200 or Zero) with Import Time Attendance
- Attendance Allowance (RM 200, ANY Leave = Zero) without Import Time Attendance
- Attendance Allowance (RM 200, RM 100, Zero) with Import Time Attendance
- Attendance Allowance (RM 200, RM 100, Zero) without Import Time Attendance
Million Payroll
* Late calculate by time, example below late 15min = count 1.
| Description | Million Payroll Formula |
|---|---|
| 1. Meal Allowance (RM 5 per day) | AW * DAY_WORK |
| 2. Attendance Allowance (RM 200 or Zero) | IIF(PAY_LEAVE + NPAY_LEAVE + LATE_HR = 0, AW, 0) |
| 3. Attendance Allowance No Leave & No Late = RM 200, Leave 1 day / Late < 15 min = RM 100, Leave >= 2 day / Late >= 15min = Zero. | IIF(PAY_LEAVE + NPAY_LEAVE + LATE_HR = 0, AW, IIF((PAY_LEAVE + NPAY_LEAVE = 1 AND LATE_HR = 0) OR (PAY_LEAVE + NPAY_LEAVE = 0 AND LATE_HR < 0.25), AW/2, 0)) |