How to create my own formula
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]

Section 1: New Payroll Formula settings

  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. For basic content examples, refer to Section 2.

Section 2: Basic formula examples

Note: The Formula field is case-sensitive. The percent in the formula should be entered as a decimal percentage. (Example. 20% would be represented as 0.20 when used in formula creation).

  • Formula based on Gross:

    ANSWER=-GROSS*(percent)
    The (percent) value should be entered 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

    The /100 would 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
      For use as an employee deduction or company portion.
    • ANSWER=EMP_SPECIAL1_NUMBER
      For use as an employee benefit.

Note: When creating a formula using Hourly and Salary fields, ensure that you capitalize the names, HOURLY and SALARY. How do the payroll formulas work?

Steps to duplicate
Related Solutions