To check an owner-operator settlement statement with AI, turn your lease into a table of agreed charges, turn the statement into a table of actual deductions, and ask the assistant to compare them line by line. Every difference, missing clause or unexplained charge goes on a list you can raise with the carrier in writing.
The assistant compares wording and numbers well. It cannot say whether a clause is lawful or fair, and it can misread a vague one. Treat its output as a list of questions to ask, backed by quotes from your own lease, and not as a verdict.
Why the lease must come first
A settlement statement shows what the carrier took. Only the lease shows what it was allowed to take. Checking a statement without the lease means judging charges by whether they feel reasonable, and a deduction can feel fair and still have no basis in the agreement, or feel steep and be exactly what you signed.
Read your lease once with a pen before any AI is involved. Note the settlement period (weekly or otherwise), the pay basis, any time limit for raising a dispute, and whether charges may be changed by notice. Then you can tell when the assistant misreads a clause, because you will already know roughly what it says.
If you are not yet sure whether leasing on to a carrier beats running your own authority, the cost side is worked through in cost per mile from your own statements, and the same comparison applies to what a settlement leaves you with.
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 nowTurn the lease into a terms table
A lease is long, and the charges are scattered across clauses and schedules. Ask the assistant to extract them into a fixed table, with the clause reference and a short quote, so every later comparison can point at the words.
Below is the text of my owner-operator lease. Extract every charge, deduction, fee, reserve or rate that the carrier may take from my settlement, and every payment I am due.
Return a table with columns: Item, Amount or rate, Unit (per week, per mile, per load, percent, one-off), Cap or end condition, Clause number, Exact quote (under 25 words).
Rules:
- Quote the lease; do not paraphrase the amount.
- If a clause allows a charge but gives no amount, write "not stated".
- If you are unsure whether something is a charge, list it under "Unclear" with the quote.
- Do not add anything not in the text.
[paste lease text]If the lease is a scanned PDF, run it through an OCR step first and check the amounts by eye, because a misread digit here poisons everything after. An illustrative result for a weekly settlement:
| Item | Rate | Unit | Cap or end | Clause |
|---|---|---|---|---|
| Physical damage insurance | 62.00 | Per week | None stated | 7.2 |
| Escrow contribution | 100.00 | Per week | Stops at 2,500.00 balance | 9.1 |
| Trailer rental | 30.00 | Per day used | None stated | 6.4 |
| ELD service | 25.00 | Per week | None stated | 8.3 |
| Fuel card purchases | At cost | Per transaction | n/a | 10.2 |
| Tolls | At cost | Per toll | n/a | 10.5 |
| Administrative fee | not stated | Unclear | n/a | 12.1 |
Look at the last row. The lease mentions administrative arrangements but states no amount, so the table says so. That is the correct behaviour, and it is the line you will want to ask about. Read the whole table against the lease once. If two or three rows are wrong, fix the prompt before trusting any later comparison.
Turn the statement into a matching table
Statements arrive as PDFs with columns that differ by carrier. Paste the text or a clean export and ask for the same shape as the terms table. Use the same item names where you can.
Below is one weekly settlement statement. Return two tables.
Table 1, Earnings: Load reference, Description, Amount.
Table 2, Deductions: Item, Amount, Any reference or note on the statement.
Then give: total earnings, total deductions, net pay as printed, and whether earnings minus deductions equals the printed net pay (yes or no, with the difference).
Do not change any figure. Remove any account numbers.The last request, a check that earnings less deductions equals the printed net, catches a surprising number of errors on its own. For an illustrative week:
| Earnings | Amount |
|---|---|
| Linehaul, three loads | 3,420.00 |
| Fuel surcharge | 412.50 |
| Detention | 150.00 |
| Total earnings | 3,982.50 |
| Deduction | Amount | Statement note |
|---|---|---|
| Fuel card | 1,226.40 | 7 transactions |
| Physical damage insurance | 74.00 | |
| Escrow | 100.00 | Balance 2,550.00 |
| ELD service | 25.00 | |
| Trailer rental | 175.00 | 5 days |
| Administrative fee | 15.00 | |
| Tolls | 41.25 | 3 tolls |
| Total deductions | 1,656.65 |
Net pay on that statement is 3,982.50 less 1,656.65, which is 2,325.85. The statement's own arithmetic is right; the question is whether the lines are.
The comparison prompt, and what it should return
Now put the two tables in front of the assistant and ask for variances only. Asking for "any problems" invites padding; asking for variances against the lease keeps it concrete.
Compare the deductions table with the lease terms table.
For each deduction, state: lease item and clause, expected amount (show the working), actual amount, difference, and one of: MATCHES, OVER, UNDER, NO BASIS IN LEASE, CANNOT CHECK.
Rules:
- Use only the lease terms table for expected amounts.
- If the expected amount depends on something not on the statement, say what is needed.
- For caps, use the balance printed on the statement and the cap in the lease.
- Finish with a list of OVER and NO BASIS lines, largest first, and the total difference.For the figures above, a correct answer reads:
| Deduction | Expected | Actual | Difference | Result |
|---|---|---|---|---|
| Physical damage insurance | 62.00 (cl. 7.2) | 74.00 | +12.00 | OVER |
| Escrow | 50.00 (balance would reach 2,500 cap) | 100.00 | +50.00 | OVER |
| ELD service | 25.00 (cl. 8.3) | 25.00 | 0 | MATCHES |
| Trailer rental | 150.00 (5 days x 30.00, cl. 6.4) | 175.00 | +25.00 | OVER |
| Administrative fee | not stated (cl. 12.1) | 15.00 | +15.00 | NO BASIS |
| Fuel card | At cost | 1,226.40 | n/a | CANNOT CHECK |
| Tolls | At cost | 41.25 | n/a | CANNOT CHECK |
The escrow line deserves a pause. The statement shows a balance of 2,550.00 after a 100.00 deduction, so the balance before it was 2,450.00. With a 2,500.00 cap in the lease, only 50.00 was needed, which is why the expected figure is 50.00. That is the kind of reasoning an assistant does well, and the kind that is worth confirming by hand before you rely on it.
Total difference on the four lines: 12.00 + 50.00 + 25.00 + 15.00 = 102.00. The net pay should have been 2,427.85, not 2,325.85.
Lines the AI cannot check, and how to check them yourself
Fuel and tolls are "at cost" in this lease, so the statement can only be tested against your own records. That is where your fuel receipts and card data matter.
- Fuel card. Compare the number of transactions, the total gallons and the total amount with your own fuel receipts or app records for the same dates. A statement showing seven transactions when you remember six is worth asking about, as is a pump price well above what the receipts show.
- Tolls. Compare the number and amount with your transponder statement or toll receipts.
- Detention and accessorials in earnings. If you were told detention would be paid, check that it appears as earnings, and that it matches your own time log. If you track waits already, tracking waits and invoicing detention shows a method.
- Linehaul against rate confirmations. Check each load's rate and miles against the paperwork, because the biggest error in a settlement is more often on the earnings side than the deductions side.
Paste your own fuel and toll rows and ask for a reconciliation in the same variance style. A prompt that takes two tables and returns "in statement not in my records" and "in my records not on statement" does the job.
The dispute email, written once and reused
A good query is short, specific and attaches the evidence. It asks for explanations first, not refunds, and it quotes the clause each time. A template to adapt (illustrative):
Subject: Settlement dated [date]: four deductions to clarify
Hello [first name],
I have checked the settlement for the week ending [date] against my lease and have four questions.
1. Physical damage insurance: 74.00 was deducted. Clause 7.2 sets 62.00 per week. Please confirm the basis for the extra 12.00.
2. Escrow: 100.00 was deducted and the balance now shows 2,550.00. Clause 9.1 stops contributions at 2,500.00. Please confirm why the cap was exceeded.
3. Trailer rental: 175.00 for five days. Clause 6.4 sets 30.00 per day used, which is 150.00. Please confirm the days used.
4. Administrative fee: 15.00. Clause 12.1 mentions administrative arrangements but I cannot find an amount for this fee in the lease. Please tell me where the 15.00 was set out and how it is calculated.
The total difference is 102.00. If any of these are correct, please send the clause and calculation. If they are errors, please correct them in the next settlement or send a revised statement.
Thank you,
[your name]Ask the AI to draft it from the variance table, then read every figure against the lease yourself. A drafting prompt that helps keep the tone neutral: "Write this as a polite request for explanation. Do not accuse anyone of wrongdoing, do not mention legal action, and quote each clause number and amount exactly as in the table." Send by email, not by phone alone, so you have a dated record. Keep the sent message with the statement and the lease in one folder per month.
An error that looked like a carrier mistake and was not
Take an illustrative case. An owner-operator's comparison flagged a 40.00 insurance charge as OVER, because the AI read the lease clause as "per week" while the statement period was a fortnight. The real lease wording was "per settlement period", so 40.00 per fortnight was correct and the statement matched. Raising it as a mistake would have cost goodwill for nothing.
The cause was a unit mismatch, and the cure was in the prompt: the terms table has a Unit column, and the comparison rule now says "If the lease unit and the statement period differ, say so and do not flag; ask me to confirm". It is also why the exact quote column exists. When you can see the words next to the figure, a misread unit shows up in seconds. A second habit helps: for any flagged line over a certain size, read the clause yourself before you send anything. Pair that with the cautions in why AI hallucinations matter to business owners, because a confident-sounding misreading of a contract is exactly that.
Keeping a running log of disputes and outcomes
One statement is a check; twenty make a pattern. Keep a simple log with a row per queried line.
| Statement date | Item | Amount queried | Raised on | Outcome | Resolved on |
|---|---|---|---|---|---|
| 14 Oct | Escrow over cap | 50.00 | 16 Oct | Refunded | 28 Oct |
| 14 Oct | Trailer days | 25.00 | 16 Oct | Rate corrected to 30.00 a day | 28 Oct |
| 14 Oct | Admin fee | 15.00 | 16 Oct | Clause cited, accepted | 21 Oct |
After three months, ask the assistant to read the log and say which item recurs, how long answers take and how much was recovered. If the same item turns up every month, the cause is probably a setting in the carrier's system, and one clear conversation fixes it for good. If the carrier cannot explain a recurring item, that is the moment to take advice. The log also feeds your own books; sorting receipts and fuel statements with AI shows where the corrected figures go.
Three lease patterns where the arithmetic is the trap
The weekly flat charges above are the easy case. Three other shapes of charge need a worked sum, and each is worth adding to the comparison prompt as a rule, because that is where a plausible figure can hide a wrong one.
A charge per mile
Suppose the lease sets a plate or permit charge at 0.04 per mile and the statement shows 1,640 miles and a deduction of 82.00. Expected: 1,640 x 0.04 = 65.60. The difference of 16.40 may be loaded and empty miles being counted differently, which is a genuine question to ask. The prompt rule is: "Where a charge is per mile, state which mileage figure the statement uses (loaded, empty or total) and whether the lease says which to use."
A percentage of earnings
Say the lease takes 3 per cent of linehaul as a dispatch fee. On linehaul of 3,420.00, that is 102.60. If the statement shows 3 per cent of total earnings (3,982.50), the deduction is 119.48, a difference of 16.88. A lease that says "of linehaul" and a carrier that applies it to "gross" is a common source of small, repeated overcharges. The comparison prompt should say: "For percentage charges, show the base used, the base the lease names, and the amount under each."
A one-off chargeback
A line such as "Cargo claim, load 4471, 380.00" depends on facts, not the lease table: whether the claim is valid, how it was assessed, and what the lease says about who bears loss. The assistant can only mark it CANNOT CHECK and list what you would need: the claim paperwork, the delivery receipt, photographs and the lease clause on liability. Do not let the assistant argue the merits. Your job is to ask for the documents, in writing, and keep the answer.
What to ask for when the explanation is a shrug
Sometimes a query comes back as "that's what the system shows". A polite request for supporting records usually moves things forward. Use this list as the second email, and tick off what you have been sent.
- Escrow: a ledger of every contribution, any interest or deductions and the current balance, with dates.
- Fuel card: the transaction-level detail (date, location, gallons, price) behind the total.
- Insurance and equipment charges: the schedule or rate card the carrier used and the date it took effect.
- Percentage deductions: the base figure and the percentage applied, load by load.
- Chargebacks: the claim notice, the evidence relied on and how the amount was calculated.
- Any fee not in the lease: the clause or written notice that introduced it, and the date you were told.
The assistant can draft this follow-up from the list, and again you read it before it goes. The more your query reads as a calm request for records, the easier it is for the carrier's office to answer. If answers stay vague over several weeks, that is the signal to take advice, with the log and the comparison tables as your starting pack.
Statements that carry balances from one week to the next
Many statements print a previous balance, a carried-over negative, or a reserve that builds over time. These make a simple weekly comparison misleading, because a charge this week may relate to an earlier one. Two habits keep it straight.
First, keep the previous statement beside the current one and ask the assistant to reconcile the carried amounts: "Does the opening balance on this statement equal the closing balance on the last one? If not, show the difference." A break in that chain is a finding in itself. Second, for any running balance such as escrow or an advance being repaid, keep a small table of your own, with a row per statement and the balance before, the movement and the balance after. A model asked to maintain that table from each new statement will do it quickly, and you will see the cap being reached or an advance repaid before the carrier's statement says so.
A short illustration: an advance of 600.00 is repaid at 100.00 a week with no interest in the lease. After six statements the balance should be zero. If statement seven still takes 100.00, you have found a real item, one that no single week's check would have caught, because every individual week looked normal.
A weekly routine that takes about 25 minutes
- Day the statement arrives, 5 minutes: save it, remove identifiers from a copy and paste it with the statement prompt. Check the earnings-less-deductions line.
- 10 minutes: run the comparison prompt against the saved terms table. Read each OVER, NO BASIS and CANNOT CHECK line against the lease and your records.
- 5 minutes: reconcile fuel and tolls with your own records.
- 5 minutes: if anything stands, draft the email, read it, send it and log it.
Save the three prompts and the terms table together, in a saved Project in a chat assistant or a plain note, and update the table whenever the lease is amended. Keep a person in the loop at the sending step; adding human approval steps to AI work is the principle. If a dispute grows beyond a few dollars of difference or concerns what a clause allows, the next step is advice from a transport adviser or lawyer, with your comparison table and quotes in hand. They will find it far quicker to work from than from a pile of statements.
One last point on privacy. Settlement statements hold your earnings, load details and your carrier's account numbers. Keep what you paste to what the task needs, use a business plan or switch off training in your account's privacy settings, and keep the originals as the record. The AI's tables are working copies, nothing more.
Questions about checking a settlement with AI
Can AI tell me whether a deduction is legal?
No. It can show whether a deduction matches the wording of your own lease and flag lines with no basis in it. Whether a clause or a charge is allowed is a legal question that depends on your contract and your rules, so take a flagged line to a transport adviser or lawyer if the carrier will not explain it.
How soon should I query a settlement?
Soon. Some leases set a window for raising a dispute, and memories and paperwork fade quickly. Read your lease for any time limit, put the check in your diary for the day each statement arrives, and send queries in writing so there is a record of when you raised them.
What documents do I need before I start?
The signed lease and any later amendments, the settlement statement, your own fuel and toll records, and the load paperwork for the period. Without the lease the AI can only tell you what looks odd, not what contradicts the agreement.
Is it safe to upload my lease and statement to a chat assistant?
Use a business plan or turn off training in a consumer account's privacy settings, remove identifiers such as account numbers, and avoid pasting anything you are bound to keep confidential. Check the lease for a confidentiality clause. The assistant is a working tool; your original documents remain the record.
What if the lease is vague about a charge?
Flag it and ask the carrier in writing which clause allows it. Vague wording is the most common reason a deduction is disputed, and a polite request for the clause reference often settles it without argument. Do not assume the AI's reading of an unclear clause is the right one.
Further reads
- Trucking Accounting Software: Do the AI Features Earn Their Price? — Software that keeps settlements and expenses in one place.
- Trucking Companies Using AI: A Claude Audit of Yard Time and Tolls — Audit yard time and tolls with a chat assistant.
- AI in the Trucking Industry: What a Small Fleet Owner Can Use Now — Other jobs a small fleet owner can hand to AI.
- AI for a Trucking Business: Can It Chase Late Invoices and Missing PODs? — Chase late invoices and missing proofs of delivery.
- DOT Audit Checklist for a Small Fleet: Organise Records With AI — Organise records so any query has its evidence ready.
- AI Clauses for Agency Contracts: Disclosure, Ownership, Approvals — How to read contract clauses with AI without over-trusting it.
- AI Dispatcher or Dispatch Service? An Owner-Operator Cost Check — Percentage fee, flat weekly fee or a monthly AI subscription: one weekly sum, where each goes wrong and the checks before booking a load.
- Load Boards for Owner-Operators: Rank Offers by Profit per Day With AI — Paste three load offers and your costs, get net profit per day for each, and pick the one that pays for the days it uses.
- Negotiate Freight Rates: Prepare Counter-Offers With AI and Data — Work out your cost-per-mile floor, check a lane against your own history, and use AI to prepare a counter-offer, a short phone script and a walk-away number.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: OpenAI help centre data-controls article and Claude privacy centre (model-training settings), checked 5 November 2026; the lease clauses, statement lines and figures are illustrative and none of this is legal advice.