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 upload your own CSV file. Enter payroll details, then upload.
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 assigns each employee a unique identifier called the "Gusto employee ID." This is a 6-character alphanumeric ID (e.g. 5G9934) that is securely generated and randomly assigned. The ID enables a better distinction of employees for accurate payments and record keeping.
Most of the time, the ID will be a combination of letters and numbers. Some IDs may be all letters or all numbers.
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.
At this time, Gusto employee IDs are not customizable and cannot be disabled.
Use the Employee report builder for a report of all employee IDs.
Follow the formatting guidelines in the table below.
|Type||Column title (non-regular payrolls)||Details|
|Employee name||first_name: last_name|| |
Not case-sensitive, required
Example: "Smith", "smith", or "SMITH"
|Social Security Number (SSN)||ssn|| |
Last 4 digits, preceded by an asterisk (*), required if there are two employees with the same name
|Gusto employee ID||gusto_employee_id|| |
Not case-sensitive; optional
|Job title||title|| |
Not case-sensitive, required for employees with multiple pay rates.
Learn more about multiple-pay-rate formatting below this chart.
|Pay||regular_hours; overtime_hours; double_overtime_hours; bonus; commission; paycheck_tips; cash_tips; correction_payment; reimbursement|| |
Positive numbers, decimals optional
|Personal note||personal_note|| |
Can contain numbers and letters
Example: Thanks for giving it 100%
|Invoice number||invoice_number|| |
Any alphanumeric combination, up to 25 characters
Different computer systems use unique naming conventions for similar fields, and mapping is often required when connecting software systems to make sure information is synced correctly.
This CSV mapping template serves to bridge the gap between your source system and what Gusto’s system expects. To use this mapping template, follow the steps below.
Useful links for Google Sheets
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.