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.
Most of the time, the ID will be a combination of letters and numbers, however, our system might generate an ID that is 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 here.
At this time, Gusto employee IDs are not customizable and cannot be disabled.
Follow the formatting guidelines in the table below.
|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 ensure 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 these steps:
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.