Generate a compliance/audit report
Build a compliance and audit trail in Upper from the Route Plan Detailed Report, the Driver Timesheet Report, and a driver's actual route path.
An audit rarely turns on a single number — it turns on proof: that a stop was completed, that the driver was on shift, and that the route was actually run. Upper holds the data for each of those questions across Analytics and Live Tracking. This guide shows you how to pull the three pieces together into one audit trail.
This guide uses the default driver / delivery labels. Your workspace may instead show technician / service (for example, the "Driver Timesheet Report" may read "Technician Timesheet Report"). The label is configurable per workspace — the steps are the same.
The three pieces of an audit trail
| Question an audit asks | Where Upper answers it |
|---|---|
| Was the stop completed, with proof? | Route Plan Detailed Report (one row per stop) |
| Was the driver on shift when expected? | Driver Timesheet Report (clock in/out, shift duration) |
| Did the driver follow the route? | A driver's actual path in Live Tracking |
Before you start
- Retention window — Upper keeps historical data per plan: Starter 6 months, Professional 1 year, Optimize 2 years, Enterprise custom. Once data passes your window it is deleted permanently and can't be recovered, so pull exports before it ages out. See Data retention policy.
- Report availability — The Summary and Detailed reports are available to everyone. The Driver Timesheet Report appears in the View by list only when your workspace has shift-hours tracking enabled.
Delivery compliance (proof of delivery)
The Route Plan Detailed Report has one row per stop, which makes it the backbone of a delivery audit.
Open Analytics
In the left sidebar, go to Track → Analytics.
Choose the Detailed report
From the View by dropdown, select Route Plan Detailed Report.
Filter to your audit period
Open the Filter panel and set the Date Range to your audit window. Narrow further with Select Route Plan, Drivers, Route Plan Status, and Stop Status (All, Success, Fail) as needed, then click Apply.
Pick the compliance columns
Click the Customize Columns icon to open the Edit Column modal. Check the columns that prove the delivery, and drag to reorder:
- Stop Address, Start At, Arrive At, Completion Time
- Stop Status, Reason
- Notes From Driver
- Photo, Signature
- Latitude, Longitude, Attempted Lat, Attempted Long
Click Done. Your column choices are saved for this report.
Export the record
Click Export. In the Export modal, set the Export File Name, choose a Format (CSV or XLS), and use the Default or Custom field tab to confirm which fields are included. Optionally tick Send e-mail when Export is complete, then click Start Export.
Driver hours compliance
For shift and hours records, use the Driver Timesheet Report. It has fixed columns: Driver Name, Date, Clock In, Clock In Location, Clock Out, Clock Out Location, Shift Duration, and Status. The location entries link out to a map at the clock-in/out coordinates.
Open the Timesheet report
Go to Track → Analytics, then choose Driver Timesheet Report from View by.
Filter by driver and period
Open the Filter panel, set the Date Range and Drivers, optionally set Status (Clocked In / Clocked Out), and click Apply.
Export
Click Export, choose CSV or XLS, and click Start Export.
If the Driver Timesheet Report isn't in the View by list, shift-hours tracking isn't enabled for your workspace. Contact us at support@upperinc.com to turn it on.
Route adherence
Where an audit also needs to show how a driver got from stop to stop, review the actual path the driver drove. In Track → Live Tracking, turn on Show Actual Path to draw the driven line over the planned route, and read each driver's stop timings from the Detailed Report. For the full dispatcher-facing walkthrough, see Audit driver activity and route adherence. Combined with the Detailed Report export, this gives you both what was delivered and how the route was run.
After your plan's retention window, Upper deletes historical data permanently and it can't be recovered. For multi-year compliance requirements, schedule recurring exports to your own storage before the data ages out.
Common scenarios
- Quarterly contract audit — Route Plan Detailed Report for the period, filtered to that customer's route plans, exported with the proof columns (Photo, Signature, Notes From Driver, Completion Time, Stop Status, timestamps). Pair it with the Driver Timesheet Report for the same period.
- Insurance audit on an incident — Export the Detailed Report for the date, driver, and route, then pair it with the driver's actual path in Live Tracking so the file shows both the delivery proof and the path taken.
- Internal monthly compliance review — Export the Detailed Report and Timesheet Report each month and archive them in your own storage to cover long retention horizons.
Need a custom format?
If your regulator or contract requires a specific layout the standard columns don't cover, contact us at support@upperinc.com or through in-app chat to discuss options.
Related
Generate a proof of delivery report
Proof of delivery data lives in Upper's Route Plan Detailed Report. Add the POD columns in Analytics, then export the report as CSV or XLS.
Generate proof of delivery reports
Pull proof of delivery records in Upper by filtering the Route Plan Detailed Report and exporting POD columns like Photo, Signature, and Completion Time.