GPS vs Timesheet Report

Settings

Header Branding

Title

Subtitle

Footer

Footer text

Upload Instructions

Text shown below each upload card to help users locate the files.

Timesheet Export - where to find it

Trips Report - where to find it

Waste Calculation

Hourly rate ($)

Shift day ends at (cutoff)

Any GPS activity before the cutoff time is attributed to the previous shift day. Overnight rows with times crossing midnight appear on the Overnight tab with the date shown next to the time.

Active Groups

Names must exactly match the GROUP column in your Trips Report.

Driver / Van Assignments

Van #	Driver Name

CSV: column 1 = Van # (e.g. #23 or 23), column 2 = Driver name

GPS vs Timesheet - Daily Report

Dallas Service - Almcoe Austin - Tyler Service

Upload the Timesheet Export and Trips Report to compare clock-in/out times against GPS ignition data. Supports single-day or full-week files.

📋

Timesheet Export

Drag and drop or click - .xlsx

Timesheet_Default_Export.xlsx

🚐

Trips Report

Drag and drop or click - .xlsx

TRIPS_REPORT-xxxx.xlsx