How to Calculate Your Cost Per Mile as an Owner-Operator (Spreadsheet Method)

Ask ten owner-operators what their cost per mile is and you’ll get four shrugs, four numbers pulled from memory, and two people who actually know. The two who know are almost always the ones still in business in three years.

The number matters because it’s the only thing that turns a rate offer into a decision. Without it, “$2.40 a mile to Atlanta” is just a number a broker said. With it, it’s either a load you take or a load you pass on, and you know which within about four seconds.

Here’s how to build the number properly, and why the shortcut versions of this calculation are the ones that quietly put people under.

The Formula, and Where It Goes Wrong

Cost per mile is not complicated:

(Fixed costs + Variable costs) ÷ Total miles run = Cost per mile

Every failure mode in this calculation is in the inputs, not the arithmetic.

Fixed costs are what you owe whether the truck rolls or sits in the yard all month: truck or trailer payment, physical damage and liability insurance, occupational accident coverage, base plates and permits amortized monthly, ELD subscription, accounting or dispatch fees, parking. If the bill arrives regardless of miles, it’s fixed.

Variable costs scale with the wheels turning: fuel, DEF, tires, oil changes and preventive maintenance, unplanned repairs, tolls, scales, lumpers, and any road expenses you eat.

Total miles is the input people get wrong most often, and they get it wrong in the direction that flatters them.

The Deadhead Problem

If you divide costs by loaded miles only, you’re pretending the empty miles were free. They weren’t. You burned fuel, put wear on the truck, and used up hours.

Say you ran 9,400 loaded miles last month plus 1,100 deadhead. Your costs were $17,800.

• Divided by loaded miles: $1.89/mile
• Divided by total miles: $1.70/mile

The second number is your true cost of operating. The first is the number that matters when you’re comparing a broker’s rate offer, because a broker pays you on the loaded run. Both are useful, and mixing them up is how you end up booking freight that pencils out on paper and doesn’t in your bank account.

The workable rule: calculate break-even on total miles, evaluate individual loads on loaded miles, and track deadhead as its own column so you can see whether a lane’s empty leg is quietly eating your margin.

Where the Industry Number Sits

For context on whether your figure is plausible: ATRI’s 2026 Analysis of the Operational Costs of Trucking put the industry-average cost to operate a truck in 2025 at $2.336 per mile — up 3.4% year over year and the highest in the report’s history. Excluding fuel, costs rose 4.2% to $1.854 per mile.

The line items that moved most were tolls (up 13.2%), repair and maintenance (up 8.6%), driver benefits (up 6.6%), and tires (up 6.4%). First-quarter 2026 data, per ATRI, show most of those trends continuing.

Your number will differ from $2.336, sometimes by a lot. A fleet’s figure includes driver pay as an expense; an owner-operator running their own truck often doesn’t, which makes an owner-operator break-even look lower — right up until you remember you still have to eat. Whether you count your own pay is a bookkeeping choice, but be consistent about it, and know which version of the number you’re quoting yourself when you evaluate a load.

Building It in a Spreadsheet

The reason this belongs in a spreadsheet rather than a notebook is that the inputs change constantly and the output has to stay current. Here’s the structure that works.

Tab 1 — Truck fixed costs. One row per unit: payment, insurance, permits. A formula totals them into a fixed dollars-per-month figure. You set this up once and touch it when a policy renews.

Tab 2 — Load log. One row per load: date, truck, load number, origin, destination, loaded miles, deadhead miles, broker, revenue. A rate-per-mile column calculates itself from revenue and miles.

Tab 3 — Fuel log. Date, truck, state, miles in state, gallons, price per gallon. Cost and MPG calculate from those. Tracking by state matters for a second reason we’ll get to.

Tab 4 — Expenses. Date, truck, category, vendor, amount. Categories should map to Schedule C lines so this doubles as your tax prep.

The dashboard. This is where it pays off. Total revenue, total miles, fuel cost, and other expenses roll up automatically, and three numbers fall out:

That third row is the whole point. Profit per mile is the number that tells you whether the month worked, and it updates every time you log a load.

The Trucking Owner-Operator Bookkeeping & IFTA Tracker from ReadySheetGo is built around exactly this structure — fixed costs per unit feeding a dashboard that calculates revenue, cost, and profit per mile automatically as you log loads and fuel stops.

The Numbers Most Owner-Operators Forget

Four categories that reliably get left out, each of which moves cost per mile by a few cents:

Amortized major repairs. A $6,000 engine repair isn’t a March expense; it’s a cost of running the truck across the whole year. If you only count it in the month it happened, March looks catastrophic and every other month looks better than it was. Set aside a per-mile maintenance reserve instead — many operators use 10 to 15 cents per mile — and treat it as a real cost.

Tire replacement. Same logic. Drive tires don’t fail on a schedule, but they fail predictably enough to reserve for.

Downtime. The week the truck was in the shop, fixed costs kept accruing over zero miles. Your annual cost per mile absorbs this correctly. Your good-month cost per mile doesn’t.

Your own time. If you’re not paying yourself a line-item wage, your cost per mile isn’t a business cost per mile — it’s a break-even-before-eating figure. Know which one you’re using.

Using the Number

Once it’s live, the decision framework is short.

A broker offers $2,450 for an 785-mile run, with 45 miles of deadhead to the pickup.

• Rate per loaded mile: $2,450 ÷ 785 = $3.12
• Cost against total miles run (830): 830 × your $1.70 cost per mile = $1,411
• Gross margin: $1,039

That’s a load you take. Change the offer to $1,700 and the margin drops to $289 for two days of work plus the deadhead — at which point the question isn’t whether it’s profitable, it’s whether it’s worth the truck’s time versus waiting for something better in a market where you have options.

Owner-operators who know their number can answer that in seconds. Owner-operators who don’t end up running a lot of miles for a thin margin and calling it a busy month.

The math isn’t the hard part. Keeping it current is. That’s what the spreadsheet is for.

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, fuel and 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, an IFTA quarterly summary that calculates taxable gallons and net tax owed by state, a business dashboard with cost per mile and 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: ATRI — 2026 Analysis of the Operational Costs of Trucking