A fleet manager can hand seven jobs to AI beyond service and fuel reminders: a driver licence register, accident forms, insurance renewal packs, repair quote comparisons, penalty notice matching, vehicle replacement cases and the monthly board report. AI drafts and sorts; you check the figures, and a person owns every decision.
Service dates and fuel cards are the obvious jobs, and they have their own tutorial. The seven here are the ones that pile up around them: they involve people's records, outside parties and money, which is why they take time and why a careless draft does damage. For that reason each job below comes with a plain check, and the order runs from the safest to start with to the one that needs the most care.
I'll use an illustrative delivery firm with 22 vehicles and 28 drivers. The figures are made up for the sake of the sums; swap in your own. The service, check and fuel jobs sit in the tutorial on automating services, checks and fuel.
The seven jobs at a glance
| Job | What AI does | What stays with you |
|---|---|---|
| 1. Driver licence register | Builds the tracker, flags expiries, drafts reminder letters | The official check itself; consent; decisions on drivers |
| 2. Accident forms | Tidies accounts into a neutral statement, lists gaps | Fault, insurer contact, any report to authorities |
| 3. Insurance renewal pack | Assembles schedule, claims summary and cover letter | Choosing cover and the broker conversation |
| 4. Repair and parts quotes | Lines up quotes side by side, queries odd items | Which garage, and the approval |
| 5. Penalty notices and tolls | Matches notices to vehicle logs, drafts driver letters | Deciding who pays and what is deducted |
| 6. Replacement cases | Builds the cost comparison and the write-up | The purchase decision |
| 7. Monthly board report | Summarises the numbers and writes the commentary | Checking every figure, the conclusions |
Job 1: a driver licence register that warns you in time
The risk here is a driver whose licence lapses or acquires a restriction while still on the road. A register records each driver's licence categories, expiry date, the date you last checked it through the official route, and the date the next check is due.
AI helps in three ways. It builds the spreadsheet with date formulas that turn a cell amber at 60 days and red at 30. It writes the standard reminder letters. And once a month it reads the sheet and lists who needs action. It does not perform the licence check: that happens through the official checking service for your licences, with the driver's consent where the rules require it.
Here is a driver register with columns: driver ID, name, licence
categories, licence expiry, last check date, next check due.
Today is [date]. List every driver whose licence expires within
60 days or whose next check is overdue, sorted by urgency. For
each, draft a two-sentence reminder to the driver. Do not include
licence numbers in any output. If a date is missing, list the
driver under "missing data".
In the illustrative firm, the monthly run lists three drivers: one expiring in 41 days, one overdue for a check by nine days, and one with no expiry date recorded. The third is the most useful find. The register's gaps are exactly the risk.
The check: open the original record for each driver on the list and confirm the dates, because a typo in the register will produce a false alarm or, worse, a false all-clear. Treat the information as personal data: use a business plan, keep licence numbers out of the prompt, and limit who can open the register. Ask your adviser what you may record and how long you may keep it.

