How to Retrieve Employee Internal IDs (For Imports)

To complete your time entry imports and employees' updates, you must use the Employee Internal ID. Using Internal IDs instead of names ensures correct mapping, prevents duplicate records, and avoids failed imports.

Follow the steps below to enable Internal IDs in NetSuite and export your employee list for easy reference.

Step 1: Enable Internal IDs in NetSuite

1. Navigate to: Home → Set Preferences.

2. Under the General tab, check the box for Show Internal IDs.

3. Click Save.

   Note: If Internal IDs are still not visible after saving, refresh your screen to update the display.

Step 2: Access the Employee List

1. Navigate to: Payroll Administration → Payroll Records → Employees.

2. Your full employee list will now be displayed.

Step 3: Export the List to Excel

1. From the employee list screen, click Export (or Export to Excel).

2. Download and open the file in Excel.

Step 4: Identify and Use Internal IDs

In your exported Excel file, locate the Internal ID column. You must use these numerical values in your CSV template under the Employee field.

Example ID Mapping: 

| Employee Name | Internal ID | 

| Test S Monthly   | 428           | 

Best Practices

• Avoid Mapping Errors: Always use the unique Internal ID rather than the employee's name.

• Data Integrity: This process ensures a successful time entry import and prevents failed records.