How to Know if a Load Is Worth Taking Before You Book It (Rate-Per-Mile Spreadsheet)

The load board shows a number. The broker’s on the phone. You have maybe ninety seconds to decide, and the decision compounds — take enough marginal loads and you’ve run a very busy quarter for very little money.

The operators who consistently get this right aren’t better negotiators. They just have the arithmetic already done, so the ninety seconds is spent on the decision instead of the math.

The Four-Number Check

Every load evaluation is the same four numbers:

1. Rate per loaded mile. Revenue ÷ loaded miles. This is the number brokers quote and the number you compare against other offers.

2. Total miles you’ll actually run. Loaded miles + deadhead to the pickup. This is what the truck burns.

3. Your cost against those miles. Total miles × your cost per mile.

4. Gross margin. Revenue − cost.

Worked example. A broker offers $2,450 on a 785-mile Dallas–Atlanta run, and you’re 45 miles from the pickup.

• Rate per loaded mile: $2,450 ÷ 785 = $3.12
• Total miles: 785 + 45 = 830
• Cost at $1.70/mile: 830 × $1.70 = $1,411
• Gross margin: $1,039

Take it.

Now the same lane at $1,700:

• Rate per loaded mile: $2.17
• Cost: still $1,411
• Gross margin: $289

That’s two days of driving, a night out, and the truck 830 miles from home, for $289 before you pay yourself. In a soft market you might take it to reposition. In a market with 75,000 loads posted, you don’t.

The point isn’t that $2.17 is bad and $3.12 is good in the abstract. It’s that you can’t tell which is which without your cost per mile, and that number is the one most owner-operators don’t have current.

Where the Market Sits Right Now

Some context for what you should be seeing on the board. FTR and Truckstop.com data reported by Overdrive in early July 2026 put the broad spot average at $3.64/mile, with van at $2.99, reefer at $3.46, and flatbed at $3.83. DAT’s Trendlines showed posted loads in the last week of June up 62% year over year.

Diesel’s national average sat at $4.67/gallon in that same window — down 16 cents on the week and roughly 97 cents off the 2026 high set a couple of months earlier.

That combination is unusual and it’s in your favor: strong rates, more selection, and falling fuel. It also raises the cost of a bad decision. When there are three loads to choose from, taking a weak one isn’t just thin margin — it’s the better load you didn’t book because your truck was committed.

One owner-operator quoted in that piece put it plainly: he books in advance because “you get better rates and way more selection booking in advance.” That only works if you can evaluate offers fast enough to commit early with confidence.

The Costs That Don’t Show Up in the Rate

Rate per mile is a headline. Four things reliably erode it, and none appear in the number the broker quotes.

Detention that doesn’t get paid. Six hours at a receiver is six hours of clock you can’t spend elsewhere. Track it as a column on the load log with a paid/unpaid flag. Over a quarter, the pattern of which brokers and which receivers burn your hours becomes obvious, and it’s actionable — you stop booking with them.

Lumpers, scales, and tolls. Reimbursed sometimes, eaten sometimes. Log them against the specific load so your per-load margin is real rather than notional.

The reload problem. A load that pays well and strands you in a market with nothing outbound has a hidden cost: the deadhead on the next run. This is the one people miss, because it shows up on a different row of the spreadsheet. Tracking origin and destination on every load, and deadhead separately, is what surfaces it.

Payment terms. A rate that’s 10 cents better on 45-day terms versus quick pay is not necessarily better if you’re financing fuel in the meantime.

Making the Check Take Four Seconds

None of the above is hard. It’s just that doing it per load, in your head, on the phone, is unrealistic — so people stop doing it and go by feel.

The fix is that your cost per mile lives somewhere current, and the load log does the per-load arithmetic automatically.

A load log with columns for date, truck, load number, origin, destination, loaded miles, deadhead, broker, revenue, and a calculated rate-per-mile gives you two things at once. Per load, it tells you what you actually made. Across the quarter, it tells you your revenue per mile, which lanes and which brokers pay, and where deadhead is concentrated.

Combine that with a dashboard that rolls fuel, expenses, and fixed truck costs into a live cost-per-mile figure, and the ninety-second phone call becomes: rate per loaded mile is X, my cost is Y, the deadhead is Z miles. Yes or no.

The Trucking Owner-Operator Bookkeeping & IFTA Tracker from ReadySheetGo handles both halves — a load/trip log with automatic rate-per-mile and separate deadhead tracking, feeding a dashboard that calculates revenue per mile, cost per mile, and profit per mile as you go.

What the Log Tells You After Three Months

The per-load decision is the immediate payoff. The pattern data is the bigger one.

After a quarter of logging, four questions have answers that you were previously guessing at:

Which brokers actually pay well? Average rate per mile grouped by broker. Some of the names you assume are cheap aren’t, and some you like aren’t paying what you think.

Which lanes work? Not just rate, but rate net of the deadhead required to service them and the reload availability at the far end.

What’s your real revenue per mile? Not the good loads you remember. All of them, including the repositioning runs and the cheap freight you took on a slow Thursday.

Is your cost per mile moving? It is. Tires, a repair, an insurance renewal, fuel swinging a dollar a gallon in two months — the number you calculated in March isn’t the number in July.

That last one is why this belongs in a sheet that recalculates rather than a figure you worked out once and remember. The market is moving fast in both directions right now. Booking against a stale cost per mile is how a strong-rate quarter still comes up short.

Featured on ReadySheetGo

Trucking Owner-Operator Bookkeeping & IFTA Tracker — 9 tabs built for one truck or a small fleet. Load/trip log with automatic rate-per-mile and separate deadhead tracking, fuel & IFTA log by state with MPG, expense log mapped to Schedule C categories, per-unit fixed cost sheet, preventive maintenance schedule with next-due odometer alerts, IFTA quarterly summary with taxable gallons and net tax owed by state, a dashboard with revenue/cost/profit per mile, and a tax summary with net taxable profit. Pre-filled with sample data. Works in Excel and Google Sheets, no macros. Instant digital download — $19.99.

Sources: Overdrive — Volumes boom, diesel fizzles: Fireworks hit the spot market before July 4