See RateConChecker in Action

Explore how RateConChecker transforms messy, abbreviated rate confirmation data into clean, organized summaries with proper formatting and full field names.

Before: Messy RateCon Data
Load ID,Rate,Pickup,Del,From,To,Equip,Product,Wt,Mi,Carrier,MC#,Ref
RC001,$2450,3/15/24,3/17/24,"Chicago, IL","Denver, CO",DV,Electronics,34000,920,Swift,12345,789012
RC002,$3200,3/16/24,3/19/24,"Los Angeles, CA","Houston, TX",RF,Fresh Produce,42000,1540,Schneider,67890,345678
RC003,$1850,3/18/24,3/20/24,"Atlanta, GA","Miami, FL",FB,Construction Materials,38500,660,JB Hunt,24680,901234

• Abbreviated field names

• Inconsistent formatting

• Hard to read and analyze

• Missing currency symbols

• Unclear date formats

After: Organized Data
Load ID:RC001Rate Amount:$2,450.00Pickup Date:2024-03-15Origin:Chicago, IL
Load ID:RC002Rate Amount:$3,200.00Pickup Date:2024-03-16Origin:Los Angeles, CA

• Full, descriptive field names

• Consistent date formatting

• Proper currency formatting

• Easy to read and analyze

• Ready for TMS import

The Transformation Process

Messy RateCon
RateConChecker
Organized Data

Sample Organized Rate Confirmations

Here's what your organized data looks like after processing through RateConChecker.

Load Details

Load ID: RC001

Rate: $2,450.00

Miles: 920

Schedule

Pickup: 2024-03-15

Delivery: 2024-03-17

Route

From: Chicago, IL

To: Denver, CO

Cargo

Equipment: Dry Van

Commodity: Electronics

Weight: 34,000 lbs

Carrier

Name: Swift Transportation

MC Number: MC-12345

Reference: REF-789012

Load Details

Load ID: RC002

Rate: $3,200.00

Miles: 1,540

Schedule

Pickup: 2024-03-16

Delivery: 2024-03-19

Route

From: Los Angeles, CA

To: Houston, TX

Cargo

Equipment: Refrigerated

Commodity: Fresh Produce

Weight: 42,000 lbs

Carrier

Name: Schneider National

MC Number: MC-67890

Reference: REF-345678

Load Details

Load ID: RC003

Rate: $1,850.00

Miles: 660

Schedule

Pickup: 2024-03-18

Delivery: 2024-03-20

Route

From: Atlanta, GA

To: Miami, FL

Cargo

Equipment: Flatbed

Commodity: Construction Materials

Weight: 38,500 lbs

Carrier

Name: J.B. Hunt

MC Number: MC-24680

Reference: REF-901234

Data can be exported in multiple formats for easy integration:

CSV Format
Excel (.xlsx)
JSON Format

Try It With Your Own Data

Ready to transform your messy rate confirmations into organized data like this?