Moving from QuickBooks to Business Central: what happens to your data

When a manufacturer asked us what would cause their Microsoft Dynamics 365 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 to understand early, because it's usually the longest single stretch of the project and the place where the unpleasant surprises show up.

Migration Scope

Moving to a new ERP (enterprise resource planning) system 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 into usable form, 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.

Microsoft's Migration Tools

Business Central ships with two data migration extensions for QuickBooks, one for QuickBooks Online and one for QuickBooks Desktop, both run from the Data Migration assisted setup guide. It helps to know what they carry across and what they leave behind.

They bring over customers, vendors, items, the chart of accounts, beginning balances in the general ledger, on-hand quantities for inventory items, and open customer and vendor documents such as invoices, credit memos, and payments. Migrated transactions arrive unposted, so your team reviews them in Business Central before anything hits the ledger.

They do not bring over sales orders or purchase orders. A partially paid invoice migrates at its full amount, so partial payments are applied by hand before or after the move. Markups and discounts on transactions are re-added manually. Every general ledger account needs an account number before migration, because Business Central requires one. And for QuickBooks Desktop, Microsoft's documentation states that its exporter tool works with the 2017 and 2018 versions, so a newer Desktop file is loaded through Excel and configuration packages instead.

For most businesses, the wizard covers the master data and the Excel route covers the rest. Either way, the account mapping is decided before the load, not during it.

Inventory Reconciliation

Here's the pattern we see over and over with QuickBooks: the inventory sub-ledger rarely ties to the general ledger. On one 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 Business Central posts inventory value to the general ledger from the item ledger and expects the two to reconcile.

Starting Position

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. What you want is to know exactly what you're carrying over and how clean it is before the clock starts.

Pre-Migration Checklist

1. Identify which master data lives in QuickBooks versus other tools you already use.
2. Confirm whether your inventory sub-ledger reconciles to the GL, and by how much if it doesn't.
3. Decide what transaction history you need in the new system versus what you can archive.
4. Flag any year-end adjustments or workarounds that hide underlying detail.
5. Check that every general ledger account carries a number, and note which QuickBooks version you run.

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.