The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowJob 2: accident forms that end up complete and neutral
After a collision the first account from a driver is rarely complete. It lacks a time, a road name, the other driver's details or the weather, and it tends to be written in a hurry. A standard form fixes the gaps, and an assistant can help turn the messy account into a tidy statement and list what remains to be asked. The accident report form tutorial covers the form design; this is the drafting step.
Below is a driver's account in their own words, and the form
fields we need. Rewrite the account as a neutral, chronological
statement in the third person, without adding anything the driver
did not say and without judging fault. Then list every form field
that is still blank or unclear, as questions to ask the driver.
Account: "pulling out of the depot, van 14, small bump with a
parked car, I think the mirror clipped it, nobody about, about
quarter past seven this morning, raining..."
An illustrative reply gives four sentences in order (vehicle, location, time and conditions, what happened) and lists blanks: registration of the other vehicle, whether the other car was occupied, photographs taken, damage to the van. It does not say who was at fault, and it does not call the incident minor.
The check: read the statement against the driver's own words and strike any word the driver did not use. Keep the original account unedited and attach the AI version as a working copy. Insurance and legal consequences attach to the original, and a polished paraphrase that changes a nuance can hurt. Fault and any reporting duty belong to your insurer and, if relevant, the authorities.
Job 3: the insurance renewal pack
A renewal is a negotiation conducted in paperwork. The broker or insurer wants the vehicle schedule, driver list, annual mileage, claims history and what you do to reduce risk. Assembling it takes a day when the data is scattered and an hour when it is not. AI helps with the assembly and the cover note.
Take the illustrative firm: premium last year was $41,800, with five claims in twelve months. The first renewal quote arrives at $46,816, which is $5,016 or 12 per cent higher. Ask the assistant to summarise the claims as the broker will read them.
From this claims table (date, vehicle, cost, cause, status),
write a one-paragraph summary for an insurance broker: number of
claims, total cost, split by cause, how many are closed, and
any pattern. Then list the safety measures from my notes below as
bullet points. Do not soften or hide any claim. Notes: [paste]
A good illustrative summary reports five claims, notes that three involved reversing in the depot yard, and lists measures such as reversing cameras fitted to eight vans and a refresher briefing for all drivers. A pattern such as "three of five claims happened while reversing" is good news for negotiation if you have acted on it, because it shows a cause with a fix.
The checks: totals against your claims log; the vehicle schedule against the actual fleet (a sold van still listed costs you premium, and a new one missing may leave it uninsured); the driver list against Job 1's register; every claim included. Leaving out a claim is a disclosure problem, not a drafting choice. The AI summary goes to the broker alongside the underlying records, and the choice of cover is a conversation with them. The contractor insurance renewal checklist gives a parallel list of figures to gather.
Job 4: repair and parts quotes compared properly
Three garages quote the same repair in three different shapes: one lump sum, one split into parts and labour, one with a vague "sundries" line. Comparing them by eye is slow and error-prone. Paste the three quotes and ask for a like-for-like table.
An illustrative case: front brake pads and discs on a van. Quote A is $612 all-in. Quote B is parts $310, labour 2.5 hours at $85 ($212.50), total $522.50 before sundries of $35, so $557.50. Quote C is parts $395 and labour 1.5 hours at $95 ($142.50), so $537.50.
Compare these three repair quotes for the same job. Build a table
with columns: garage, parts, labour hours, hourly rate, labour,
other charges, total, warranty. Recalculate each total from the
parts, labour and charges and tell me if the stated total differs.
Flag any line that is vague (for example "sundries") and any quote
that lacks a warranty statement. Do not recommend a garage.
The arithmetic check matters: ask the assistant to recalculate, then do one yourself. For Quote B, 2.5 times 85 is 212.50, plus 310 is 522.50, plus 35 is 557.50. The table shows B ahead of A by $54.50 and behind C by $20, but the vague sundries line and the labour hours (2.5 against 1.5) are the questions to put to the garage. A big difference in hours for the same job suggests different work being quoted.
The decision is yours, informed by the warranty, past reliability and downtime, and by whether the cheapest quote is really the same repair. The assistant's contribution is to expose the differences you would otherwise find after the job.
Job 5: penalty notices and tolls matched to the right driver
Penalty notices arrive by post or portal, naming a vehicle, date and time. Which driver had the vehicle at that moment is the question. Match them against your vehicle allocation or job sheet, and the answer is usually quick, but only if someone does it before the deadline on the notice.
Match these penalty notices to drivers using the allocation log.
Columns for notices: reference, vehicle, date, time, amount,
response deadline. Allocation log: vehicle, driver, start time,
end time. For each notice, return the driver if exactly one
allocation covers that time; otherwise write "no match" or
"more than one match" and say why. Sort by deadline, soonest first.
A realistic illustrative output: ten notices, seven matched, two "no match" because the van was between jobs (so the log has a gap), and one "more than one match" because a shift handover overlapped by 20 minutes. Those three are the ones a person needs to chase. The assistant also drafts the driver letter: factual, naming the notice, date, time and deadline, asking the driver to confirm or contest.
The checks: confirm the deadline on the notice itself, never from the assistant's table alone; confirm the allocation against the original job sheet for every matched driver; and keep the wording of any letter factual. Whether a driver is asked to pay, and what your contracts and employment law allow you to deduct, is a decision for you and, where needed, a qualified adviser. The grey fleet policy tutorial shows how to write the rules in advance so these letters have something to point to.
Job 6: the case for replacing a vehicle
A replacement case compares keeping an ageing vehicle with replacing it: repair spend, downtime, resale value and the cost of the new one. The assistant builds the comparison from your records and writes it up for whoever approves the spend.
An illustrative van: 6 years old, 240,000 km. Last twelve months of repairs: $3,900 and 11 days off the road. A like-for-like replacement is $34,000 with expected repairs of $600 a year and 2 days of downtime. Assume the old van would fetch $6,500 now.
- Keep for one more year: $3,900 repairs, plus 11 days of lost work. If a day off the road costs $280 in lost jobs or hired cover, that is $3,080, so about $6,980 in total, with the van worth less afterwards.
- Replace now: net outlay $34,000 minus $6,500 = $27,500, plus $600 repairs and 2 days of downtime ($560), so $28,660 in year one, with a van that retains most of its value.
Year one alone favours keeping; the question is the following years, and whether repair costs keep rising. Ask the assistant to run the same sum over three years with your own assumptions stated at the top, and to show which assumption changes the answer most. The tutorial on which vans to switch to electric first applies the same method to a different decision.
The check: every input traced to a record (repair invoices, a trade-in estimate), the downtime cost agreed with the operations side, and the write-up stating that figures are estimates. The purchase decision, finance terms and tax treatment belong with you and your accountant.
Job 7: the monthly report for the owner or board
The report most fleet managers dread is the monthly one. It needs the same ten numbers, a paragraph of explanation, and a list of what needs a decision. Once the data sits in one sheet, the assistant can write the explanation from the numbers and flag what changed.
| Measure | This month | Last month | Change |
|---|---|---|---|
| Vehicles available (average) | 20.4 of 22 | 20.9 of 22 | -0.5 |
| Repair spend | $7,850 | $5,210 | +$2,640 (+51%) |
| Open accident claims | 3 | 2 | +1 |
| Licence checks overdue | 1 | 0 | +1 |
| Penalty notices received | 10 | 6 | +4 |
Write a half-page commentary for the board from the table
above. Lead with the biggest change. For each measure that moved
by more than 25 per cent, give one possible cause as a question
for me to confirm, not as a fact. End with up to three decisions
needed. Do not add figures that are not in the table.
An illustrative first line: "Repair spend rose 51 per cent to $7,850; one brake job on van 9 and a gearbox repair on van 3 account for $3,400 of it, to be confirmed." The assistant cannot know the cause unless you told it; the prompt asks it to pose the cause as a question precisely so you fill it in.
The check: recompute two percentages by hand (7,850 minus 5,210 is 2,640, and 2,640 divided by 5,210 is 50.7 per cent), read every cause as a hypothesis until you have confirmed it, and send the board the table as well as the prose. They will trust a report whose numbers match the ones they can see.
Driver data: what to keep out of the prompt
Four of the seven jobs touch records about identifiable people: licences, accident accounts, penalty notices and, indirectly, the board report. A few habits keep that safe without slowing you down.
- Use IDs, not names, wherever the task allows. The licence run above works from driver IDs, and the assistant never needs a licence number or date of birth to flag an expiry.
- Use a business plan, not a personal account. Business plans from the main providers do not train on your content by default, and they keep the work in an account the firm controls if a manager leaves.
- Paste the minimum. For an accident statement, the driver's account and the form fields are enough; leave out home addresses and medical details unless the task truly needs them.
- Keep originals untouched. The AI version is a working copy. The signed form, the driver's statement and the notice itself are the records.
Rules on what you may record about drivers, how long you may keep it and what you must tell them vary by place and contract, so settle that with your adviser before the register goes live, and tell drivers what the register is for.
A weekly routine that keeps the seven jobs in check
Seven new outputs can feel like seven new things to review. A short routine keeps the load small, because most jobs only need attention when something changes.
| When | What you do | Time |
|---|---|---|
| Every Monday | Open the licence list and the penalty notice list; assign any unmatched item to a named person | 15 minutes |
| After any incident | Run the accident statement prompt; ask the driver the open questions within a day | 20 minutes |
| When a quote arrives | Paste it into the comparison; query vague lines | 10 minutes |
| First working day of the month | Update the report sheet, run the commentary, check two percentages | 45 minutes |
| Six weeks before renewal | Build the renewal pack and check the schedule against the fleet | 2 hours |
Add those up for a typical month (four Mondays, one incident, three quotes and the report) and the routine takes about two and a half hours, or four and a half in the month the renewal pack is due, against the day or more the same jobs can consume when they are done in a rush. The saving is real but modest at first; the larger gain is fewer surprises, such as a lapsed licence or a missed notice. Track the count of corrections you make to the drafts for the first two months. If it falls, the saved prompts are working; if it does not, the prompt or the source data needs fixing before you add more jobs.
A late penalty notice slips through
The error I would expect first is a missed deadline, not a wrong word. In the illustrative firm, ten notices arrive in the month and the assistant matches seven. Two have "no match", one is "more than one match", and the manager, pressed, deals with the seven and plans to return to the three. Two weeks later one of the three has passed its deadline, and the chance to contest it, or to pay the lower amount, has gone.
The assistant did its job: it listed all ten, sorted by deadline. The failure is in the process. The cure is to make "no match" a task with an owner and a date: whoever gets the sorted list works the unmatched items first, since they are the ones nobody can answer from the log, and the list is reviewed again two working days before the earliest outstanding deadline.
The wider lesson holds for every job here: the output of the assistant is a list, and a list needs somebody to act on it. Put the owner's name next to each open item.
Starting order for the first month
- Week 1: build the driver register and run the first 60-day check against the originals.
- Week 2: set up the accident form and a saved prompt for tidying accounts; use it on the next incident.
- Week 3: run the board report from your existing sheet and compare it with the one you would have written.
- Week 4: match last quarter's penalty notices as a trial, with nothing sent to drivers.
Leave the renewal pack for six weeks before the renewal date, and run the replacement case when a vehicle's repair spend crosses a threshold you set. If you would rather work out which of these pays back first for your own fleet, that is what my AI implementation consultation covers; the contact page has the details.
Questions fleet managers ask about these jobs
Is it safe to put driver licence details into an AI tool?
Treat them as personal data. Use a business plan, share only the fields a task needs (a licence number is rarely needed for drafting), and get your own data-protection and employment advice on what you may record. Often a tracker can hold expiry dates and categories while the checking itself happens through the official service.
Can AI decide who was at fault in an accident?
No, and it should not try. It can turn a driver's account and the form fields into a neutral, ordered statement and list what is missing. Fault is for your insurer, the parties and, where needed, the authorities. Keep the original statement unedited and file any AI summary beside it.
Will AI get me a cheaper insurance premium?
Not by itself. What it does is assemble a clean renewal pack quickly: vehicle schedule, driver list, mileage, claims summary and the safety measures you run. A broker who receives complete, accurate information can shop your risk properly, which is where the saving usually comes from.
Which of the seven should I do first?
Start with the licence register or the board report. Both rest on a spreadsheet you already have, produce output you can check line by line, and repay within the first month. Leave penalty notices and accident statements until you have one month of clean checks.
Do I need telematics for any of this?
No. Each job here works from spreadsheets, forms and emails. Telematics data adds extra uses, such as scoring or yard-time audits, which other tutorials cover. Start with what you already hold, then add data sources when a job needs them.
Further reads
- AI Tools for Fleet Management: Spot Fuel-Card Misuse in a Spreadsheet — Spot fuel-card misuse in a spreadsheet.
- Driver Scorecard Template: Fair Scoring From Telematics With AI — Score drivers fairly from telematics data.
- AI Route Planning for Small Delivery Fleets and Mobile Teams — Plan routes for small delivery fleets and mobile teams.
- Compliance Calendar: Track Licences, Insurance and Certificates — Track licences, insurance and certificates in one calendar.
- AI in the Trucking Industry: What a Small Fleet Owner Can Use Now — What a small fleet owner can use AI for now.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: ChatGPT Business pricing page, Anthropic commercial terms, Microsoft and Google Workspace privacy pages (no training on business content by default); figures and sample messages are illustrative.