How_do_I_update_a_calculation_formula_

How do I update a calculation formula?

Replace a calculation formula with a master formula. Following these steps will replace the existing formula with the formula from the master formula.  

Why is this important?

Payroll uses Calculations (Organization > Calculations) to link together the calculation formula, calculation table, and pay code type. Like this...

Calculation = Calculation Formula + Calculation Table + Pay Code Type

 

To complete the Payroll Year-end Checklist, you will need to update the formulas, rates, and modifiers for the next payroll year.

 

 

Watch a video

 

Updating a calculation formula

1. Open Connect Payroll > Organization > Calculation Formulas.

2. Look up a calculation formula and then press Enter.

Look up a calculation formula

3. Verify the calculation formula that you want to replace is displayed on the screen.

4. Click Select.

Select button

5. When the Replace Formula dialog displays, "OK to replace existing formula with master?" message, click Yes,

Replace Formula dialog box

6. Use the Import Master window to select a master formula, and then click OK.

Import Master window

The existing formula is replaced with the master formula. The formula name that you have selected displays as the Original Master.

Original master

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • How do I update a calculation table?

      Replace a calculation table with a master calculation table. Following these steps will replace the rates and modifiers on the existing calculation table with the rates and modifiers in the master calculation table. Rates and modifiers Why is this ...

    • How do I add a calculation?

      A calculation uses a formula to determine an amount, percentage, or number. Use Calculations to set up the formulas that you will use in the Payroll application to calculate state, federal, and earned income credits. The calculation associates the ...

    • Step 2. Set up calculation formulas for IRS tax levy

      Add the IRS tax levy calculation formula. These instructions are for 2023. You may need to update the instructions if you are setting up the IRS tax levy for a different year. Setting up IRS tax levy calculation formula 1. Open Connect Payroll > ...

    • Step 3. Set up calculation for IRS tax levy

      Set up the IRS tax levy calculations to link the calculation table with the calculation formula for Head of Household Married Filing Jointly Married Filing Separately Single These instructions are for 2023. You may need to update the instructions if ...

    • What is a calculation formula?

      Use Calculation Formulas to set up a new formula, edit an existing formula, or delete an old formula. All formulas used in the Payroll program are stored in this table. Then, you can use the calculation formula to set up the options in the ...