Export Timesheets

Click Export on the Export Timesheets screen to update the appropriate staging tables with the collected timesheet information. You cannot export timesheets until they have been processed.   

If you selected the Labor Distribution option on the Manage Timesheet Classes screen for the selected employee's class, timesheet information is exported to the export labor staging table.

If you selected the Payroll option on the Manage Timesheet Classes screen for the selected employee's class, timesheet information is exported to the export payroll staging table.

Attention: Refer to the Deltek Time & Expense Technical Guide for details on this table.

In addition to writing records to the staging tables, the export does the following:

  • Exported hours are updated to equal the prorated hours on the timesheet cell.
  • Timesheet cell status is changed to "Processed" for approved timesheets or to "Sent" for in-process timesheets.
  • The timesheet cell batch ID is updated with the batch ID from this screen.
  • If all the timesheet cell records on a timesheet have a status of "Processed," the timesheet header status for that timesheet is changed to "Processed."
  • The timesheet header is marked as being available, and the batch ID on the header is cleared.

If the export process, including the transformation step, finishes normally, the message "Export completed successfully" appears.

If the export process finishes normally, timesheets for the current period export, and it is not the last period of the schedule, this confirmation message "Export completed successfully. Would you like to close the current period and make the next period the current period?" appears. If you click Yes, the current period is closed and the next period in the schedule is opened.

Note: Ten timesheet exports can run at the same time. If an eleventh user attempts to run an export, Time & Expense displays a message indicating that the maximum number has been exceeded and prevents the export from proceeding at that time.