Broker Settlement Statement Reconciliation, Line by Line

Broker settlement statement reconciliation is a three-column job: what the statement paid, what the rate confirmation promised, and what document justifies the difference. Work it load by load, not in total. A statement that nets out to the right dollar amount can still contain an underpaid load offset by a duplicate payment, and totals hide both.

The reason nobody does this is structural. Settlement statements arrive weekly or biweekly, covering thirty to two hundred loads, formatted for the payer’s accounting system rather than for your review. Rate confirmations arrive one at a time, days or weeks earlier, in a different system. Nothing joins them automatically. So the statement gets checked against the expected total, the total looks close, and it gets filed.

This post is the line-by-line procedure: what each line type on a settlement statement is, which document proves it, and where the money actually leaks. It applies in both directions. If you receive settlement statements, this is your audit. If you issue them, it is the audit your carriers should be running on you, and the errors it finds are the ones that cost you a carrier relationship.

What a settlement statement is, and what it is not

A settlement statement is a payment advice, not an invoice. It says: here are the loads we are paying you for in this cycle, here is the gross on each, here are the deductions, here is the net wire.

That distinction matters because the legal furniture around freight bills does not automatically attach to it. A motor carrier’s freight bill has a required contents list under 49 CFR 373.103: consignor and consignee names, shipment date, origin and destination, package count, freight description, weight or volume, the exact rates assessed, total charges due with the nature and amount of each charge, the route, transfer points, and the remittance address. Notice how much of that a typical settlement line omits. A settlement statement line is often a load number, a date, and two dollar figures.

It is also worth being precise about who the rules cover. Parts 377 and 378 of 49 CFR apply to for-hire non-exempt motor carriers and household goods freight forwarders, per the scope of Part 377. A property broker is not a motor carrier. Broker-to-carrier settlement is governed by your broker-carrier agreement and the rate confirmations issued under it, not by the freight billing regulations. When something on a settlement statement is wrong, the fix is contractual almost every time. Say that plainly in your dispute and you will sound like someone who has read the agreement.

The five line types, and the document that proves each one

Every settlement line falls into one of five categories. Sort them first, because each category has a different proof document and a different failure mode.

Line type	What it should equal	Proving document	Common failure
Linehaul	The agreed rate on the rate confirmation for that load number	Rate confirmation	Paid against an earlier version of the rate con after a rate change was verbally agreed
Fuel	Either included in an all-in rate or computed per the stated method	Rate confirmation plus the index or table it names	Fuel paid as a flat amount when the rate con specified a per-mile calculation
Accessorials	Charges authorized in writing, on the rate con or a written amendment	Rate con, plus the POD, lumper receipt, scale ticket or timestamps	Approved by phone, never added to the rate con, then denied at settlement
Deductions	Claims offsets, advances, fees and chargebacks with a stated reason	Advance record, claim file, or the agreement clause authorizing the deduction	A single “adjustment” line with no reason code
Payment terms	Quick-pay discount or factoring assignment at the agreed percentage	The quick-pay election and the agreement	Percentage applied to gross including reimbursables

Do the sort mechanically. Export the statement, add a column for line type, and only then start matching. Mixing categories is how a $300 accessorial denial and a $300 claim offset cancel each other in your head.

Step one: match load numbers, not amounts

Match on load or pro number first, and confirm the count before you look at a single dollar figure.

Three things fall out of a count-first match:

Loads on the statement that are not in your records. Usually a co-brokered load or a load number reused across a carrier’s own systems. Occasionally a genuine misapplication of someone else’s freight to your settlement.
Loads in your records that are not on the statement. These are the expensive ones, because they are silent. A load delivered on the 28th that missed the cycle cutoff is fine. A load delivered six weeks ago that has never appeared on any statement is a receivable nobody is chasing.
Loads appearing twice. A duplicate on a settlement statement usually looks nothing like a duplicate invoice: same load, different reference, two cycles apart. The detection patterns for duplicate freight invoices work here too, and the same near-match logic applies.

Keep a standing aging report of delivered-but-never-settled loads. That single report catches more money than any per-line check, because a missing line generates no exception anywhere else in your process.

Step two: linehaul against the rate confirmation

For each matched load, compare the settlement’s gross linehaul to the rate confirmation. Most of the time this ties. When it does not, the cause is almost always one of four things:

A superseded rate con. The load was re-rated after a reconsignment, a delay, or a market shift, and one side is working from version one while the other is working from version two. Fix: settle only against a written amendment, and make the amendment carry a version number and timestamp.
Rate agreed verbally, never documented. The most common single cause of settlement disputes, and the least defensible on both sides. If a dispatcher agreed to $250 extra for a Saturday delivery and it lives only in a phone call, neither party has anything to reconcile against.
Mileage basis mismatch. Per-mile rates settled on a different mileage engine or a different version of the same engine. Practically invisible on a single load, systematic across a lane.
Rounding and stop-off allocation. Multi-stop loads where the stop charge was folded into linehaul on one side and broken out on the other.

The full field-by-field method is in the rate con versus carrier invoice reconciliation procedure. A settlement statement is that same comparison, run in bulk, with the added complication that the payer has already decided the answer.

Step three: fuel, when it is broken out

If your rate confirmations are all-in, skip this. If fuel is separately stated, the rate con should name the mechanism: which index, which region, which week, and which peg and progression.

That is the part to check, because a settlement statement almost never shows the calculation. It shows a fuel amount. To verify it you have to recompute from the index the agreement names. The method for recomputing a truckload fuel surcharge from the DOE index is the arithmetic; the question of which index week applies to a given load is where the disagreements actually live, because pickup date, delivery date and invoice date can each land in a different index week.

