Free Driver Settlement Template: When Spreadsheets Break at 10+ Trucks

By Truckpedia Team. Updated November 2026.

Quick answer

A driver settlement statement lists each load in the pay period, the pay method (per mile, percentage of revenue or flat rate), accessorials and reimbursements, then subtracts deductions like fuel advances, escrow, lease and insurance to reach net pay. A spreadsheet works for a few trucks; once you settle 10+ drivers weekly, re-typing and errors usually justify a TMS.

Key takeaways

• Every settlement needs: header (carrier, period, driver), load lines, pay method, additions, deductions, net pay.
• Covers company drivers (per mile, W-2) and leased owner-operators (% of linehaul + fuel surcharge, 1099), plus a flat-rate CSV option.
• Keep owner-operator (1099) deductions separate from company-driver (W-2) payroll taxes.
• Breakpoints at 10+ trucks: weekly volume, fuel card reconciliation, disputes, re-keying from dispatch.
• Download the Excel workbook (with built-in formulas), printable PDF sample, or flat CSV below. No sign-up needed.

Download free (no sign-up): Driver Settlement Template (.xlsx with formulas) · Sample Statements (.pdf) · Flat Table (.csv)

What a driver settlement must include

A settlement is the document your driver checks before anything else you send them. If it is clear, you get fewer calls. If it is not, every line turns into a dispute. Build every statement with these four blocks.

Settlement header

• Carrier name and MC/DOT number
• Settlement number
• Pay period: the date range of the loads covered, not the pay date
• Issue date

Driver details

• Driver name
• Driver type: company driver (W-2) or owner-operator (1099)
• Truck number

Load lines and additions

• Load number
• Miles (for per-mile pay) or load revenue (for percentage pay)
• Pay type and line pay
• Additions: detention, layover, stop pay
• Reimbursements: tolls, scales and other approved out-of-pocket costs

Deductions and net pay

• Fuel advances
• Fuel card charges
• Escrow
• Truck lease
• Insurance
• Other agreed deductions
• Net pay = line pay + additions + reimbursements − deductions

A note on taxes: payroll taxes for company drivers (W-2) belong in your payroll system, not on this sheet. Owner-operator (1099) deductions follow your lease agreement. Check both with your accountant; this template is not tax advice.

Free driver settlement templates (Excel, PDF and CSV)

Pick the format that matches how your office works today:

• Excel workbook (.xlsx with formulas): ready-to-use spreadsheet with three tabs (Company Driver, Owner-Operator and How to Use), automatic totals, a fuel card detail table, year-to-date tracking and an escrow balance summary.
• Sample statements (.pdf): finished, driver-ready PDF printouts for both pay structures so you can review the layout before customizing.
• Flat load table (.csv): single sheet covering per-mile, percentage and flat pay if you prefer importing raw columns into Google Sheets or another tool.

Template tabs and sections

Formulas

In the Excel workbook (.xlsx), black cells already contain live formulas and update automatically when you edit the yellow pay settings or blue input cells. If you build from the flat CSV, use these formulas:

• Company driver (per mile): line pay = (loaded miles + empty miles) × rate per mile
• Owner-operator (% of linehaul + FSC): load pay = (linehaul × linehaul share) + (fuel surcharge × FSC share)
• Flat rate: line pay = flat rate
• Total deductions: fuel card purchases + cash advances + escrow + trailer or truck lease + insurance + other deductions
• Net settlement: gross pay + non-taxable reimbursements − total deductions

How to use the template

1. Open the Excel workbook and replace the sample carrier header (Ridgeline Freight LLC) with your company name, address and MC/DOT number.
2. Enter the driver's pay settings in the yellow cells (rate per mile for company drivers; linehaul percentage and fuel surcharge share for owner-operators).
3. Type the period's loads, accessorials, reimbursements and deductions into the blue input cells. Leave the black formula cells untouched.
4. Need more rows? Insert them inside the table (above its last row) so the SUM ranges expand automatically.
5. Keep reimbursements separate from taxable gross wages on W-2 statements, and show gross revenue per load plus every chargeback on leased owner-operator statements.
6. Export a PDF for the driver and save a separate workbook copy for each pay period so you never overwrite past statements.

Worked example

From the downloadable Excel and PDF sample statements (fictional carrier Ridgeline Freight LLC, pay period Nov 2–8, 2026). Replace all numbers with your own rates and agreements.

