Time: Wage & Hour Upload

Table of Contents

Navigating to the Time Cards Page

To navigate to the "Time Cards" page, click the "Time" tab from the primary navigation bar at the top of the page. This will open a list of all users in your company and their time entries for a given pay period. To open a different pay period use the forward or back arrow at the top right of the screen or click the date range to open a dropdown menu of all available pay periods.

See the video below for a demonstration:

Creating a Wage & Hour Import

From the "Time" page, click the "New Import" button and then select "+ New Wage & Hour Import" from the dropdown menu. This will open the "New Import" page. Then, drag and drop the file into the field or click the "CHOOSE FILE" button and select the applicable wage & hour template file. Lastly, click "Continue" and allow DSPTCH a few moments to process the import.

See the video below for a demonstration:

Once the upload is successful, it may take a few minutes for the wage & hour import data to appear in DSPTCH.

Wage & Hour Import Template

DSPTCH only accepts a strict file format for the wage & hour import.

Download the wage & hour import template here.

There are several fields included in the wage & hour import template:

  • payroll_number
    • Leave blank
  • project_code
    • External ID of applicable job in DSPTCH, specified when creating or editing a job
  • contract_id
    • Unsupported value will be ignored
  • work_order
    • Unsupported value will be ignored
  • week_end_date
    • Final date of the applicable pay period in DSPTCH, format YYYY-MM-DD.
  • check_num
    • Unsupported value will be ignored
  • ssn
    • Unsupported, value will be ignored
  • employee_ID
    • Payroll ID in DSPTCH, this is specified on the user's profile, specific to their employment with your company.
  • class_code
    • Unsupported, value will be ignored
  • gross_employee_pay
    • Total paid to the employee for time worked on the job
  • all_projects
    • Total taxable earnings across all time worked in the week, including earnings not on the specified Job. Frequently equivalent to "Gross Pay" on paystub
  • wages_paid_in_lieu_of_fringes
    • Total cash paid to worker in lieu of required fringes
  • total_paid
    • Total earnings for the worker in the week, after all payments, taxes, and deductions are incorporated, frequently equivalent to "Net Pay" on the worker's paystub
  • st_hrs_date1
    • Straight time (1x) hours worked on the first day of the pay period, on the job
  • st_hrs_date2
    • Straight time (1x) hours worked on the second day of the pay period, on the job
  • st_hrs_date3
    • Straight time (1x) hours worked on the third day of the pay period, on the job
  • st_hrs_date4
    • Straight time (1x) hours worked on the fourth day of the pay period, on the job
  • st_hrs_date5
    • Straight time (1x) hours worked on the fifth day of the pay period, on the job
  • st_hrs_date6
    • Straight time (1x) hours worked on the sixth day of the pay period, on the job
  • st_hrs_date7
    • Straight time (1x) hours worked on the seventh day of the pay period, on the job
  • ov_hrs_date1
    • Overtime (at 1.5x) hours worked on the first day of the pay period, on the job
  • ov_hrs_date2
    • Overtime (at 1.5x) hours worked on the second day of the pay period, on the job
  • ov_hrs_date3
    • Overtime (at 1.5x) hours worked on the third day of the pay period, on the job
  • ov_hrs_date4
    • Overtime (at 1.5x) hours worked on the fourth day of the pay period, on the job
  • ov_hrs_date5
    • Overtime (at 1.5x) hours worked on the fifth day of the pay period, on the job
  • ov_hrs_date6
    • Overtime (at 1.5x) hours worked on the sixth day of the pay period, on the job
  • ov_hrs_date7
    • Overtime (at 1.5x) hours worked on the seventh day of the pay period, on the job
  • ov_hrsx2_date1
    • Overtime (at 2x) hours worked on the first day of the pay period, on the job
  • ov_hrsx2_date2
    • Overtime (at 2x) hours worked on the second day of the pay period, on the job
  • ov_hrsx2_date3
    • Overtime (at 2x) hours worked on the third day of the pay period, on the job
  • ov_hrsx2_date4
    • Overtime (at 2x) hours worked on the fourth day of the pay period, on the job
  • ov_hrsx2_date5
    • Overtime (at 2x) hours worked on the fifth day of the pay period, on the job
  • ov_hrsx2_date6
    • Overtime (at 2x) hours worked on the sixth day of the pay period, on the job
  • ov_hrsx2_date7
    • Overtime (at 2x) hours worked on the seventh day of the pay period, on the job
  • Total_Hours_All_Projects
    • The total number of hours the employee worked during the pay period across all projects and pay rates.
  • ep_haw
    • Total fringe contributions paid on behalf of the employee toward health and welfare benefits for the pay period
  • ep_pension
    • Total fringe contributions paid on behalf of the employee toward pension benefits for the pay period
  • ep_vac_hol
    • Total fringe contributions paid on behalf of the employee toward vacation, holiday, or dues-related benefits for the pay periodp
  • ep_train
    • Total fringe contributions paid on behalf of the employee toward training programs for the pay period
  • ep_all_other
    • Total fringe contributions paid on behalf of the employee toward any other qualifying fringe benefits not otherwise specified, for the pay period
  • vol_cont_pension
    • Total pension contributions paid by the employer on behalf of the employee across all projects for the pay period
  • vol_emp_pay_med
    • Total medical contributions paid by the employer on behalf of the employee across all projects for the pay period
  • dts_fed_tax
    • Total value of deductions for federal income tax withholding
  • dts_fica
    • Total value of deductions for Social Security contributions
  • dts_medicare
    • Total value of deductions for Medicare. A combined FICA amount (i.e., both Social Security & Medicare) deductions is acceptable
  • dts_state_tax
    • Total value of deductions for state income tax
  • dts_sdi
    • Total value of deductions for state and local taxes, excluding state income tax
  • dts_dues
    • Total value of deductions for union dues
  • dts_savings
    • Total value of deductions for savings such as 401(k) or other pension schemes
  • dts_other
    • Other deductions not otherwise enumerated
  • dts_total
    • Total amount of deductions
  • trav_subs
    • Non-taxable per diem payments under IRS ยง 274(d), and other travel / subsistence payments
  • pay_rate
    • Hourly rate of pay
  • OT_rate
    • Hourly rate of pay for overtime hours
  • 2OT_rate
    • Hourly rate of pay for double overtime hours
  • prnotes
    • Unsupported, value will be ignored
  • Payment_date
    • Unsupported, value will be ignored
  • first_name
    • Unsupported, value will be ignored
  • last_name
    • Unsupported, value will be ignored
  • address1
    • Unsupported, value will be ignored
  • address2
    • Unsupported, value will be ignored
  • city
    • Unsupported, value will be ignored
  • state
    • Unsupported, value will be ignored
  • ZIP
    • Unsupported, value will be ignored
  • phone
    • Unsupported, value will be ignored
  • gender
    • Unsupported, value will be ignored
  • ethnicity
    • Unsupported, value will be ignored
  • apprentice_id
    • Unsupported, value will be ignored
  • craft_id
    • Unsupported, value will be ignored
  • vac_hol_dues_rate
    • Unsupported, value will be ignored
  • emp_ep_haw
    • Unsupported, value will be ignored
  • emp_ep_pension
    • Unsupported, value will be ignored
  • emp_ep_other
    • Unsupported, value will be ignored
  • training_rate
    • Unsupported, value will be ignored
  • vol_cont_pension_rate
    • Unsupported, value will be ignored
  • vol_cont_medical_rate
    • Unsupported, value will be ignored
  • in_lieu_payment_rate
    • Unsupported, value will be ignored
  • vac_chk_box
    • Unsupported, value will be ignored
  • fringe_paid_chk_box
    • Unsupported, value will be ignored
  • date_hired
    • Unsupported, value will be ignored
  • emp_status
    • Unsupported, value will be ignored
  • work_county
    • Unsupported, value will be ignored
  • IsForeman
    • Unsupported, value will be ignored
  • IsDisadvantaged
    • Unsupported, value will be ignored
  • VeteranStatus
    • Unsupported, value will be ignored
  • OtherDeductionNotes
    • Unsupported, value will be ignored
  • num_exempt
    • Unsupported, value will be ignored
  • DriversLicense
    • Unsupported, value will be ignored
  • DriversLicenseNumber
    • Unsupported, value will be ignored
  • Owner_Operator
    • Unsupported, value will be ignored
  • I9Verified
    • Unsupported, value will be ignored
  • Geographic_Ward
    • Unsupported, value will be ignored
  • Geographic_Area
    • Unsupported, value will be ignored
  • Congressional_District
    • Unsupported, value will be ignored
  • State_Senate_District
    • Unsupported, value will be ignored
  • OD_Category
    • Unsupported, value will be ignored
  • OD_Type
    • Unsupported, value will be ignored
  • OD_Amount
    • Unsupported, value will be ignored
  • FringesProvidedByEmployer
    • Unsupported, value will be ignored
  • LocalUnionNumber
    • Unsupported, value will be ignored
  • YTD_SickPayTime
    • Unsupported, value will be ignored
  • Email
    • Unsupported, value will be ignored
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us