October 5, 2026 · Mitt Patel · 6 min read
Three trucks, one fuel bill, one repair bill, one loan payment total on the statement each month. You know the whole fleet costs you something in the neighborhood of $4,000 a month. What you don't know is whether Truck 2 is quietly costing more than the other two.
Why this happens
Most small fleets start with one truck, one gas card, one loan. You track total vehicle expense because that's all there is to track. Then you add a second truck, then a third, and the habit never changes. Fuel still goes into one "vehicle expense" account. Repairs still land in one bucket. The loan payments show up as separate lines, but nobody connects them back to which truck is actually earning its keep.
The cost of not knowing shows up in decisions, not in the bookkeeping itself. You decide whether to replace a truck based on a gut feeling that "it's been in the shop a lot," not on a number. You quote jobs using an average cost-per-mile that's wrong for every truck except the one that happens to sit exactly at the average. You keep an old truck running because the payment is gone, without noticing that repairs and fuel have quietly replaced the payment and then some.
None of this is a bookkeeping failure exactly. It's a setup gap. QuickBooks Online can split every dollar by vehicle without much extra work once it's built, but almost no one builds it until a truck decision forces the question.
A worked example
Say you run three service trucks. The combined monthly numbers look like this:
- Loan payments: $1,800 total
- Fuel: $1,500 total
- Tolls: $300 total
- Repairs and maintenance: $600 total
Total: $4,200 a month in cash going out the door. Divided three ways, that's $1,400 per truck, and if you're pricing jobs off that average, every job gets roughly the same vehicle charge baked in.
Now say you tag every one of those expenses by truck for a month and the real breakdown looks like this:
- Truck 1: $900 loan, $400 fuel, $50 tolls, $50 repairs — $1,400 total
- Truck 2: $600 loan, $450 fuel, $100 tolls, $400 repairs — $1,550 total
- Truck 3: $300 loan (almost paid off), $650 fuel, $150 tolls, $150 repairs — $1,250 total
The average was hiding the story. Truck 2 has a middling payment but by far the highest repair cost — it's likely older and getting expensive to keep on the road. Truck 3 has almost no payment left but burns the most fuel, which might mean it's doing the longest routes, or it might mean it needs a look. Once you see these three numbers apart, the next decision — repair, replace, or reassign routes — has something real behind it.
One note on the loan lines: they're the full monthly payments, which is the right way to compare what each truck costs you in cash. On the profit and loss, only the interest part of each payment is an expense; the principal pays down what you owe on the truck.
How to set it up
- Create a class or tag for each vehicle in QuickBooks Online. Use the vehicle's name or number — "Truck 1," "Van — Ford Transit," whatever your crew already calls it. Classes work well here because you can run a Profit and Loss by Class report and see every vehicle's numbers side by side, though this requires setting up a class for each truck consistently.
- Turn on class tracking if it isn't already on, and set QuickBooks to prompt you for a class on every transaction. This closes the door on expenses slipping through untagged.
- Get a separate fuel card per truck where your fuel provider allows it. Some fleet card programs let you assign one card per vehicle at no extra cost, though this varies by provider. This alone fixes the biggest blind spot, because fuel is usually the most frequent transaction and the easiest to lose track of.
- Set up each loan payment as a recurring split transaction: principal to that truck's loan account, interest to interest expense with the truck's class. Payments rarely change amount, so this is built once per vehicle and the split is updated from the lender's statement.
- Tag repair and maintenance bills as they come in, ideally right from the shop invoice, since that's the moment you know which truck it was.
- Run a Profit and Loss by Class report monthly and scan the vehicle columns against each other, not just against last month.
Mistakes that undo it
- Splitting fuel evenly across trucks instead of by card. If two trucks still share one card, someone has to remember which fill-up belonged to which truck, and that habit doesn't survive a busy week.
- Leaving a "shared" or "shop" catch-all class for anything that seems like it applies to more than one vehicle. This becomes a dumping ground and quietly erodes the accuracy of every truck's number.
- Forgetting insurance and registration. These are often paid once or twice a year and get missed because they don't show up monthly. If they're not tagged by vehicle, your per-truck cost will look lower than it really is.
- Booking the whole loan payment as an expense. Only the interest is an expense; the principal reduces what you owe on the truck. Split each payment using the lender's statement, and a lease needs its own look, since the treatment depends on its terms.
- Letting a truck sit un-tagged after it's sold or retired. Old classes left active clutter the report and make it harder to compare the fleet you actually have.
Monthly checklist
- Confirm every fuel, toll, repair, and loan transaction has a vehicle tag before you close the month.
- Run Profit and Loss by Class and check that no dollar amount shows up under an "unclassified" or "shared" column.
- Compare each truck's total to last month's — a repair spike or fuel jump is easier to catch early than after three months of drift.
- Check that insurance, registration, or any annual vehicle cost due that month is tagged correctly.
- Note any truck whose repair costs are creeping up month over month; that's the signal that matters most for a replace-or-repair decision.
Common questions
Do I need separate fuel cards, or can I just track fuel by receipt?
Separate cards make it far more reliable, since the system does the sorting for you at the pump. If a separate card per truck isn't available through your provider, tracking by receipt works, but it depends on someone writing the truck number on every receipt the same day — a habit that tends to slip during busy weeks.
What if two trucks share a driver or a route?
Tag the expense to whichever truck actually generated it — the fuel that went into Truck 2's tank belongs to Truck 2, even if the same driver used Truck 1 the day before. Labor and route planning are separate questions from vehicle cost, and mixing them tends to blur both.
Should I use classes or tags for this in QuickBooks Online?
Classes are usually the better fit for vehicles because they let you run a full Profit and Loss by Class report, showing income and expenses side by side by truck if you also track which jobs each vehicle was used for. Tags are a lighter option if you only want to filter expense reports. Which one fits depends on whether you also want job or crew data broken out the same way.
How far back should I go to get a useful comparison?
A single month is enough to prove the setup works, but three to six months gives a real pattern, especially for repairs, which tend to cluster rather than spread evenly. Seasonal businesses may want a full year before drawing conclusions about any one truck.
North Hudson Bookkeeping sets up this kind of vehicle-by-vehicle tracking in QuickBooks Online and keeps it current every month, so the numbers are ready when you need to make a call on a truck. The first call is free.
