Use the CSV upload feature to upload hours and earnings to payroll/payments to make processing payroll easier. CSV uploads are available for:
A CSV (comma-separated values) file is a text file where information is separated by commas. CSV files are most commonly encountered in spreadsheets.
You can download Gusto's CSV template or create your own CSV file. Enter payroll details, then upload. You can upload multiple CSVs as long as the columns for each are different. For example, you could upload one CSV with everybody's hours, another with commissions, and a third with reimbursements.
Heads up: If you've entered information such as hours or reimbursements throughout the week in the payroll and saved it for later, uploading a CSV will overwrite anything previously entered.
Your employees' info will be filled out and ready to go—just continue processing payroll.
Gusto will assign each employee a unique identifier called the "Gusto employee ID." This is a 6-character alphanumeric ID (e.g. 5G9934) that gets securely generated and randomly assigned. This is to enable a better distinction of employees for accurate payments and record keeping.
The Gusto employee ID can be found in a few places in your account—under the "Personal" tab of an employee’s profile, and as an optional field in the CSV template on step 1 while running payroll. Learn more about how CSV uploads work here.
At this time, Gusto employee IDs are not customizable and cannot be disabled.
Take a look at the columns you can use and how to format them.
If an employee has multiple pay rates:
If you upload a file that contains zeroes, a zero will be populated in payroll and replace any previously entered or uploaded data.
If you upload a field that contains blank values, nothing will be populated in payroll for that field and any previously entered or uploaded data will remain.