How to run driver settlements without spreadsheets, step by step
When pay comes from the load record, Friday payroll stops eating your weekend. Here's how to set it up and which rules to follow.

Key points
- Driver wages averaged $0.818 per mile in 2025 per ATRI, the biggest cost line for most fleets. Small mistakes add up fast.
- US leased owner-operators must be paid within 15 days of turning in delivery paperwork under 49 CFR 376.12(f).
- Every owner-operator chargeback must be listed in the lease with its math. Escrow must come back within 45 days of termination.
- The fix: enter each load once, so pay, deductions and the settlement sheet all come from the same record.
Driver settlement software builds each driver's and owner-operator's pay straight from the loads you already dispatched. Miles, percentage pay, extra stops, detention, fuel advances and escrow all come from that record, so nobody types numbers into a spreadsheet on Friday night. The fix is simple: enter each load once, attach the paperwork, and let pay come out of that record.
That's the whole idea. The rest of this article covers what goes on a settlement, the rules it has to follow in the US and Canada, and a weekly routine you can set up in an afternoon.
Why spreadsheet settlements break as you grow
Settlement spreadsheets usually start small. One tab per driver, a column for miles, a column for advances. It works at two trucks. By eight trucks it's a weekend job. By 20, the person who built it is the only one who can run it.
The problem isn't Excel. The problem is double entry. The load already lives in your dispatch board, the rate con, the invoice and the fuel card report. A spreadsheet makes someone copy all of that by hand a fourth time, and every copy is a chance to get it wrong.
And this is real money. According to the American Transportation Research Institute (ATRI), the average cost to run a truck in 2025 was $2.336 per mile, the highest ever recorded. Driver wages alone averaged $0.818 per mile, plus $0.210 in benefits. When your biggest cost line runs through copy-and-paste, a few missed stops or a double-counted advance every week adds up quickly. So do upset drivers.
Here's the good news. Pay errors are one of the easiest back-office problems to fix for good.
What goes into a driver settlement
A settlement is the pay statement for one period. It has three parts:
- Earnings. Each load and how it pays: per mile, percentage of the load, hourly or flat. Add extras like stop pay, detention, layover, tarp pay or a breakdown day.
- Deductions. Fuel and cash advances, escrow, insurance or ELD chargebacks for owner-operators. For employees, add taxes and benefits.
- Reimbursements. Lumpers, scales, tolls and parking the driver paid out of pocket, backed by a receipt.
If you're still choosing a pay model, our breakdown of driver pay per mile vs percentage vs hourly walks through what each one really costs you.
Here's a simple example. Say a company driver runs 2,400 paid miles at $0.62 a mile ($1,488), with two extra stops at $50 each and a $300 fuel advance. The settlement should show $1,588 gross, the $300 advance and the tax deductions. Every number should trace back to a load, a receipt or a card transaction. If you can't click from a line on the settlement to the document behind it, that line will turn into a phone call.
The rules your settlements have to follow
Settlement rules depend on two things: who the driver is (employee or contractor) and where you run.
Leased owner-operators (US). If an owner-operator drives their truck under your authority, the federal Truth-in-Leasing rule in 49 CFR 376.12 sets the ground rules:
- 15-day pay. The lease has to say you'll pay within 15 days after the owner-operator turns in the delivery documents for a trip. You can only ask for the logs and the papers you need to get paid by the shipper.
- Rated freight bill. If you pay a percentage of the load, you have to give them a copy of the rated freight bill (the bill showing what the customer was charged) before or at settlement. You can black out shipper and consignee names.
- Chargebacks. Every item you pay up front and later deduct has to be listed in the lease, along with how the amount is figured. The owner-operator gets copies of the documents that prove each charge.
- Escrow. If you hold escrow (a deposit you keep back from settlements), the lease must state the amount and what it can cover. You have to account for it on each settlement sheet or in a monthly statement, pay interest at least every quarter, and return it no later than 45 days after the lease ends.
A spreadsheet can technically do all of this. In practice, the rated freight bill, the receipt behind each chargeback and the escrow balance end up in three different places. Software that keeps them on the same record makes these rules easy to follow.
Employee or contractor? This choice decides whether you withhold taxes at all. The IRS's worker classification training guide says someone is an independent contractor when you control only the result of the work, not how it's done. In Canada, the CRA's page on payments for trucking services lays it out plainly. For employee drivers you withhold income tax, CPP contributions and EI premiums. For a truly self-employed Canadian-resident driver you withhold none of them. If you run "Driver Inc." setups, have your accountant review them. Classification is a question to settle before you build pay rules, not after.
Pay statements in Canada. Carriers that cross provincial or national borders are generally federally regulated. Under section 254 of the Canada Labour Code, every wage payment needs a written statement showing the pay period, hours paid, rate of wages and deductions. Carriers that stay inside one province follow that province's employment standards instead.
What each settlement line needs, and where it should come from
| Settlement line | Company driver (employee) | Leased owner-operator (US) | Where the number should come from |
|---|---|---|---|
| Gross pay | Miles × rate, % of load, or hours, per your pay policy | Amount or % stated in the lease | The dispatched load and rate con |
| Extras (stops, detention, layover) | Per your written pay policy | Only if the lease includes them | Stop times from the driver app or ELD |
| Fuel and cash advances | Deducted per policy and local wage rules | Listed as a chargeback, with how it's figured | Fuel card transactions |
| Escrow | Not typical | Amount, uses, accounting, quarterly interest, return within 45 days | A running escrow balance per lessor |
| Taxes | Withhold income and payroll taxes (US) or income tax, CPP and EI (Canada) | No withholding; year-end contractor reporting | Payroll tax tables |
| Paperwork the driver sees | Pay period, hours, rate, deductions (federal Canada) | Rated freight bill for % pay; proof for each chargeback | Rate con, invoice, receipts |
A weekly settlement routine that takes minutes, not a weekend
Here's the routine fleets use once settlements come from the load record instead of a spreadsheet:
1. Set pay rules once per driver. Per mile, percentage, hourly or flat, plus stop pay, detention and any standing deductions. Owner-operator rules should match the lease word for word.
2. Dispatch the load once. The rate con becomes the load. Miles, rate, stops and driver assignment are entered one time, ideally read from the rate con instead of typed in.
3. Let drivers send paperwork from the cab. The POD, lumper receipt and scale ticket go up from the driver's phone and attach to the load. This one step does double duty: the same POD that starts your invoice also makes that load ready to pay. (More on that in our guide to getting paid faster.)
4. Pull in fuel and card data automatically. Advances and fuel purchases should come from the fuel card feed and match to the right driver and truck. Nobody should be keying in a card statement.
5. Review exceptions, not every line. On settlement day, your job is to check the handful of loads missing a POD, a detention claim without stop times, or a receipt that doesn't match. Everything else is already done.
6. Approve, send and post. Drivers get a clear statement with each load listed, and the totals post to your accounting system. TorqueAI works this way. Dispatch, billing and payroll share one load record, so trip sheets and expenses are ready to process in one go, and its CPA-certified reporting suite gives your accountant and bank reports they can use.
What to look for in driver settlement software
When you compare tools, ask the vendor to run a real week of your settlements in the demo, not a sample. Check these points:
- Pay comes from the load. If someone has to retype miles or rates into a payroll screen, it's still a spreadsheet with a nicer look.
- Every pay model you use. Per mile, percentage, hourly and flat, plus mixed setups like team splits and owner-operators with their own drivers.
- Documents on every line. The rate con, POD, receipts and rated freight bill should be one click away from the settlement line they support.
- Escrow and chargeback tracking. Running balances, interest and itemized deductions, so your Truth-in-Leasing paperwork builds itself.
- Driver-facing statements. Clear, itemized pay sheets cut down on Monday-morning "where's my detention?" calls. That matters for keeping drivers, too.
- Accounting sync. Settlement totals should post to your books, whether you use a built-in ledger or QuickBooks Online.
- Fits your fleet size. A 2-truck carrier and a 300-truck carrier need different setups. The right system adjusts to your operation and where you're headquartered.
Our page on trucking payroll software goes into more detail on how driver pay and settlements connect to the rest of the operation, from 1 truck to 500+.
How to switch without missing a pay run
You don't need a big-bang switchover. Most fleets do it in three moves:
Write down your pay rules first. Every driver's rate, every extra, every standing deduction. This step alone usually turns up a few drivers being paid "the way we've always done it" with no written rule behind it. Fix those now.
Run one pay period in parallel. Do your normal spreadsheet settlement and the new system side by side for one week. Compare driver by driver. Any difference is either a setup fix or an old spreadsheet error you just caught.
Cut over and retire the spreadsheet. Once the numbers match, stop updating the old file. Keep it as a read-only archive for audits and year-end.
With TorqueAI, most fleets are up and running within 24 hours, so the parallel week is usually the longest part.
The payoff shows up fast. Friday stops being payroll night. Drivers trust their checks because every line has proof behind it. And because pay, invoicing and profit all come from the same load record, you can see what each truck really earned that week, not a guess at year end.
Sources and notes
- The figures above that come from rules or research are as of November 2026, from the official sources linked in the article.
- The settlement example and step-by-step routine are illustrations, not real customer numbers.
- I couldn't fully confirm the 2026 IRS change that raised the 1099-NEC reporting threshold from $600 to $2,000, so I left it out. If you want to add it, check it on IRS.gov first.
Questions readers ask
What is a driver settlement in trucking?+
A driver settlement is the pay statement for one pay period. It lists the loads a driver or owner-operator ran, how each one was paid, any extras like detention or stops, and deductions like fuel advances or escrow. The total at the bottom is what lands in the driver's bank account.
How fast do I have to pay a leased owner-operator in the US?+
Under the federal Truth-in-Leasing rule, 49 CFR 376.12(f), the lease must say you'll pay within 15 days after the owner-operator turns in the delivery documents for a trip. You can only require the logs and the papers you need to get paid by the shipper. You can't make settlement wait until your customer pays you.
What deductions can I take from an owner-operator settlement?+
Only what your lease lists. Under 49 CFR 376.12(h), every item you pay up front and later deduct, like fuel advances or insurance, must be spelled out in the lease along with how the amount is figured. The owner-operator also has the right to copies of the documents that prove each charge.
Do Canadian trucking companies have to give drivers a pay stub?+
Yes. Federally regulated carriers, usually those running across provincial or national borders, must give employees a written statement with each payment under section 254 of the Canada Labour Code. It shows the pay period, hours paid, rate of wages and deductions. Carriers that stay inside one province follow that province's employment standards, which have similar pay statement rules.
Can driver settlement software connect to QuickBooks?+
Many can, and you should insist on it. Settlement totals, deductions and reimbursements should post to your books automatically so your accountant isn't re-entering payroll. Ask any vendor to show a real settlement flowing into QuickBooks Online or Desktop before you sign.



