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
Should I have a separate bank account for each rental property?
Not necessarily. If all your properties are in one LLC or your personal name, a single operating account with proper bookkeeping can track each property separately. But if properties are in different LLCs, you need to keep the accounts separate to maintain legal protection.
Read answerHow do I calculate profitability for my short-term rental?
Profitability comes down to net revenue minus operating expenses. Track booking revenue after platform fees, then subtract cleaning costs, supplies, utilities, insurance, and all the other expenses that come with running the property.
Read answerHow do I track business expenses effectively?
Start with a dedicated business bank account and credit card. Capture receipts immediately, categorize transactions weekly, and connect everything to accounting software that pulls in your bank feeds automatically.
Read answerHow do I set up bookkeeping for rental properties?
Start with a dedicated bank account and set up per-property tracking in your accounting software. Your chart of accounts should mirror Schedule E categories, and security deposits must be recorded as liabilities, not income.
Read answerHow do I calculate cost per mile for my trucking business?
Add up every expense tied to running your truck and divide by total miles driven. The challenge is capturing all costs, not just the obvious ones like fuel and maintenance.
Read answerHow do I track labor costs by project in QuickBooks?
Enable projects in QuickBooks, set up time tracking that assigns hours to each project, and connect it to payroll so hours convert to actual labor costs. The setup is straightforward but requires daily discipline from your crew.
Read answer
