Automatically translated from Dutch. Some wording may be inaccurate.
This module lets you update the gross wage and rates of placements using an import file.
•Separate rates can be imported for different overtime percentages.
•The wage amounts for overtime percentages are recalculated automatically.
The import process consists of three steps: reading the data, validating it and finally importing it.
Read file
This button opens a menu for opening an Excel file.
For details of the file contents, see Import placement wages and rates - Excel file.
Regelneef validates the data after opening the file and displays it in the import module.
Validate
After reading the data, Regelneef validates it automatically. For example, it checks whether a matching placement exists and whether the overtime percentages are defined for that placement. Any problems are shown on the relevant row.
If an overtime percentage is missing from a placement but a value greater than zero must be written, you can open that placement in another screen and add the percentage. Then click Validate again to clear the message.
 | Delete If a group of records should not be imported, you can remove them from the import module together by selecting them and clicking Delete. |
Import
When validation no longer reports any problems, click Import to update the placements with the imported data.