How to Calculate Driver Pay for Car-Hauling Fleets

One driver expects a percentage of the whole invoice. Your dispatcher calculates it on linehaul only. The settlement sheet subtracts a fuel receipt, but nobody can explain whether that receipt belongs in the pay calculation at all. Before you argue over the final number, fix the inputs.

For a quick one-load comparison, TruckTA's free truck driver pay calculator shows percentage, per-car, and per-mile gross amounts using only the numbers you enter. It does not calculate taxes, withholding, or take-home pay. This guide goes further: build written pay rules, connect work to the right driver, and separate earned compensation from the final payout.

All rates, dollar amounts, mileages, and assignments below are illustrative, not market benchmarks or recommended compensation. This is an operating worksheet, not a payroll compliance determination. Before using it for actual pay, have your payroll or legal adviser confirm current requirements for your operation, including pay timing, deductions, and any additional compensation.

Write the pay rules before building formulas

Start with a pay-plan record for each driver. Give it a plan ID, effective date, calculation method, rate, and approval reference. Keep the previous version when a rate changes. An old trip should still point to the rule used to calculate its earnings, not silently recalculate whenever someone edits the driver's current rate.

For percentage pay, replace “percentage of gross” with an exact description. Does the basis include linehaul, fuel surcharge, detention, extra-stop charges, and cancellation revenue? Record each category as included or excluded. On a brokered load, use the documented carrier revenue specified by the plan; don't substitute an assumed amount the shipper paid the broker.

For per-car pay, specify what earns the unit payment. In this template, use one completed vehicle movement identified by load ID and VIN, with separate handling for a relay or repeat movement. Decide how pickup-only work, a failed gate release, a canceled vehicle, or a second delivery attempt enters the calculation. Don't leave dispatch to invent those rules during settlement.

For mileage pay, name the mileage source and treatment of deadhead, repositioning, and approved reroutes. Keep estimated miles separate from final payable miles. If your plan uses a routing distance, store that distance and its source with the trip. If it uses actual mileage, retain the supporting trip record. Don't switch sources halfway through the pay period.

Also separate the work date, calculation period, scheduled pay date, and customer collection date. Give unresolved items an owner and a review deadline rather than quietly moving them to another week. Treat the compensation schedule as a separate rule from whether the broker has paid the invoice.

Finally, distinguish three labels throughout the workbook: eligible revenue is the basis selected for percentage pay; gross driver earnings is calculated compensation before payout adjustments; net payout is the resulting payment after separately reviewed adjustments. Never label all three simply “net.”

Compare all three methods on the same work

Use one completed-work example to test your formulas. Suppose a driver completes eight vehicle movements over 1,200 loaded miles and 300 deadhead miles. The carrier's revenue is $4,800 in linehaul, $400 in fuel surcharge, and $200 in detention, totaling $5,400. An additional $75 driver payment applies under each sample plan.

For this comparison only, the percentage plan includes linehaul and detention but excludes fuel surcharge. The per-car plan counts all eight completed movements. The mileage plan pays both loaded and deadhead miles at the same rate. These are three alternative plans, not three payments to add together.

For the percentage formula, calculate eligible revenue first, then multiply by the rate. Store 25% as 0.25 if your spreadsheet uses decimal rates. A useful check is to display the included revenue categories next to the result. Here, paying 25% of the full $5,400 instead would produce $1,350 before the $75 addition, a $100 difference caused entirely by the revenue definition.

For the per-car formula, multiply completed payable units by the applicable unit rate. If different vehicle categories carry different rates, calculate each category separately and sum the results. Keep the vehicle movement list behind that total. A dispatch board showing eight booked cars isn't, by itself, the completed-work list used in this example.

For mileage pay, calculate loaded miles and deadhead separately, even when their rates match. The general formula is loaded miles × loaded rate + payable deadhead miles × deadhead rate. In this example, loaded-mile pay is $900 and deadhead pay is $225. Leaving out the empty leg would reduce base pay by $225.

Keep stop pay, waiting-time payments, bonuses, and other approved earnings on their own lines. If a payment is already inside a vehicle rate or percentage calculation, don't add it again unless the plan expressly provides both. Customer detention revenue and driver waiting-time compensation should have distinct fields, even when your plan connects them.

For an operating comparison, divide each gross earnings total by the same 1,500 total route miles. The results are approximately $0.883, $0.797, and $0.800 per total mile, respectively. Label these comparison figures clearly; they are not the contractual mileage rates.

Separate gross earnings, reimbursements, and payout

