No rule says you must buy software. Several say you must produce a record, in a form, inside a window — and that is the test that actually matters.
Key takeaways
The signal is not fleet size. It is the first time you cannot produce a required record, in the form required, inside the window required — and discover that the spreadsheet was never the system of record, just the last person who touched it. Nothing in Canadian law says a carrier must buy software. A great deal of it says a carrier must produce.
So the honest test is a production test. Pick a date eighteen months ago, pick a truck and pick a driver, and see how long it takes to assemble what an auditor would ask for. If the answer involves a person’s memory, you have your signal.
Most operators know one or two of these and are surprised by the rest. Taking British Columbia’s regulations as the clearest written example, a carrier must maintain at its principal place of business a transcript of the driving record of each driver, dated the later of the driver’s date of engagement and one year from the date of the previous transcript; copies of the records required by the laws of any jurisdiction respecting the use of commercial motor vehicles by each driver; records of notification of accidents, violations or convictions for each driver; inspection and maintenance records for each vehicle; manufacturer defect notices and evidence the defects were corrected; records of accidents resulting in injury, death, or total property damage including cargo of $1,000 or more; and any safety plan and scheduled maintenance plan. The driver’s side has its own deadline: the driver must deliver accident, violation and conviction records to the carrier within 15 days.
Those records must be kept readily accessible for inspection and audit purposes for the calendar year in which they were made and the following 4 calendar years. Trip inspections run on a shorter clock: the report is placed at the carrier’s principal place of business within 30 days of receipt and the original kept for at least 3 months. Non-compliance notices run on another: the notice and the driver’s signed acknowledgement are retained for 6 months from the date the non-compliance occurred.
Federal hours-of-service records add two more. A driver forwards each record of duty status and its supporting documents to the home terminal within 20 days, and the motor carrier deposits them at its principal place of business within 30 days of receipt and keeps them in chronological order for each driver for at least 6 months. The carrier must also monitor the compliance of each driver and record the dates of non-compliance and the action taken.
Then the tax layer, which is longer than all of them. Books and records must be kept until the expiration of six years from the end of the last taxation year to which they relate, and where they are kept electronically they must be retained in an electronically readable format for that period. The GST/HST side requires records to be kept in Canada in English or in French unless otherwise authorised and retained until the expiration of six years after the end of the year to which they relate, likewise in an electronically readable format where kept electronically. In Ontario there is a fast clock on top: you are required to submit any changes to your information within 15 days, including corporate officers, legal name and business addresses.
A spreadsheet is not illegal
There is no rule requiring a database. What there is, is a requirement that the record exists, is accurate, is kept for a stated period, and is readily accessible for inspection and audit. A spreadsheet can satisfy all four for a two-truck operation. What it cannot do is tell you who changed a cell, stop two people editing at once, or notice that a driver transcript is now thirteen months old.
1. No audit trail. A cell changes and nothing records who or when. This is survivable until the first dispute, at which point it is the whole problem.
2. Concurrency. Two people open the file, one saves over the other, and the loss is silent. Every fleet discovers this at the worst possible moment.
3. Nothing watches the clocks. The transcript that needed refreshing at one year from the date of the previous transcript is fourteen months old and nobody noticed, because a spreadsheet does not raise its hand.
4. The record is not where the rule says it is. Trip inspection reports in a truck’s cab rather than placed at the principal place of business within 30 days. Tax records on a foreign cloud drive rather than kept in Canada.
5. Retrieval time. “Readily accessible” is doing real work in the retention provision. Four calendar years of files in a folder tree that only one person understands is a retrieval problem that becomes a compliance problem on the day that person is away.
A nine-truck British Columbia carrier. Records made in 2026 must stay readily accessible for the calendar year in which they were made and the following four — 2027, 2028, 2029 and 2030 — so they cannot be discarded before 31 December 2030. Tax records for the 2026 taxation year run six years from the end of that taxation year, into 2032. Trip inspection reports for the same fleet are held at least 3 months, and records of duty status at least 6 months. That is four different retention clocks over one nine-truck fleet, and the shortest one is generating the most paper.
The volume makes the point. Nine trucks doing a pre-trip and a post-trip inspection five days a week produce 9 × 2 × 5 = 90 reports a week. Across the roughly 13 weeks of a three-month retention window that is 90 × 13 = 1,170 reports that must be findable at any moment. A spreadsheet index to 1,170 pieces of paper is not a system of record; it is a list of where the paper was last seen.
None of that means the fleet needs an expensive platform. It means the fleet needs something that stores the document, stamps who filed it, knows its retention date, and can answer “show me every trip inspection report for unit 407 in March” without a person walking to a cabinet.
In order: the records with the shortest clock and the highest inspection likelihood. Trip inspection reports and records of duty status first, because they are high volume, short-retention and the ones an audit reaches for. Driver files second, because the one-year transcript refresh is the classic silent lapse. Maintenance history third. Tax records last — not because they matter least, but because your accounting software is probably already holding them in a form that satisfies the electronically readable requirement.
If you are weighing platforms rather than clocks, the note on dispatch software for trucking companies covers the selection question, and this piece on where AI pays off first in a freight operation covers sequencing.
This is document work, which is what these tools are actually good at. Reading a scanned trip inspection report or work order into structured fields so it files itself against the right unit and date. Watching every retention and refresh clock at once — three months, six months, fifteen days, one year, the calendar year plus four, six years — and naming what is about to lapse. Assembling an audit pack for a date range without a person opening folders. Reconciling records of duty status against supporting documents so the carrier’s verification and monitoring duties are discharged in fact.
It does not decide whether a defect is major, whether a driver is compliant, or whether a record satisfies an auditor. A person reads, decides and signs.
No. The obligations are about the record, not the tool. What changes with size is the probability that a spreadsheet fails one of the four requirements — exists, accurate, retained, readily accessible — on any given day.
It is not defined as a format. British Columbia requires the records to be kept readily accessible for inspection and audit purposes for the retention period, and gives an inspector the right to attend where they are maintained. Paper in an indexed cabinet can meet that. Paper in three trucks and a home office generally does not.
It varies by record, which is part of the problem. British Columbia requires carrier records at the principal place of business in British Columbia or another place approved in writing by the director. Federal records of duty status are deposited at the carrier’s principal place of business within 30 days. GST/HST records must be kept in Canada in English or in French unless the Minister authorises otherwise — worth checking against wherever your accounting data is actually hosted.
The driver file, because it has a refresh obligation rather than just a retention one. A transcript dated the later of the driver’s engagement date and one year from the previous transcript quietly ages out, and nothing in a spreadsheet says so.
A 30-minute call is enough to tell you whether AI pays for itself in your back office.
