Driver Management & HR · Excel template
Free Owner-Operator Driver Settlement Statement
A settlement statement for paying owner-operators and lease drivers: itemizing load revenue, deductions (fuel, insurance, escrow, advances), and net pay per settlement period. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.
Built and reviewed by the FleetOpsClub research team. Preview it free below.
- A load-by-load revenue section with mileage and rate
- An itemized deductions section: fuel, insurance, escrow, advances, and equipment
- Gross, total-deductions, and net-pay calculations
- A settlement-period and driver/contractor header
- Editable CSV. Yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
How to use it
- 1
Set the settlement period (weekly is common) and the driver/contractor details in the header.
- 2
List each load with its miles, rate, and gross pay; total the revenue.
- 3
Enter each deduction: fuel advances, insurance, escrow contribution, cash advances, equipment.
- 4
Subtract total deductions from gross to calculate net settlement pay.
- 5
Update the escrow/reserve balance and issue the statement with the payment.
What's inside
- A load-by-load revenue section with mileage and rate
- An itemized deductions section: fuel, insurance, escrow, advances, and equipment
- Gross, total-deductions, and net-pay calculations
- A settlement-period and driver/contractor header
- A running escrow / maintenance reserve balance line
- An Excel layout you can hand a contractor as a clear pay statement
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Owner-Operator Driver Settlement Statement
Settlement structures and allowable deductions are governed by your contractor agreement and, for leased owner-operators, the FMCSA truth-in-leasing rules (49 CFR 376). Confirm escrow and chargeback terms against the contract and the regulation.
| Line item | Type | Miles / qty | Rate | Amount | Running balance |
|---|---|---|---|---|---|
| Load #4821 (Columbus → Atlanta) | Revenue | 575 | $2.05/mi | +$1,178.75 | $1,178.75 |
| Load #4830 (Atlanta → Nashville) | Revenue | 250 | $2.20/mi | +$550.00 | $1,728.75 |
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
A settlement statement pays an independent owner-operator or lease driver based on the loads they hauled, minus contracted deductions: it's not a W-2 payroll check. Company drivers are typically paid via payroll instead. Classify correctly and consult your accountant.
Allowable deductions are defined by the contractor/lease agreement and, for leased owner-operators, by the FMCSA truth-in-leasing rules (49 CFR 376), which govern chargebacks and escrow. Disclose every deduction and confirm escrow handling against the regulation.
Escrow (a maintenance or performance reserve) is money withheld from settlements and held by the carrier under the lease agreement. The truth-in-leasing rules require disclosing the amount, what it can be used for, and how it's returned.
Weekly is most common, but the period is set by your agreement. Keep the period consistent so the contractor can reconcile loads to pay.