Resolve Error: "Invalid payrollitem reference key xx for employee xx" on Track Time CSV import

Written by
Pamela Caringal
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

  1. 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.

  2. 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.

  3. Upload again the CSV file.