If you are running Sage BusinessVision, you already know the clock is ticking. You have seen the sunset notices, and you are likely already weighing or planning your move to Spire.

What is harder to find is a straightforward, practical account of what actually happens once you hand over your data.

Because Spire provides direct, built-in conversion tools for BusinessVision, moving your data is far closer to a turnkey process than migrating off older, non-BV software. But turnkey does not mean instantaneous, and it does not mean flipping a switch on a Friday afternoon.

Here is what the conversion path actually looks like, how your data gets used along the way, and why the trial phase is your best safeguard before go-live.

 

The Real Sequence: From Tailored Demo to Working Sandbox

A proper conversion begins long before your actual cutover weekend. In fact, it starts before you even sign a contract.

The first step is handing over a backup copy of your BusinessVision data. We take that backup and run it directly through Spire's native conversion tools. At this stage, we do not adjust settings or clean up messy records. We let the data come over exactly as it sits in BusinessVision.

This raw conversion serves two critical purposes:

  1. A tailored demo using your real operations. Instead of watching a sales rep click through generic sample data for a fictional bicycle company, you see your own customers, your active items, and your actual order history inside Spire. You can immediately see how your daily workflow looks in the new interface.
  2. A working sandbox for setup and training. If you decide to move forward, that converted database becomes your non-production sandbox. This is where we design and print sample invoices, purchase orders, and packing slips to test your custom forms. It is where we build custom reports against your real numbers. Most importantly, it gives your team a zero-risk environment to train and practice daily tasks without touching live operations.

Treating this initial conversion as a sandbox is deliberate. It acts as a diagnostic window, revealing exactly what needs to be adjusted before you commit to a live cutover.

The Surprises That Surface in the Data

When a business runs the same system for ten, fifteen, or twenty years, data quirks accumulate. These are not signs of a broken software platform; they are simply the natural result of decades of real-world operations, changing staff, and evolving processes.

Because Spire's conversion routines are thorough, they hold up a clear mirror to your historical data. Running that initial conversion often brings several common situations to light:

  1. Trial balances out of balance. In older datasets, historical general ledger balances sometimes do not balance cleanly. While this does not prevent you from using the sandbox for training, it is something that must be reconciled before the final cutover.
  2. Missing date fields halting a conversion. Occasionally, specific historical transaction rows lose a date value over time. Spire requires valid dates to build its relational database, so an empty date field will pause the conversion routine until that specific record is corrected.
  3. Negative inventory running millions in the red. If a company used BusinessVision primarily for order processing and invoicing rather than full inventory management - recording sales without entering purchase orders - items set as physical inventory will steadily accumulate negative balances. Seeing an inventory valuation millions of dollars in the red can be jarring, but it is simply a configuration mismatch.
  4. Decades of inactive accounts and obsolete items. Companies with data stretching back before 2000 often carry thousands of former customers and discontinued parts. Spire will convert every record it finds, bringing legacy clutter right along with active accounts.
  5. Dormant warehouses carrying forward. Spire converts every warehouse set up in BusinessVision, even locations unused for a decade. Because modern ERP systems maintain strict audit trails and resist deleting tables with historical activity, those old warehouses will remain visible unless addressed.

 

What Real Cleanup Looks Like Before Go-Live

The entire reason for running a sandbox conversion months before your target launch date is to give you time to address these findings without operational pressure.

Cleanup is a shared effort between your team and your implementation partner:

  • What you can clean up before the final conversion. For obsolete items, inactive customers, or dormant warehouses, the best strategy is often to archive and purge very old history inside BusinessVision before running the final live export. For mass updates, providing spreadsheets of accounts or parts to mark inactive allows your consultant to batch-update records rather than having your staff edit them one by one.
  • What your consultant fixes under the hood. For structural hurdles like missing date fields, out-of-balance ledgers, or resetting negative physical inventory to non-physical items with zeroed-out balances, an experienced partner works behind the scenes to adjust the data so the live conversion runs cleanly.

Treating data cleanup as a deliberate, methodical phase ensures that when go-live day arrives, you are moving into a clean, well-structured environment.

What This Means for Your Timeline

A data conversion done properly is not a single weekend event. It is a phased process that runs parallel to your planning and training.

When an implementation partner pauses to point out an out-of-balance subledger, missing transaction dates, or obsolete master records during the sandbox phase, that is not a setback. That is the system working exactly as intended. Finding and resolving data oddities in a sandbox takes time, but it protects your live business from disruption.

A partner who catches these quirks early is protecting your go-live. A process that rushes past the sandbox stage without scrutinizing the converted data simply defers those problems to day one of live operations, when fixing them is far more stressful and disruptive.

Taking the time to test forms, verify reports, and clean up historical clutter turns go-live day from an anxious gamble into an orderly non-event.

 

Taking an Honest Look at Your Data

If you are currently running BusinessVision and planning your next move, you do not need to have all your data sorted out before you start talking to a partner.

The sandbox conversion exists specifically to show you where things stand. Running a trial conversion against a backup copy of your data gives you a clear, factual starting point. You will see what converts cleanly, what needs a quick adjustment, and what your team might want to clean up before cutover.

