Login
Driver ID · Free Excel log

Driver-ID login compliance log

Your ID reader knows which tag started each trip, or that none did. Paste the trips, and the log flags trips with no tag, unknown and inactive tags, shared tags and logins on the wrong vehicle, and tells you when the reader itself needs a check.

Get the Excel log (.xlsx)
Arabic version
Free: enter your name and e-mail and we send you the file. Works in Excel, Microsoft 365, Google Sheets and LibreOffice.
  • Tag register and trip log
  • Six exception types
  • Compliance by vehicle
What's inside

What is in the login log?

Eight sheets. You fill two: the tag register and the trip log. The rest is calculated.

  1. 01

    Tag register

    Tag ID as your platform reports it, driver, staff number, allowed vehicles, issue date and status: active, lost, returned or blocked.

  2. 02

    Trip log

    Date, vehicle, start and end time, distance and the tag read. Each trip gets the driver, the tag status and one exception, with columns for the cause and the action.

  3. 03

    By vehicle

    Trips counted, trips with a valid tag, each exception type, the compliance share against your target, and a reader-check flag.

  4. 04

    By tag

    For each tag: trips, shared-tag trips, wrong-vehicle trips and inactive-tag trips, with a follow-up flag.

  5. 05

    Summary

    Compliance for the period, each exception count, open exceptions and the vehicles whose reader needs a check.

  6. 06

    Settings, Start here and Lists

    Shortest trip that counts, your target and the reader-check share, with the color legend and the drop-downs.

Exception types

Six readings for every trip

Each trip gets one reading, in this order: not counted, no ID, unknown tag, inactive tag, shared tag, wrong vehicle, or OK.

  • Fine
  • Look again
  • Stop and act
ExceptionWhat the data showsCheck first
No IDTrip with no tag readDriver habit, then the readerMany drivers on one vehicle: the reader
Unknown tagTag not in the registerNumber format, then a missing row
Inactive tag usedLost, returned or blocked tag readWho holds the tag now
Shared tagSame tag on two vehicles at the same timeCopied or lent tags
Wrong vehicleTag outside its allowed vehiclesAn authorized swap, then the register
Not countedTrip shorter than your minimumNothing: yard moves
How it runs

From the platform export to the safety meeting

  1. Register the tags

    One row per tag, with the ID exactly as your platform shows it and the vehicles the driver may use.

  2. Paste the trips

    Export the trips for the week or month and paste date, vehicle, times, distance and tag.

  3. Review the exceptions

    Start with the vehicles flagged for a reader check, then talk to the drivers on the By tag sheet.

  4. Close and report

    Write the cause and the action, set Closed to Yes, and print the summary.

Why log tag logins?

Every report that names a driver depends on the tag read at the start of the trip. A trip with no tag cannot be assigned. A shared tag assigns it to the wrong person. A tag on a vehicle the driver is not set up for may mean a swap nobody approved. This log checks the login data before anyone uses it.

How is each trip read?

Not counted if distance < shortest trip that counts No ID if no tag was read Unknown tag if the tag is not in the register Inactive if the tag status is lost, returned or blocked Shared tag if the same tag is on another vehicle at an overlapping time, also across midnight Wrong vehicle if the plate is not in the tag's allowed list (ALL allows any) OK otherwiseCompliance = trips with a valid tag ÷ trips counted. Example: 7 of 17 trips = 41%.

The shortest trip that counts ships as 0.5 km, the target as 95 percent and the reader-check share as 60 percent. All three are typical values you replace with your own.

How are shared tags found?

A tag cannot be in two vehicles at once. The log compares each trip with every other trip of the same tag. If another vehicle has a trip that starts before this one ends and ends after this one starts, both trips show Shared tag. A trip whose end time is earlier than its start time ends the next day, so trips that cross midnight are compared too.

Is it the reader or the driver?

One driver forgetting a tag is a habit. Many drivers with no tag on the same vehicle points to the reader: its wiring, its connection to the device, or the device configuration. The By vehicle sheet flags a vehicle when its no-ID share reaches your reader-check value. Check the hardware before you talk to the drivers.

Why do tag numbers not match?

The number printed on a card, the number a reader sends and the number a platform shows can differ: decimal or hexadecimal, with or without leading zeros, or in reversed byte order. If a known driver shows as Unknown tag, convert the number before you blame the driver. The Driver-ID Card and Key Number Converter on this site does that.

Limits

The log works on the trips you paste. It does not read your platform, it does not prove who drove, and it does not cover driving hours or driver scores. Use it to clean the login data that those reports depend on.

Related Tracom solution

Make every trip start with a tag

A driver-ID reader wired to the tracker reports the tag with the trip. Ask Tracom how to set up the reader, the buzzer reminder and the tag format on your model so the log starts clean.

  • Advanced configuration files. The same reader settings on every vehicle.
  • Driver behavior monitoring with voice alerts. In-cab alerts the driver hears. Ask what your model supports.
  • Real-time SMS adjustments. Fix a reader setting without a visit.
  • Secure access and immobilization. Ask whether your model can tie access to a tag.
Questions

Driver-ID login questions

Setting up driver-ID readers? Talk to Tracom.

What counts as a compliant trip?

A counted trip with a tag that is in the register, active, not used on another vehicle at the same time, and allowed on that vehicle.

Why are short trips not counted?

Moves inside a yard or a workshop often happen without a tag. The file ignores trips under 0.5 km by default, a typical value you can change.

A driver may use any vehicle. What do I write?

Write ALL in Allowed vehicles. The wrong-vehicle check then never fires for that tag.

Many no-ID trips on one truck. Who is at fault?

Often the reader. If several drivers show no tag on the same vehicle, check the reader, its wiring and the device setup before you speak to the drivers.

Does this replace a driving-hours log?

No. It checks the logins that a driving-hours log or a driver report depends on. Hours and scores are separate tasks.

What is Tracom's role here?

Tracom makes the trackers that read driver tags and can help you set the reader up. The log works with any device. It does not decide who drove and it is not a disciplinary record.

Next step

Find the trips nobody can name

Get the log, paste last month's trips, and see which vehicles and tags need attention.

Contact Us Get the log
Related tools and templates

More for driver ID and safety

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Tracom uses your details to send what you requested and may contact you about it. See our privacy notice for your rights and how to delete your data.

Tracom is an advanced GPS tracking device designed to enhance fleet visibility, safety, and efficiency through real-time data, intelligent alerts, and remote monitoring.

Device

Help

Facebook Youtube Linkedin Instagram X-twitter

Copyright © 2026 SAFEE

Scroll to Top