Skip to main content
All CollectionsPayroll (SG)
Formulated Pay Item Guidance
Formulated Pay Item Guidance
StaffAny avatar
Written by StaffAny
Updated over 3 months ago

Contents of this article are applicable to the following users

Tier: N/A

Platform: Web

This guide will cover the following:


Formula Elements

You can refer to the full list of supported formulas here. Some of the elements that should be included in this formula:

  1. Functions
    We currently support functions that are listed in Formula.JS

  2. Variables

    1. Timesheet Summary
      These variables are taken from the accumulations of staff timesheets of a certain period such as Late Shift, Days Worked, & Overtime Hours.

    2. 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.

    3. 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)

Did this answer your question?