Somewhere in your operation right now there’s a rate con buried in your email, a fuel receipt on the floor of the cab, a settlement you haven’t opened yet, and a broker who still owes you for a load you delivered eleven days ago, and if somebody asked you this minute what your truck actually earned last week, the honest answer is that you’d have to go digging before you could say. That’s not a character flaw. That’s what happens when the whole back office of a trucking company lives in one person’s head while that person is also driving the truck. The fix doesn’t cost anything. A free spreadsheet on your phone, set up once and filled in for five minutes a day, will tell you more about your business than most paid software tells a fleet ten times your size.
This lesson walks you through building it. Three tabs, a handful of columns, and a routine you can keep from a truck stop parking spot. You don’t need to buy software to get organized. You need to know where every load, every dollar and every mile went, and a spreadsheet does that job fine at one truck, three trucks, and for a lot of carriers, well past that.

Why the Numbers Have to Live Somewhere
Running blind is expensive right now. The American Transportation Research Institute’s latest cost analysis put the average cost of running a truck at a record $2.34 per mile in 2025, up 3.4 percent from the year before, as Overdrive reported. When costs sit that high and rates sit where they sit, the carriers who survive are the ones who know their numbers to the penny, not the ones who feel like the week went okay.
The money side is just as unforgiving. Brokers and shippers commonly take 30 days to pay, some stretch to 60 or 90, and FreightWaves has described small carriers sitting on $40,000 to $100,000 of delivered but unpaid work at any given time. If you’re not tracking who owes you what and since when, you won’t notice the broker who quietly slid past his terms until your own bills notice for you.
Build the Load Tab First
Open Google Sheets or Excel on your phone, both free versions work, and name the first tab Loads. One row per load. Give it these columns and nothing fancier. Date delivered. Broker or customer name. Load or reference number. Origin and destination. Loaded miles. Deadhead miles. Line haul rate. Fuel surcharge. Lumper or accessorial money. Total due. That last column just adds the rate, the surcharge and the extras together.
Keep the fuel surcharge in its own column instead of burying it in the rate. When diesel moves, you want to see what the surcharge actually covered, and when you start quoting direct shippers, you’ll already be used to pricing the line haul and the fuel separately. How to Build a Fuel Surcharge Into a Shipper Deal covers how that works on the customer side.
Here’s what a row looks like in practice. Say your Thursday load runs 340 loaded miles at $2.05 a mile with a 38-cent fuel surcharge. That’s $2.43 a mile all in, which comes to $826.20, and you type five numbers to capture all of it. Thirty seconds at the fuel island while you’re waiting on a receipt to print.
Add the Money Tab
The second tab is Invoices, and its whole job is answering one question. Who owes me money and how old is the debt. Columns: invoice number, broker or customer, amount, date you sent the invoice, payment terms, the date the money actually landed, and days outstanding. That last one is today’s date minus the invoice date, and the spreadsheet will calculate it for you once and forever.
Sort it by days outstanding once a week. Anything past its terms gets a call that day, and How to Invoice a Broker and Get Paid on Time walks through what that follow-up sounds like. This tab is also where factoring decisions stop being guesswork. Factoring companies typically advance 90 to 97 percent of an invoice and charge roughly 1.5 to 4 percent, while broker quick pay runs 1 to 5 percent per load. When your Invoices tab shows you’re waiting an average of 38 days to get paid and carrying $12,000 outstanding, you can do the math on what that wait is really costing you instead of signing a factoring agreement out of panic. How to Choose a Factoring Company picks it up from there.

The Cost Per Mile Tab Ties It Together
The third tab is Costs, and it’s the one that turns a load log into a business tool. List your fixed costs by month: truck payment, insurance, trailer payment, ELD subscription, parking, plate and permit money set aside monthly. Then your variable costs as they happen: fuel, maintenance, tolls, washouts. At the end of each month, divide total costs by total miles from the Loads tab. That’s your cost per mile, for your truck, from your real life, not an industry average.
Now every load you’re offered has a floor. If your all-in cost is $1.92 a mile and a broker offers a load that pays $1.85 with the deadhead counted, the spreadsheet already made the decision for you. If you want the math checked, run your numbers through the free cost per mile calculator, then keep the habit going monthly in your own sheet. Pricing direct freight starts from this same number, which is why How to Price a Direct Lane From Your Cost Per Mile should be your next read once this tab has a month of data in it.
The Five-Minute Routine That Keeps It Alive
A spreadsheet nobody updates is just a guilty conscience with gridlines. Tie the habit to things you already do. When you get a rate con, the load goes in the Loads tab before you roll. When you send paperwork for a load, the invoice row goes in before you put the phone down. When you fuel, the receipt amount goes in the Costs tab while the pump is still clicking. None of those moments takes a full minute, and together they keep the whole system honest without ever feeling like office work.
Photograph every receipt and BOL as backup while you’re at it. How to Go Paperless With Your Load Documents shows you how to set that up in an evening, and the two systems feed each other. The photos prove the numbers, the spreadsheet finds the numbers.
What Changes at Three Trucks and at Ten
At one truck, the three tabs are the whole system. At two or three trucks, add a truck number column to every tab and filter by it, because now you need to know which truck is earning and which one is eating. The structure holds, and most carriers at this size still don’t need to pay for anything. At somewhere between five and ten trucks, the spreadsheet starts to strain, not because the math breaks but because too many hands need the same file at once and dispatch needs to see it live. That’s the point where entry-level transportation management software earns its monthly fee, and What to Automate First in a Small Fleet lays out that upgrade path in order. The best part of starting with the spreadsheet is that by the time you shop for software, you’ll know exactly which columns you can’t live without, because you built them.
Questions Carriers Ask
Do I really need this if my factoring company already shows me my settlements? Yes, because your factoring portal shows what they bought from you, not what your business earned or spent. It won’t show the load you didn’t factor, your deadhead, your cost per mile or the broker you invoiced directly. Their records serve their business. This one serves yours.
Google Sheets or Excel? Whichever you’ll actually open. Sheets is free with any Google account, lives in the cloud automatically, and works fine on a phone, which is where most of your entries will happen. Excel’s free mobile version does the same job. Pick one and don’t switch, because the habit matters more than the software.
I’m leased on and the carrier handles my settlements. Is there any point? More than you’d think. Track your settlements, deductions, miles and fuel in the same three-tab layout, and you’ll know your real cost per mile under the lease. That number is exactly what you’ll need the day you run the math on your own authority, and How to Know You’re Ready for Your Own Authority starts from it.
How far back should I go when I set it up? Start with the first of this month and go forward. Rebuilding six months of history sounds responsible, but it’s the kind of project that kills the habit before it starts. A clean month of real data beats a heroic weekend of reconstruction you never finish.
This Week’s Assignment
Build the three tabs tonight, it takes about twenty minutes, and enter only this week’s loads, invoices and fuel. Then do the thirty-second entry every time a rate con, invoice or receipt touches your hands for the next seven days. Next weekend, sort your Invoices tab by days outstanding and look at who’s past terms. That one sort usually pays for the whole habit.
Learn this next
Once the tracker is running, put the paper side on your phone with How to Go Paperless With Your Load Documents, tighten up your billing with How to Invoice a Broker and Get Paid on Time, and when the fleet grows, follow What to Automate First in a Small Fleet.
Bottom Line
You don’t need software to run your trucking company like a business. You need every load, every invoice and every dollar of cost written down in one place you can open from the driver’s seat, and a free spreadsheet does that the day you build it. Start with three tabs this week, and let the numbers start working for you instead of hiding from you.

Innovative Logistics Group

