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
- In the Timesheets field, select the timesheet status to export: Approved, In-Process with Signed, or In-Process without Signed.
- Enter a unique identifier in the Batch ID field.
- Select the Costpoint Company if Multicompany is enabled.
- Set the export options for Labor Distribution or Payroll based on your timesheet class configuration.
- Select timesheet periods, employee groups, and timesheet classes in the selection tables.
- Click Process to collect the timesheet data and update the staging tables.
- 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.
Related
- Process Timesheets in Deltek Time
- Export Timesheets Screen Reference in Deltek Time
- Timesheet Interfaces Overview in Deltek Time