Importing bonuses with payout date in bulk

Available for plans : Foundation, Growth, Strength.

Bonuses are usually paid over and above the salary to reward the employee for the good work they are doing or to mark the completion of an important milestone. While you can add bonuses to employees individually and also at a salary structure level, it maybe necessary to bulk import bonuses for a group of employees. You can do this on Keka using an excel template. 

Let us look at how you can do this. Navigate to Payroll from the left navigation pane. Select the Payroll Admin and then select the Operations tab.

Find the Payroll Imports section on this page and click on Import Bonuses with Payout Date

Here on the Import Employee Bonuses page, select a Pay Group from the drop-down if you have more than one pay group configured on your portal. Click on Download the Excel Template to get the Excel template with details of all the employees in the pay group you have selected. 

In the downloaded excel file, find the employees for whom you want to add bonuses. It is a good idea to delete all the other rows from the file and only keep the details of those employees for whom bonuses are being added. 

Select the bonus type from the drop-down in the excel sheet. Also add other details such as the Amount and the Payout Date. You can also choose a status to indicate whether the bonus is pending or already paid out. This will help you add bonuses that have been paid outside Keka Payroll as well and assign it to the employee for tax calculations. You can also add the date on which the bonus was paid. It is also recommended that you add a note to indicate what is the context in which the bonus was added to the employee. 

Once you have added the necessary details, save the file. On the Import Employee Bonuses page , click on Upload Excel File and select the saved file from your system. 

In the Match Columns section of the page, ensure that the columns on the excel file are mapped correctly to the fields on Keka. Click Continue to move to the Preview Data screen. Here, you can review the data that you're uploading from the excel file. You will also see if there are any errors in the file like missing data in mandatory fields or wrong data type being entered. If there are any errors, correct these in the excel file and then re-upload the file from the Upload Template section of the page.

If there are no errors, click Continue to finish uploading the file. Click Confirm in the confirmation window to complete the action. 

This will add the new bonuses you have added in the file to the respective employees. If they are pending to be paid out, these will be processed as a part of payroll for the selected month. 

If you have previously added a bonus for the employee with the same bonus type and payout date, the value in the Amount column will be updated as the pending bonus amount to be paid out on the selected date. 

More questions regarding adding bonuses in bulk? Talk to us and we will help you out