How to Set Up a One-Time Adjustment using Mass Upload (Excel File)

Payroll Adjustments can be easily be made using one-time adjustment template. Kindly note that before you add one-time adjustment, you must create payroll.

 

Follow this link on how to create payroll: How to Process Payroll in Sprout

 

Here's a simple way to upload adjustments for more than one employee using one-time adjustment template:

 

1. Payroll should be in "Pending" status

 

2. Click View

 

3. At the lower portion, click Upload Adjustments

 

4. Download Excel Template

 

5. Fill-out necessary details

 

If the adjustments are for employee's deduction, add (-) before the values. See sample below:

 

However if only one employee will be uploaded you may refer to this simple step. Here's the link:  How to Setup One-Time Adjustment for Specific Employee

 

Kindly note that if an employees don't have any adjustments, delete the entire row. Refer below sample screenshot:

 

For employees with more than one adjustment, you may insert another column and copy paste employee details, see sample below:

 

 

6. Once done, import the updated template