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.

 

I once got a call from a client whose warehouse manager pulled them aside and said, "If we're switching systems, I'm out." This was their best person. Someone who'd been there 15 years. Someone who knew every SKU, every quirk of the operation, every workaround that kept things running.

They hadn't even picked the software yet.

Here's what I've learned after years of helping companies through ERP implementations: the technology is actually the easy part. It's the people part that makes or breaks it.

The Real Problem Nobody Wants to Say Out Loud

Your team isn't being difficult. They're scared.

Scared they'll look stupid learning something new. Scared their hard-won expertise won't matter anymore. Scared about whether their job still exists in six months. Scared that management is going to make their lives harder and call it progress.

And honestly? They've probably earned that fear. Because how many times have they been told "this will make things easier," only to spend the next three months cleaning up the mess?

Start the Conversation Before You Mention Software

I tell every client the same thing: don't lead with the solution. Lead with the problem.

Sit down with your team and ask: what's driving you crazy right now? What takes way longer than it should? What keeps you here late? What makes you want to throw your keyboard across the room?

Let them tell you what's broken. Let them complain. Write it all down.

Because here's what happens: when you eventually say, "I think we need better software," they'll remember that you asked first. That you listened. That you're trying to solve their problems, not create new ones.

Make Them Part of the Decision

You know what kills buy-in faster than anything? When people find out you already signed the contract, they just have to deal with it.

I've seen this work best when key users are involved in demos from the start. Let your warehouse lead ask the hard questions about receiving workflows. Let your customer service person poke holes in the order entry process. Let your inventory manager grill the vendor about lot tracking.

Two things happen when you do this: First, you catch problems before you're locked in. Second, your team starts to feel ownership. It stops being "management's new system" and starts being "our new system."

Say the Scary Stuff Out Loud

Don't dance around it. Your team is already thinking about the hard questions. In my experience, addressing them directly builds trust faster than anything else.

"Will my job go away?" Be honest. If roles are changing, say so. If you're eliminating manual data entry but need those people doing quality control instead, tell them that. If someone's job really is at risk, they deserve to know sooner rather than later.

"I'm terrible with computers." I hear this all the time, and it's legitimate. Acknowledge that learning new systems is hard. Talk about training. Talk about support. Talk about expecting a messy few months, and that's okay.

"We're going to lose everything we've built." This is where I remind people that data migration is part of the process. And more importantly, their knowledge of how things actually work is precisely what you need to set up the new system right.

Turn Skeptics Into Champions

Every team has early adopters and skeptics. You need both.

Your early adopters will figure out the workarounds and help everyone else. I always tell clients to empower these people. Give them extra training. Let them be the heroes.

Your skeptics will find every problem before it becomes a disaster. Listen to them. When they say "but what about when we have to do X," that's not resistance, that's expertise. Write it down. Make sure the new system can handle it.

What to Actually Say

I've watched a lot of these conversations go sideways. Here's what I've seen work better:

Instead of: "This new system is going to be so much better." Try: "I know change is hard. This is going to be messy for a while. But here's why I think it's worth it."

Instead of: "You'll love it once you get used to it." Try: "I need your help making sure this actually works for how we operate. You know this business better than any software vendor does."

Instead of: "We have to do this, corporate decided." Try: "Here's what's breaking. Here's what we're trying to fix. What am I missing?"

The Truth About Implementation

The best software in the world fails if your people aren't on board.

I've seen implementations with perfect technical execution fall apart because nobody thought about the people side. And I've seen messy, imperfect rollouts succeed because the team was invested from day one.

Implementation success isn't about hitting your go-live date. It's about whether your team is still there six months later, actually using the system, and not secretly running everything through spreadsheets when you're not looking.

Technology doesn't run your business. People do. Treat them like it.

~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