Update the Employer State Unemployment (SUI ER) Formula to a New Payroll Year

Related topics

Print Yearly Earnings report

Print Payroll Exception report to correct differences between calculated withholdings and actual withholdings

Print vendor 1099 forms

Pay employees

Perform other payroll tasks

Review payroll year-end procedures

Read the close fiscal year overview

Employer state unemployment (Sage 50's SUI ER) wage limits and percentage rates can depend on your company location or type of business. Therefore, you maintain the SUI ER formulas and must update them each year. Updates in employer state unemployment tax formulas are not included in the Sage Business Care plans.

Note: Some "employee-paid" state unemployment formula updates are included in a Sage Business Care plan (Gold or Platinum) or a monthly subscription. The procedure below is only intended for employer–paid state unemployment formulas.

Tip: You can also use the following procedure to update other company formulas unique to your business (for example, vacation accrue, sick accrue, 401K, or employee loan calculations).

You must subscribe to a Sage Business Care plan to update payroll formulas in Sage 50.

  1. From the File menu, select Payroll Formulas, then choose User-Maintained. Sage 50 displays the User-Maintained Payroll Formulas window.
  2. Select the old SUI ER formula ID for your state in the formula list (for example, GASUI ER 00).
  3. In the Formula ID field, add or change the number following the ID.

    For example, you might change GASUI2 to GASUI3.

  4. In the Name field, change the two-digit year to the current payroll year.

    For example, change GASUI ER 11 to GASUI ER 12 (changes 2011 to 2012).

  5. In Formula box, locate the LIMIT= and PERCENT= lines. Below is an example of how the formula might appear.

    LIMIT = 8500;

    PERCENT = 3.00000;

    TAXABLE_GROSS = YTD_LIMIT (ADJUSTED_GROSS, LIMIT);

    ANSWER = -TAXABLE_GROSS * PERCENT%

    If your state unemployment wage base limit and percentage have changed, you will need to edit the formulas. If you are unsure, check with your state unemployment authority to determine if your area has a new unemployment limit and percent.

    Note: When entering a PERCENT value, use at least two decimal places. For example, if your percentage rate is 3%, then enter PERCENT=3.00; if your percentage rate is 2.7%, then enter PERCENT=2.70.

  6. If required, change the limit and percentage displayed in the formula.
  7. Click Save.

    A new, updated formula is listed alongside the old tax formula.

  8. Click Close.