How do I track loads and income by customer?
Tracking loads by customer starts with setting up every broker, shipper, and freight company you haul for as a separate customer in your accounting software. In QuickBooks, add each one with their company name and relevant details. When you invoice for a completed load, select that customer so the income automatically gets attributed to them.
For each load, create an invoice or sales receipt that captures the essential details. Include the load number or reference, origin and destination, line haul rate, and any accessorial charges like detention, layover, or lumper fees. Some trucking companies use the memo field for lane information while others add custom fields for equipment type. The goal is capturing enough detail to understand what you hauled and what you earned without making data entry a burden.
If you run multiple loads for the same customer, track each load as a separate invoice. This gives you visibility into individual hauls while the customer total rolls up automatically. You can also use the projects feature in QuickBooks Online to group loads under a customer if you want that extra layer of organization.
Run a Sales by Customer report monthly to see where your revenue comes from. Sort by total amount and you’ll quickly identify your top customers. Compare this across quarters to spot trends. A customer who was 30% of your revenue last year but only 15% this year might have changed their rates or reduced their freight. That’s worth knowing before you plan next year.
Many owner-operators and small trucking companies use dispatch software, load boards, or TMS systems to manage operations. The challenge is making sure your books match what your dispatch shows. Either enter loads manually from your dispatch reports weekly or look for integrations that sync data to QuickBooks. Manual entry takes more time but forces you to review each transaction. Automated syncing saves effort but requires verification that everything imported correctly.
Tracking income by customer tells you who pays. The deeper question is which customers are actually profitable after your costs. Fuel, maintenance, tolls, and your time all factor in. A customer paying higher rates on short runs with deadhead back might be less profitable than one paying modest rates on consistent lanes with loaded return trips. Getting your books set up correctly is the foundation, and working with a bookkeeper for small business owners who understands trucking can help you build reports that show real profitability by customer.
Keep rate confirmations and load confirmations organized by customer. Save them in folders or attach them directly to invoices in QuickBooks. When disputes come up months later about what was agreed, you need documentation accessible without digging through email.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I catch up on months of bookkeeping?
Start by gathering bank statements, credit card statements, and receipts for every month you're behind. Work chronologically from the oldest month forward, reconciling each account before moving on. The time investment grows quickly beyond a few months.
Read answerWhat chart of accounts should an art gallery use?
Art galleries need a chart of accounts that handles consignment properly. The key is separating gallery-owned sales from consignment commissions and tracking what you owe artists as a liability.
Read answerHow do I track equipment costs across multiple job sites?
Track equipment hours or days on each job site, then allocate depreciation, fuel, and maintenance costs proportionally. Set up your accounting software to assign these allocated costs to specific jobs.
Read answerHow do I track cleaning fees and platform fees for vacation rentals?
Track platform fees and cleaning expenses as separate line items. Record gross booking revenue as income, then record platform fees as a deductible expense. Cleaning fees collected from guests are income, and payments to cleaners are expenses.
Read answerHow do I set up QuickBooks for my small business?
Start with the right version for your needs, build a chart of accounts that matches how you actually run your business, connect your bank feeds, and enter accurate opening balances. Getting these fundamentals right from the start prevents problems later.
Read answerWhat is the best bookkeeping software for truckers?
The best software depends on your operation size and tracking needs. QuickBooks works well for core bookkeeping, though you may need trucking-specific apps for IFTA tracking and load profitability. What matters most is picking something you'll actually use consistently.
Read answer
