How to Use a Car Hauling Trip Profitability Worksheet Before Accepting a Load

A $3,000 car-haul load can look strong on the dispatch board and still create a cash squeeze. The route may include a long pickup deadhead, expensive tolls, a contractor settlement, and a broker payment term that leaves you funding the trip for weeks. Those are two different questions: Does the move make money, and when will the money be available? Use a car hauling trip profitability worksheet for each candidate load. Calculate the load-level operating margin first, then map the billing packet and expected payment date separately. That keeps a profitable trip from being mistaken for immediately available cash.

Step 1: Fill out the car hauling trip profitability worksheet before you price the load

Start with the facts you know and label estimates clearly. Record the broker or customer, rate confirmation amount, vehicle count, pickup location, delivery location, appointment windows, equipment required, and the likely next lane after delivery. Include the planned start date, expected delivery date, and the date you can submit a complete invoice. A load that delivers on Friday but cannot be billed until a signed POD, condition report, or gate release is uploaded may collect later than the delivery date suggests. Use separate fields for confirmed revenue, estimated accessorials, estimated miles, and payment assumptions.

Step 2: Calculate total route miles, including deadhead

Loaded miles are only part of a car-hauling trip. Add the miles from the truck’s starting point to pickup, miles between multiple pickup or delivery stops, loaded route miles, and the post-delivery reposition to the next planned load or home base. Keep each segment visible in the car haul revenue and expense worksheet so you can see where the route is consuming capacity.

If you’re comparing two loads, compare the whole route rather than the payout alone. A load with a lower rate can produce a better result if it starts near your truck, uses a practical lane, and leaves you positioned for the next dispatch. A higher-paying load may lose that advantage when pickup deadhead and an unattractive outbound lane are included.

Step 3: Convert miles into fuel and toll costs

Use a conservative fuel assumption based on the truck, trailer, terrain, weather, and expected idle time. The basic calculation is: Fuel cost = total trip miles ÷ estimated miles per gallon × fuel price per gallon. If fuel price varies across the route, split the estimate by region or use a documented planning average. Keep the assumption visible so you can replace it with actual receipts after delivery.

Add tolls as a separate line instead of burying them in a mileage rate. Include tolls for the loaded route, deadhead repositioning, and any bridge or turnpike charges created by the appointment sequence. If the route may change, enter a range and use the higher reasonable estimate when deciding whether the load clears your margin target.

Step 4: Add driver, contractor, and trip-level operating costs

Labor is usually one of the largest load-level costs, but the correct treatment depends on how your operation pays the driver. Enter driver or contractor pay using the method your company actually uses: percentage of linehaul, cents per mile, day rate, salary allocation, or another documented settlement method.

Then add costs that belong to this move or can be reasonably allocated to it, including fuel, tolls, lodging, parking, trip advances, loading or unloading fees, storage or yard charges, permitted booking or payment-processing fees, and a maintenance reserve or equipment allocation used consistently across comparable loads. Don’t count the same cost twice. If a contractor percentage already includes a fuel component, don’t add that same fuel amount again unless the settlement agreement treats it separately.

Step 5: Separate confirmed revenue from accessorial exposure

Enter the base linehaul first. Then list accessorials in two categories: amounts already approved in writing and amounts that are possible but not yet confirmed. Potential detention, storage, redelivery, extra-stop, washout, or delay charges may affect the final invoice, but they shouldn’t be treated as guaranteed revenue.

A useful worksheet shows both figures: Expected collected revenue = confirmed linehaul + approved accessorials − known deductions. Upside revenue = expected collected revenue + unapproved accessorials that may be recovered. Make the decision using expected collected revenue, not the upside number. If the trip only works when an unapproved detention claim is paid, the load carries more billing risk than its rate confirmation suggests.

Step 6: Calculate operating margin and margin per mile

Once the revenue and trip costs are entered, calculate the load-level result: Operating margin = expected collected revenue − trip-level operating costs. Then calculate: Operating margin per total mile = operating margin ÷ total trip miles. Use total trip miles, not loaded miles, when comparing candidate moves. This exposes the cost of pickup deadhead and the reposition after delivery.

You can also calculate margin per calendar day if the load consumes multiple appointment days, but keep the measure consistent across the dispatch board. This worksheet is a decision tool, not a substitute for your full company profit-and-loss statement. Insurance, truck payments, permits, office payroll, taxes, and other fixed costs still have to be covered by the fleet. Whether you allocate those costs to each load or review them at the monthly level, use one method consistently.

