TM+ TimeClock → Labor Export

1. Upload TimeClock Daily Summary (.xlsx)

CLICK TO COLLAPSE

Required headers: Employee, Start Date, Clock In, Clock Out, Hours Worked. Optional supported: Title, Vehicle/Vehicles, Breaks.

📁 Select TimeClock File

No file selected. Additional uploads will be added to the existing list until Reset is used.

2. Crew Sheet Project Information Section

CLICK TO COLLAPSE

Fill out the crew sheet project information below. This will be part of the export for Daily Crew Sheet conversion. If no data is entered it will cause the Project Information to be blank on the Daily Crew Sheet.

Project Name

Project Location

Project Number

Project Manager

Loss Type

Date (mm/dd/yyyy)

Assignment

Crew Sheet Filled Out By

Save Details for Next TimeClock Import

When enabled, your Crew Sheet Project Information is stored in this browser and auto-fills next time.

Export / Import Project Profile lets the same Crew Sheet Project Information move with the user to another computer.

The Date field auto-populates from the first Start Date found in the imported TimeClock file and is forced into mm/dd/yyyy.

3. Preview & Export

CLICK TO COLLAPSE

Waiting for file...

TM+ Export Scope

Full Export Labor Without Travel Travel Only

Choose Full Export or a filtered export group. Labor Without Travel excludes travel rows from the export without changing Travel selections. Hotels can be edited or cleared in the preview before export.

Preview (mapped rows) — editable

Import Date: —

Total Reg. Hours: 0.00

No travel controls available until data is loaded.

No data loaded yet.

Hotels

CLICK TO COLLAPSE

Hotel rooms are calculated from the imported TimeClock labor classes using the required rules.

Import a file to calculate hotel rooms.

Labor Class	Headcount	Rule	Rooms	Calculation
Import a file to calculate hotel rooms.

4. Mapping

Mapping rules used to convert TimeClock into TM+ exports.

CLICK TO COLLAPSE

TimeClock → TM+ Labor Export (per labor row)

Employee → Name

Title → Work Description

The value in Work Description is used to derive the coded Title value in the TM+ export.

Work Description → Title

Exported as a coded value: SUPV / TL / CLK / TECH / RSKLBR / GENLBR

Start Date → Date

Normalized to mm/dd/yyyy.

Clock In → Time In

Exported as the original string value.

Clock Out → Time Out

Exported as the original string value.

Breaks → Time Lunch

Stored as decimal hours. May be auto-computed when time range exceeds reported hours.

Hours Worked → Reg. Hours

Numeric and editable in the preview table.

Vehicle/Vehicles → Vehicle

If the column is present in the import, the value is carried into the export.

Vehicle Requirement Rule → Vehicle = Van

Inserts Van for 1 out of every 15 people (rounded up), assigned to the first person in each 15-person group (no priority list).

Defaults → Small Tools = No, Per Diem = (blank unless Yes), PPE = No, PRP = No, PFP = No

Additional defaults: Prev Wage / Lodging / Travel / PPE / PRP / PFP / Manager / Taxes = No, PR Hours = 0, Mileage = 0, Sort Value = 0.

Work Description → TM+ Title Code

Supervisor → SUPV

Team Lead → TL

Clerk → CLK

Technician → TECH

Restoration Skilled Labor → RSKLBR

General Labor → GENLBR

TimeClock → Crew Sheet Export (per labor row)

Employee → Role / Name

Title → Labor Class Code

Current behavior exports the raw Title text into Labor Class Code.

Clock In → Start Time | Clock Out → End Time

Converted to Excel time serial and formatted as h:mm AM/PM.

Breaks → Breaks (hrs)

Decimal hours (General format).

Vehicle/Vehicles → Vehicle

Defaults → Small Tools = No, PPE = No, PRP = No, PFP = No

Mileage and Hotel are exported blank in the Crew Sheet export.

Crew Sheet Project Info → Crew Sheet Export (first labor row only)

Project Name → Project Name

Project Location → Project Location

Project Number → Project Number

Project Manager → Project Manager

Loss Type → Loss Type

Date (mm/dd/yyyy) → DAY/DATE

Assignment → Assignment

Crew Sheet Filled Out By → Crew Sheet Filled Out By

5. Headers in the Export Files

File names, sheet names, and the exact header lists used for each export.

CLICK TO COLLAPSE

TM+ Labor Export

Output Details

File → TM+_Labor_Export_from_TimeClock.xlsx

Sheet → TM+ Labor Export

What This Contains

One row per labor entry, formatted for TM+ Labor Import. Includes coded Title, Reg. Hours, optional Vehicle, and default compliance fields.

Headers

Crew Sheet Export

Output Details

File → Crew_Sheet_Export_from_TimeClock.xlsx

Sheet → Crew Sheet Export

What This Contains

One row per labor entry. Time columns export as Excel time serials and render as h:mm AM/PM. Project info fields populate on the first labor row only.

Headers

Hotel Rooms Report

Output Details

File → TM+_Hotel_Rooms_Report.xlsx

Sheet → Hotel Rooms Report

What This Contains

Summary report showing room totals by labor class using the required calculation rules. Includes a calculation column for audit clarity.

Headers