Skip to content
English
  • There are no suggestions because the search field is empty.

How to bulk update payroll items in step 1

You can save time during payroll runs by updating employee additions, deductions, and overtime in bulk using an Excel spreadsheet.

Step 1: Download the Bulk Update Template

  1. While running payroll, click the Bulk update button. This opens the Update payroll items in bulk panel.
     
    Screenshot 2026-11-18 at 5.21.12 PM
     

    Screenshot 2026-11-18 at 5.24.35 PM
     

  2. Click Download to save the Excel template to your computer. 
  3. The file automatically includes all employees selected in Step 1 of your payroll run, along with any existing values already entered.
     

Note: 

  1. The bulk update panel stays open across page refreshes for all admins until someone closes it by clicking the X icon

  2. Your downloaded file will be named based on the payroll type and pay period (e.g., bulk_payroll_items_monthly_01112026-30112026.xlsx).

 

Step 2: Fill Out the Excel Spreadsheet

Open the downloaded Excel file. You will see two tabs: Instructions (a locked reference guide) and Payroll items (where you enter your data).

What You Can Edit
  • Additions, Deductions, and Overtime: Enter amounts or units (hours/days) under the corresponding columns configured in Payroll > Settings > Payroll items.
  • Salary to Pay (Ad hoc payroll only): Enter the amount you wish to pay, up to the employee's Remaining amount. (Note: This field is locked for Monthly and Mid-month payrolls).
  • No. of Units (Non-monthly employees only): Enter the number of weeks, days, or hours worked for weekly, daily, or hourly employees.
What You Cannot Edit (Locked or Excluded)
  • Employee Details & Basic Salary: Employee names, departments, and basic salaries are locked and cannot be changed in the file.
  • System-Synced Items: Reimbursements submitted from Claims, overtime imported from Time, and Statutory deductions are excluded from the spreadsheet and can only be viewed or managed directly in the payroll table.
Formatting & Entry Rules
  • Numbers only: Only enter numeric values. Entering plain text will trigger an error or be ignored.
  • Zero values: Any item left at 0 will not be imported into the payroll table.
  • Rounding: Values automatically round to the appropriate decimal places based on your country and unit type (e.g., 2 decimal places for SGD/MYR currency, whole numbers for TWD, and up to 4 decimal places for units).
     

Step 3: Upload the Completed File

  1. Return to the Update payroll items in bulk panel in your payroll run.
  2. Click Upload and select your saved Excel file.
  3. Wait for the upload confirmation message. Once successful, the payroll table will automatically update with your new figures. (Note: Upload status messages are temporary and disappear once you refresh the page).
     
    upload1
     
    upload2
     

Troubleshooting Upload Errors

If your file fails to upload, an error banner will indicate what went wrong:

Error Message Cause How to Fix
"Please upload a correct file for [Payroll Type] payroll ([Month Year])." You uploaded a file meant for a different pay period or payroll type (e.g., uploading a Monthly file into an Ad hoc run). Download and use the template specifically from your current payroll run.
"There is an invalid value in the file. Please upload it again." A cell contains non-numeric text, or the Salary to pay exceeds the Remaining amount. Check the specific Row and Column listed in the error banner, fix the value, and re-upload.
"[Payroll item name] does not exist / is missing in the file..." A payroll item was added, deleted, or edited in Payroll Settings after you downloaded the template. Download a fresh template to sync the latest payroll item settings, re-enter your data, and upload again.