This article reviews the Employee Update Template and the Payroll Employee Update Template. These two imports are used to update Employee information in bulk.
Article Topics:
Employee Update Template
The Employee Update Template is used to update fields that are found on the Basic Info tab and Employment tab of Employee Records. When downloaded all active Employees will be included on the Update Template. When uploaded, any fields within the template with new data will be updated.
Downloading and Uploading the Employee Update Template
To download the Employee Update Template:
- Navigate to the Import Tool
- Select 'Employee' from the 'Options' drop-down menu
- Select 'Update Existing' from the 'Type' drop-down menu
- Click 'Download Template'
To upload a completed Employee Update Template:
- Navigate to the Import Tool
- Select 'Employee' from the 'Options' drop-down menu
- Select 'Update Existing' from the 'Type' drop-down menu
- Click 'Upload File'
- Select the saved file
- Click Next
- Confirm the Mapped Fields
- Note: If the Mapped Fields are not automatically matched, the incorrect file may have been selected or the column titles may have been changed.
- Click Next
- Click Import
Employee Update Template Columns
The Employee Update Template has the following columns:
Column Title | Description | Accepted Entry and Notes | |
A | Employee ID | R365 GUID for the Employee | This column is for reference and should not be edited. The Employee ID must be identical on upload as it was on download. |
B | Full Name | Employees full name | This column is for reference and should not be edited. Changes made will not be imported. |
C | Payroll ID | The Employee's Payroll ID used in past payroll systems | Text |
D | Primary Location | The Employee's primary/default Location | Text |
E | Hire Date | Employee's date of hire | YYYY-MM-DD Note: This field cannot be edited for Employees who have already been onboarded for Payroll. |
F | Preferred Contact Method | How the Employee will receive messages from R365 | Text Both Text & Email |
G | Employee's personal email address | Text | |
H | Mobile Phone | Employee's personal phone number | Numerical |
I | Allow Text Messaging | If text messages can be sent to the Employee from R365 | True False |
J | Break Waiver | If the Employee has break waiver on file | True False |
K | App Access | If the Employee has access to the R365 Red App | True False |
L | Login Password | Password for logging into the R365 Red App | Text |
M | Birth Date | Date of Birth | YYYY-MM-DD |
N | Job Title | Employee's primary job Note: The job name must match an associated Job Record. Note: Requires that Job Location and Pay Rate are also entered. Note: Jobs cannot be imported for separated employees. | Text |
O | Job Location | Name of the location associated with the Job Record Note: Location name must match an associated Location Record. Note: Requires that Job Title and Pay Rate are also entered. | Text |
P | Pay Rate | Employee's rate of pay associated with the job Note: If Pay Rate is blank when Job Title and Job Location are entered, Pay Rate will be imported as $0.00. Note: Requires that Job Title and Job Location are also entered. | Numerical, up to two decimals. |
Q | Inactive | If the Employee is 'inactive' in R365 | True False |
R | Address1 | Address Line 1 | Text |
S | Address2 | Address Line 2 | Text |
T | City | City | Text |
U | State | State | Text |
V | Zip Code | Zip Code | Numerical |
W | Preferred Name | Preferred Name | Text |
X | Gender | Demographic Information | Male Female Choose no to identify No Selection |
Y | Ethnicity | Hispanic or Latino Not Hispanic or Latino Choose not to identify No Selection | |
Z | Race | White Black or African American Asian American Indian or Alaska Native Native Hawaiian or other Pacific Islander Hispanic or Latino Two or More Races (not Hispanic or Latino) Choose not to identify No Selection | |
AA | Employment Type | Employment Information | Full-Time Part-Time |
AB | Primary FLSA Status | Exempt Non-Exempt |
Payroll Employee Update Template
The Payroll Employee Update Template is used to update direct deposit and W4 details for Employees who are active in R365 Payroll.
Requesting the Payroll Employee Update Template
The Payroll Employee Update Template is only accessible by R365 Support. For assistance with downloading and uploading Payroll Employee information, please contact your CSM, Payroll Coach, or R365 Support.
Payroll Employee Update Template Columns
The Payroll Employee Update Template has the following columns:
Column Title | Description | Accepted Entry and Notes | |
A | R365 Employee ID | GUID Employee ID | This column is for reference and should not be edited. The Employee ID must be identical on upload as it was on download. |
B | Legal Entity Name | Name of the Legal Entity associated with the Employee's Primary Location | This column is for reference and should not edited. Changes made will not be imported. |
C | Basecamp Employee Id | Employee's R365 Payroll ID | This column is for reference and should not edited. Changes made will not be imported. |
D | First Name | Employees first name | This column is for reference and should not edited. Changes made will not be imported. |
E | Last Name | Employees last name | This column is for reference and should not edited. Changes made will not be imported. |
F | Legacy Payroll Id | Employee's Payroll ID used in past payroll systems | Text |
G | Legacy Employee Id | Employee's Employee ID used in past payroll systems | Text |
H | Employees personal email address | Text | |
I | Phone Number | Employees personal phone number | Numerical |
J | Tax Payer ID | SSN / TIN | Numerical 9 digits exactly |
K | Pay Schedule | Pay Cycle for the Employee | Monthly Bi-weekly Weekly Daily Note: The Pay Cycle entered must be configured for the Legal Entity |
L | Account Nickname | Direct Deposit Account Information | Text |
M | Financial Institution | Text | |
N | Account Type | Checking Savings | |
O | Routing Number | Numerical 9 digits exactly | |
P | Account Number | Numerical | |
Q | W4 Filing Status | W4 Tax Information | M=Married filing jointly S=Single or married filing separately H=Head of household |
R | W4 Multiple Jobs | True False | |
S | W4 Children Under 17 | Numerical - whole number | |
T | W4 Other Dependents | Numerical - whole number | |
U | W4 Other Income | Numerical - with decimals | |
V | W4 Deductions | Numerical - whole number | |
W | W4 Extra Withholdings | Numerical - with decimals | |
X | W4 Exempt | True False |