Updating salary tables

You can update an existing salary table by creating a new version of the salary table. The scales and steps of the salary table must therefore be present. See this article for more information on creating a new salary table.

Go to the level where you created the salary table that is to be updated (debtor or master level, Settings tab);

There are two ways to update a salary table:

  1. by entering a percentage or
  2. by export/import.

Both methods are explained here.

  1. Use the button with the two arrows (1, 'Update') for implementing a percentage increase.
  2. Use the button with the little eye (2, 'To scales/steps') for implementing an increase that is not linked to a fixed percentage.
 

Method 1: Updating by entering a percentage

When choosing method 1 (updating by entering a percentage), you will see the above screen. Here, you enter the period that starts when the new version of the table takes effect. To determine what the correct monthly, weekly and 4-weekly combination is, click on the triangle to expand the calendar. Here, you can select the start date; at the bottom, you can see from when to when the selected periods run.

After selecting the correct starting period, you can minimise the calendar by clicking on the triangle again.

  1. Then, enter the percentage by which the table should be increased. Also specify a method of rounding and the number of decimals that should be used in rounding.
  2. You can test whether the percentage increase gives the desired results by entering a value under Test and clicking the 'Calculate' button.
  3. If all of your data have been correctly entered, click below on 'Update'.
The new version of the salary table is now available.
 

Method 2: Updating by export/import

When choosing method 2 (updating by export/import), the current scale is displayed on your screen.

1. Export the current version to an Excel file using the 'Export' button.

In the export file, adjust the salary amounts. Please make sure to not change anything in this file except for the values. The scales and steps are linked to one another via the scale and step codes that are already present in the salary table. Furthermore, the descriptions in the top row and the name of the tab ('Scales') must not be modified, or else the file cannot be imported.

2. After the values have been modified and the file has been saved under a random name, the file can be imported using the 'Import' button.
  1. First enter the period that starts when this new version of the table takes effect. To determine what the correct monthly, weekly and 4-weekly combination is, click on the triangle to expand the calendar. Here, you can select the start date; at the bottom, you can see from when to when the selected periods run. After selecting the correct starting period, you can minimise the calendar by clicking on the triangle again.
  2. Then click on 'Browse' to select the file to be uploaded.
  3. Finally, click on 'Upload'.
The new version of the salary table is now uploaded and available.
Follow

Comments