Loans and Recurring Adjustments

Recurring adjustments are used particularly for loans and allowances. They indicate how much to deduct from an employee's salary as provided by the terms of their loan or how much to add for any incentives or pro-rated adjustments. To set-up recurring adjustments, follow these steps:

1. Under the Employees tab on Sprout Payroll, click on Upload Adjustments.

2. Click on Download Excel Template.

3. Fill out the necessary fields with the correct information. Then save the template in your local device.

• Column D: Adjustment Type
  (*Required field) - Select the adjustment type from the
  dropdown
  (e.g. salary adjustment or reimbursable allowance).

• Column E: Adjustment Name (*Required field) - Input the name for this adjustment.

• Column F: Adjustment Code (*Required field) - Input a unique adjustment code, with a maximum of 10 characters only.

• Column G: Adjustment Date (*Required field) - Input the 1st date of the cutoff period.

• Column H: Adjustment Amount - Input the adjustment amount. This will also serve as your monthly amortization.

• Column I: Remarks - Input remarks if any.

• Columns J & K: Apply Before Tax and Is Taxable (*Required fields) - If taxable, select "Yes" for both. If non-taxable, select "No" for both. This should always be the case.

• Column L: Maximum Amount - This is used for recurring adjustments. This means the adjustment will stop when it reaches the maximum amount inputted. If it’s intended for allowance just leave it blank.

• Column M: Amount will be divided per period (*Required field) - Selecting "Yes" will split the total Adjustment Amount (column G) into two. Selecting "No" will require you to input an answer in Column N.

• Column N: Apply Period - (*Required if "No" is selected in Column L) - Input "1" or "2" to indicate which period the amount will be assigned to. If you selected "Yes" in Column M, you can leave this blank. .
• Column O: Date Issued - Refers to the check’s issued date for the new loan. For existing adjustments, just copy Adjustment Date.
• Column P: Principal Amount - Refers to the approved loan amount for the new loan. For existing loan, just copy maximum amount.
• Column Q: Payroll Type - This will serve as reference adjustment if you intend to include on Normal Payroll/Final Pay/Special Run, Adjustment payroll, and Reimbursement payroll.

4. Click select and search for the saved file in your device folders. Then, upload the saved file by clicking on Import File.

5. A notification message will prompt if uploading was successful.

Aside from bulk upload, you may opt to add recurring adjustments manually in Sprout Payroll.

1. In Employees tab, search for the employee and click Adjustment on the same row of the employee’s name

2. Click Add new record to Add adjustment. Fill in necessary details such as 

• Adjustment type
• Adjustment name
• Code
• Adjustment date (effectivity of the adjustment)
• Applied Before Tax and Taxable Max amount
• Payroll Type
• Principal amount
• Date issued
• Amount divided per period

Note: Refer to the description above.

3. Once you save the adjustment, it will be reflected in the employee's payroll based on the effectivity date and any future pay periods.