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
When 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 answerHow do I prepare my rental property books for my CPA?
Your CPA needs income and expense totals by property, categorized correctly for Schedule E. Separate each property in your records, distinguish repairs from improvements, and have mortgage statements and receipts ready.
Read answerHow do I prepare my contractor books for tax season?
Start by reconciling all accounts through December 31 and ensuring every expense is coded to the correct job. Then gather 1099 information for subcontractors, compile equipment records, and review outstanding receivables and payables.
Read answerWhat documents do I need to catch up my books?
Bank statements are the essential foundation for any catch-up project. Add credit card statements, payment processor records, and whatever invoices or receipts you have. Missing some documents shouldn't stop you from getting started.
Read answerShould I use a payroll service or do it myself?
For most small businesses, a payroll service is worth the $40-100 monthly cost. DIY payroll can work if you have one or two employees and are willing to stay on top of tax filings and deadlines yourself.
Read answerHow do I add users to my QuickBooks account?
In QuickBooks Online, go to Settings, then Manage Users, and click Add User. Choose a user type based on what access they need, enter their email, and they'll receive an invitation to join your company file.
Read answer
