1. Deltek Learning Hub
  2. Timesheet Interfaces
  3. Export Timesheets
Timesheet Interfaces

Export Timesheets

Export approved or in-process timesheets to a Costpoint labor or payroll staging table for downstream cost accounting and payroll processing.

Export timesheets sends processed timesheet data from Time & Expense into Costpoint labor or payroll staging tables. Run this task at the end of a timesheet period after timesheets are approved and processed. The export uses the Labor Distribution and Manage Payroll values configured on the Manage Timesheet Classes screen.

Prerequisites

  • Timesheets must already be processed on the Export Timesheets screen
  • Timesheets must be approved, or your timesheet class must allow in-process exports
  • A unique 10-character Batch ID
  • Costpoint company access if Multicompany is enabled

How to Open

Go to Time & Expense > Timesheet Interfaces > Export Timesheets.

Steps

  1. In the Timesheets field, select the timesheet status to export: Approved, In-Process with Signed, or In-Process without Signed.
  2. Enter a unique identifier in the Batch ID field.
  3. Select the Costpoint Company if Multicompany is enabled.
  4. Set the export options for Labor Distribution or Payroll based on your timesheet class configuration.
  5. Select timesheet periods, employee groups, and timesheet classes in the selection tables.
  6. Click Process to collect the timesheet data and update the staging tables.
  7. Click Export to write the collected data to the target staging tables.

Common Use Cases

  • End-of-period payroll export: Send approved timesheets to the payroll staging table for the pay run.
  • Mid-period labor cost capture: Export in-process timesheets to update labor distribution while a period is still open.
  • Subcontractor billing: Use Subcontractor Export to isolate subcontractor timesheets for prime contractor invoicing.

Best Practices

  • Process timesheets before exporting; you cannot export unprocessed timesheets.
  • Use a descriptive Batch ID. The export filename is derived from it.
  • Save default values once your export configuration is stable to speed up routine runs.
  • Verify the Costpoint Company selection in Multicompany environments to avoid sending data to the wrong company.
  • Process Timesheets in Deltek Time
  • Export Timesheets Screen Reference in Deltek Time
  • Timesheet Interfaces Overview in Deltek Time