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 delete a calculation table?

      You cannot delete a calculation table with related transactions. Deleting a calculation table 1. Open Connect Payroll > Organization > Calculation Tables. 2. Use the Lookup bar to enter a calculation table name. Press Enter. 3. Click Delete (CTRL+D). ...

    • How do I add a calculation table?

      Create a new record to store the rates in a calculation table. Adding a calculation table 1. Open Connect Payroll > Organization > Calculation Tables. 2. Click New (CTRL+N). New button 3. Click to select the field titled Calculation Table Name, to ...

    • How do I remove a rate from a calculation table?

      Edit an existing calculation table by removing a rate from it. Removing a rate from a calculation table 1. Open Connect Payroll > Organization > Calculation Tables. 2. Use the Look Up bar to enter the calculation table name. Press Enter. 3. Click to ...

    • How do I edit a rate in a calculation table?

      Make changes to an existing calculation table. For example, updating withholding rates and amounts for the new tax year. Changing a rate from a calculation table 1. Open Connect Payroll > Organization > Calculation Tables. 2. Use the Look Up bar to ...