Owner Operator Settlement Template (Free Excel Download) — 2026 Guide

Most owner-operators and small fleet owners start with a paper log or a messy spreadsheet nobody else can read. That works for 2-3 trucks. At 5 trucks, it breaks — you miss advances, forget deductions, and drivers start questioning every check.

This is the template we wish existed when we started building FleetLegend. It's free. Download it, customize the rates and deductions for your operation, and use it every week. When spreadsheet math starts eating more than an hour a week, it's time to automate — but the spreadsheet version is a real starting point.

📥 Download: FleetLegend Owner-Operator Settlement Template (Excel, .xlsx)

Who This Template Is For

• Owner-operators running 1-3 trucks who pay themselves (or a second driver) weekly
• Small fleet owners with 5-25 drivers on per-mile, percentage, or flat-rate pay
• Dispatchers who handle settlements on Fridays and need a repeatable workflow
• New authority holders who just got their MC number and need a pay system from day one

If you already run a TMS with settlement automation, you don't need this template. If you're paying drivers from memory, a notes app, or whatever QuickBooks field you can find — you do.

What's in the Template

The template has five sections. Each section feeds the next, so your net settlement pay calculates automatically at the bottom once you fill in the top.

How to Use the Template

Section 1: Loads

Enter every load the driver covered in the settlement period. One row per load. Fields:

• Load # — your internal reference (L-1001, L-1002, etc.)
• Pickup Date
• Origin and Destination (city/state)
• Miles (Loaded) — paid miles under load
• Miles (Empty) — deadhead miles returning or repositioning
• Gross Pay — what the customer/broker paid for that load

The template sums loaded miles, empty miles, total miles, and gross pay at the bottom. Don't skip the empty miles column if your pay method is per-mile — most fleets pay some portion of deadhead, and tracking it separately keeps you honest at tax time.

Section 2: Driver Pay Method

