✦ TMS Migration
TMS Migration
Moving to a new TMS? Cleans historical load, invoice, and customer data. Flags missing load numbers and rates. Marks each row import-ready.
Output: _migration_ready column
⟳ Weekly Dispatch
Weekly Dispatch
Consolidates multi-carrier weekly data. Normalizes carrier names, routes, truck IDs. Flags missing carriers and unconfirmed delivery dates.
Output: _dispatch_ready, _week_processed
⇄ Accounting Sync
Accounting Sync
Normalizes TMS exports for QuickBooks, Sage, or Wave import. Flags zero, negative, and unusually large amounts. Revenue without invoice numbers.
Output: _accounting_ready column
📂
Drop your file here or click to browse
CSV, XLSX, XLS, or TSV
.csv .xlsx
.xls .tsv
✓
Output format
Excel (.xlsx) — recommended
CSV (.csv)
Date format in output
YYYY-MM-DD (2024-01-15)
MM/DD/YYYY (01/15/2024)
DD/MM/YYYY (15/01/2024)
🧹
Complete steps above to continue
Cleaning your data…
Typically 10–30 seconds depending on file size.
○ Parsing file structure○ Detecting column types○ Normalizing dates & amounts○ Deduplicating names○ Running module checks○ Building change report
✅
Your cleaned file is ready.
Review the changes above before importing into your TMS or accounting software.
⬇ Download cleaned file
Clean another file