Overview
SimplySub can export your employees' payable hours into an Excel (.xlsx) file for use with Gusto Smart Import. This lets you bring regular hours, overtime, and other payable time categories into a Gusto payroll draft without retyping every employee's hours.
Important: SimplySub creates the spreadsheet; it does not send payroll directly to Gusto or submit payroll on your behalf. Review all imported values before approving payroll.
Before you begin
-
Review and correct employee punches and time codes in SimplySub.
-
Confirm the date range matches the payroll period you intend to run in Gusto.
-
Ensure employees are set up in Gusto and can be matched by name (and employee number where applicable).
-
Confirm that your company's workweek start day in SimplySub matches the workweek settings in Gusto, especially when overtime applies.
-
If a pay period spans multiple workweeks, review the week-by-week breakdown carefully.
Step 1: Export hours from SimplySub
-
Sign in to SimplySub and open Reports.
-
Open Payroll Summary (Report 2), Timesheet Summary (Report 31), or Employee Time Cards (Report 35).
-
Select the correct date range and any employee or user-tag filters, then click Run Report.
-
Review regular hours, overtime, vacation, holiday, and any other payable time codes.
-
Select the Payroll Export / Export Hours card.
-
Choose Export for Gusto (.xlsx).
-
Read the confirmation and click Download Excel File.
-
Save the downloaded spreadsheet.
What's in the file? SimplySub creates one row per employee per workweek, with employee number, first and last name, workweek start and end dates, regular hours, overtime hours, and any additional payable time-code columns. Unpaid hours are excluded from payable-hour totals.
Why are there multiple rows for an employee? A payroll period may contain more than one workweek. Keeping workweeks separate supports overtime review and Gusto's workweek-based pay calculations.
Step 2: Open Smart Import in Gusto
-
Sign in to Gusto.
-
Open Pay → Run payroll.
-
Select the payroll you want to run.
-
Above the employee table, near Filter and Columns, click Import payroll data.
-
Upload the Excel file from SimplySub by selecting Upload or dragging the file into the upload area.
-
Click Upload and continue.
Gusto's Smart Import supports .xlsx files and attempts to recognize spreadsheet columns automatically. If Gusto can't interpret the file, you can download Gusto's CSV template and transfer the relevant data into it.
Step 3: Review the imported data
-
Check that Gusto matched each row to the correct employee.
-
Verify regular hours, overtime hours, vacation, holiday, and other payable categories.
-
Check that the imported workweek dates align with the payroll period and your Gusto workweek settings.
-
Correct any mismatches or unsupported pay categories before proceeding.
-
When the preview is correct, select Import.
Important: Gusto states that importing payroll data can replace existing entries for the same payroll. In particular, imported zero values can overwrite previously entered amounts, while blank values do not affect existing entries. Review the preview carefully if you've already entered hours.
Overtime and workweek note: Gusto documents a workweeks field for allocating hours to the correct workweek. SimplySub supplies workweek start and end columns; confirm that Gusto recognizes or correctly maps them. If Gusto flags the dates or requires a specific workweeks column, adjust the spreadsheet to Gusto's current instructions before importing. Do not assume the week columns are mapped automatically.
Step 4: Verify and submit payroll
Review each employee's hours and pay types in Gusto. Confirm overtime calculations, paid time off, pay rates, gross pay, and any other payroll details. Once everything is correct, continue through Gusto's normal payroll review and submission process.
Troubleshooting
Gusto doesn't recognize the spreadsheet
Try uploading the original .xlsx export again. If it still fails, download Gusto's CSV template from Smart Import, copy the appropriate SimplySub values into the template, and upload that version.
An employee isn't matched correctly
Verify the employee's name and payroll profile in Gusto. Check for duplicate or similar employee names before importing.
Gusto flags the workweek dates
Confirm that the date range falls inside the selected payroll period and that the workweek boundaries match Gusto's settings. Gusto may require workweek dates in its expected workweeks format.
Vacation or holiday hours appear in the wrong category
Review Gusto's pay-type matching and configure or correct the applicable categories. Make any necessary adjustments before submitting payroll.
Hours already entered in Gusto disappeared or changed
Gusto's Smart Import can replace existing values. Recheck the uploaded spreadsheet, especially zero-hour cells, and correct the payroll draft before submitting.
The report includes lunch hours, but the export does noy
Unpaid lunch or other unpaid time may appear in SimplySub reports for recordkeeping but is not included as payable payroll hours.