Marcus Reed (W-2 company driver) ran five loads totaling 2,141 loaded miles and 126 empty miles at $0.62 per dispatched mile ($1,405.54 line pay), plus $180.00 in detention, extra stop and layover pay ($1,585.54 taxable gross). Reimbursements of $56.25 (tolls and CAT scale) stay separate because they are non-taxable, and $162.50 in deductions brings his settlement statement to $1,479.29 before payroll tax withholdings on his pay stub.

Tony Alvarez (1099 leased owner-operator) ran four loads earning 75% of $6,745.00 in linehaul plus 100% of $1,252.00 in fuel surcharge ($6,310.75 load pay) and $335.00 in pass-through detention and lumper fees ($6,645.75 gross settlement). Fuel card purchases from the itemized Fuel Detail table ($1,167.83 across Pilot and Love's) plus recurring lease, insurance, ELD, IFTA, escrow ($100.00, bringing his escrow balance from $1,400.00 to $1,500.00) and a $200.00 EFS advance total $1,812.83 in deductions, leaving $4,832.92 net via ACH.

Where spreadsheets break at 10+ trucks

A spreadsheet is a fine way to settle a few drivers. The trouble starts when the same steps repeat every week for a bigger team.

Weekly volume

Every driver needs a statement every pay period. Each new truck adds another one to build, check and send, on the same deadline.

Fuel card reconciliation

Fuel card charges have to be matched to the right truck and driver before they can come off a settlement. With more cards, more drivers swapping trucks and more transactions, that matching gets harder to do by hand.

Re-typing loads from dispatch

The loads are already in your dispatch board and on the BOLs. In a spreadsheet, someone types them again: miles, revenue, accessorials. Every re-type is a chance to get one wrong.

Disputes and version control

When a driver questions a number, you need to show which file, which rate and which deduction. With copies saved on different desktops and emailed back and forth, finding the right version takes time.

Escrow audit trail

Escrow balances build up week by week and have to be correct when an owner-operator leaves. A spreadsheet does not keep a reliable history of who changed what.

What a TMS automates in driver settlements

A TMS built for carriers takes the settlement out of the spreadsheet and builds it from data you already have:

• Pulls loads from dispatch, so miles, revenue and accessorials are not typed twice.
• Applies pay profiles per driver: per mile, percentage or flat.
• Brings in fuel card transactions and puts them on the right driver.
• Runs recurring deductions like escrow, lease and insurance each period.
• Produces statements you can send to drivers.
• Exports to accounting, so the books match what you paid.

Truckpedia includes driver settlements in its plan, from $299/month with 100+ integrations, and connects to your ELD, fuel card and factoring company. Brown Dog Carriers is saving 20 hours on average each week after switching from McLeod TMS to Truckpedia. Truckpedia is an AI-powered TMS built to automate 80% of manual work, and it is rated #1 with 4.8 stars.

New to TMS software? See our guide to what a trucking TMS does.

Checklist before you switch from spreadsheets

• List every pay type you use today (per mile, percentage, flat, hourly) and which driver gets which.
• List every deduction type, one-time and recurring.
• Export the last 3 months of settlements.
• List your fuel card and factoring providers.
• Confirm current escrow balances for every owner-operator.
• Run one parallel pay week: settle in the spreadsheet and the new system, and compare line by line.

FAQ

What should a driver settlement statement include?
The carrier and driver details, the pay period, each load with its pay method and amount, accessorials and reimbursements, every deduction, and the final net pay.

How do you calculate percentage pay for an owner-operator?
Multiply the load revenue by the agreed percentage, add accessorials and reimbursements, then subtract deductions such as fuel advances, escrow, lease and insurance.

What deductions go on a trucking settlement?
Common ones are fuel advances, fuel card charges, escrow, truck lease payments, insurance and other agreed items. Payroll taxes for W-2 drivers are handled in payroll; check with your accountant.

When should a trucking company stop using spreadsheets for settlements?
When weekly settlements, fuel card reconciliation and re-typing loads from dispatch start causing errors or disputes. For many carriers that shows up around 10 or more trucks.

Is the driver settlement template free?
Yes. Download the Excel workbook (with built-in formulas for company drivers and owner-operators), the printable PDF sample, or the flat CSV with no sign-up. All sample data uses fictional carrier numbers; replace them with your own rates.

Settle drivers from your dispatch data

Keep the template as long as it works for you. When settlement day starts taking over your week, see how Truckpedia builds settlements from the loads you already dispatch, from $299/month with 100+ integrations.

Get a demo

Related: Truckpedia pricing, Truckpedia vs Truckbase.