Resolve Error: "Invalid payrollitem reference key xx for employee xx" on Track Time CSV import
Published on
June 30, 2023 at 9:16:27 AM PDT June 30, 2023 at 9:16:27 AM PDTth, June 30, 2023 at 9:16:27 AM PDT
Scenario
A user imports Time Entry using CSV import and encountered the error: "Invalid payrollitem reference key xx for employee xx"
Solution
- Verify that the Payroll Item is valid and active
- Navigate to Lists > Employees > Payroll Items
- Show Inactives: Enter Checkmark to include inactive payroll items on the list
- Locate the payroll item using the Internal ID or the Payroll Item Name.
- If payroll item is inactive choose a replacement or unmark the Inactive box if the payroll item should still be active
- If payroll item is not on the list choose a replacement or create a new one.
- Update the CSV file with the correct internal id.
- Check if the payroll item is associated with the Employee record
- Navigate to Lists > Employees > Employees
- Click View on the Employee record
- Navigate to Payroll tab
- Check if the payroll item is setup in the Earnings, Taxes, Deductions, CompanyContributions, or Accrued Time subtab.
- Update the employee record with the payroll item if needed.
- Upload again the CSV file.