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
Can a bookkeeper fix years of disorganized records?
Yes, a skilled bookkeeper can reconstruct and organize financial records going back several years. Bank statements provide the foundation, and missing documentation can usually be worked around. The longer you wait, the harder it becomes.
Read answerWhen should I hire a bookkeeper?
When bookkeeping takes more time than it's worth, when you don't know your actual numbers, or when tax time becomes a scramble. Most business owners wait too long. Hiring before you're behind is cheaper than cleaning up the mess later.
Read answerWhat expenses should contractors track for each job?
Track labor hours, materials, subcontractor invoices, equipment costs, and permits for every job. Each expense needs a job code before it hits your books. Without this discipline, you won't know which projects actually make money.
Read answerWhat bookkeeping mistakes do contractors commonly make?
The biggest mistake is not tracking costs by job, which makes it impossible to know which projects actually make money. Other common errors include mixing personal and business expenses, mishandling subcontractor 1099s, and waiting too long to reconcile accounts.
Read answerWhat expenses can artists deduct on their taxes?
Artists can deduct materials, studio space, equipment, marketing costs, show fees, travel, and professional development. The key is running your art practice as a business and tracking expenses as they happen.
Read answerHow do I track fuel costs and mileage for my trucking business?
Fuel cards capture purchase data automatically, while ELD or GPS systems track mileage by truck and by state. Organize everything by unit number so you can calculate cost per mile and have clean records for IFTA reporting.
Read answer
