Driver Settlement Sheets for a 1-5 Truck Fleet: The Math, the Disputes, and a Sheet That Does It Itself

A driver settlement sheet shows a driver what they earned and why: gross revenue for the loads they ran, with the fuel surcharge either included or passed through separately (decide that once, in writing), times their percentage, minus advances, escrow and deductions, every line itemized. At one to five trucks you do not need a TMS subscription to produce one; you need a sheet that does the same math every week and prints a statement per driver. I have not run a trucking company. What I have built is the engine that does this per-person, per-week math and renders it to a PDF, for Minnesota certified payroll.

A settlement sheet that does its own math, one PDF per driver.

Key takeaways

  • A settlement is gross (decide once, in the lease, whether the fuel surcharge is in it) times the driver's percentage, minus advances, escrow and deductions, with every deduction shown alongside how it was computed.
  • On a two-load week with $4,250 in linehaul and $550 in surcharge, splitting the surcharge instead of passing it through moves $137.50 from the driver to the carrier. Over fifty weeks that is $6,875, which is why the argument never stays small.
  • FMCSA's leasing rules (49 CFR 376.12) require payment within 15 days of the delivery paperwork, an accounting and interest on escrow, and the escrow balance returned within 45 days of termination.
  • One truck: a spreadsheet. Three trucks: the spreadsheet starts producing disputes. Five trucks: either an office person on a TMS, or a generator that turns one data file into a PDF per driver.
  • I ran twelve weeks of per-worker certified payroll through one generator: ten workers, about 3,000 hours and roughly $220,000 in gross wages, the same code doing the math every week. A settlement sheet is that engine pointed at loads instead of hours.

The short answer: gross times percentage, minus advances, escrow and deductions

The whole calculation, in the order a statement should show it:

  1. Gross for the period: linehaul for every load delivered. Decide once, in the lease, whether the fuel surcharge is inside that number or passed through separately.
  2. Times the driver's percentage.
  3. Plus 100% pass-throughs: the surcharge if that is your rule, detention, layover, lumpers.
  4. Minus advances issued this period from the fuel card or in cash.
  5. Minus escrow until the cap in the lease is reached.
  6. Minus standing deductions: insurance charged back, trailer rent, plates, ELD, each with how it was computed.
  7. Equals net, on a statement showing every line, the escrow balance and year-to-date totals.

The tool that does this needs to run the same arithmetic every week without a human retyping it. A spreadsheet manages that for one truck; by three it usually stops, and that is the real subject of this post.

I'm not a lawyer, and my first-hand experience is the PDF engine, not the trucks, so every rule below is cited by name; have your lease reviewed.

What goes on a driver settlement sheet (and what FMCSA says has to be in the lease)

A settlement sheet for an owner-operator leased to your authority answers three questions: what did you haul, what did it pay, what came out. Top to bottom:

Most of that is what FMCSA's Truth-in-Leasing regulations, 49 CFR Part 376 (ecfr.gov/current/title-49/part-376), already require the lease to spell out: how compensation is calculated, a copy of the rated freight bill at or before settlement for a driver paid on percentage, every charge-back listed with how it is computed, and payment within 15 days after the delivery paperwork is turned in. A sheet that shows all of that is most of your Part 376 paper trail.

If your drivers are W-2 employees in trucks you own, the word is paystub, Part 376 does not apply, and state wage law does; in Minnesota that means an earnings statement every pay period under Minn. Stat. § 181.032 (revisor.mn.gov/statutes/cite/181.032).

The worked example: one week, two loads, one advance

Every number below is invented, insurance included; put your own in. The driver is an owner-operator leased on at 75% of linehaul, with a $2,000 escrow cap funded at $100 a week, and a $600 fuel-card advance taken Tuesday. Two loads: 48213, 620 loaded miles, $2,400 linehaul, $310 surcharge; and 48231, 480 miles, $1,850 linehaul, $240 surcharge. The week: 1,100 miles, $4,250 linehaul, $550 surcharge.

The same week under both surcharge rules:

