Importing financial information in bulk

Financial information of the employees need to be kept updated regularly to ensure that the salary payment is done by the preferred mode and credited to the right account. It is also necessary to keep the statutory component details updated so that you're not missing out on compliance. 

Keeping track of all individual updates can be difficult in many cases. Updating the financial information in bulk is an option that is available on Keka to ensure that the financial information on the system is always up-to-date. 

To bulk update financial information, 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 Financial Information. 

On the Import Financial Details page, select the Pay Group if you have multiple pay groups configured.

Download the Excel template from this window. 

Edit the Excel template to include the updated financial information of the employees for which you want to update. Delete all rows in the excel file except those corresponding to the employees for whom you are updating the financial information.

On this file, you can update details including PAN information, Salary Payment Mode, Bank Information, and information about the statutory components like PF, ESI, LWF, Professional Tax, as well as Aadhar information.

Enter the information as per your need for the employees you choose.

Save the file and upload it using the Upload Excel File button on the Import Financial Details page. 

In the Match Columns section of the page, make sure that the columns on Excel are mapped correctly to the fields on Keka. Click Continue to preview the data you have uploaded here. You will see if there are any errors in the file that you have updated. Go back to the Excel file and correct any errors that you can find on the Preview Data screen. Once you are done, click Complete to finalize the upload. 

This will update the financial information of the selected employees. More questions regarding importing employee financial information in bulk? Get in touch with our product experts for help!

Please let us know if you find this article helpful.