How do I set up bookkeeping for a small fleet of trucks or freight brokerage?
The foundation of fleet bookkeeping is treating each truck as its own profit center. Instead of lumping all revenue and expenses together, you want to see exactly how much each truck earns and how much it costs to operate. This is the only way to know which trucks are profitable, which ones are bleeding money, and whether adding or cutting a truck makes financial sense.
In QuickBooks Online, set up classes or locations to represent each truck. Every transaction gets tagged to the appropriate truck. When you run a Profit and Loss by Class report, you get what amounts to a separate income statement for each unit. That single report will tell you more about your business than a standard P&L ever could.
For each truck, track these direct costs: driver pay (wages or per-mile pay), fuel, maintenance and repairs, insurance, and the truck payment or lease. These are the costs that exist because that specific truck is on the road. When you record a fuel purchase, tag it to the truck that burned it. When you pay a driver, tag it to the truck they drove. No shortcuts here. If you skip the tagging, your per-truck reporting is meaningless.
Fleet-level overhead is separate. Office rent, dispatch salaries, authority and compliance fees, software subscriptions, and accounting costs don’t belong to any single truck. Set these up in their own expense categories without a truck class. You can allocate overhead across trucks proportionally (usually by revenue or miles driven) to get a fully loaded cost picture, but keep the allocation separate from direct costs so you can see both views.
Beyond the P&L, track three numbers that every freight and logistics operation needs to watch. Revenue per mile tells you how well you’re pricing loads. Cost per mile tells you what it actually takes to move freight. Empty mile percentage tells you how much you’re driving without getting paid. These metrics are what separate fleet owners who grow profitably from those who stay busy but never make money. Build them into a simple spreadsheet or dashboard and review them weekly.
If you’re running a freight brokerage rather than an asset-based fleet, the structure shifts. You don’t have truck-level costs, but you still need to track margin per load. Revenue minus carrier cost gives you gross profit on each shipment. Categorize your overhead separately so you can see true brokerage margins after operating expenses.
Set up your chart of accounts with enough detail to be useful but not so much that data entry becomes a nightmare. Fuel, maintenance, insurance, driver pay, and truck payments each get their own expense account. Don’t bury truck insurance inside a general insurance line item. You need to see these breakdowns clearly.
The most common mistake with small fleet bookkeeping is starting sloppy and trying to fix it later. Get the structure right from day one. If you already have months of untagged transactions, clean them up before moving forward or your reports will be unreliable. A bookkeeping professional in Orange County who understands trucking can configure QBO correctly and train you or your team to tag transactions consistently so the numbers you rely on are actually accurate.
Orange County's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote with no surprises.
More Questions
Can a bookkeeper handle my payroll or do I need a separate payroll service?
For most small businesses, a bookkeeper can absolutely handle payroll. It's a natural extension of bookkeeping, and having one person manage both means cleaner books and fewer reconciliation headaches. A dedicated payroll service becomes worth considering when your situation gets complex.
Read answerHow do I track restricted vs. unrestricted donations in QuickBooks?
Use separate income accounts for donations with and without donor restrictions, and track specific restrictions using classes in QuickBooks Online. When the restriction is fulfilled, release the funds through a journal entry.
Read answerHow does per diem work for truck drivers and how do I track it in bookkeeping?
Owner-operators can deduct per diem for meals while away from their tax home overnight. The IRS allows 80% of the federal M&IE rate, currently $69 per day for most locations. Tracking requires a logbook showing dates and locations of overnight stays.
Read answerWhat is the difference between payroll setup and ongoing payroll processing?
Payroll setup is a one-time project covering state registration, workers' comp, and software configuration. Ongoing processing is the recurring work each pay period of calculating pay, withholding taxes, filing deposits, and generating pay stubs.
Read answerHow often should a restaurant owner review their books and what reports matter most?
Weekly at minimum for food cost, labor cost, and daily sales trends. Monthly for the full P&L, prime cost analysis, A/P aging, and cash flow. Thin margins mean waiting too long to review your numbers can cost thousands before you notice.
Read answerDo I need a bookkeeper if I run a small import and distribution business?
Yes. Import and distribution businesses deal with landed costs, 3-way matching, inventory valuation, and cash flow timing that make accurate bookkeeping essential even at a small scale.
Read answer