Set this once per driver (or once for yourself if you're the owner-operator).

• Per-Mile: Enter cents-per-mile rate (typical owner-op: $0.55-$0.70 all-in)
• Percentage: Enter % of gross (typical owner-op pulling 70-80%; company drivers 25-30%)
• Flat Rate: Enter weekly salary amount

The template auto-selects the right formula based on your dropdown. If you're not sure which method to pick, read our full guide on per-mile vs percentage driver pay — the short answer is: per-mile for predictability, percentage for high-rate lanes, flat for company driver retention.

Section 3: Accessorial & Bonus Pay

Extras that drivers earn on top of base pay. Every fleet handles these differently, but the template covers the common five:

Make sure your accessorial rates match what you actually collect from customers. If you charge detention to the customer but don't pass any of it to the driver, be ready to explain why — drivers talk.

Section 4: Deductions

The part nobody likes. But getting this clean is what separates a real settlement from a guess.

• Advance Received — cash the driver already got during the week (fuel advances, cash draws)
• Fuel Card Charges — what the driver spent on the company fuel card
• Insurance Deduction — driver contribution if applicable (W-2 drivers usually; 1099 contractors rarely)
• Escrow / Maintenance Reserve — amount held back per week for driver maintenance fund
• Trailer Lease — if driver leases a trailer through the fleet
• Other Deduction — catch-all (violations, damage reimbursement, loan repayments)

Rule of thumb: Never deduct anything from a driver's settlement that wasn't agreed to in writing. If you find yourself adding a deduction mid-week to "make up" for something, you're building the lawsuit that ends your fleet.

Section 5: Net Settlement Pay

The math:

• Gross Driver Pay (from Section 2 formula)
• Plus: Total Accessorial / Bonus (Section 3)
• Less: Total Deductions (Section 4)
• Equals: Net Settlement Pay

The template calculates this at the bottom. Both the driver and the dispatcher/owner sign off before cutting the check. Keep a signed copy (physical or digital) for every settlement. If you're audited (IRS, DOL, or for worker classification), these are the first records auditors ask for.

Worked Example: 12-Trip Week for a Per-Mile Owner-Operator

To show how the template works end-to-end, here's a realistic week for a single-truck owner-operator paying themselves $0.60/mi on all miles (loaded + empty):

Why the net is so low: fuel card + cash advance already ate most of the gross pay during the week. This is why owner-ops who don't track advances in real time blow past their net pay and don't realize until settlement day. The template solves this by forcing the deductions column to be filled every week.

The 7 Most Common Settlement Mistakes Small Fleets Make

1. Forgetting to deduct mid-week cash advances

You give the driver $300 on Wednesday for fuel. You don't write it down. Friday settlement pays them as if the advance never happened. You're out $300. Fix: log every advance in the deduction column the same day it's taken.

2. Mixing loaded and empty miles inconsistently

Some fleets pay per-mile on loaded miles only. Others pay on all miles. Pick one policy, put it in writing, and stick to it. Mixing the policy by driver or by week is how you end up in court.

3. Using outdated per-mile rates

Driver pay rates move with the freight market. If you locked in a $0.55/mi rate 18 months ago and haven't revisited, your drivers are either overpaid (and you're losing margin) or underpaid (and they're leaving). Review rates quarterly.

4. Not tracking accessorial charges on the customer side

You pay drivers detention. Do you charge customers for it? If not, you're eating that cost. Your settlement template needs a mirror on the customer invoice side so accessorial flows both ways.

5. Treating 1099 contractors like W-2 employees

1099 owner-operators are independent contractors. You can't dictate routes, force specific work hours, or require company uniforms. Deductions that look like wage-style withholding (taxes, Social Security) on a 1099 are a red flag for IRS misclassification audits. Consult an accountant — or a lawyer — before you blur this line.

6. Paying weekly on one method, then tipping or side-paying on another

Cash bonuses, side payments, and "I'll make it up next week" promises destroy the math. Everything goes on the settlement. Everything.

7. Not reconciling with QuickBooks (or your accounting system)

Your settlement spreadsheet and your accounting books need to match. If the spreadsheet says you paid Driver A $1,200 last week but QuickBooks shows $1,450, something is wrong. Reconcile monthly at minimum. Reconcile weekly if you can.

When to Graduate From Spreadsheet to Software

This template works. But it doesn't scale. Here are the signs you've outgrown it:

• You spend more than 60 minutes per driver per week on settlements
• You have 5+ drivers and the weekly settlement now takes a full workday
• You're re-entering the same data into QuickBooks or payroll after finishing the spreadsheet
• Drivers dispute settlements and you can't pull the source data fast enough to resolve it
• You're doing IFTA quarterly by hand because your settlement data doesn't flow to IFTA
• You catch a deduction error a month later and have no audit trail to fix it cleanly

FleetLegend handles all of this automatically. Settlements pull load data directly from dispatch. Accessorial and deductions carry over week-to-week. Settlements sync to QuickBooks bi-directionally, so the two systems can never drift. And your IFTA data comes from the same load records you already entered — no duplicate data entry.

If your fleet has outgrown the spreadsheet, start a free FleetLegend trial — connect your existing telematics, import your driver list, and run your next settlement in under 15 minutes.

Frequently Asked Questions

Is this template free to use?

Yes. Download it, modify it, share it with your drivers. There's no license fee and no tracking. It's an Excel (.xlsx) file you own outright once you download it.

Does the template work in Google Sheets?

Yes. Open the .xlsx file in Google Sheets and all formulas convert automatically. The only difference is cell formatting may need light cleanup.

How do I customize it for my fleet?

Change the default rates (per-mile, percentage, accessorial amounts) in Section 2 and Section 3. Add or remove deduction rows in Section 4 based on what you actually deduct. If you add rows, check that the TOTAL formula at the bottom extends to cover the new rows.

What's the difference between per-mile, percentage, and flat-rate pay?

Per-mile pays a fixed cents-per-mile rate (good for predictable weekly revenue and long-haul drivers). Percentage pays a % of the gross the load earned (good for drivers running high-value lanes). Flat-rate pays a weekly salary regardless of miles (used for dispatchers, yard drivers, or W-2 retention). Most small fleets use per-mile for company drivers and percentage for owner-operators.

Should I pay my drivers on loaded miles only or all miles?

All miles is the more common model today and generally the fairer one — drivers don't control when they have to deadhead. Loaded-miles-only is cheaper for you but harder to recruit against. If you run loaded-miles-only, pay a higher per-mile rate to offset (e.g., $0.70/loaded mile is roughly equivalent to $0.55/all miles for most lane mixes).

How do I handle IFTA and settlements together?

IFTA tracks fuel tax owed to each state based on miles driven in that state. Settlement pays the driver based on total miles (or %, or flat). The two workflows share source data (miles per trip) but have different outputs. The template here covers settlements only. See our complete IFTA filing guide for the IFTA side — and FleetLegend automates both from the same load records.

What records should I keep for IRS / DOL audits?

Keep signed settlement sheets (physical or digital) for 7 years. Keep supporting documents (BOL copies, rate confirmations, fuel card statements) for the same period. For 1099 contractors, keep the 1099 and the W-9 on file. For W-2 drivers, keep standard payroll records per federal and state law. IRS and DOL don't accept "we didn't keep that" as a response.

Can drivers see the settlement before payment?

They should. Best practice is to share the settlement sheet on Thursday, let drivers flag issues on Friday morning, finalize and pay Friday afternoon. Driver signoff (even a text reply) creates a clean record and cuts dispute risk.

Download the Template

Click below to download the Excel template. Branded for FleetLegend. Works in Microsoft Excel, Apple Numbers, and Google Sheets. All formulas preserved.

📥 Download the FleetLegend Owner-Operator Settlement Template (.xlsx)

File size: ~9 KB. Hosted on Sanity CDN — no email gate, no form, no tracking pixel. Just download and use.

When you've outgrown the spreadsheet, FleetLegend handles the same workflow automatically — settlements, deductions, accessorial, QuickBooks sync, IFTA mileage — all from the same load records your dispatcher already enters. Start a free trial, or book a 15-minute walkthrough.

Related Reading

• Complete Guide to Driver Settlements — full pillar article
• How to Calculate Driver Settlements Per Mile — step-by-step
• Per-Mile vs Percentage Driver Pay: Which Is Better?
• Trucking Chart of Accounts: Free Template & Setup Guide