Driver Violation Points Tracker Spreadsheet — Excel Free Template for 2026

Review Company Point Assumptions

Begin on Settings. The initial examples use a 36-month default tracking window, a 4-point Watch threshold, a 7-point High threshold, a 30-day upcoming-end warning, a 10-point override warning level, and a 20-point maximum override. Review the violation types, default points, and tracking months in rows 15 through 24, along with the status, corrective-action, and jurisdiction lists. The calculated Settings Check reports whether the numeric thresholds are logically ordered.

Replace the Sample Driver Roster

On Drivers, rows 5 through 12 contain eight populated sample drivers. Rows 13 through 104 provide 92 additional operating rows with blank input cells and prepared formulas. Enter or replace values in columns A through H: Driver ID, Driver Name, Status, Hire Date, License State, License Last 4, Supervisor, and Terminal. Columns I through N are calculated and should remain intact. They return tracked points, active violation counts, open or under-review counts, Risk Level, last violation date, and the driver record check.

Enter One Violation Per Record

Violations rows 5 through 14 contain ten sample records. Rows 15 through 504 add 490 prepared operating rows whose input cells are blank. Enter Violation ID, Driver ID, Violation Date, Violation Type, State/Jurisdiction, Citation/Reference, optional Point Override, Status, Disposition Date, Corrective Action, Fine Amount in U.S. dollars, and Notes. Driver Name and Default Points are looked up automatically. Applied Points uses the override when supplied; otherwise it uses the default. Tracking Months and Tracking End Date are calculated, while Active Points becomes zero for dismissed, future-dated, or expired records. Review the calculated Record Check before relying on totals.

Set the Dashboard Reporting Window

Enter valid dates in Reporting Period Start and Reporting Period End. The period check reports OK or Check dates. Dashboard outputs then summarize period violation count, non-dismissed points, recorded fines, counts and shares by violation type, and points per active driver. Separate current totals show active drivers, all-driver tracked points, Watch or High drivers, and records that are Open or Under Review.

Each violation type can have a default point value and tracking period in Settings. When a type is selected in the violation log, Excel retrieves those values. An optional override replaces the default for that record, subject to the configured maximum.

The tracking end date is the violation date plus the applicable number of tracking months. Current active points equal applied points unless the record is dismissed, dated in the future, or past its tracking end date. Driver totals add the active points associated with each Driver ID.

For active drivers, the risk calculation compares current tracked points with the Watch and High thresholds in Settings. Drivers who are not marked Active receive a Not Active risk result rather than Normal, Watch, or High.

Open and Under Review records are counted separately from violations that still carry points. This helps distinguish unresolved case status from point duration. Corrective Action options include None, Coaching, Written Warning, Refresher Training, Ride-Along Review, and Other.

The Dashboard reporting dates control period-based violation counts, non-dismissed point totals, recorded fine amounts, and the violation-type breakdown. Record count includes violations dated inside the selected period, while the points summary excludes records marked Dismissed.

A chart compares record counts across the ten violation types listed in Settings. Current active points by violation type are also displayed separately, so a period report does not replace the workbook’s current point view.

Validation restricts Driver IDs and Violation IDs to unique entries, violation dates to dates no later than today, and disposition dates to dates between the violation date and today. Driver and violation drop-downs draw from the workbook’s Settings and Drivers ranges.

Calculated checks can identify duplicate IDs, missing required fields, unknown drivers, future violation dates, and disposition-date problems. The Dashboard also summarizes violation record issues, driver record issues, duplicate IDs, tracking periods ending soon, and the settings result.