Bulk Upload Pay Items in Payroll Table

In cases where you need to update multiple pay items at once for employees, using the bulk upload feature in the payroll table can save time. This feature allows you to download a pre-formatted template, input the required pay information, and upload it back into the system. Follow the steps below for a smooth process:

1. In your draft payroll, locate and click the UPLOAD PAY ITEM button.

2. Select the specific pay items you want to upload, then click DOWNLOAD TEMPLATE to receive an Excel file.

3. Open the Excel Template and input all necessary details, ensuring the format is followed correctly. Once completed, save the file.

4. Click on the Drop files to upload area and select your saved template, then click IMPORT.

5. After importing, the system will show the status of the upload on the Summary page. 

6. Once the upload is completed, refresh the draft payroll to view the imported data. You can now review the entries and proceed with further payroll processing.

Additional Notes: 

• This feature is applicable to Variable Pay Items only. 
• Available for accounts in Singapore, Malaysia, Thailand, Indonesia and Hong Kong. 
• Employee name and NRIC are mandatory fields. 
• Only employees selected in the draft payroll will appear in the template. Avoid manually adding new employees in the template if they haven't been included in the payroll.
• Ensure that the Excel template contains no formulas—only enter the actual amounts.