How to Bulk Upload Pay Items

Learn how to efficiently upload multiple pay items at once using Remote's bulk upload feature. This guide will walk you through the process of importing payroll data using CSV files.

Prerequisites

• Access to the Payroll runs page
• A CSV file containing your pay item data
• Legal Entity Pay Items must be already set up for the relevant legal entity

Step-by-Step Guide

1. Access the Bulk Import Tool

Navigate to Payroll runs and click Upload payroll data, then select Upload a file.

2. Select the Bulk Uploader

Choose from two options:

• Specific bulk uploaders for particular pay items (like Expenses or Time Off)
• "Other pay items" bulk uploader for general pay items

3. Choose Legal Entity

Select the appropriate legal entity from the dropdown menu.

4. Prepare and Upload Your File

You can either:

• Upload your own CSV file in any format
• Download and fill out Remote's template

Required Fields for CSV File

• employee_identifier: Can be Email, Remote ID, or Employment ID
• pay_item: Must match a Legal Entity Pay item for the employee
• amount: The value of the pay item
• effective_date: Date when the pay item should be applied

5. Map Columns

Match your file's columns to the corresponding Remote fields. Any unmapped required fields can be filled in during the review step.

6. Review and Correct Data

Check for any validation errors and correct them using the inline editor. Alternatively, you can re-upload a corrected CSV file.

7. Submit for Processing

Once all data is correct, submit the pay items. You'll receive a summary before and after completion.

Important Notes

• The bulk uploader supports all pay item types except Expense and Time off types
• Only one pay item can be specified per row
• You cannot add pay items for multiple legal entities in a single upload
• EOR employees are not supported in the bulk upload feature