Build the earnings calculation first. Then create a separate payout section. For this worksheet, use: gross driver earnings − reviewed payroll withholding and deductions − reviewed advance recovery + reimbursements paid with this payout = net payout. Import reviewed payroll amounts rather than estimating taxes with a universal percentage.

Using the percentage example, suppose the reviewed payroll output supplies $250 in withholding and deductions, and a separately reviewed advance recovery is $100. The driver also has a $60 reimbursement to receive with this payment. The arithmetic is $1,325 − $250 − $100 + $60 = $1,035 paid out. The $250 and $100 are hypothetical inputs, not guidance on what may be withheld.

Keep the $60 visible as a reimbursement rather than presenting it as additional trip earnings in this operating comparison. Link it to the receipt and record who originally paid. If the company already paid the expense directly, don't also enter it as money owed back to the driver. Leave tax treatment to the reviewed payroll process.

Treat “percentage of net revenue” as a different pay basis, not another name for take-home pay. If an approved plan uses revenue after specified costs, list those costs individually before multiplying. For illustration, a $5,000 eligible revenue basis less a specified $600 cost gives $4,400; at 25%, base earnings would be $1,100 instead of $1,250. That $150 difference belongs in the explanation.

Don't add a generic expense subtraction just because the company incurred fuel, repairs, tolls, factoring charges, or a broker chargeback. Keep company expense tracking separate unless the applicable pay arrangement and required review establish a particular treatment. A disputed damage claim should enter an exception review, not an automatic deduction formula.

Keep an owner-operator business settlement separate from the company-driver worksheet. Give each its own fields and review process instead of relabeling the same total. Likewise, don't call revenue minus driver earnings “fleet profit.” Use the trip profitability worksheet for the separate task of modeling the trip's full cost.

Assign every earning to the right driver

Use a driver-work row as the basic calculation unit, not one total per truck. Include the driver ID, load ID, trip or segment ID, vehicle movement reference where relevant, completion date, pay-plan version, payable quantity, rate, base earnings, additional earnings, and evidence reference. Summarize those rows by driver and pay period only after the assignments are complete.

For mileage records, keep truck-segment miles separate from vehicle records. If eight cars travel together over a 600-mile segment, enter 600 truck miles once for the segment, not once per VIN. Vehicle-level records support per-car calculations; segment-level records support mileage calculations. Connect them without multiplying the route distance by the car count.

A relay needs a recorded allocation rule. Suppose the sample percentage plan creates a $1,250 base-pay pool, and the approved arrangement allocates 60% to Driver A and 40% to Driver B. Their base shares are $750 and $500. Assign the additional $75 to the driver or drivers who earned it under the plan. Don't award the whole pool twice because both names appear on the load.

For team mileage arrangements, write whether the rate is a shared truck-mile rate or a separate rate for each driver. Put that choice into the plan record before calculating. For per-car relay work, specify whether pickup and delivery have separate component payments or share one movement payment.

Create a duplicate check using driver ID, load ID, segment or movement ID, and earning type. Flag repeated combinations for review rather than deleting them automatically. A second delivery attempt might be a legitimate separate earning, while a second import of the original delivery is not. Require a distinct event reference for the former.

Keep missing information in an exception column with a named owner. Examples include a VIN missing from delivery support, an unexplained mileage change, or a rate entered without an effective date. Don't convert missing values into zero pay without review. Reconcile the work list against dispatch closeout records and use the load-file checklist to organize supporting documents.

Test the worksheet and close each settlement

Before rollout, run a completed pay period through the proposed worksheet alongside your existing records. Include a straightforward trip, a deadhead-heavy move, a canceled vehicle, and a driver handoff. Explain every difference by its input, rate, allocation, or adjustment. Don't change a formula merely to force the new total to match an old one.

Protect formula cells and choose a consistent rounding rule. For this template, calculate each earning line, round it to cents, and sum those rounded lines. Keep a blank rate or missing mileage source visibly unresolved. A zero is a valid value only when someone has established that zero is the correct input.

Make the statement readable without opening the whole workbook. Show the period, work references, calculation basis, quantities, rates, gross earnings, separate adjustments, reimbursements, and resulting payout. Provide a contact and process for questions. If a correction is needed after approval, preserve the original and create a dated adjustment linked to it rather than overwriting the explanation.

A one-load comparison is only the start. TruckTA's free calculator shows gross and optional adjusted amounts from your entries; it does not allocate team work, estimate withholding, or approve a settlement. Treat its result as an input to the documented pay workflow above.

Run one completed pay period through this worksheet alongside your existing records. Ask a driver or settlement reviewer to trace each amount to a load, plan version, work segment, and approved adjustment. If they cannot, fix the input or rule before the next payment.