LineRule A: surcharge passed through at 100%Rule B: surcharge in gross, split at 75%
Gross subject to percentage$4,250.00$4,800.00
Driver share at 75%$3,187.50$3,600.00
Surcharge pass-through$550.00$0.00
Gross to driver$3,737.50$3,600.00
Fuel-card advance, Tue-$600.00-$600.00
Escrow deposit (balance $1,500 to $1,600 of $2,000 cap)-$100.00-$100.00
Occupational accident, weekly flat-$38.00-$38.00
Physical damage, weekly flat-$55.00-$55.00
Non-trucking liability, weekly flat-$12.00-$12.00
Trailer rent, weekly flat-$100.00-$100.00
Net settlement$2,832.50$2,695.00

Same loads, same deductions, same percentage, $137.50 apart in one week. Over fifty working weeks that is $6,875, which is why the surcharge argument never stays small.

The fuel-surcharge dispute, escrow caps and charge-backs: how to end them in the lease

The fuel surcharge

The driver's position: I bought the fuel, so the surcharge is mine. The carrier's: it is shipper revenue like any other line, and the percentage applies to all of it.

Part 376 does not pick a side; it only requires the pay method stated clearly in the lease and the rated freight bill handed over. OOIDA, the owner-operators' association, has pushed for years for a mandatory full pass-through of the surcharge to whoever buys the fuel.

End it with one sentence in the lease, worded by your lawyer: the surcharge is either paid to the contractor in full and excluded from the gross the percentage applies to, or included with the percentage set accordingly. Print that rule on every statement.

Escrow

49 CFR 376.12(k) is specific: the lease states the amount and what the fund can be applied to; you account for every transaction, and the driver can demand an accounting at any time; you owe interest at no less than the 91-day Treasury bill yield; and when the lease ends the balance comes back within 45 days with a final accounting.

A sheet that prints the running balance every week is one of the two ways 376.12(k) lets you give that accounting (the other is a separate monthly statement).

Charge-backs: insurance, trailer rent, plates, ELD

376.12(h) says every item you pay first and deduct later must be listed in the lease with how its amount is computed, and the driver gets the documents to check it.

For insurance you charge back, 376.12(j) adds that the driver can get the policy and a certificate showing what each coverage costs them, and 376.12(i) says you cannot make buying services from you a condition of the lease. So "insurance $105" is not enough; it is three lines the driver has seen on paper.

Spreadsheet vs light tool vs custom generator at 1, 3 and 5 trucks

One truck, one driver. A spreadsheet. Build the formula once, one tab per week, copy it forward, twenty minutes on Friday.

Three trucks. The spreadsheet starts failing quietly: a percentage cell overwritten on one driver's tab, an escrow balance that stopped carrying forward in March, a fuel advance keyed twice. Each is a dispute.

Two options: a light TMS or settlement tool in the low hundreds of dollars a month, often priced per truck, or a generator built for your fleet that turns one data file into a PDF per driver.

Five trucks. Dispatch, invoicing, settlements and IFTA all want the same load record now, and re-keying loads into three places is the real cost. If an office person will live in a TMS, it earns its keep.

If the office person is you at 9 p.m., a generator fed by the dispatcher's sheet and the fuel-card export gets you statements and a clean file for your bookkeeper without a login nobody opens.

Do you need a TMS for two trucks? Not for settlements. What pushes two-truck operations onto a TMS is IFTA and factoring-company invoicing, and most ELD providers already export the miles IFTA needs.

What a custom generator costs. A set price for the build, quoted up front from a short scope, then a monthly plan for only the services it needs, such as hosting, support and updates when a lease changes. It is priced to compete with the per-truck subscriptions; a free quote lays out both the build and the plan. The calculator below prices the problem instead: what building settlements by hand costs you now. Our development team builds these remotely for fleets anywhere, and the Minnesota team can sit at your desk if you are within driving distance of central Minnesota.

What Friday-night settlements are costing you

Drag the sliders to match your business. The numbers update instantly.

—
hours a year on it
—
what it costs you a year
—
per month

Assumes 50 working weeks. Your numbers, not ours — nothing here is sent anywhere. A system built for your business has a set build price and a monthly plan for just the services you use: get a free quote.

How a settlement generator works: data in, a PDF per driver out

This is the part I can speak to first-hand. In August I built a generator for Minnesota certified payroll: one data file a week lists each worker, classification, hours by day and rate; the script computes gross, FICA, Minnesota Paid Leave, deductions and net, carries cumulative gross forward, and renders the official Department of Labor and Industry form as a PDF. Twelve weeks, ten workers, about 3,000 hours and roughly $220,000 in gross wages, the same code every week.

