Exporting Timesheet Data (CSV File)

Menu Item: Export

Time entries created in Hour Timesheet can be exported to your accounting/payroll software.  Follow the instructions below for exporting timesheet data from Hour Timesheet.

NOTE: The Payroll export file will have to be created first. Once the export to QuickBooks is run, the ADP export is no longer available.

STEP 1. CREATE CSV FILE TO EXPORT TO 3RD PARTY PAYROLL SOLUTION

1. Login to Hour Timesheet as Admin
2. Approve timesheet data for current period(s)
3. Navigate to Export Time
4. Navigate to Time Period to Export
5. Place a check in the box next to the employee’s time to be exported
6. Click Export Selected
7. From Select Payroll System select the 3rd party payroll option from the drop down list
8. Select Download CSV
9. Click Close

STEP 2. EXPORT TO QUICKBOOKS

1. Login to Hour Timesheet
2. Navigate to Export Time
3. Navigate to Time Period(s) to be exported
4. Place a check in the box next to the employee’s time to be exported
5. Click Export Selected
6. From Select Payroll System select QuickBooks
7. Select Export to QuickBooks
8.  If you wish to mark these timesheets as Processed place a check in the check box for “Also mark selected timesheets as processed”.
9.Click Close

ADDITIONAL NOTES

Marking the timesheets as Processed in the Export to QuickBooks process will enable
correction timesheets to be generated. Do NOT mark as processed until you are
completely done with the period. Once you mark timesheets as processed, you won’t be
able to export additional files for the same period.

Custom Export [Video clip]