In version 1.1.6, we have added two new columns: “Hourly Rate” and “Total Hourly Pay”

Purpose:

The “Hourly Rate” column is used to automatically display the employee’s hourly wage in the Payslip. This value is pulled directly from the employee profile (integrated with HR Records or from the Staff screen in Setup).

The “Total Hourly Pay” column is used to automatically calculate the total hourly payment based on the employee’s actual working hours:

Total Hourly Pay = Hourly Rate × Actual Working Time

➡️ With these two options, when generating a payslip, the hourly wage will be auto-filled, and the total hourly pay will be automatically calculated without the need for manual entry.

How it works:

When using version 1.1.6, select Upgrade Database. The system will automatically display the “Hourly Rate” and “Total Hourly Pay” columns in the Payroll Columns screen.

Next, ensure that each employee has an Hourly Rate entered in their profile, and that Actual Working Time data is available.

You can then create a Payslip Template, select the “Hourly Rate” and “Total Hourly Pay” columns, along with any other related columns.

These two columns pull data automatically from the system, so you do not need to set any formulas or manually enter values for them.

Once the Payslip Template is ready, proceed to generate a Payslip to verify the values.