Base Compensation Import

  1. First, you should create your Base Compensation Import file found in Company Settings>Imports>Overview and save in a location that is easy to find.
  2. In Kronos WFR, Navigate to Select Menu > Company Settings > Imports > Employee Setup > Base Compensation History.
  3. In the screen below, click “Choose File” to find the import file that you created. The type will remain “Excel.” When the file is selected, choose Test.
  4. The system will then test your file to see if there are any formatting errors. If all data is entered correctly, you will see the message shown below. Please ensure that the total number of rows in the file exactly matches the number of processed rows:
  5. If there any messages other than those shown above, you will need to edit your Excel file to resolve the errors, and you can then follow steps 1-4 to test the file again. Once all errors are resolved and you receive the message above, click the “Import File” button in the upper right.
  6. The system will complete the import, and you will see the import results as shown below:
  7. Your import is now complete. At this point, we suggest spot checking a few of the employees that were included on the import file to ensure that their base compensation updates are correct.
  8. Once the updates are made and correct, you must reapply rates to the employee’s timesheet to update information for punches already in the system. This is completed by going to Team> Time> Timesheets> All Timesheets> Reapply Rates to Timesheets.
  9. In the screenshot below, enter a “From” date of the date that the base comp changes went into effect. (Ex: if effective date of new rates is 01/0/20, enter the date as shown below. Do NOT enter a “To” date). When this date is entered, click the “All” box to select all employees:
  10. With these two options selected, click “Reapply” in the upper right corner.
  11. When this is completed, you will receive the success message shown below at the top of your screen:
  12. Your rate change is now complete. Please verify rates on the timesheets and in payroll and reach out to payroll@rabcopayroll.com for assistance if needed.