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.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- 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
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.
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 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
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.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.