How to Extract Data from Freight Rate Confirmations (Rate Con to Excel)
Published on February 19, 2026 by CapyParse Team
If you run a freight brokerage, you know the drill. Every load you book generates a rate confirmation that needs to be processed, reconciled against invoices, and filed. At 50 rate cons a week, that's manageable. At 200+, it's a full-time job. This guide shows you how to stop typing rate con data by hand and start extracting it automatically.
Quick Summary
A rate confirmation (rate con) is the binding agreement between a broker and carrier specifying load details and compensation. Manually processing rate cons costs 15+ minutes per document and introduces errors that cause billing disputes. CapyParse uses AI to extract all key fields from rate confirmation PDFs into Excel or CSV in seconds, with no templates and no coding required.
What Is a Freight Rate Confirmation?
A rate confirmation (also called a rate con, load confirmation, or carrier confirmation) is a binding agreement between a freight broker and a carrier. It's the document that says: "You're hauling this load, from here to there, for this much money."
Who generates them: Freight brokers, shippers, and 3PLs create rate confirmations in their Transportation Management System (TMS) or manually. The broker sends it to the carrier, who signs and returns it before dispatching the load.
Who processes them: Carrier back-office staff, brokerage operations teams, and accounting departments all need the data from rate confirmations. The carrier needs it for dispatching and invoicing. The broker needs it for load tracking and invoice reconciliation.
Typical volume: A small brokerage (5-10 agents) might process 50-200 rate confirmations per week. A mid-size operation (20-50 agents) handles 200-1,000+. Each one needs to be entered into accounting software, matched to an invoice, and archived.
Key Fields on a Rate Confirmation
Rate confirmations vary in layout from brokerage to brokerage, but they all contain the same core information:
| Field | What It Is | Why It Matters |
|---|---|---|
| Load/Reference Number | Unique identifier for the load in the broker's system | Primary key for matching rate cons to invoices and BOLs |
| Broker Name & MC/DOT | Broker's company name and federal operating authority numbers | Legal identification; MC number is required for interstate brokerage |
| Carrier Name & MC/DOT | Carrier's company name and federal operating authority numbers | Confirms who is hauling the load and their authority to do so |
| Origin Address | Pickup location (facility name, address, city/state/zip) | Must match the actual pickup. Errors cause missed pickups |
| Destination Address | Delivery location (facility name, address, city/state/zip) | Must match the BOL consignee. Mismatches delay delivery |
| Pickup Date/Time | Scheduled pickup window | Late pickups can result in TONU (Truck Ordered Not Used) charges |
| Delivery Date/Time | Required delivery window | Missed delivery appointments trigger detention and late fees |
| Equipment Type | Type of trailer required (dry van, reefer, flatbed, step deck, etc.) | Wrong equipment = load rejection at pickup |
| Rate | Agreed compensation (flat rate or per-mile rate) | The core financial field; must match the carrier invoice exactly |
| Fuel Surcharge | Additional compensation indexed to fuel prices | Often calculated as a percentage. Decimal errors cause billing disputes |
| Accessorial Fees | Extra charges: detention, lumper, TONU, layover, etc. | Most common source of disputes between brokers and carriers |
| Total Compensation | Sum of rate + fuel surcharge + accessorials | Must match the carrier's invoice. Discrepancies delay payment |
| Payment Terms | When and how the carrier gets paid (Net 30, Quick Pay, factoring) | Affects carrier cash flow and brokerage payment scheduling |
Why Manual Rate Con Processing Is Costing You Money
If you're still processing rate confirmations by hand, here's what that actually costs your brokerage:
15+ Minutes Per Document
Opening the PDF, finding each field, typing it into your TMS or spreadsheet, double-checking the numbers. At 200 rate cons/week, that's 50+ hours, more than one full-time employee doing nothing but data entry.
Decimal Errors in Surcharges
A fuel surcharge of $187.50 typed as $1,875.00 or $18.75 creates a billing dispute that takes hours to investigate and resolve. These errors are more common than you'd think. Rate con surcharge tables often have small fonts and dense number grids.
Slow Invoice Reconciliation
When a carrier submits an invoice, your team has to find the matching rate confirmation, compare every field, and flag any discrepancies. If the rate con data isn't already in your system (or was entered incorrectly), this takes even longer, delaying carrier payments and damaging relationships.
Reference Number Mismatches
Load numbers, PRO numbers, and PO numbers are the keys that link rate cons to BOLs to invoices. A single transposed digit breaks the chain, sending your team on a scavenger hunt through emails and documents to find the match.
The Real Cost: A Quick Calculation
At 200 rate confirmations per week × 15 minutes each = 50 hours/week of data entry. That's 1.25 full-time employees at roughly $45,000-65,000/year (fully loaded cost). Add the cost of errors (billing disputes, delayed payments, customer complaints) and manual processing easily costs $60,000-80,000+ per year for a mid-size brokerage.
Step-by-Step: Extract Rate Confirmation Data with CapyParse
Here's how to go from a rate confirmation PDF to a clean spreadsheet in under a minute:
Upload your rate confirmation PDF
Go to CapyParse and upload your rate confirmation. It works with TMS-generated PDFs, scanned documents, and even photos of paper rate cons. No account setup required to try it.
AI identifies document type and key fields
The AI automatically detects that it's a rate confirmation and identifies all the key fields: load number, origin/destination, rate, fuel surcharge, accessorials, payment terms, and more. No template setup needed.
Review extracted data with confidence scores
Each extracted field shows a confidence score. High-confidence fields (95%+) are ready to go. Lower-confidence fields are highlighted so you can verify them quickly. This is especially useful for surcharge amounts and reference numbers.
Download as Excel or CSV
Export the extracted data as an Excel spreadsheet or CSV file. The output includes all fields in clearly labeled columns, ready to import into your TMS, accounting software, or reconciliation workflow.
Match to invoices for reconciliation
With rate con data in a structured spreadsheet, matching to carrier invoices becomes a simple lookup instead of a manual search. Compare load numbers, verify total compensation, and flag discrepancies automatically using basic spreadsheet formulas or your accounting software's matching features.
What Makes Rate Confirmations Hard to Parse
You might think rate confirmations would be easy to process automatically, since they're mostly digital documents with structured data. But several factors make them surprisingly challenging for traditional tools:
- Every brokerage uses a different template. There's no industry-standard rate confirmation format. Each TMS, each brokerage, and each shipper generates rate cons with different layouts, field names, and data arrangements. Template-based OCR tools need a separate template for every sender.
- Fuel surcharge tables and conditional logic. Many rate confirmations include surcharge schedules in footnotes, conditional fees that depend on delivery outcomes, and multi-line accessorial breakdowns. These structured-within-unstructured sections trip up basic extraction tools.
- Mixed document quality. While most rate confirmations are digitally generated (good for OCR), some arrive as scans, faxes, or photos of printed documents. Some are even handwritten on pre-printed forms at smaller carriers.
- No universal standard. Unlike EDI 204 (motor carrier load tender), which has a standardized electronic format, PDF rate confirmations have no formatting standard. This means every new brokerage relationship potentially means a new document format to handle.
AI-Powered Extraction vs. Template-Based OCR
Understanding the difference between these two approaches explains why some tools work well on rate confirmations and others don't:
| Template-Based OCR | AI-Powered Extraction | |
|---|---|---|
| How it works | You define zones on a sample document. The tool reads text from those exact coordinates on future documents. | The AI reads the entire document and understands what each field means based on context, regardless of where it appears. |
| New layouts | Breaks. Requires creating a new template for each new format. | Works automatically. The AI adapts to the layout. |
| Setup effort | High. Template per sender. Ongoing maintenance as senders update their formats. | Low. Upload and extract. No pre-configuration needed. |
| Accuracy on matching formats | Very high (95%+) when the template matches exactly. | High (90-98%) across all formats, with confidence scoring for uncertain fields. |
| Best for | High volume of identical documents from a single sender. | Variable documents from many different senders, which is the reality of freight operations. |
For freight brokerages that receive rate confirmations from dozens or hundreds of different brokers and shippers, AI-powered extraction is the clear winner. You can't maintain a template library for every sender, and you shouldn't have to.
Beyond Single Documents: Batch Processing for Brokers
Processing rate confirmations one at a time is better than manual entry, but the real time savings come from batch processing:
- Upload a week's worth at once. Instead of processing rate cons as they arrive, collect a batch and upload them together. The AI processes them in parallel, extracting data from dozens of documents simultaneously.
- Get a consolidated spreadsheet. All extracted data lands in a single spreadsheet with one row per rate confirmation. Load number, origin, destination, rate, surcharges, total, all in standardized columns regardless of the original format.
- Flag discrepancies automatically. With rate con data in a structured format, simple spreadsheet formulas can flag issues: rate cons without matching invoices, total compensation mismatches, duplicate load numbers, and missing fields.
For brokerages processing 100+ rate confirmations per week, batch processing turns a multi-day task into a one-hour workflow: upload, review flagged fields, export, reconcile.
Frequently Asked Questions
What is a rate confirmation in freight?
A rate confirmation (rate con) is a binding agreement between a freight broker and a carrier. It specifies the load details (origin, destination, pickup/delivery dates, equipment type) and the agreed compensation (rate, fuel surcharge, accessorial fees, payment terms). The carrier signs it before dispatching the load.
Can I automate rate confirmation data entry?
Yes. AI-powered extraction tools like CapyParse can read rate confirmation PDFs and extract all key fields into a structured spreadsheet. This replaces manual data entry, reducing processing time from 15+ minutes to under a minute per document.
What's the difference between a rate confirmation and a BOL?
A rate confirmation is an agreement about the load details and compensation, and it's created before the freight moves. A bill of lading (BOL) is a receipt and contract of carriage created when the freight is physically picked up. The rate con covers the business terms (who pays how much). The BOL covers the physical goods (what is being shipped and its condition).
How accurate is AI extraction for rate confirmations?
AI extraction typically achieves 90-98% accuracy on printed rate confirmation fields. Rate confirmations are generally easier to extract than BOLs because they're digitally generated and have more consistent formatting. Tools with confidence scoring let you verify any uncertain fields before exporting.