Skip to main content

Wage & Hour Export

Exporting from DSPTCH​

To access the Wage & Hour export, first navigate to the job you want to export data for.  From there, go to the "Compliance" tab in the primary navigation bar at the top of the page, and click "Wage Determination" on the side menu. On that page there will be a "Tabulate" button next to the "+ New Wage Determination" button.

See the video below for a demonstration:

Demo of navigating to the Compliance tab, clicking Wage Determination, and using the Tabulate button

Clicking the "Tabulate" button will open a tabular view of the Wage & Hour export.

Wage and Hour Export tabular view for Job #9153 showing columns for payroll_number, week_end_date, and class_code

The table displays data for the entire job by default. Since LCPtracker only accepts one week at a time, the data must be filtered to the desired week before exporting.

To do so, click on the "Filters" button on the left hand side menu (indicated by the red box and arrow in the image below). This will pull up some options of columns you can filter by.

Wage and Hour Export table with the Filters panel highlighted showing week_end_date and class_code filter options

The two important filters are "week_end_date" and "class_code."

week_end_date will be necessary to export a single week of data. Select the checkbox of the week that data is being exported from

class_code can be very useful for a job with a mix of PWA and non-PWA workers. De-selecting (Blanks) will exclude workers that are not PWA.

Filter panel showing week_end_date date checkboxes and class_code options with a specific week and class highlighted

Filter options - "week_end_date" and "class_code" are useful for exporting the data you need.

Once the table is filtered as necessary, export the data by clicking the "Exports" button in the menu on the left side of the page (indicated by the red box in the image below) and choosing "to Excel" under "Export all rows" (indicated by the green box in the image below).

Wage & Hour Exports panel with the to Excel option highlighted in a green box under Export all rows

It is important to use "to Excel" for the Wage & Hour export as that is what LCPtracker expects.

Uploading exports to LCPtracker​

Once the export is downloaded, upload it to LCPtracker by following these steps:

  1. Login to LCPtracker and navigate to the "1. Payroll Records" tab
  2. Click "Upload Records"
  3. Choose the week end date, project and location sections
    1. If there is payroll data syncing with DSPTCH, leave the "Calculate fringes automatically" box un-checked
  4. Choose the file downloaded from DSPTCH to upload
  5. Hit the "Upload" button

LCPtracker Payroll Records page with the 1. Payroll Records tab and Upload Records button highlighted in red boxes

Example of LCPtracker screen, steps 1. and 2.

LCPtracker Upload Records form showing week end date, project, location, and file fields with the Upload button highlighted

Example screen for steps 3., 4. & 5.

After clicking the "Upload," button a progress bar should appear with records being uploaded and verified. Upon success, a screen will open to Craft Match or Edit the uploaded records.

For more information about how to Craft Match or Edit, please refer to LCPtracker's Documentation

We have seen the upload process run into errors when using the Microsoft Edge browser. If you are getting errors when uploading, try uploading while using Google Chrome.

LCPtracker Uploading Payroll dialog showing progress bar and Creating Record 1 of 9 status message

Example progress bar

LCPtracker Upload Results dialog showing 9 rows accepted

Example upload success message

LCPtracker Edit Uncertified Payroll Records screen showing uploaded entries with Craft Match, Edit, and Delete actions

Example Payroll Record screen