When a manufacturer asked us recently what would cause their Business Central go-live to slip, the answer wasn't the software. It was the data. Specifically, the data coming out of QuickBooks.
If you're planning a move off QuickBooks, this is the part worth understanding early, because it's usually the longest single stretch of the project and the place where the unpleasant surprises show up.
Migration is more than exporting a file
Moving to a new ERP isn't a copy and paste. We work with your team to sort out two things: what master data needs to load into the new system (your chart of accounts, vendors, customers, items), and your transaction history so opening balances tie back to your existing reports.
Getting access to that data, and getting it in usable shape, is where timelines can stretch. When the data is clean, this moves quickly. When it isn't, an intermediate cleanup step can slip in before anything migrates.
Inventory is the usual trouble spot
Here's the pattern we see over and over with QuickBooks: the inventory sub-ledger rarely ties to the general ledger. On one recent project moving a business off QuickBooks, the inventory sub-ledger was overstated by about two and a half times what the GL showed, and the team had no clear starting point to reconcile it. Their year-end habit had been to book one large adjustment and move on.
That approach works well enough inside QuickBooks. It becomes a problem the moment you try to carry accurate inventory balances into a new system, because the new system expects those numbers to reconcile.
Before you migrate, find out whether your inventory sub-ledger actually ties to your GL. If it doesn't, some reconciliation is almost always needed, and it's better to know that up front than to discover it mid-project.
You may be in better shape than you think
Not every QuickBooks setup is a mess. The manufacturer we spoke with keeps very little core data in QuickBooks: mostly journal entries, transactions, and year-end financials. Vendor detail lives in their payables tool, customer records are basically just names, and they adjust inventory value with a monthly journal entry. They also get audited, so their inventory value is something they track closely and feel good about.
That's a reasonable position to be in. When your core records live in purpose-built tools and QuickBooks is really just the ledger, there's less to untangle and the migration gets simpler. The point isn't that QuickBooks is bad. It's that you want to know exactly what you're carrying over and how clean it is before the clock starts.
A short checklist before you migrate
- Identify which master data lives in QuickBooks versus other tools you already use.
- Confirm whether your inventory sub-ledger reconciles to the GL, and by how much if it doesn't.
- Decide what transaction history you actually need in the new system versus what you can archive.
- Flag any year-end adjustments or workarounds that hide underlying detail.
If you're thinking about a move off QuickBooks and want a realistic read on how much data cleanup stands between you and a go-live date, we're glad to take a look at what you've got and talk it through.