How to create a Payroll Advance in Sage 100
Resolution
- If you do not already have an Earnings Code for Payroll Advance, you may set up a new Earnings Code, refer to KB Article 37651, DocLink: How to Setup Earnings Codes. You will need to determine if this is to be paid back (as in “loan”) or if this is a true advance and not to be paid back. If the latter, you will need to set up Payroll Advance with taxes.
- Select the appropriate Tax Rule: i.e., if the employee is paying it all back, like a loan, then no taxes would be taken out.
- If you do not already have a Deduction Code for Advance, you may set up a new Deduction Code, refer to KB Article 18879, DocLink: How to set up a Deduction Code.
To create the Payroll Advance:
- Open Payroll, Main, Payroll Data Entry – create a Pay Cycle
- Select Employee
- Go to Tab 2. Lines
- Select Earnings Code “Advance“
- Enter Hours if it doesn’t auto populate. Make sure Hours and Amount are correct.
- Accept
- Say No to Auto Deductions
- Run Payroll Tax Calculation
- Process Advance like you would normally process Payroll, printing any reports necessary, checking that no taxes were taken out.
- Print Check
- Update Check Register
- Update Daily Transaction Register.
To create the Auto Payroll Advance Repayment:
- Open Payroll, Main, Employee Maintenance
- Select Employee
- Accept
- Choose Tab 7. Deductions
- Add Row by clicking on the ‘Add Deduction‘ icon on the right, or selecting Alt-U
- Select Deduction Code “Advance“
- Add Amount/Rate to be paid back per pay period
- Add a Goal (Same amount as Advance)
- Select Automatic for auto deductions each pay period
- OK
- Exit out of Deductions
- Accept