The EIA publishes the underlying series on a fixed cadence: the On-Highway Diesel Fuel Price Survey captures the cash pump price as of 8:00 a.m. local time Monday and publishes around 10:00 a.m. Eastern on Tuesday, per EIA’s published methodology. If your agreement says “the week’s DOE average” without saying which week, that ambiguity is worth one email to close permanently.

Step four: accessorials, where written authorization decides everything

Accessorial lines on a settlement statement come in two flavors: charges you expected that are missing, and charges that were reduced without explanation.

The practitioner taxonomy is broad. A standard list of twenty accessorial charge types covers liftgate, redelivery, layover, reclassification and reweigh, limited access, lumper, residential, inside delivery, oversized, sort and segregate, hazmat, after-hours, truck ordered not used, diversion miles, additional stops, storage, and detention. Any of these can appear or vanish at settlement.

The rule that resolves most of them is simple and unpopular: an accessorial is owed when the agreement authorizes it and a document proves the condition occurred. Two conditions, both required. A liftgate that genuinely happened but was never authorized is a negotiation, not a claim. An authorized detention charge with no timestamps is a claim you will lose. For detention specifically, the documents that actually carry a detention charge are the ones to attach at settlement time, not after a denial.

Practical habit: any accessorial approved during a load gets a same-day written amendment to the rate con, even if it is a one-line email confirming the phone call. This costs a minute and eliminates the most common settlement argument entirely.

Step five: deductions, the section nobody reads

Deductions are where settlement reconciliation stops resembling invoice reconciliation. Typical categories:

Advances. Fuel advances or cash advances issued mid-load, plus the fee charged for them. Verify both the principal and the fee percentage, and verify the advance was actually drawn.
Claim offsets. A cargo claim withheld against a future settlement. This should reference an open claim file and a specific amount, not a round number.
Chargebacks. Detention paid to a receiver, a lumper reimbursed, a rework cost, a TONU reversed.
Escrow or reserve. Held funds under the agreement, with release conditions.
Fees. Insurance, plate programs, ELD, occasionally a “processing” fee.

The check on every one of them is the same: does a clause in the signed agreement authorize this specific deduction, and does a document establish the amount? A deduction with no reason code is not a reconciliation problem, it is a request for information, and it is entirely reasonable to send one.

Where a claim offset is involved, keep the two processes separate in your file. A cargo claim and a billing dispute have different documentation requirements and different clocks, and merging them into a single email is how both stall.

Step six: quick pay and factoring, priced properly

Quick pay is a discount for early payment, and it is worth pricing as an annualized cost rather than as a percentage, because the percentage always looks small.

Illustrative arithmetic, not a market figure: if standard terms are 30 days and quick pay nets you funds on day 2 for a 2 percent discount, you are paying 2 percent to accelerate 28 days. Against the 98 percent you actually receive, that is 2 / 98 = 2.04 percent for 28 days, and 365 / 28 = 13.04 such periods in a year, so roughly 26.6 percent annualized. That can still be the right decision if the alternative is a line of credit at a higher rate or a stalled payroll. It is simply worth knowing the number before electing it every cycle.

Two things to verify on the statement itself:

The discount percentage matches what you elected, and is applied to the agreed base. A quick-pay percentage applied to gross including reimbursed lumpers and tolls quietly overcharges you on every load with a reimbursable.
Factoring assignments net correctly. When invoices are assigned, the statement should show the gross, the assignment, and the residual, and the residual should reconcile to what the factor remits after advances, reserves and chargebacks.

The deadlines that still bind, and the ones that do not

Because broker settlement runs on contract, most of the timing that matters is in your agreement: the settlement cycle, the cutoff, the documentation deadline for POD submission, and the dispute window.

Two federal clocks are still worth knowing, because they govern the motor carrier side of the same freight and often show up in broker-carrier agreements by imitation. Under 49 U.S.C. 13710, a carrier must bill charges additional to those originally billed within 180 days of the shipper’s receipt of the original bill to preserve collection rights, and a shipper must contest a bill within 180 days of receipt to preserve its right to challenge. And under 49 CFR 378.8, a processing carrier must pay, decline, or settle a written overcharge claim within 60 days of receipt absent a written agreement to extend.

If your broker-carrier agreement sets a 15-day or 30-day window to dispute a settlement statement, that window is the operative deadline for you, and it is short. Build the reconciliation into the cycle rather than into month-end. The full set of federal timing rules is collected in the freight billing deadlines reference.

The reconciliation checklist

Run this every cycle, in this order:

Export the statement to a spreadsheet. If it only arrives as a PDF, ask for a data file; most payers have one.
Match on load number and confirm the count against your delivered-load list.
List loads delivered but never settled, aged by delivery date. Chase anything over one full cycle.
Sort every line into linehaul, fuel, accessorial, deduction, or payment-terms adjustment.
Compare linehaul to the rate con of record. Flag any load where the rate con was amended.
Recompute fuel where it is separately stated, using the index and week the agreement names.
Confirm every accessorial has both written authorization and a supporting document.
Require a reason code and an amount source for every deduction. No exceptions for round numbers.
Verify the quick-pay or factoring math against the elected terms and the correct base.
Send one consolidated exception list per cycle, not one email per load.

That last point does more for the relationship than anything else on the list. A single organized exception list with document references attached reads as competence. Nine separate emails read as friction, and the person on the other end is usually not the person who caused the error.