A settlement generator is the same engine with loads instead of hours:

  1. Loads come from wherever they already live: the dispatcher's sheet or the rate confirmations. One row per load: number, driver, dates, miles, linehaul, surcharge, accessorials.
  2. Advances come from the fuel-card export, matched to drivers by card or unit.
  3. Each driver's rules live in one record: percentage, surcharge rule, escrow cap and deposit, standing deductions with their basis.
  4. The script does the math in the order above and refuses to issue a statement whose lines do not sum to the net exactly. I learned that from a bug in my own bookkeeping app, Fischer Books: a reconciliation check that hunts for a number that makes the math work is not a check.
  5. Out comes a PDF per driver: load rows, pass-throughs, advances, escrow balance, each deduction with its basis, net and year-to-date, plus a carrier summary and a CSV for your bookkeeper.
  6. Issued statements are frozen. A correction is a new line on next week's statement labelled as a prior-period adjustment, never an edit to a PDF that already went out.

None of it needs a login or a dashboard nobody opens; it needs the data file filled in honestly. That is automation for a small company, and the settlement CSV feeds straight into the bookkeeping setup I wrote about.

Record-keeping: what the IRS, FMCSA and your drivers expect to see

I'm not a lawyer or an accountant. This is the list I would hand my own bookkeeper.

The IRS

FMCSA

Your drivers

Number statements sequentially, never re-issue one, and keep a year-to-date line that equals last week's plus this week's. For Minnesota W-2 drivers, wage records are kept three years under Minn. Stat. § 177.30 (revisor.mn.gov/statutes/cite/177.30); your payroll provider should handle that.

A generator fixes this as a side effect: statements, freight bill copies and the fuel-card export land in one dated folder per week, which is also what lets the company run without you (see the key-man risk post).

Frequently asked questions

What is a driver settlement sheet?

It is the itemized statement a carrier gives an owner-operator, or any percentage-paid driver, each pay period: the loads hauled, the gross revenue and the driver's share, any pass-throughs, the advances, escrow and deductions taken out, and the net paid.

How do you calculate an owner operator settlement?

Add up the linehaul for the loads delivered in the period, apply the lease's surcharge rule (included in gross or passed through at 100%), multiply by the driver's percentage, add any 100% pass-throughs like detention, then subtract fuel and cash advances, the escrow deposit until the cap is reached, and each standing deduction. In the worked example above, 75% of $4,250 plus a $550 surcharge pass-through, minus $905 in advances, escrow and deductions, nets $2,832.50.

What percentage do owner operators get paid?

There is no regulated number; 49 CFR 376.12 only requires the lease to state clearly how pay is calculated. Carrier recruiting pages quote everything from the mid-60s to the high-80s percent of linehaul, and the spread is mostly about what counts as gross and what gets charged back. Compare offers on a sample week's net, not on the headline percentage.

Is there free software for driver settlements?

Not that I would trust. The 'free settlement template' results on Google are mostly ad pages, and the free tiers of TMS products are trials. For one truck, a spreadsheet you build yourself is genuinely free and genuinely fine. Past three trucks the choice is a TMS subscription or a generator built for your fleet, and the better option is whichever one your drivers stop disputing.

Do I need a TMS for 2 trucks?

Not for settlements. A TMS earns its keep when dispatch, invoicing, IFTA and settlements all need the same load record and someone will use it every day. At two trucks a spreadsheet or a small generator covers settlements, your ELD export covers IFTA mileage, and your factoring company or an invoice template covers billing.

What deductions go on a driver settlement?

Only the ones the lease names. Typically fuel and cash advances, the escrow deposit, insurance the carrier charges back (each coverage on its own line), trailer rent, plates and permits, and ELD or other equipment fees. Under 49 CFR 376.12(h) each one must be listed in the lease with how its amount is computed, and the driver is entitled to the paperwork behind it.

Want settlements that do their own math?

Tell me how many trucks you run, how your drivers are paid, and where your load and fuel-card data lives today. I'll come back with a clear scope, a set price for a generator that turns it into a statement per driver, and a monthly plan for only the services you need, priced to compete with the TMS subscriptions. Our development team builds it around how your fleet already works.

Jacob Fischer
Jacob Fischer

Founder, Style Marking · owner, Revisions Unlimited. Jacob builds custom websites, apps and operations systems for small-business owners — and runs a remodeling company on the same tools he builds for clients. Every post here comes from systems he has actually shipped.

Related reading