How to Set up Sage 100 Payroll Auto Earnings

Summary

Follow the steps to create Sage 100 payroll data entries automatically.

Resolution

Use Automatic Earnings Code Maintenance to set up multiple earnings codes for each employee. Then, you can use the Auto Pay feature to create Payroll Data Entry automatically.

Set up Auto Earnings

  1. Open Payroll, Main, and Employee Maintenance.
  2. Select the applicable employee.
  3. Click Wages.
  4. Select the Multiple Automatic Earnings Codes check box and click Auto Earnings.
  5. Configure the following fields. 
    • Earnings Code – Enter the appropriate earnings code.
    • Automatic Earning – Check this box to include the earnings code in the employee’s pay calculation.
    • Frequency – Enter the period number for the earnings code to be included in the employee’s pay calculation.
       NOTE: This value matches the Deduction/Earnings Period in the Pay Cycle to determine if the earnings code is included. If you want the earnings code included for every pay period, type 12345. 
    • Department – Enter a department or click Lookup to list all departments.
    • Calculation – Select Fixed Amount or Percentage.
        NOTE: This field shows Fixed Amount and appears only when using the Fixed Amount entry method for the selected earnings code. 
    • Allocation – Enter a percentage to adjust the Payment Amount field. This field appears only if you select Percentage in the Calculation field.
    • Pay Rate to Use – Choose a pay rate specified in Employee Maintenance. Or select None to input a rate in the Pay Rate field. This field appears if the earnings code has a Fixed Amount method or when selecting Fixed Amount in the Calculation field.
    • Pay Rate – Type a pay rate. This field shows if the Pay Rate to Use is None.
    • Hours – Enter hours to use in the Payment Amount calculation. This field shows if the selected earnings code has a Fixed Amount method.
    • Payment Amount – Enter a pay amount.
    • Earnings Limit – Enter the maximum amount an employee can earn for the selected earnings code. Once this limit is reached, Auto Pay will exclude this earnings code.
  6. Click OK.