Creating your own salary tables

You can personally create salary tables in Nmbrs. As an accountant, you do this at the debtor level using the Settings -> Salary Settings tab (for one debtor) or at the Master level using Settings -> Master Salary Settings tab (for multiple debtors, see screen grab below). As a business client, you can do this by going to Settings -> Salary settings tab.

Pleaste note: It is not possible in Nmbrs to create a net salary table.

Please note: If you create your own salary table, the number that you assign it has to be unique (so it cannot coincide with one of the numbers from the default salary tables at the System Level).

 

Adding a new salary table

Click on 'Add new salary table':
 
 

Specify the start period for this salary table (monthly, weekly and 4-week period types), the number, the name and the scale type:


You can also indicate here for which employment contract you are creating this table (this is purely for further information and is not linked to the salary table in question being made with Nmbrs).

Salary tables options

After the table is created, there are several options:

  • Click on the Scales tab or on the little eye to go to the salary table;
  • Click on the little icon with the arrows to edit an existing salary table;
  • Click on the i-icon to see which companies use this salary table;
  • If you want to delete the salary table, click on the little 'x' at the far right.

Setting up the scale (Scales tab)

The Scales tab contains several options:
  • 'Add scales': add a scale or scales to the salary table;
  • 'Add step': add a step or steps to the salary table;
  • 'Delete this version': delete the current version of the salary table;
  • 'Import': import a complete salary table from an existing Excel file with scales and steps. This is the simplest and quickest option for creating a new table. . Please note: for monthly tables, you have to leave the 'Hour' column empty; for hourly tables, you must only fill out the 'Hour' column! For monthly tables, you can enter only the monthly amount, if required; 4-Weekly and Weekly are optional. Read at the bottom of this page the points to consider for importing salary tables
  • 'Export': export the current scales, steps and the accompanying values to an Excel file.
 

Adding scales

Click on 'Add scales', enter a code and description and click 'Save':

 

Adding steps

Then you add a step to the scale using 'Add step':

  • Select the accompanying scale in the topmost input field.
  • For 'Step Sequence', specify the sequence for the automatic step increase.
  • Specify the monthly, 4-weekly and weekly salary.

Adjusting or deleting steps

On the Scale tab, click on a step to change the values afterwards, or click on the 'x' on the far right to delete a step:

 
 

Points to consider when importing salary tables

It is possible to add a scale to an existing salary table using the import function, if you use a new scale code.

 

'Unknown error' when importing salary tables

It is not possible to use the same scale codes and step codes, but only to enter a different description. This results in an 'Unknown error'.

An example of how it should look:

Scalecode Scale description Step code Step description Monthly 4-Weekly Weekly Hourly
1 Description 1 15yr 15 year 0 0 0 4
1 Description 1 16yr 16 year 0 0 0 4
2 Description 2 15yr 15 year 0 0 0 5
2 Description 2 16yr 16 year 0 0 0 5

 Example on how it should not look: 

Scalecode Scale description Step code Step description Monthly 4-Weekly Weekly Hourly
1 Description 1 15yr 15 year 0 0 0 4
1 Description X 16yr 16 year 0 0 0 4
2 Description 2 15yr 15 year 0 0 0 5
2 Description Y 16yr 16 year 0 0 0 5

 

Underlying reason for this error message

If you want to assign a scale at the employee level, this would cause an error, because it is only possible to import into the import sheet in the employee tab based on the following:

Salary table no. Salary table Scale no. Salary table Step no.
 
Deleting a scale from an existing salary table via the import is not possible, but it can be set to zero. If you perform an export, delete a scale and then import it again, you will receive the following error.
ExampleSalaryTableError.png
 
 
 
 
 
 
 
 
 
 
 
 
Follow

Comments