How_do_I_update_a_calculation_table_

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 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 table

1. Open Connect Payroll > Organization > Calculation Tables.

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

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

4. Click Select.

Select button

5. When the Replace Table dialog box displays, "OK to replace the existing table, rates, and modifiers with master?" message, click Yes.

Replace Table dialog box

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

Import Master window

The existing calculation table is replaced with the master calculation table. The master name that you have selected displays as the Original Master and the date it was published.

Original master

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • 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 ...

    • 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 ...

    • Idaho Child Tax Credit Allowance Table - Updating tax rate - 2024 (2024.05)

      Issue The state of Idaho updated the child tax credit allowance with a new tax rate in 2024. I need to update payroll to calculate the Idaho state withholding correctly. Explanation The state income tax withholding tables were updated for 2024 due to ...

    • 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 ...

    • Step 1. Set up calculation tables for IRS tax levy

      Add a calculation table for the IRS tax levy for Head of Household Married Filing Jointly Married Filing Separately Single These instructions are for 2023. You may need to update the instructions if you are setting up the IRS tax levy for a different ...