🎉 New mobile experience now live for all employee iOS & Android users! See what's new

Export Work Order Capture Data

Prev Next

The Timesheet Daily Summary Export includes Work Order Capture data so Project Number and Work Order Number can be used for payroll, billing, job tracking, or reporting.

Before you begin

  • Work Order Capture must be enabled and configured.

  • Employees must have recorded Project Number and/or Work Order Number values on their time segments.

Export Work Order Capture fields

The export includes the following additional columns:

  • Project Number

  • Work Order Number

If a value was not entered, the corresponding field is exported as a blank cell.

How exported hours are grouped

Rows are grouped by employee, date, Project Number, and Work Order Number.

  • Time segments with the same Project Number and Work Order Number are combined into a single row.

  • Different Project Number and Work Order Number combinations are exported as separate rows.

  • Blank values are treated as blank fields in the export.

Example

Time Segments

Export Result

  • 9:00 AM–11:00 AM
    Project Number: 132435
    Work Order Number: 1245

  • 1:00 PM–3:00 PM
    Project Number: 132435
    Work Order Number: 1245

One exported row with 4 total hours.

  • 3:00 PM–5:00 PM
    Project Number: 132435
    Work Order Number: 7788

A separate exported row with 2 hours.