Moving Off Legacy Shipping Software Without Losing Data (or a Sailing)


By GDZ Computer Services · Updated 2026-10-21 · 7 min read · Blog › Shipping operations and software

Many shipping lines and NVOCCs still run on a system installed decades ago that only one or two people fully understand. Replacing it is less risky than keeping it forever, but only if the move is planned around your data: what exists, what must move, what must stay retrievable for regulators, and how to switch over without missing a Customs filing or an invoice.

Key takeaways
  • Inventory every type of data before you choose what migrates: master data, open transactions, history and accounting balances need different treatment.
  • Clean customer, vendor and tariff data before conversion; migrating duplicates and errors just moves the problem.
  • Plan the cutover so no shipment is filed, rated or invoiced in two systems, and confirm Customs filing works in the new system before go-live.
  • Keep old records retrievable: 46 CFR 515.33 requires NVOCC records to be readily available to the FMC, and 19 CFR 163.4 sets a general five-year retention period for records CBP requires.

Why legacy migrations go wrong

The software itself is rarely the problem in a failed migration. The problems are usually data that nobody knew was there, balances that do not match after conversion, and a go-live date that lands in the middle of a vessel closing. The result is a team running two systems at once, retyping shipments, and losing trust in the new system before it has a chance.

A legacy system also holds knowledge that is not written down anywhere: special rating rules for one customer, a report the accounting department depends on, an EDI file a terminal still expects. Finding those dependencies early is most of the work.

Step 1: inventory your data

Start by listing every kind of data the current system holds and deciding how each will be handled. The table below is a typical starting point for a carrier or NVOCC.

DataTypical approachWatch out for
Customers, vendors, agents, truckersMigrate after cleanupDuplicates, old addresses, missing tax or FMC reference numbers
Tariffs, service contracts, NRAsMigrate current ones, archive expiredRates stored as free text or in side spreadsheets
Equipment master and current statusMigrate with last known eventContainers in the field with no recent move
Open bookings and bills of ladingMigrate, or finish in the old systemShipments half-filed with Customs
Historical bills of lading and documentsMigrate or keep in a readable archiveAttachments and printed forms that are not in the database
Open receivables and payablesMigrate as open items by invoiceTotals that do not tie to the general ledger
General ledger balancesMigrate opening balances at a period endUnposted or suspense entries
EDI partner setups and reportsRebuild and retestFormats only the old vendor understood
A sample migration inventory. Your own list will be longer.

Step 2: clean the data before you move it

Conversion is the best opportunity you will ever have to fix master data. Merge duplicate customers and vendors, retire contacts nobody has used in years, standardize port and commodity codes and confirm reference numbers such as FMC organization numbers and tax IDs.

Validate container numbers too. Every ISO 6346 container number ends in a check digit that validates the owner code and serial number, so numbers that fail the check can be found and corrected before they enter the new system. Our guide to container tracking for small carriers explains how the number is built.

Agree on who owns each cleanup task and a date by which it must be finished. Cleanup that is left for after go-live rarely happens.

Step 3: keep old records retrievable

Not everything has to move into the new system, but everything you are required to keep has to stay retrievable. Two sets of rules are worth reading with your counsel before you decide what to archive:

  • FMC. 46 CFR 515.33 requires licensed or registered NVOCCs to keep all records and books of account for their OTI business current, correct and orderly. Electronic records must be readily available in usable form to the Commission and no less accessible than paper. Licensed ocean freight forwarders must keep specific shipment and financial records for five years.
  • CBP. 19 CFR 163.4 sets a general retention period of five years for records CBP requires under 19 CFR 163.2, with listed exceptions; the persons listed in 163.2 include those who transport or store merchandise carried or held under bond. 19 CFR 163.5 requires records to remain retrievable on lawful request and allows alternative storage methods only with advance written notice to CBP Regulatory Audit at least 30 calendar days before implementation.

In practice, that means the old database should not simply be switched off. Either migrate the history, or keep a read-only copy with a documented way to search and print it, and do not destroy originals until your customs broker or counsel confirms that you can.

Before shutting down the old server, test that someone other than its usual operator can find and print every document for a shipment from several years back. If they cannot, the archive is not ready.

Step 4: plan the cutover around your sailings

The safest cutover point is a natural boundary in your business: the start of an accounting period and, ideally, a quiet point in your sailing schedule. A few rules keep the switch clean:

  • Every shipment lives in exactly one system. Decide in advance which open bookings and bills finish in the old system and which start fresh in the new one.
  • Convert accounting at a period end, and tie migrated receivables, payables and opening balances back to the old general ledger before posting anything new.
  • Freeze changes to master data in the old system during the final conversion so nothing is lost between the last extract and go-live.
  • Run the two systems in parallel for a limited, defined period if you need confidence, comparing rated bills and invoices on the same shipments.

Step 5: protect Customs filing and EDI continuity

Customs deadlines do not pause for a software project. Under 19 CFR 4.7(b)(2), CBP must receive the electronic cargo declaration 24 hours before the cargo is laden at the foreign port, so the new system must be able to file before the old one stops. Confirm that the new system is set up to transmit through a CBP-approved system, test with real bills of lading and agree with your vendor on who handles CBP responses during the first sailings.

Do the same for every EDI trading partner: terminals, truckers, carriers and foreign customs systems. List each interface, the format it uses and a contact on the partner side, then schedule tests well before go-live. CBP's ACE Import Manifest Documentation is the reference for the ocean manifest messages your new system must handle.

Step 6: go live, then keep improving

  1. Train each team on its own daily tasks with its own real shipments, not generic examples.
  2. Go live at the agreed boundary, with the vendor available and the old system set to read-only.
  3. Reconcile receivables, payables and the general ledger at the end of the first period.
  4. Review exceptions daily for the first few weeks: rejected filings, unmatched invoices, containers without events.
  5. Retire the old system only after the archive test above has passed.

Choosing the right partner makes every step easier. If you are still comparing systems, start with our shipping line software checklist. GDZ acts as a system integrator for GDZ-ISIS, tailoring each installation to the company that runs it, so the way you work can be discussed before anything is converted.

Frequently asked questions

How do I migrate from old shipping software?

Inventory every type of data, clean master data, decide what migrates and what stays in a readable archive, convert accounting at a period end, confirm Customs filing and EDI work in the new system, then go live at a defined boundary with the old system set to read-only.

Do I have to migrate all historical data?

Not necessarily, but records you are required to keep must remain retrievable. 46 CFR 515.33 requires NVOCC records to be readily available to the FMC, and 19 CFR 163.4 sets a general five-year retention period for records CBP requires. Confirm with your counsel.

When is the best time to switch shipping systems?

At an accounting period end and, ideally, a quiet point in your sailing schedule. Each shipment should live in only one system, and accounting balances should be tied out before new transactions are posted.

How do I avoid missing a Customs filing during the switch?

Make sure the new system can transmit to CBP before the old one stops, test with real bills of lading, and agree who monitors CBP responses during the first sailings. The 24-hour advance cargo declaration rule in 19 CFR 4.7 still applies on go-live day.

Should we run both systems in parallel?

A short, defined parallel run can build confidence by comparing rated bills and invoices on the same shipments. A long open-ended one usually means double work and confusion about which system is right.

Sources

Schedule a GDZ-ISIS demo

See how GDZ-ISIS handles bookings, bills of lading, ACE manifest filing and accounting in one system.
Schedule a GDZ-ISIS demo

Related articles