Logistics and distribution
Rate confirmations and load tender histories in freight brokerage: AI value
By SourceX Editorial · Updated
Short answer
Rate confirmation data and load tender histories show AI teams how a brokerage prices, accepts and covers freight: what the shipper tendered, what was quoted, which carrier took the load on what terms and what changed after booking. The value comes from linking tenders, rate confirmations, amendments and outcomes, with carrier and shipper identities treated as confidential.
Key takeaways
- A rate confirmation records the agreed carrier terms; the tender records what the shipper asked for; the value lies in linking them.
- Revised rate confirmations and accessorial changes show what went wrong after booking, which quoting and booking agents need to learn.
- Rejected tenders and declined carrier offers teach as much as booked loads.
- Shipper contracts and broker-carrier agreements commonly treat rates and identities as confidential, so both are reviewed before scoping.
- Rate confirmations stored only as PDFs can still be used, but extracting fields takes preparation work.
What is in a rate confirmation and a load tender?#
A rate confirmation is the document a broker sends a carrier to confirm the terms of one load, and a load tender is the shipper's request for a broker or carrier to move it. Together they record both sides of a brokered move: what the customer needed and what the broker agreed to pay to get it done.
Tenders arrive by EDI, by email, through shipper portals or by phone, and rate confirmations usually go out as PDFs generated by the TMS. AI teams assessing a brokerage's history start with the fields below.
| Field | Where it appears | What a quoting or booking agent learns |
|---|---|---|
| Origin, destination and stops | Tender and rate confirmation | Lane structure and stop complexity |
| Pickup and delivery windows | Tender and rate confirmation | How tight timing affects price and coverage |
| Equipment, commodity and weight | Tender | Which loads need special equipment or handling |
| Shipper rate or contract reference | Tender or customer quote | The revenue side of the margin |
| Carrier linehaul and fuel | Rate confirmation | What it cost to cover the lane on that day |
| Accessorials | Rate confirmation and amendments | Which loads add detention, lumper, layover or truck-order-not-used charges |
| Carrier terms and special instructions | Rate confirmation | Tracking, appointment and payment requirements the broker imposed |
| Tender response | EDI response or email reply | Which tenders the broker accepted, rejected or countered |
Why does the sequence from tender to rate confirmation carry the value?#
The sequence from tender to rate confirmation carries more value than any single document, because it shows a decision made under time pressure with incomplete information. A model that sees only the final rate learns little; a model that sees the tender, the quote, the carrier offers, the booking and the amendments learns how the desk thinks.
- Tender received: an EDI 204 motor carrier load tender, an email, a portal posting or a phone request.
- Tender response: accepted, rejected or countered, often recorded as an EDI 990 or an email reply.
- Coverage: carrier offers from load boards, calls and emails, with rates offered and declined.
- Booking: the rate confirmation sent to the chosen carrier, with linehaul, fuel and terms.
- Execution: check calls, tracking updates and EDI 214 status messages, including late and missed appointments.
- Changes: revised rate confirmations for added stops, detention, layovers or cancellations.
- Close: carrier invoice, shipper invoice such as an EDI 210, and any disputes or short pays.
What quoting and booking agents learn from these records#
Quoting and booking agents learn the judgment between the market rate and the final booked rate from these records. Market data says where a lane is trading. A brokerage's own tender and rate confirmation history says when the desk took a load below cost to protect a customer, which carriers held their rates on short notice and which lanes regularly needed a second or third carrier offer.
Rejected tenders matter as much as accepted ones. A tender declined because no truck was available at an acceptable rate shows the edge of what the desk would do, and a model needs those edges to avoid confident but unworkable quotes.
Booking agents also learn from carrier-side records: how quickly offers came in, which carriers countered and what terms they asked for. Those records often sit in email and load board messages rather than the TMS, which is one reason linked histories are rarer than they should be.
Why are revised rate confirmations overlooked?#
Revised rate confirmations are the most overlooked records in a brokerage archive, because they are filed as paperwork rather than treated as decisions. Each revision records something that went differently than planned: a shipper added a stop, a receiver held the truck, a load was cancelled after dispatch or a carrier negotiated more money mid-route.
For an AI team, those revisions are labeled examples of risk. Linked back to the tender, they show which lanes, shippers and facility types tend to generate detention or layovers, which is exactly what a quoting agent should price in and what a booking agent should warn about. Brokerages whose TMS overwrites the original rate confirmation lose that history, so check how revisions are stored.
How do carrier and shipper confidentiality shape a package?#
Carrier and shipper confidentiality shapes every brokerage package, because rates and identities are the commercially sensitive part of the record. Shipper agreements often treat contract rates and volumes as confidential, broker-carrier agreements commonly include confidentiality and non-solicitation terms, and federal rules give shippers and carriers certain rights to review a broker's records of their own transactions.
Brokerages commonly handle this by replacing identities with stable codes, generalizing facility locations, holding back recent periods and reviewing the strictest shipper contracts one by one. Counsel decides the treatment for each field.
| Field | Concern | Usual treatment |
|---|---|---|
| Shipper and consignee names | Contract confidentiality and customer relationships | Replace with stable codes and industry labels |
| Carrier name, MC and DOT numbers | Broker-carrier confidentiality and non-solicitation | Replace with stable codes and a fleet size band |
| Driver and dispatcher names and phones | Personal data | Remove |
| Facility addresses | Identifies customers and receivers | Generalize to city or metro area |
| Shipper contract rates | Often confidential under customer agreements | Review each contract; hold back or band where required |
| Carrier rates and accessorials | Commercially sensitive | Usually kept, with recent periods held back |
Which gaps weaken a brokerage archive?#
The gaps that weaken a brokerage archive usually come from tools and habits rather than missing loads. Most can be worked around in preparation if they are found before a field list is drafted, so check for them during the first inventory.
- Rate confirmations overwritten when revised, so only the final terms survive.
- Tenders accepted by phone with no record of the original request or the response.
- Carrier offers kept in personal inboxes or load board messages with no load number.
- A TMS migration that kept loads but dropped quotes, rejected tenders or document attachments.
- Accessorials billed to the shipper but never recorded on the carrier side, or the reverse.
Illustrative: a brokerage links its tenders to its rate confirmations#
Illustrative: a fictional truckload brokerage receives most shipper tenders by EDI through its TMS and the rest by email, and generates rate confirmations as PDFs from the same TMS. Revisions are saved as new versions rather than overwriting the original, and reps log carrier offers in a load board tool that exports to spreadsheets.
The operations leader finds that tenders and rate confirmations link by load number, but carrier offers link only by date and lane. The brokerage decides to license tenders with responses, original and revised rate confirmations, accessorials and invoice outcomes, with shippers and carriers coded, facilities generalized to metro area and the most recent period held back. Carrier offers are added only where they match a load number cleanly, and two shippers whose contracts forbid any use of rate data are excluded.
How SourceX approaches brokerage records#
SourceX assesses brokerage histories with a metadata-only fit check: the TMS, how tenders arrive, how rate confirmations and revisions are stored, years of linked history and known contract limits. Nothing is shared at that stage.
When a brokerage moves ahead, the work runs through the SourceX five-step transaction (Supply, Rights, Preparation, Approval, Delivery), and the SourceX Evidence Packet records which shippers were excluded, how identities were coded and who authorized release.
Frequently asked questions
Are rate confirmations stored as PDFs still useful?
Yes, but they need extraction. Fields can be pulled from TMS-generated PDFs reliably because the layout is consistent, though the work belongs in Preparation and needs checking. If the TMS also holds the same fields in its database, that is the better source, with PDFs as a cross-check.
Do we need carriers' permission to license rate confirmation data?
Often not, if carrier identities are removed and your broker-carrier agreement does not restrict use of load records, but that is a conclusion for counsel after reading the agreement's confidentiality clause. Some brokerages also exclude carriers that negotiated special terms, which keeps the review simple.
How much history is needed for quoting and booking work?
Enough to cover several market cycles and seasons on your core lanes. Consistency matters as much as length: stable load numbering, kept revisions and recorded tender responses make a shorter history more useful than a longer one with gaps.
Does including recent rates create a competitive risk?
It can. Recent rates on named lanes are the most sensitive part of a brokerage archive. Holding back the most recent period, generalizing locations and restricting the license to training and evaluating models reduce that risk. Counsel may also review competition questions around sharing price data.
What if our tenders mostly arrive by email rather than EDI?
Email tenders are common and still usable. The tender, the reply and any rate discussion often sit in one thread, which can capture reasoning that EDI fields do not. Linking those threads to load numbers in the TMS is the main preparation task, along with removing contact details.
Related resources
See if your company qualifies
A short company assessment. No data uploads are needed.