Step 7: Map payment timing separately from profitability

After calculating the margin, start a second section for cash timing. Record the expected delivery date, date the POD and invoice packet will be complete, stated payment terms, factoring or quick-pay assumptions, anticipated deductions, and the date funds are expected to clear. The expected cash date isn’t the same as the invoice date.

Missing paperwork, a disputed condition report, a rate-confirmation mismatch, or an unapproved accessorial can delay collection even when the trip itself was profitable. Use this sequence: delivery completed; POD, BOL, condition report, photos, and other required documents collected; invoice submitted to the correct payer; invoice accepted or returned for correction; payment term begins according to the applicable agreement; and funds received, posted, and matched to the load.

If you use factoring or quick pay, show the fee as a separate cost and record the earlier funding date as a cash-flow assumption. Don’t present the accelerated amount as the load’s gross revenue.

Step 8: Keep the supporting records with the worksheet

The worksheet should point to the documents behind each material number: rate confirmation, fuel receipts, toll records, settlement detail, invoices, receipts, delivery paperwork, and payment confirmation. The IRS says businesses may use a recordkeeping system suited to their operation, but it should clearly show income and expenses. Supporting documents such as invoices, receipts, paid bills, and deposit records should support entries in the books. Verify current tax-record requirements with the IRS or your tax adviser before relying on a retention practice.

Use one cash-flow review before accepting the load

Run this short review after the operating margin is calculated. It should expose a cash problem before the truck commits to the lane.

Review the result with the dispatch board

The final decision should use both numbers: operating margin and cash timing. A load may be worth accepting if the margin is strong and the cash gap fits your reserve. Another load with similar margin may be a poor choice if it creates a long deadhead, consumes several appointment days, or requires you to fund a large driver settlement while the receivable remains unresolved.

Before accepting, challenge the assumptions that can move the result most: total miles, fuel price, pickup access, appointment feasibility, driver pay, toll exposure, and payment documentation. For routes with tight appointment windows, confirm that the plan fits available HOS and that the driver and administrative staff can properly record, certify, and transfer required ELD information. FMCSA’s ELD training guidance assigns operational responsibilities to drivers and administrative staff, including accurate records, edits, certification, malfunction reporting, and electronic transfer. Verify current ELD and HOS requirements for the vehicle and operation before dispatch.

Use one worksheet for each candidate load and review the assumptions before accepting it. The goal isn’t to predict every dollar perfectly. It’s to make the deadhead, cost, margin, and collection risk visible before they become your problem.

Frequently asked questions

How do car haulers calculate profit per load?

Subtract trip-level costs such as fuel, tolls, driver or contractor pay, lodging, fees, and allocated operating costs from expected collected revenue. Divide the result by total trip miles—not only loaded miles—to compare loads with different deadhead exposure.

What should a car haul revenue and expense worksheet include?

Include confirmed linehaul, approved accessorials, total route miles, pickup and delivery deadhead, fuel, tolls, driver or contractor pay, trip expenses, possible deductions, operating margin, and margin per total mile. Add a separate section for invoice submission and expected payment timing.

Why should payment timing be separate from load profitability?

A load can have a positive operating margin while the carrier is still waiting for the invoice to be processed and paid. Separating the two shows whether the trip is profitable and whether the company has enough cash to fund fuel, settlements, and other obligations before collection.

Should unapproved detention or storage be counted as revenue?

No. Show unapproved accessorials as possible upside or billing exposure, but base the acceptance decision on confirmed revenue and accessorials that are reasonably supported. Update the worksheet after the broker or customer approves or rejects the charge.

What records should support a car-hauling profitability worksheet?

Keep the rate confirmation, invoice, POD, condition documentation, fuel and toll records, settlement detail, receipts, payment records, and notes about deductions or disputes with the worksheet. The IRS states that a business recordkeeping system should clearly show income and expenses and that supporting documents substantiate entries in the books; verify current requirements with the IRS or a tax adviser.

Related TruckTA resources

• How to Reduce Empty Miles in Auto Transport: Compare the Whole Route, Not Just the Payout
• Car Hauling Accounts Receivable Checklist: From POD to Payment
• Car Hauler Load File Checklist for Billing
• Car Hauler Dispatch Appointment Feasibility Checklist: HOS, Waiting Time, and Escalation