Loading...

Exporting Timesheet Data to QuickBooks Desktop

You are here:

Timesheet data created in Hour Timesheet can be exported to your accounting/payroll software.  To export data from Hour Timesheet, follow the instructions below:

 

Hour Timesheet Export screenshot

 

  1. Login to your Hour Timesheet login page as user with admin or accountant rol
  2. Navigate to the Export Timesheet menu item
  3. Place a check in the box next to the timesheet(s) that you would like to export
  4. Click the Export Selected button to begin the sync process.
  5. A pop-up box will appear confirming the records to be exported.
  6. Click the Export button to complete the export process request

 

conf export popup box screenshot

 

NOTE: At this point the web connector will run at its auto scheduled time, if a time increment for syncing data has not been set, you will need to  open the web connector file and force the update so that the payroll export created above can be imported into QuickBooks Desktop. YOUR QUICKBOOKS COMPANY FILE MUST BE OPEN FOR THE WEB CONNECTOR TO RUN SUCCESSFULLY.  To force the update between Hour Timesheet and QuickBooks Desktop follow the steps below.

  1. Locate and open the Web Connector on your computer
  2. Place a check next to the Hour Timesheet Application
  3. Click the Update Selected

Best Practice – check the Auto-Run box next to the Hour Timesheet application and set the Every_Min to “60”. This will ensure that your QuickBooks and Hour Timesheet file is synced every 60 minutes. You will need to save the Hour Timesheet password in the Web Connector as well.

web connector screenshot

 

Once the data has been imported to your QuickBooks Desktop file, you will receive an email confirmation message containing the a summary of the information in the export file

 

export email conf screenshot

 

For troubleshooting issues visit Reasons Why Timesheet Data Fails to Export


Back to Knowledge Base Main