From Rate Con to Driver Pay in 15 Minutes

Settlements are the most repeated back-office task in a small carrier and the one most often done in a spreadsheet at the kitchen table on Sunday night. The work itself is not complicated. What makes it take half a day is that the inputs are scattered across a broker’s PDF, a fuel card portal, a factoring statement, and somebody’s memory of last week.

Here is the whole sequence, the arithmetic worked out, and the two rules that quietly cost money when this is done by hand.

The sequence

1. 01Capture the rate confirmation. Broker, reference number, origin and destination, loaded miles, gross, accessorials, terms.
2. 02Create the load and assign it. To a truck and a driver. This is what makes both the settlement and the per-truck P&L possible later.
3. 03Let costs attach as they occur. Fuel purchases, cash and fuel advances, tolls, lumpers, repairs. Each one lands on the load or the driver as it happens, not at month end.
4. 04Close the period. Gather the loads that belong to it, proposed by date, adjusted by judgment.
5. 05Apply the driver arrangement. The agreed split and fee percentages, taken from the arrangement on file.
6. 06Apply deductions and any carryforward. Fuel net of rebate, advances, recurring items, and any shortfall from a prior negative period.
7. 07Review, approve, pay, and issue the statement. The only step that genuinely needs a person.

The arithmetic, worked out

Take a lease operator on a common arrangement: the driver keeps 81.5% of gross, the company retains 15%, and 3.5% covers factoring. Four loads delivered in the period, $9,240 in gross.

Gross for the period                        $9,240.00

Driver share      81.5%  ×  9,240.00   =    $7,530.60
Company fee       15.0%  ×  9,240.00   =    $1,386.00
Factoring          3.5%  ×  9,240.00   =      $323.40
                                            ─────────
                                            $9,240.00

The driver’s share is the starting point for deductions, not the payment. Everything attributable to that driver during the period comes off next:

That is the entire calculation. Repeat per driver, produce a statement each, and the period is closed.

Rule one: the arrangement rate is the rate

The fee percentages belong to the driver’s arrangement, set at onboarding. They are not a pass-through of what your factoring company charged you that week.

This matters because factoring cost is not constant. A particular invoice may settle at a lower rate, or a promotional period may drop it entirely. When that happens, the difference between the arranged 3.5% and the actual cost is company margin, which is precisely what the arrangement contemplates. Both parties agreed to a rate, not to a cost-plus reimbursement.

The operational fix is to derive fees from the arrangement in one shared calculation used by every screen that shows pay, so a preview and a final settlement can never disagree. Track the actual factoring cost separately. It belongs in company P&L as a revenue and cost line, not on the driver’s statement.

Rule two: negative weeks have to carry forward

A driver’s deductions can exceed their share of gross. It happens in a light week that follows a heavy fuel week, or when a large advance lands in a short period. The settlement goes negative.

The shortfall does not disappear. It becomes a deduction on the next settlement, and it must be carried automatically. Done by hand, this is the step that gets forgotten, and it gets forgotten in exactly the weeks where the balance is largest, because those are the unusual weeks nobody has a routine for. Every missed carryforward is money advanced and never recovered.

Loads do not respect period boundaries

In practice, loads regularly fall outside the period they get paid in. A load delivers on the last day and its paperwork arrives Monday. A rate confirmation is amended after the period closed. A driver runs a load that logically belongs to the prior week.

Which period a load belongs to is a judgment call, so the tooling should propose by date and then get out of the way:

• Propose the loads whose delivery date falls in the period.
• Allow a load from outside the range to be pulled in deliberately.
• Lock the assignment when the settlement is approved, so the same load can never be paid on two settlements.

What the statement has to show

A settlement statement is two documents at once: a driver’s pay stub and your audit trail. It needs to carry enough that a question is answered by reading it rather than by rebuilding it.

A note on classification

Lease operators and owner-operators are typically paid as contractors and receive a 1099-NEC, while company drivers are employees on a W-2. Settlement statements are what the year-end 1099 totals are built from, so the arrangement type needs to be right in the system all year. Worker classification itself is a legal determination with real consequences. Treat it as a question for your attorney or CPA, not a field you pick to make the bookkeeping simpler.

Why fifteen minutes is realistic

Nothing in the sequence above is intellectually hard. It takes half a day because the inputs live in four places and get assembled from scratch every week.

When rate confirmations are parsed on arrival, fuel and factoring statements land against the right driver automatically, and the arrangement math is derived rather than retyped, what is left is the part that genuinely needs you: looking at four proposed settlements, checking the exceptions, and approving them.

That is a fifteen-minute job. The rest was never the work.