How to Import SimplySub Payroll Hours into QuickBooks Online Payroll

SimplySub helps you prepare payroll by exporting your employees' payable hours to an Excel (.xlsx) file. You can upload that file into supported QuickBooks Online Payroll accounts

Updated 2026-11-21

Overvie

SimplySub helps you prepare payroll by exporting your employees' payable hours to an Excel (.xlsx) file. You can upload that file into supported QuickBooks Online Payroll accounts, review how QuickBooks matches employees and pay types, and add the hours to a payroll draft.

Important: SimplySub does not submit payroll, transfer funds, or connect directly to QuickBooks Payroll. You remain responsible for reviewing and approving payroll in QuickBooks.

Before you begin

  • Confirm the correct employees, time punches, time codes, and payroll dates in SimplySub.

  • Make sure employee names (and employee numbers, when used) correspond to their QuickBooks payroll profiles.

  • Ensure employee payroll setup is complete in QuickBooks.

  • Check whether your QuickBooks account offers Add from file. Intuit currently describes spreadsheet importing as available in the U.S. with QuickBooks Online and QuickBooks Workforce Premium or Elite, with a gradual rollout. Availability can vary by account.

  • Use a date range that corresponds to one QuickBooks pay schedule. If you have multiple schedules, create separate exports.

Step 1: Export hours from SimplySub

  1. Sign in to SimplySub and open Reports.

  2. Open Payroll Summary (Report 2), Timesheet Summary (Report 31), or Employee Time Cards (Report 35).

  3. Choose the payroll date range. Apply any employee or user-tag filters you need, then select Run Report.

  4. Review the reported hours, including regular time, overtime, vacation, holiday, and any other payable time codes.

  5. Select the Payroll Export / Export Hours card.

  6. Choose Export for QuickBooks Payroll (.xlsx).

  7. Read the confirmation and select Download Excel File.

  8. Save the downloaded file somewhere you can find it.

What's in the file? SimplySub produces one row per employee for the selected date range. Columns include employee number, first and last name, regular hours, overtime hours, and additional payable time-code columns when applicable. Unpaid hours, such as an unpaid lunch, are not included in payable-hour totals.

Step 2: Upload the file into QuickBooks

  1. Sign in to QuickBooks Online with permission to run payroll.

  2. Go to Payroll → Run payroll.

  3. Select Add from file, if this option is available in your account.

  4. Choose the Excel file downloaded from SimplySub and upload it.

  5. Wait while Intuit Intelligence reads the spreadsheet.

If Add from file is missing, your QuickBooks account may not have the feature yet. You can use the SimplySub spreadsheet as a reference to enter hours manually, or contact QuickBooks support about availability.

Step 3: Match and review payroll data

  1. Review QuickBooks' imported employee and hour summary.

  2. Confirm the pay period and match each row to the correct employee.

  3. Check the mapping for Regular Hours, Overtime Hours, and any additional pay categories.

  4. Correct any unmatched or incorrectly interpreted data before proceeding.

  5. If the payroll draft already contains hours, carefully choose whether to replace or add imported values. Adding may duplicate hours already entered.

  6. Select Add to payroll once the preview is correct.

Pay-code note: A SimplySub column such as Holiday Hours or Vacation Hours may require matching to a corresponding QuickBooks pay type. Do not assume all additional categories will import automatically.

Step 4: Verify and submit payrol

Before submitting payroll in QuickBooks, verify employee names, the pay period, regular and overtime hours, paid time off, pay rates, and the resulting gross pay. Enter any required deductions, contributions, garnishments, or other information not imported from the spreadsheet. Then submit payroll in QuickBooks when everything is correct.

Troubleshooting

I don't see “Add from file"

Spreadsheet import is not available in every QuickBooks account. Confirm your subscription and rollout eligibility with QuickBooks. You can still use the exported hours as a manual-entry reference.

QuickBooks didn't recognize an employee

Check that the employee's payroll profile is complete and that their name matches the SimplySub export. Review QuickBooks' matching prompts before adding the data.

Vacation or holiday hours weren't mapped correctly

Review the pay-type mapping in QuickBooks and confirm the applicable pay type is configured. Enter or correct unsupported categories manually.

Hours look doubled

Check whether the payroll draft already contained hours. During import, QuickBooks may ask whether to add to or replace existing values.

Total Hours in a SimplySub report differ from exported payable hours

Some report views display unpaid time, such as lunch breaks, for tracking purposes. The payroll export uses payable hours; compare it with the report's paid-hour breakdown rather than total recorded time.