Loading...

Exporting Timesheet Data (CSV File)

Exporting Timesheet Data Using a 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.

  1. Login to your Hour Timesheet login page as user with admin or accountant role
  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

Custom Export [Video clip]

Back to Knowledge Base Main

ADP Integration

Saving ADP Exporting Settings (A One-time Requirement)

Timesheet data created in Hour Timesheet can be exported to ADP using a csv file.  To export data from Hour Timesheet, follow the instructions below.

  1. Login to your Hour Timesheet login page as user with admin or accountant role
  2. Navigate to the Export/Payroll Settings menu item
  3. Complete the Payroll Settings data fields
    • Payroll System – Select ADP
    • File Identifier – Hour Timesheet will create a unique file name for you
    • Pay Frequency – Select from Weekly, Bi-weekly, Semi-monthly or Monthly
    • Enter the Company Code/Client Code
    • If additional mapping is required, select the field that maps to the Pay Types in ADP from the Earning Code/Pay Type Mapping drop down provided
    • Click Save

ADP Export Settings screenshot

Exporting Timesheet Data to ADP

  1. Navigate to the Export/Payroll Settings menu item
  2. Place a check in the box next to the timesheet(s) that you would like to export
  3. Click the Export Selected button to begin the sync process.
  4. A pop-up box will appear confirming the records to be exported.
  5. Click the Export button to complete the export process request

Custom Export [Video clip]