Contents of this article are applicable to the following users
Tier: N/A
Platform: Web
Access Level: Owner
This guide will cover the following:
Use case Example
Formula Elements
You can refer to the full list of supported formulas here. Some of the elements that should be included in this formula:
Functions
We currently support functions that are listed in Formula.JSVariables
Timesheet Summary
These variables are taken from the accumulations of staff timesheets of a certain period such as Late Shift, Days Worked, & Overtime Hours.Custom Timesheet Column
These variables are taken from the custom timesheet that is listed in the Settings > Timesheet Export Format. Learn how to make a custom timesheet column.Wage Detail
These variables are taken from staff’s wage setup information such as Overtime Rate, Basic Rate, & Pay Cycle.
Formula Format
To ensure that the formula format is correct and working fine, please note the following format requirements:
All functions (e.g., IF) must be in capital letters.
Equals signs should be in double (==).
Use double quotation marks (“...”) to differentiate text.
Use square brackets ( [ ] ) to denote variable data from your timesheets.
For Example:
Use Case Example
Monthly Overtime
Monthly overtime with a fixed monthly limit
If you have a calculation that gives overtime pay to staff that has already exceeded a certain monthly paid hours limit:
Formula:
MAX([Total Paid Hours] - 198, 0) * [Overtime Rate]
Explanation:
If total paid hours exceed the 198-hour monthly limit, they will be multiplied by the overtime rate. If total paid hours are below the limit, no overtime is applied.
Note: If you have a different fixed limit for some staff, create another pay item.
Monthly overtime limit based on the working days & daily overtime limit
If you have a monthly overtime limit that is based on the month’s working days and daily overtime limit:
Formula:
MAX( [Total Paid Hours] - [Working Day] * [Contract Hours (Day)], 0 ) * [Overtime Rate]
Explanation:
If total paid hours exceed the base calculation of working days and daily overtime limit, they will be multiplied by the overtime rate. If total paid hours are below the limit, no overtime is applied.
Note: Please make sure to set up the Daily Overtime Limit in the Staff’s profile.
Monthly overtime limit based on the working days & weekly overtime limit
If you have a monthly overtime limit that is based on the month’s working days and weekly overtime limit:
Formula:
MAX([Total Paid Hours] - ([Working Day]*[Contract Hours (Week)]/[Working Days Per Week]), 0) * [Overtime Rate]
Explanation:
If total paid hours exceed the base calculation of working days and weekly overtime limit, they will be multiplied by the overtime rate. If total paid hours are below the limit, no overtime is applied.
Note: Please make sure to set up the Daily Overtime Limit in the Staff’s profile.
Lateness Deduction
If you have a deduction if in a month staff is late more than 5 times or 45 minutes in total:
Formula:
IF(OR([Late Shifts] >= 5, [Late In Hours] >= 45/60), 10000, 0)
Explanation:
If the total late shift in a month >= 5 times or there’s late >= 45 mins in a shift. Deduct by Rp. 10,000 (depending on the currency)