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
How do I track cash sales and prevent theft in a retail business?
Cash-heavy retail businesses need daily cash counts, POS reconciliation, same-day bank deposits, and surprise audits. In QuickBooks Online, record daily cash deposits and compare them to your POS cash sales report. Any variance over $5 per day signals a problem worth investigating.
Read answerWhat California labor laws affect salon payroll and bookkeeping?
California has strict rules around tip credits, daily overtime, meal and rest breaks, piece-rate pay, and worker classification that directly impact how salon owners run payroll and keep their books. Getting any of these wrong can trigger EDD audits and costly penalties.
Read answerWhat are the biggest bookkeeping mistakes restaurant owners make?
The costliest mistakes include not tracking food costs weekly, failing to reconcile POS reports to bank deposits daily, and commingling personal and business expenses. These errors hide profit leaks and create tax problems.
Read answerHow do I handle multi-currency transactions for an import business in QuickBooks?
Enable multi-currency in QuickBooks Online, then record vendor bills in the supplier's currency. QBO converts at the exchange rate on the transaction date and recognizes gains or losses when you make the actual payment.
Read answerWhat financial reports should a healthcare practice owner review monthly?
Focus on your P&L by location and provider, A/R aging for both insurance and patient balances, net collection rate, overhead ratio, and cash flow statement. These reports together tell you whether your practice is financially healthy or heading toward trouble.
Read answerWhat does a nonprofit need for Form 990 preparation and how does bookkeeping help?
Form 990 requires functional expense allocation, revenue by source, key employee compensation, governance disclosures, and program accomplishments. Clean monthly bookkeeping with proper categorization makes 990 prep straightforward instead of an expensive reconstruction project.
Read answer