Types Of Payroll Columns

This section will explain different types of payroll columns.

Predefined Calculations Columns #

Predefined calculations are used to get information from other modules like attendance, and leave for payroll calculations. In the previous section, we create a predefined calculation column to get an employee’s department name. In this section let us create a payroll column to get the total number of hours an employee has worked for a particular month.

Advanced Calculation Columns #

You can use advanced calculation columns when you have a complex payroll calculation. In advanced calculation columns, you can add a JavaScript function that will do the calculation for you. For this example, we will create a simple JavaScript function that deducts 10% of your basic salary, if your basic salary is greater than 100,000. (Note that in these payroll examples, the currency we have used is LKR)

Since we need the basic salary for this calculation, I have added it as a variable in this column.

The JavaScript function used in the above payroll column:

function taxCalculation(salary){
	if(salary >100000){
    	return salary*0.1;
    }else{
    	return 0;
    }
}

taxCalculation(salary);

Saved Calculations #

You can perform similar calculations using the Saved Calculations feature as well. But we recommend you use the advanced calculation feature for complex calculations. Let us see how we can implement the same example we used for advanced calculation in saved calculations.

Go to saved calculations and follow the below steps:

Now that you have added the saved calculation, go to payroll columns, create a payroll column and select the relevant saved calculation.

Now let us the predefined calculation column and the advanced calculation column for the payroll report. Go to the Payroll Reports tab.

Now save the payroll report and process it.

This is what the processed payroll report looks like: