Choose the format that works best for you google sheets or an excel spreadsheet

What Does Your Truck Actually Cost to Run?

Most owner-operators can’t name their cost per mile within twenty cents. That’s the number that decides whether $1.90 a mile is a decent run or a slow loss once deadhead, the truck note, and maintenance are counted. This free cost per mile calculator works it out in about ten minutes.

No email required. No form. Take it and use it.


 

Diesel just made this number matter a lot more

The national average for diesel passed $6 a gallon this month for the first time on record. California’s statewide average is above $8. Year over year, diesel is up roughly $2.30 a gallon.

Run 100,000 miles at 6.5 MPG and that’s about $35,000 more in fuel this year than last — for the same miles, in the same truck.

Here’s the part that should worry you: fuel spikes have historically lined up with waves of carrier failures. Not because fuel went up, but because rates didn’t, and the operators who couldn’t see it kept hauling loads that had quietly stopped being profitable.

The ones who came through knew their number and either renegotiated or turned the load down.


What the calculator does:

Three tabs. Nothing to install.

Cost Per Mile

Fixed costs and variable costs, kept separate — because that separation is where most people get it wrong. Your truck payment costs the same whether you run 8,000 miles or 12,000. Fuel doesn’t. Mix them together and every number after that is wrong.

Enter your figures and it gives you your real cost per mile, plus the rate you need per loaded mile to clear it.

Expense Log

Every expense in one place, with categories that line up with Schedule C. Come tax time you’re not rebuilding a year from a shoebox.

Summary

Pulls it all together. Cost per mile, target rate, where the money actually went.

It comes pre-filled with example numbers, so you’re typing over something rather than staring at an empty grid.


The mistakes this catches

Deadhead miles are real miles

Empty miles burn fuel, wear the truck and use hours, and they earn nothing. If your cost per mile is worked out on loaded miles only, it’s too low — and every rate you’ve accepted was measured against the wrong number. The calculator separates loaded from total.

Your settlement pays net, but your 1099 reports gross

If you’re leased on, fuel advances, escrow, occupational accident, trailer rent and tolls come off before the deposit lands. Book the deposit as your revenue and both your income and your expenses are understated — and the figure on your return won’t match what the IRS already has.

Escrow is worse. That’s your money, held back and coming back to you. Net it out and nobody is tracking the balance. Over two years that’s real money people forget to ask for.

Accounting is a fixed cost, not an afterthought

It’s in the fixed cost list on the first tab, because it is one. Whether you do it yourself at 11pm or pay someone, it costs you something. Worth pricing honestly.


Who this is for

Owner-operators and small fleets. Leased on or running your own authority — the math is the same, only the deductions change.

If you’re about to add a truck, do this first. Cost per mile on one truck is a number. Across three it’s the thing that tells you which truck is making money and which one isn’t.


What to do with the number

Once you know your cost per mile, three things get easier:

  • Say no to a load and know why. A rate below your break-even is a loss you’re volunteering for.
  • See your fuel surcharge for what it is. Often the difference between a profitable lane and one that isn’t.
  • Talk to a lender or a factor with evidence. “I run at $1.61 a mile” lands differently than “I think I’m doing alright.”

Choose the format that works best for you google sheets or an excel spreadsheet

Who made this?

COGS Bookkeeping does bookkeeping for owner-operators and small fleets. Settlement reconciliation, IFTA records, cost per mile reporting, and books that are ready at tax time instead of a January scramble.

We built this calculator because it’s the first thing we work out for a new client, and there’s no reason you should have to hire someone to find out your own number.

If you’d rather not keep the books yourself, that’s what we do. If you would, keep the spreadsheet — it’s yours either way. Either way, get in touch if you have questions.


Questions

Is it really free?

Yes. No email, no signup.

Do I need Google Sheets?

No. The download version opens in Excel, Numbers or LibreOffice. The Sheets version is there if you prefer working in a browser.

What if my numbers change?

They will. Fuel moves, rates move, maintenance comes in waves. Redo it quarterly — it takes ten minutes once your figures are in.

I’m leased on. Does this still apply?

Yes, and it’s arguably more useful. Your deductions come off the settlement, so the money leaves before you see it. This puts it back where you can look at it