The Formula Editor is flexible enough to adapt to your payroll needs and allows you to make your own formula for each item in a payslip. The Formula Editor also enables you to connect your payroll with Attendance and Leave.

This video gives you an overview of the Formula Editor.

The Formula Editor is flexible enough to adapt to your payroll needs and allows you to make your own formula for each item in a payslip. The Formula Editor also enables you to connect your payroll with Attendance and Leave.

Overview

Let me give you an overview of the Formula Editor. You can either type in a formula in the Formula Box, or you can double click any of the variables to bring it to the Formula Box.

Creating a new salary head

Formula Items

The Formula Items include:

Variables Pre-defined

Salary Heads selected to form the Salary Group

Variables from the Attendance Module

Variables from the Leave Module

Basic Mathematical operators

Pre-defined functions and Conditional Operators

[Rate Per Hour] and [Rate Per Day]

[Rate Per Hour] and [Rate Per Day] are defined in the Salary Card of the employee.

[Night Shifts Planned]

Night Shifts Planned is the count of shifts assigned to the employee that overlap midnight.

[Months of Service]

Months of service is calculated from the Date of Joining until today.

[Days Worked]

Days worked is the number of days worked as per attendance or the value of the Salary Head as specified in the Salary Settings.

[Employer Workdays]

Employer Workdays is defined as you create a Salary Period.

[Days in Period]

Days in Period is the exact number of days in the Salary Period.

[Planned Work Days]

Planned Work Days is the number of days the employee is planned to work.

[Planned Work Hours]

Planned Work Hours is the number of hours the employee is planned to work.

[Number of Day Offs]

Number of Day Offs gives you the number of Day Offs for the employee in the salary period.

[Days without plan]

Days without plan gives you the number of days where no plan is defined.

[Night Shifts Worked]

The count of shifts actually worked where the employee work time overlap midnight.

[Value]

Value as defined in the Salary Card.

When you define formula for a Salary Head, you can use all other Salary Heads which are placed above in the Salary Group. You won’t be able to use the Salary Heads which are placed under the selected Salary Head, as the calculation is always done from top to bottom of the Salary Group.

The Attendance Type values are calculated for the Salary Period.

The leave balances are calculated based on the Leave Entilements and leaves taken during the Salary Period.

Switch on the Slab to apply the result of the formula on a pre-defined slab.

You can even write IFF blocks to manage complex needs.

The formula editor allows you to configure your payroll with ease, no matter how complicated your payroll is!

Frequently Asked Questions

The Formula Editor will only list Salary Heads that can be used in the formula. When you define formula for a Salary Head, you can use all other Salary Heads which are placed above in the Salary Group. You won’t be able to use the Salary Heads which are placed under the selected Salary Head, as the calculation is always done from top to bottom of the Salary Group.