Excel for trucking owner-operators and small fleets
For owner-operators, small fleet owners and dispatchers who want to know whether a load is worth taking before they say yes. Excel works out your real cost per mile from fixed and running costs, shows what a load pays per mile once the deadhead is counted, puts a profit on every load, and gives you the minimum rate to quote. Every formula below runs on a month of loads for a one-truck operation you can edit.
- Owner-operators
- Small fleet owners
- Dispatchers
- Hotshot and box truck operators
- Office staff who track loads and settlements
General spreadsheet help, not tax, legal or compliance advice. Your costs, fuel prices and rates go in the input cells; check rules for your operation with a professional.
Sample data
Every result on this page comes from this sheet, calculated by the same engine the Cellwise app uses. Change a number and watch the formulas react.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Date | Broker | Loaded mi | Deadhead mi | Pay | Tolls | Settings | |
| 2 | Nov 2, 2026 | Ridgeway | 612 | 48 | 1650 | 0 | Diesel price per gallon | 3.85 |
| 3 | Nov 3, 2026 | Blue Lake | 438 | 95 | 1120 | 22 | Truck MPG | 6.5 |
| 4 | Nov 5, 2026 | Harbor | 805 | 30 | 2210 | 0 | Fixed costs per month | 6200 |
| 5 | Nov 6, 2026 | Ridgeway | 290 | 140 | 780 | 14 | Maintenance and tires per mile | 0.21 |
| 6 | Nov 9, 2026 | Blue Lake | 1040 | 60 | 2650 | 38 | Planned miles per month | 10000 |
| 7 | Nov 11, 2026 | Harbor | 520 | 25 | 1480 | 0 | Target profit per mile | 0.4 |
| 8 | Nov 12, 2026 | Ridgeway | 375 | 110 | 900 | 0 | ||
| 9 | Nov 16, 2026 | Blue Lake | 690 | 40 | 1890 | 26 | ||
| 10 | Nov 18, 2026 | Harbor | 455 | 180 | 1050 | 0 | ||
| 11 | Nov 20, 2026 | Ridgeway | 930 | 55 | 2420 | 31 |
What Excel does for trucking
Know your cost per mile
Every rate decision starts here. Your cost per mile has three parts: fixed costs (truck payment, insurance, permits, software) spread over the miles you run in a month, fuel (price per gallon divided by MPG), and the per-mile running costs like maintenance and tires.
Keep each input in its own cell. When diesel moves or your insurance renews, you change one number and every quote on the sheet updates.
Result: 1.4223076923 shows as $1.42 with Currency format
$1.42 a mile: $0.62 of fixed cost ($6,200 over 10,000 miles), $0.21 for maintenance and tires, and $0.59 of fuel ($3.85 a gallon at 6.5 MPG).
Compare rate per loaded mile with rate per total mile
Brokers and load boards quote per loaded mile, but you also drive the deadhead to pick up, and those miles burn the same fuel. Divide the pay by loaded plus deadhead miles to see what the load really pays for every mile the truck moves.
The gap matters most on short loads with a long drive to the shipper. A load that looks like the best rate on the board can be one of the worst once the empty miles are in.
Result: 1.8139534884 shows as $1.81 with Currency format
$1.81 per total mile for the Nov 6 load. At $2.69 per loaded mile it looks as good as the Nov 2 load ($2.70), but its 140 deadhead miles drop it to $1.81 per total mile, against $2.50 for the Nov 2 load.
Put a profit on every load
Profit per load is the pay, minus tolls, minus every mile (loaded and empty) times your cost per mile. Using the full cost per mile, fixed costs included, tells you whether the load pays its share of the truck, not just its fuel.
Write it once and fill it down a load log, and sorting by profit shows which lanes and brokers are carrying the month.
Result: 711.27692308 shows as $711.28 with Currency format
$711.28 profit on the Nov 2 Ridgeway load: $1,650 of pay, no tolls, less 660 miles at $1.42.
Track your deadhead share
Empty miles are the quiet cost in trucking. Total deadhead divided by all miles (loaded plus deadhead) is the share of the truck's miles nobody paid for directly.
Watch it by month and by broker. A rising share usually means you are taking loads that end far from the next freight, which is a reason to plan the reload before you book.
Result: 0.11285673105 shows as 11.3% with Percent format
11.3% of the month's 6,938 miles were deadhead: 783 empty miles.
Work out the pay you need before you accept a load
Before you counter a broker, work out what the load must pay to hit your target: all its miles (loaded plus deadhead) times your cost per mile plus your target profit per mile, plus tolls. ROUNDUP to the next whole dollar gives a number you can say on the phone.
If the offer is under it, you know exactly how far to push, or that the load is one to pass on.
Result: 798 shows as $798 with Currency format
$798 for the Nov 6 load: 430 miles at $1.42 cost plus $0.40 profit, plus $14 of tolls. It paid $780, so it missed the target by $18 even though $2.69 a loaded mile sounded good.
Find the load that paid least per mile
MIN on pay divided by total miles finds the lowest rate in the month; MATCH finds its row and INDEX returns the broker. The division runs for every load at once inside the formula, so you need no helper column.
Change INDEX(B2:B11 to INDEX(A2:A11 to get the date instead.
Result: Harbor
Harbor: the Nov 18 load paid $1,050 for 635 miles (455 loaded, 180 deadhead), $1.65 per total mile, the lowest of the month, even though Harbor's other loads paid well.
See which broker pays best per mile
Average the rate per mile by broker the right way: total pay divided by total miles for that broker, using SUMIF on each column. Averaging the per-load rates instead lets one short load count as much as a 1,000-mile run.
Do the same for each broker in a small table to compare them side by side.
Result: 2.3952602624 shows as $2.40 with Currency format
$2.40 per total mile from Blue Lake ($5,660 over 2,363 miles), ahead of Harbor at $2.35 and Ridgeway at $2.25.
Practice: 8 exercises
Use the sample data above. Type a formula and press Check: it is graded by a real spreadsheet engine, the way Cellwise grades lessons. Solved: 0
-
1How many loaded miles did the truck run this month?
Show answer
=SUM(C2:C11)= 6155. 6,155 loaded miles across the ten loads. -
2How much did Ridgeway loads pay in total?
Show answer
=SUMIF(B2:B11,= 5750. Four Ridgeway loads paid $5,750."Ridgeway", E2:E11) -
3How many loads had more than 100 deadhead miles?
Show answer
=COUNTIF(D2:D11,= 3. Three loads: Nov 6, Nov 12 and Nov 18.">100") -
4What did the Nov 5 Harbor load (row 4) pay per loaded mile?
Show answer
=E4/C4= 2.7453416149. $2,210 over 805 miles is about $2.75 a loaded mile. -
5How many gallons of diesel did the Nov 9 load (row 6) burn, counting deadhead? Use the MPG in H3.
Show answer
=(C6+D6)/H3= 169.23076923. 1,100 miles at 6.5 MPG is about 169 gallons. -
6What did the whole month pay per total mile?
-
7How much did loads delivered before Nov 16 pay?
-
8What was the profit on the Nov 18 load (row 10) after tolls and all miles at the full cost per mile (H4/H6+H5+H2/H3)?
Show answer
=E10-F10-(C10+D10)*(H4/H6+H5+H2/H3)= 146.83461538. $1,050 minus 635 miles at $1.42 is about $146.83: it covers its costs, but at $0.23 a mile it is well under the $0.40 target.
Free templates for trucking
- Trucking cost per mile calculator templateFor owner-operators and small fleet owners who want to know their real cost per mile and the lowest rate worth taking.Free .xlsx
- Trucking load tracker templateFor owner-operators and dispatchers who want a month of loads in one place.Free .xlsx
Guided project: Owner-operator cost per mile
Guides for these formulas
- How to calculate fuel cost and mileage in Excel
- How to make a mileage log in Excel
- How to calculate the break-even point in Excel
- SUMIF vs SUMIFS: what is the difference?
- SUMIF date range in Excel: sum between two dates
- How to use the INDEX MATCH formula in Excel
- ROUND vs ROUNDUP vs ROUNDDOWN in Excel
- How to calculate cost per unit in Excel (formula and examples)
FAQ
How do I calculate my trucking cost per mile in Excel?
Put your monthly fixed costs, miles per month, diesel price, MPG and per-mile running costs in cells. Then =fixed/miles + price/MPG + running_costs gives the cost of every mile the truck moves. The free trucking cost per mile calculator does this and checks any load offer against it.
Should I include deadhead miles when I work out rate per mile?
Yes, when you compare a load with your costs. The truck burns fuel and wears tires on empty miles too. Divide the pay by loaded plus deadhead miles, and compare that with your cost per mile.
What is a good rate per mile for an owner-operator?
It depends on your own costs, lanes and equipment, so start from your numbers rather than someone else's: your cost per mile plus the profit you want, divided by your loaded share of miles, is your minimum rate per loaded mile.
How do I track truck maintenance in Excel?
List each service with its interval in miles and the odometer when it was last done, look up each truck's current odometer, and subtract to get miles until due. The free fleet maintenance tracker flags what is overdue or due soon by miles and by date.
Excel for other fields
- Auto repair
- Bookkeeping
- Call centers
- Cleaning services
- Coaches and sports teams
- Construction and trades
- Event planning
- Farms and growers
- Fitness and habits
- Freelancers
- Home and family
- HR and people ops
- Marketing
- Medical office
- Nonprofits
- Personal finance and taxes
- Project management
- Real estate
- Restaurants
- Retail and ecommerce
- Sales teams
- Salons and spas
- Small business
- Students
- Teachers
- Warehouse and logistics
Updated