TM+ TimeClock → Exports

Upload your TimeClock Daily Summary and generate a TM+ Labor export plus a Crew Sheet export.

Time and Material • Labor
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.

No file selected.
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.

When enabled, your Crew Sheet Project Information is stored in this browser and auto-fills next time.
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...
Preview (mapped rows) — editable
Total Reg. Hours: 0.00
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.
4. Mapping
Mapping rules used to convert TimeClock into TM+ exports.
CLICK TO COLLAPSE
TimeClock → TM+ Labor Export (per labor row)
1
Employee → Name
2
Title → Work Description
The value in Work Description is used to derive the coded Title value in the TM+ export.
3
Work Description → Title
Exported as a coded value: SUPV / TL / CLK / TECH / RSKLBR / GENLBR
4
Start Date → Date
Normalized to mm/dd/yyyy.
5
Clock In → Time In
Exported as the original string value.
6
Clock Out → Time Out
Exported as the original string value.
7
Breaks → Time Lunch
Stored as decimal hours. May be auto-computed when time range exceeds reported hours.
8
Hours Worked → Reg. Hours
Numeric and editable in the preview table.
9
Vehicle/Vehicles → Vehicle
If the column is present in the import, the value is carried into the export.
10
Vehicle Requirement Rule → Vehicle = Van
Inserts Van for 1 out of every 15 people (rounded up). Priority selection: Supervisor → Team Lead → Restoration Skilled Labor → Clerk.
11
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)
1
Employee → Role / Name
2
Title → Labor Class Code
Current behavior exports the raw Title text into Labor Class Code.
3
Clock In → Start Time   |   Clock Out → End Time
Converted to Excel time serial and formatted as h:mm AM/PM.
4
Breaks → Breaks (hrs)
Decimal hours (General format).
5
Vehicle/Vehicles → Vehicle
6
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

© 2026 TM+ Solutions – Export Utility → Patent Pending Designed for use with TM+ Bill