---
title: How to bulk update payroll items
description: bulk update payroll items
---

[Skip to content](https://help.swingvy.com/knowledge/how-to-bulk-upload-payroll-items#main-content)

English

Show submenu for translations

[Submit a request](https://help.swingvy.com/knowledge/kb-tickets/new?hsLang=en)

[![Swingvy logo.svg](https://help.swingvy.com/hubfs/Frame%20927-3.svg)](https://help.swingvy.com/?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Submit a request](https://help.swingvy.com/knowledge/kb-tickets/new)
- [Swingvy website](https://www.swingvy.com/)

[Swingvy website](https://www.swingvy.com/)

 Hello, how can we help you? 😊

- There are no suggestions because the search field is empty.

1. [Swingvy | Help Center](https://help.swingvy.com/knowledge?hsLang=en)
2. [Payroll Malaysia](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en)
3. [For payroll manager](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#for-payroll-manager)

# How to bulk update payroll items

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](https://help.swingvy.com/hs-fs/hubfs/Screenshot%202026-11-18%20at%205.21.12%20PM.png?width=670&height=217&name=Screenshot%202026-11-18%20at%205.21.12%20PM.png)*  
    
   
   ![Screenshot 2026-11-18 at 5.24.35 PM](https://help.swingvy.com/hs-fs/hubfs/Screenshot%202026-11-18%20at%205.24.35%20PM.png?width=670&height=307&name=Screenshot%202026-11-18%20at%205.24.35%20PM.png)
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](https://help.swingvy.com/hs-fs/hubfs/upload1.png?width=670&height=132&name=upload1.png)  
      
   ![upload2](https://help.swingvy.com/hs-fs/hubfs/upload2.png?width=670&height=142&name=upload2.png)*

#### 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. |

- [Swingvy introduction](https://help.swingvy.com/knowledge/swingvy-introduction?hsLang=en#main-content)

    - [Introduction to Swingvy](https://help.swingvy.com/knowledge/swingvy-introduction?hsLang=en#introduction-to-swingvy)
- [Get started with Swingvy](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#main-content)

    - [HR Hub](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#hr-hub)
    - [Time](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#time)
    - [Leave](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#leave)
    - [Claims](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#claims)
    - [Malaysia Payroll](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#malaysia-payroll)
    - [Singapore Payroll](https://help.swingvy.com/knowledge/get-started-with-swingvy?hsLang=en#singapore-payroll)
- [HR Hub](https://help.swingvy.com/knowledge/hr-hub?hsLang=en#main-content)

    - [People](https://help.swingvy.com/knowledge/hr-hub?hsLang=en#people)
    - [News](https://help.swingvy.com/knowledge/hr-hub?hsLang=en#news)
    - [Calendar](https://help.swingvy.com/knowledge/hr-hub?hsLang=en#calendar)
    - [Report](https://help.swingvy.com/knowledge/hr-hub?hsLang=en#report)
    - [Security](https://help.swingvy.com/knowledge/hr-hub?hsLang=en#security)
- [Time](https://help.swingvy.com/knowledge/time?hsLang=en#main-content)

    - [Basic setup](https://help.swingvy.com/knowledge/time?hsLang=en#basic-setup)
    - [For time manager](https://help.swingvy.com/knowledge/time?hsLang=en#for-time-manager)
- [Leave](https://help.swingvy.com/knowledge/leave?hsLang=en#main-content)

    - [Basic setup](https://help.swingvy.com/knowledge/leave?hsLang=en#basic-setup)
    - [For leave manager](https://help.swingvy.com/knowledge/leave?hsLang=en#for-leave-manager)
    - [For leave approver](https://help.swingvy.com/knowledge/leave?hsLang=en#for-leave-approver)
    - [Employee guide](https://help.swingvy.com/knowledge/leave?hsLang=en#employee-guide)
- [Claims](https://help.swingvy.com/knowledge/claims?hsLang=en#main-content)

    - [Basic setup](https://help.swingvy.com/knowledge/claims?hsLang=en#basic-setup)
    - [For claims manager](https://help.swingvy.com/knowledge/claims?hsLang=en#for-claims-manager)
    - [For claim approver](https://help.swingvy.com/knowledge/claims?hsLang=en#for-claim-approver)
- [Payroll Malaysia](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#main-content)

    - [Basic setup](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#basic-setup)
    - [For payroll manager](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#for-payroll-manager)
    - [General information](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#general-information)
    - [Supported bank files](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#supported-bank-files)
    - [Year-end tax](https://help.swingvy.com/knowledge/payroll-malaysia?hsLang=en#year-end-tax)
- [Payroll Singapore](https://help.swingvy.com/knowledge/payroll-singapore?hsLang=en#main-content)

    - [Basic setup](https://help.swingvy.com/knowledge/payroll-singapore?hsLang=en#basic-setup)
    - [For payroll manager](https://help.swingvy.com/knowledge/payroll-singapore?hsLang=en#for-payroll-manager)
    - [General information](https://help.swingvy.com/knowledge/payroll-singapore?hsLang=en#general-information)
    - [Supported bank files](https://help.swingvy.com/knowledge/payroll-singapore?hsLang=en#supported-bank-files)
    - [Year-end tax](https://help.swingvy.com/knowledge/payroll-singapore?hsLang=en#year-end-tax)
- [Mobile Apps](https://help.swingvy.com/knowledge/mobile-apps?hsLang=en#main-content)

    - [General information](https://help.swingvy.com/knowledge/mobile-apps?hsLang=en#general-information)
    - [Employee guide](https://help.swingvy.com/knowledge/mobile-apps?hsLang=en#employee-guide)
- [Performance](https://help.swingvy.com/knowledge/performance?hsLang=en#main-content)

    - [Basic setup](https://help.swingvy.com/knowledge/performance?hsLang=en#basic-setup)
    - [For performance manager](https://help.swingvy.com/knowledge/performance?hsLang=en#for-performance-manager)
- [Integrations](https://help.swingvy.com/knowledge/integrations?hsLang=en#main-content)

    - [Calendar Integration](https://help.swingvy.com/knowledge/integrations?hsLang=en#calendar-integration)
    - [Xero Accounting Software](https://help.swingvy.com/knowledge/integrations?hsLang=en#xero-accounting-software)
    - [StaffAny Rostering & Time tracking](https://help.swingvy.com/knowledge/integrations?hsLang=en#staffany-rostering-time-tracking)
- [Account and Billing](https://help.swingvy.com/knowledge/account-and-billing?hsLang=en#main-content)

    - [Account](https://help.swingvy.com/knowledge/account-and-billing?hsLang=en#account)
    - [Billing](https://help.swingvy.com/knowledge/account-and-billing?hsLang=en#billing)
- [Settings](https://help.swingvy.com/knowledge/settings?hsLang=en#main-content)

    - [Company settings](https://help.swingvy.com/knowledge/settings?hsLang=en#company-settings)
    - [Custom fields](https://help.swingvy.com/knowledge/settings?hsLang=en#custom-fields)
    - [Work group](https://help.swingvy.com/knowledge/settings?hsLang=en#work-group)
    - [Holiday](https://help.swingvy.com/knowledge/settings?hsLang=en#holiday)
    - [Account permissions](https://help.swingvy.com/knowledge/settings?hsLang=en#account-permissions)
- [Promotion and grant](https://help.swingvy.com/knowledge/promotion-and-grant?hsLang=en#main-content)

    - [Referral Program](https://help.swingvy.com/knowledge/promotion-and-grant?hsLang=en#referral-program)
    - [Malaysia](https://help.swingvy.com/knowledge/promotion-and-grant?hsLang=en#malaysia)
    - [Singapore](https://help.swingvy.com/knowledge/promotion-and-grant?hsLang=en#singapore)
- [Employee guide](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#main-content)

    - [Get started](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#get-started)
    - [General settings](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#general-settings)
    - [Time](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#time)
    - [Leave](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#leave)
    - [Claims](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#claims)
    - [Payroll](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#payroll)
    - [People](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#people)
    - [Performance](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#performance)
    - [Mobile apps](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#mobile-apps)
    - [Calendar](https://help.swingvy.com/knowledge/employee-guide?hsLang=en#calendar)
- [Swingvy Stella (AI assistant)](https://help.swingvy.com/knowledge/swingvy-stella-ai-assistant?hsLang=en)

[![Chill listening crop-3](https://help.swingvy.com/hs-fs/hubfs/Swingvy_Small%20logo.png?width=30&height=30&name=Swingvy_Small%20logo.png "Chill listening crop-3")](http://www.swingvy.com)

Swingvy | Help Center

<https://twitter.com/swingvyofficial> <https://www.youtube.com/channel/UC5poJRIS216p0azyaZHEBOA> <https://www.instagram.com/swingvyofficial/?hl=en> <https://www.linkedin.com/company/swingvy/>

Copyright © 2026, Singapore