Before you set an arbitrary launch date on the calendar, take an honest look at your data first. If you want to see what your BusinessVision data looks like inside Spire and walk through a realistic transition plan, the door is always open.

 

March 21, 1989. That's when it started.

My first client was a small company running everything on paper. Actual ledger books. Handwritten entries. The kind of bookkeeping that required good penmanship and a sharp pencil.

We were moving them to BPI.  A DOS-based accounting system from ACCPAC. No mouse. No Windows. Just a blinking cursor and a lot of keystrokes.

The office manager was a one-person operation. She handled the books, answered the phones, dealt with vendors, kept the whole place running. And now she had to learn an entirely new way of doing her job.  While still doing her job.

After our training sessions, she'd meditate. Not as a wellness trend. Because she was overwhelmed.

I don't blame her. She was learning something completely foreign while her bosses wouldn't even pick up the phone during our sessions. Every interruption meant backtracking. Every phone call meant losing her train of thought.

So I said something.

I pointed out that every interruption extended the training ... and extended my invoice. Suddenly, the bosses found time to answer their own phones.

That was my first lesson in ERP consulting: the software is the easy part. The people are the hard part.

What's Changed: Everything

Back then, there was no way to import data from paper ledgers. Clients typed in every customer, every vendor, every open invoice.  One by one. From handwritten records. Into a system they barely understood.

Now? We have migration tools. We export from the legacy system, clean up the data, and import it into the new one. What used to take weeks of manual entry now takes days of careful mapping and validation.

The technology has changed beyond recognition:

  • DOS → Windows → Cloud. I've migrated clients through every era.
  • Fax orders → EDI → E-commerce integrations. I've watched order entry go from paper to fully automated.
  • Stand-alone PCs → Networked servers → Hosted systems. I've helped clients stop worrying about their server closet.
  • Manual reports → Real-time dashboards. I've seen CFOs go from waiting days for financials to pulling them up on their phones.

I've moved clients off systems you've probably never heard of ... DacEasy, BPI, Peachtree DOS, ACCPAC DOS ... and onto modern platforms that would've seemed like science fiction in 1989.

What Hasn't Changed: GIGO

Garbage In, Garbage Out.

It was true in 1989. It's true today.

You can have the best software on the market. The slickest interface. The most powerful reporting engine. But if your data is messy, incomplete, or outdated, your new system will be just as useless as the old one.

Before every migration, I tell clients the same thing: we need to clean house first.

  • Customers who haven't ordered in five years? Archive them.
  • Vendors you haven't used since 2018? Don't bring them over.
  • Items with descriptions like "MISC PRODUCT DO NOT USE"? Delete them.
  • Open invoices from a decade ago that will never be collected? Write them off.

The new system isn't a fresh start if you're dragging all your old messes into it.

This is the conversation nobody wants to have. Cleaning data is tedious. It forces decisions that have been deferred for years. But it's the difference between a system that works and a system that everyone hates.

What I Never Saw Coming

In 1989, I couldn't have predicted:

  • That I'd still be doing this 36 years later. And still learning.
  • That some clients would stay with me for decades. I have clients I've migrated through three, four, even five systems over the years.
  • That the human challenges would stay exactly the same. People still resist change. Still fear new systems. Still need someone to advocate for them during training.
  • That "the cloud" would mean something other than weather.

But here's what surprises me most: companies are still running on systems that should've been retired years ago.

I just finished a migration from DacEasy. A system that hasn't been updated in over a decade. The company was holding it together with workarounds and prayers, terrified that one Windows update would bring everything down.

They didn't know what they were missing. They thought manually emailing invoices one at a time was just how it worked.

It's not.

What 36 Years Taught Me

  1. The software is never the whole story. Training, buy-in, clean data, and realistic expectations matter more than features.
  2. Advocate for the person doing the work. That office manager in 1989 taught me that. If leadership doesn't protect training time, the implementation will struggle.
  3. Don't automate a broken process. If your workflow is a mess on paper, it'll be a mess in software. Fix the process first.
  4. "Good enough" has a shelf life. Every system that's "working fine" today will eventually hit a wall. The question is whether you'll migrate on your timeline or the system's.
  5. Trust is everything. Clients don't stay for 30 years because of software. They stay because they trust you to tell them the truth...  even when it's not what they want to hear.

The Work Hasn't Changed

The tools are better. The interfaces are prettier. The integrations are more powerful.

But the core work is the same as it was on March 21, 1989:

  • Understand how the business actually runs, not how the org chart says it should.
  • Clean up the data before it poisons the new system.
  • Train the people, not just the software.
  • Be the person who answers the hard questions honestly.

If you're running a system that's held together with workarounds, or you're drowning in spreadsheets because your software can't keep up, that's the work I do.

I've been doing it for 36 years. And I'm not done yet.

 

~Audrey Quick, Founder of AGS Enterprises Consulting LLC

Audrey has spent 35+ years helping businesses manage ERP implementations and accounting software transitions.  If you're evaluating your options, we can book a free 15-minute call 

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

~Audrey Quick, Founder of AGS Enterprises Consulting LLC

Audrey has spent 35+ years helping businesses manage ERP implementations and accounting software transitions.  If you're evaluating your options, we can book a free 15-minute call