UPS Data Sanitization Tool

Upload weekly UPS data and automatically match customers using 89.67% intelligent matching

How it works

Upload the unedited UPS Excel file (244 columns) and our system will automatically match:

81.5% by username (100% accurate)
12.6% by consignee company (85% accurate)
4.8% by waybill history (94% accurate)
Only 0.8% need manual review

Boost Matching with Historical Data

Have old UPS files you've already parsed by hand? Import them to teach the system historical waybill-to-customer mappings and get 100% confidence auto-matching on those waybills!

Import Historical Waybill Mappings

Upload New File

UPS Excel File (Required)

Select the raw UPS export file (e.g., "A1T871 November 1, 2025 #445 Original file from UPS.xlsx")

UPS PDF Invoice (optional - for dataset building)

Upload the corresponding UPS PDF invoice to build training dataset for future AI improvements

Invoice Date (optional)

Auto-detected from filename if present (e.g., "November 1, 2025"). Override if needed.

File Number (optional)

Auto-detected from filename if present (e.g., "#445"). Override if needed.

Processing usually takes 30-60 seconds

Expected Results

89.67%

Auto-Matched

5-10 min

Review Time

<1%

Unknown

165 hrs

Saved/Year

Recent Uploads

Week #485

Nov 29, 2025 Uploaded 4 days ago 19380 rows

Done

Review

Test System Accuracy

Want to see how well the auto-matching system is working? Test it on your verified datasets and get a plain English report card showing accuracy and recommendations.

Go to Accuracy Testing Dashboard

Need Help?

File Format

UPS raw export file with 244 columns, no header row, Excel format (.xlsx or .xls)

Matching System

Priority 1: Username (Column 38)
Priority 2: Consignee Company
Priority 3: Waybill History
Priority 4: Postal + Name

After Upload

Review auto-matched results, manually assign unknowns, then export clean data for invoicing.