**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)