How to upload BONUS by batch, (Salary Upload Wizard)

How to upload BONUS by batch, (Salary Upload Wizard)

Step 1. Salary Upload Wizard
To use Batch Salary Upload for bonus upload, kindly go to Payroll -> General -> Salary Upload Wizard .   
The allowance - Bonus must be created before proceeding with the Batch Salary Upload for Bonus. 

Part 1 - Download the Excel Template
  1. Login as admin 
  2. Click on Payroll 
  3. Click on General 
  4. Click on Salary Upload Wizard 
  5. Click on Download Sample File
  6. (Details explanation as below, with an image as a reference) 



You will need to download the Sample File first. This is a template that you will use to key in the bonus and then upload it to the system later. 

You may perform the filtering under the advance search before exporting the file.
For further explanation regarding the advance search, you may refer to the link ( 1.1 Advance Search).

Click on the 'Download Sample File' button. 



Depending on your computer's setting, a file will be downloaded and saved on your computer, the default file name is SalaryEntryUpload.XML. Locate and open the Sample File. 

Part 2- Open & Update the downloaded Excel Template
  1. Open the downloaded Excel (SalaryEntryUpload.XML)
  2. Go to the Allowance Sheet 
  3. Search for the column, Bonus 
  4. Insert the Amount 
  5. Click on Save
  6. (Details explanation as below, with an image as a reference) 

There are many tabs in the Sample File (Excel), showing all the Pay Element, such as Basic, Allowance, Deduction, etc.

We will assume that we are going to update the Bonus for January 2020 Bonus payment period. 


Click on the 'Allowance' tab of the Sample File, you should be able to see all the allowance that exist in the System earlier (which could be different from what I have in this Sample File here).



To avoid confusion, you may hide the unused excel column.

Insert the amount for the Bonus. After you finish entering the bonus, save and update the file. 

Go to 'Salary Upload Wizard' again. This time, at Step 1, select 'Upload a New Salary Input File and Process' then click 'Next Step'. 



Part 3- Upload the Excel file to Salary Upload Wizard
  • Login as admin 
  • Click on Payroll 
  • Click on General 
  • Click on Salary Upload Wizard
  • Step  1 - Click on Next Step
  • Steps 2 - Update the "Year", "Month", "Period", "Description" and Upload with the file 
  • Steps 3 - Do not Custom Anything, Click on Next Step
  • Steps 4 - Statutory Reconciled as default method "Statutory deduction deducted on this payment period will be reconciled at every other period."
If you wish to have different options/methods for the statutory payout, you may refer to the Reconciled Methods explanation - 4. Statutory Deductions
You may also refer to our support for further clarification. 
  • Steps 5 - Click on Next Step if there is no issue with the Excel File, (If there are any error with the Excel file, it will show the error message under step 5)
  • Steps 6 - Verify if there is an exception error message, then click on Next Step
  • Steps 7 - Verify if the is no issue with the summary, click on Next Step
  • The bonus should be uploaded successfully. 

    • Related Articles

    • Step 1. Salary Upload Wizard

      To use Batch Salary Upload, go to Payroll -> General -> Salary Upload Wizard.   If this the first time you use the Upload Salary Wizard, you need to download the Sample File first. This is a template that you will use to key in the raw data and then ...

    • How to Use Batch Salary Upload?

      'Batch Salary Upload' is a feature that allows you to update multiple records at one go. This is particularly useful for companies that have variable allowance and big headcount, the User only need to update the variable allowance (such as Attendance ...

    • 3.5 Salary Entry Batch Update

      For Payroll processing, it is compulsory to migrate employees' previous month salary details as the tax calculation has to include total accumulate remuneration of the year.   How to migrate employees' salary details?  Download migration template ...

    • 10. How to perform Advanced Salary Payment?

      First, you will need to setup the ‘Advanced Basic Salary’ allowance in the Allowance/Deduction Setup.   -          Go to Payroll -> Setting  -> Allowance and Deduction Setting -> Allowance Setting  -          Click ‘Edit’ on Allowance Code ‘ADV1+’ ...

    • 1.2 Expense Layout - Creating Expense Detail Item Layout aka Batch Entry Excel Layout

      After creating Expense Layout, you can now continue to create the Expense Detail Item Layout. However, this is relatively simple and easy.  Step 1 ,2 & 3: Go to Expense -> General Setting-> Batch Entry Excel Layout, Step 4: Click 'Create'. Step ...