Skip to main content

Importing Historical Load Data into AscendTMS

Everything you need to know about importing your load history into AscendTMS, including data requirements, import templates, pricing, turnaround times, and how to get started.

🚛 Your Load History Doesn't Have to Stay Behind!

Switching TMS platforms doesn't mean leaving your load history in the rearview mirror!

Whether you're moving from another TMS platform or have years of shipment records tucked away in spreadsheets, AscendTMS can import your historical load data, giving you convenient access to your previous shipments for archival and reporting purposes.

Our team handles the technical import process, but there are a few things you'll need to know before getting started.

We've put together these frequently asked questions to walk you through what can be imported, how to prepare your data, what it costs, and how long it takes.

Let's get into it! 👇


❓ Historical Load Import FAQs

Can I import my historical loads into AscendTMS?

Absolutely! Historical load data from other TMS platforms, spreadsheets, and CSV files can be imported into AscendTMS.

Unlike Carrier, Customer, and Location imports, historical load imports must be performed by the AscendTMS team to ensure your data is properly mapped and imported.


Do I need a specific AscendTMS subscription to import historical loads?

Historical load imports are supported on all AscendTMS subscription plans.

However, accessing and reporting on your imported historical loads requires a Premium or PRO subscription, as Load Reporting is not available on the Basic plan.


Do I need to import my Carriers, Customers, and Locations first?

Yes! This is one of the most important requirements.

Before we can import your historical loads, all Carriers, Customers, and Locations referenced in your load history must already exist in AscendTMS.

This allows our team to properly match (map) each historical load to its corresponding records.

⚠️ Important: Missing records can result in incorrectly mapped, incomplete, or unusable load data. Be sure these records are imported before submitting your historical load data.

Need help importing those records? Check out our dedicated Help Guides:


Do I need to use a specific template for my historical load data?

Yes. All historical load data must be submitted using the official AscendTMS Load Import Template.

The template contains the required fields and formatting our team needs to properly map and import your historical loads.

Customers are responsible for transferring their data from their previous TMS, spreadsheet, or other source into the official template.

Before submitting your template, make sure:

  • All required fields are completed.

  • Customer, Carrier, and Location information is accurate.

  • Duplicate or unnecessary load records have been removed.

  • Pickup and delivery locations are properly formatted.

  • The data has been reviewed for accuracy and completeness.

⚠️ Important: Incomplete or improperly formatted templates may be returned for correction before the import process can begin.


Can I import historical loads that have multiple pickup or delivery stops?

Yes, but there's an important limitation.

For historical loads containing multiple stops, only the first pickup location and final delivery location can be imported.

For example, if a historical load had three pickups and two deliveries, the imported record would contain only the first pickup and final delivery locations.

Some TMS platforms combine multiple stops, cities, or addresses into a single field. These must be separated and properly formatted in the AscendTMS Load Import Template before submission.


What status will my imported historical loads have?

All imported historical loads are automatically assigned an Archived status.

This keeps your historical shipments separate from your current, active loads while allowing you to access, review, and report on them as needed.

💡 Good to Know: You can change the status of an imported historical load after the import is complete.


Can I start using AscendTMS before my historical loads are imported?

Absolutely! And we encourage it! 🚀

You can begin building and managing new loads in AscendTMS immediately. Your historical load data can be imported at any time afterward without interfering with your current operations.

💡 Important: Before creating your first load, we strongly recommend setting your Starting Load Number higher than the highest load number in your previous TMS.

This helps prevent duplicate Load IDs when your historical loads are eventually imported.

Your Starting Load Number can be adjusted in the Settings section of AscendTMS.


How much historical load data should I import?

That's entirely up to you! Historical load imports are optional and are not required to begin using AscendTMS.

In many cases, retaining older shipment records in a spreadsheet or your previous TMS may be sufficient for archival purposes.

💡 Our Recommendation: We generally suggest importing up to two years of historical load data. This gives you access to your more recent shipment history without unnecessarily importing years of older records you may rarely reference.


How much does it cost to import historical loads?

Historical load imports are performed by the AscendTMS team for a one-time fee of $1,500 per 5,000 load records (or portion thereof).

Here's how the pricing breaks down:

Historical load records

One-time import fee

1–5,000

$1,500

5,001–10,000

$3,000

10,001–15,000

$4,500

15,001–20,000

$6,000

💡 Example: If you're importing 8,000 historical loads, your one-time import fee would be $3,000.

Payment is required in advance, before the AscendTMS team begins the import process.

Our Support Team will coordinate payment arrangements with you. For convenience, we recommend using the payment method already on file with your AscendTMS account.


Will AscendTMS clean up or correct my historical data before importing it?

Our team handles the technical mapping and import process, but customers are responsible for the accuracy, completeness, and proper formatting of their historical load data.

This includes ensuring that load details, addresses, Customer and Carrier information, and other records are accurate.

While we'll handle the technical work required to import your data, we are not responsible for correcting misspellings, inaccurate addresses, duplicate records, or other issues in your source data.

💡 Good to Know: Taking a little extra time to prepare and review your data can help prevent import errors and unnecessary delays.


How long does a historical load import take?

Historical load imports are typically completed within 10 business days, depending on the volume and complexity of the data.

However, the estimated turnaround time begins only after:

  • Payment has been received in full.

  • Your completed Load Import Template has been received and reviewed for completeness and proper formatting.

  • All required Carriers, Customers, and Locations already exist in AscendTMS.

⚠️ Important: The 10-business-day timeframe is an estimate, not a guaranteed completion date. Missing information, incomplete records, or other complications may extend the timeline.


How do I request a historical load import?

Easy! Just send an email to the AscendTMS Support Team at support@inmotionglobal.com and let us know you'd like to import your historical load data.

Our team will provide you with the official AscendTMS Load Import Template, review the requirements with you, and coordinate payment and next steps.

Once everything is ready, we'll take it from there!


🎉 Your History Is Important. Your Future Is in AscendTMS!

And that's a wrap! Whether you're bringing over a few hundred loads or thousands of historical shipments, we're here to help make the transition as smooth as possible.

Just remember: prepare your data, complete the template, and let the AscendTMS team handle the rest.

Ready to get started? Shoot our Gurus an email at support@inmotionglobal.com, and we'll help get your historical load data where it belongs.

Did this answer your question?