How to create my own formula
Description
Cause
Resolution

[BCB:5:Third-party support:ECB]

How to enter new payroll formulas

  1. Go to File, Payroll Formulas, and select User-Maintained.
  2. Set up the formula by giving it a Unique Formula ID.
  3. Select the appropriate classification at the How do you classify this formula? drop-down.
    Note: If Selecting Tax, specify the appropriate Tax agency and the appropriate State and Locality as necessary.
  4. Select the appropriate drop-down for the following:
    • Effect on gross pay
    • Filing status
  5. In the formula field, enter the formula content. You can check the section below for basic examples.
    • The formula field is case-sensitive
    • When creating a formula using Hourly and Salary fields, capitalize the names HOURLY and SALARY
    • Enter percents as decimals (such as 0.20 for 20%)

Basic example formulas

Formula based on Gross:

  • ANSWER=-GROSS*(percent)
    Enter the (percent) value as a decimal percentage (for example: 0.20 to represent 20%)

Formula using the Special fields on the Withholding Info tab of the employee record:

  • ANSWER=-EMP_SPECIAL1_NUMBER/100
  • ANSWER=-EMP_SPECIAL2_NUMBER/100
    This will turn the amount entered in the Special 1 or Special 2 field into a percentage calculation

Formula using the Special fields for a flat amount:

  • ANSWER=-EMP_SPECIAL1_NUMBER
    This sets up an employee deduction or company portion.
  • ANSWER=EMP_SPECIAL1_NUMBER
    This sets up an employee benefit.
Steps to duplicate
Related Solutions

How do the payroll formulas work?