Accounting
ERP
QuickBooks to Business Central Migration: Planning, Data Mapping and Cutover
Last updated: November 4, 2026 · Independent guide · We do not sell rankings or coverage.
A QuickBooks to Business Central migration moves your customers, vendors, items, chart of accounts, opening general ledger balances and open receivables and payables into Microsoft Dynamics 365 Business Central as of one cutover date. Microsoft’s built-in QuickBooks data migration extensions handle much of the load, but they skip sales and purchase orders, bring in partly paid invoices at full amount and do not mention classes. Most of the work is in the mapping, the clean-up and the reconciliation.
The migration process at a glance
- Scope the migration and choose the load method.
- Clean up the QuickBooks file.
- Redesign the chart of accounts and map classes to dimensions.
- Configure Business Central and run trial loads in a sandbox.
- Pick the cutover date and freeze QuickBooks.
- Load opening balances and open AR and AP.
- Reconcile, go live and archive QuickBooks.
| Stage | Accountable | Responsible | Consulted |
|---|---|---|---|
| 1. Scope and load method | CFO or controller | Implementation partner | Operations, IT |
| 2. QuickBooks clean-up | Controller | AR and AP staff | Sales, purchasing |
| 3. Chart of accounts and dimensions | Controller | Partner functional consultant | Department heads, outside CPA |
| 4. Configuration and trial loads | Project lead | Partner | Controller |
| 5. Cutover date and freeze | CFO | Controller | Payroll, banking, auditors |
| 6. Opening balances, open AR and AP | Controller | Partner and staff accountant | AR and AP staff |
| 7. Reconcile, go live, archive | CFO | Controller | Outside CPA or auditor |
Our recommended split for a single-entity company using a partner.
Stage 1: Scope the migration and choose the load method
Owner: the controller, with the partner proposing the method. Inputs: QuickBooks product and version, record counts and day-one reports. Output: a written scope of what moves, what stays and how each data set loads.
Business Central offers three routes. The first is the QuickBooks data migration extension, which you start from Assisted Setup by choosing Migrate business data (Microsoft Learn, updated August 21, 2025). It migrates customers, vendors, items, the chart of accounts, a beginning GL balance transaction, on-hand inventory quantities, and open invoices, credit memos and payments. It does not migrate purchase or sales orders.
For QuickBooks Desktop, Microsoft states that “the data exporter tool only works with QuickBooks 2017 and 2018” (Microsoft Learn, updated August 21, 2025). On a newer Desktop release, use the second route: configuration packages. The default package covers 27 tables, including customers, vendors, items, G/L accounts, posting groups and journal lines, filled through Excel worksheets whose columns you must not change (Microsoft Learn, updated June 17, 2026). The third route is a partner’s own tooling.
Gestisoft, a Business Central partner, publishes 3 to 6 weeks for a simple QuickBooks migration and 10 to 16 weeks or more for a complex one, at CAD 10,000 to CAD 20,000 for a small migration and CAD 40,000 and up for a complex one (Gestisoft, April 7, 2026). Citrin Cooperman Advisors lists a four-week offer on Microsoft Marketplace covering GL, AP and AR for one entity, with no published price (Microsoft Marketplace, no date shown). Both firms sell these services.
Control: the scope names the number of trial loads, who reconciles each and how much history is summarized. What goes wrong: teams assume migration means full history, then learn at go-live that only balances and open items moved.
Stage 2: Clean up the QuickBooks file
Owner: the controller, with AR and AP staff. Inputs: aging detail, trial balance and master lists. Output: a file where every open item is real and every account has a number.
Microsoft sets three tasks. Assign account numbers in QuickBooks, because Business Central requires them. Set up a tax account in Business Central if transactions carry sales tax. And apply outstanding transactions first, because the extension migrates only full amounts: a $500 invoice with $300 paid arrives as $500 (Microsoft Learn, updated August 21, 2025).
In practice that means matching unapplied payments and credit memos to invoices, applying vendor credits to bills, writing off small stale balances with approval, and making duplicate or dormant customers and vendors inactive.
Control: a signed AR and AP aging at the clean-up date, with every partially paid document listed. What goes wrong: unapplied payments migrate as separate open credits, and customers get statements for balances they already paid.
Stage 3: Redesign the chart of accounts and map classes to dimensions
Owner: the controller, with the partner’s functional consultant. Inputs: account, class and location lists and target management reports. Output: a mapping workbook to G/L accounts, dimensions and locations.
Many growing companies used QuickBooks sub-accounts as segments, such as one revenue account per region. Business Central uses dimensions instead: two global dimensions, which act as filters on reports and batch jobs, and up to eight shortcut dimensions, which appear on journals, document lines and ledger entries (Microsoft Learn, updated April 9, 2026). Microsoft’s extension pages do not mention classes or locations, so expect your partner to map them through Excel or configuration packages. The usual mapping is:
| QuickBooks element | Business Central target | Design note |
|---|---|---|
| Account | G/L account (numbered) | Collapse segment-style sub-accounts into one account plus a dimension |
| Class (department, program, fund) | Dimension, often global dimension 1 | Make it global if most reports filter by it |
| Location used for reporting | Dimension | Global dimension 2 or a shortcut dimension |
| Location that holds stock | Location record, optionally also a dimension | Needed for inventory quantities by site |
| Customer or vendor type | Posting group or dimension | Use posting groups only where the GL account must differ |
QuickBooks Online Plus caps classes and locations at 40 combined, while Advanced allows an unlimited number (Intuit, updated August 5, 2026). If you hit the Plus cap and merged unrelated categories into one class list, split them into separate dimensions now. Also check whether you assigned classes per transaction or per row, since Intuit offers both (Intuit, updated August 3, 2026); row-level classes map to dimensions on document lines. Our QuickBooks class tracking guide covers the source side.
Control: set default dimensions on accounts, customers and vendors, and use Code Mandatory in the Value Posting field where a dimension must always be filled in (Microsoft Learn, updated April 9, 2026). Avoid Code Mandatory on accounts used by the Adjust Exchange Rates or Post Inventory Cost to G/L batch jobs, which Microsoft says cannot use dimension codes. What goes wrong: choosing global dimensions casually. Changing one later updates every posted entry, which Microsoft says can be slow and lock tables.
Stage 4: Configure Business Central and run trial loads
Owner: the project lead, with the partner configuring. Inputs: the mapping workbook and exports. Output: at least two trial loads that reconcile.
Essentials and Premium subscriptions include one production environment and three sandbox environments at no extra charge (Microsoft Learn, updated April 15, 2026). Run every trial load in a sandbox you can delete. Before loading, set up customer and vendor posting groups, which define the receivables and payables accounts (Microsoft Learn, updated August 13, 2025), plus tax setup and payment terms.
Migrated transactions arrive with the status Unposted, so you can review them on pages such as Sales Invoices or Payment Journals before posting (Microsoft Learn, updated August 21, 2025). Microsoft notes that markup and discount amounts must be added manually, and that beginning balances may need correcting because QuickBooks does not store current balances for all accounts.
Control: a tie-out sheet per trial load comparing record counts, trial balance, AR aging and AP aging to QuickBooks. What goes wrong: skipping the second trial load, so fixes are never tested end to end.
Stage 5: Pick the cutover date and freeze QuickBooks
Owner: the CFO decides; the controller runs the freeze. Inputs: close calendar, payroll and bank schedules. Output: a dated cutover plan.
Cut over at a fiscal year start if you can: the opening balance is a clean post-closing trial balance and the year sits in one system. A quarter start is next best. A mid-month cutover splits sales tax and payroll periods across systems.
A typical freeze sequence is: stop new QuickBooks entries after the last business day, close the period, run the final agings and trial balance, then lock the period. In QuickBooks Online an admin sets a closing date and optional password under Settings > Account and settings > Advanced > Accounting, and the Exceptions to Closing Date report shows any later edits (Intuit, updated August 5, 2026).
Control: run the Exceptions to Closing Date report just before the final load. What goes wrong: a late adjusting entry posted in QuickBooks after the final export, so the two systems never agree.
Stage 6: Load opening balances and open AR and AP
Owner: the controller, with the partner and a staff accountant. Inputs: final trial balance, agings and inventory valuation at cutover. Output: opening entries that match QuickBooks to the cent.
Microsoft recommends journals rather than writing directly to ledger entries, and provides four functions that create one journal line per record: Create G/L Acct. Journal Lines, Create Customer Journal Lines, Create Vendor Journal Lines and Create Item Journal Lines (Microsoft Learn, October 2, 2026).
Load open AR and AP as individual documents, one per open invoice, credit memo or bill, so future payments apply and aging stays correct. Post each against a temporary migration clearing account rather than revenue or expense. Then load the trial balance with the AR, AP and inventory control lines offset to the same clearing account. If everything ties out, clearing nets to zero.
Illustration (constructed figures): a company has 214 open invoices totaling $182,400 and 96 open bills totaling $71,250. The customer documents post a $182,400 debit to receivables and a credit to clearing. The vendor documents post a $71,250 credit to payables and a debit to clearing. In the trial balance journal, the AR line becomes a $182,400 debit to clearing and the AP line a $71,250 credit to clearing, so clearing ends at zero and receivables and payables are counted once.
Control: a signed zero clearing balance before live posting starts. What goes wrong: loading the full trial balance, AR included, then posting open invoices on top, which doubles receivables.
Stage 7: Reconcile, go live and archive QuickBooks
Owner: the CFO signs off; the controller ties out. Output: a signed cutover reconciliation and a retained QuickBooks archive.
Compare the trial balance, agings and inventory valuation to QuickBooks at cutover. Sample migrated invoices for customer, amount, due date and dimension. Then complete the first bank reconciliation promptly, since outstanding checks and deposits in transit carry over; our Business Central bank reconciliation guide covers the setup.
After you cancel QuickBooks Online, Intuit keeps your data in read-only form for one year from the cancellation date (Intuit, published October 30, 2026). The IRS generally asks for three years of income tax records, seven for bad debt or worthless securities claims, and four for employment tax records (IRS, reviewed June 30, 2026). Export the ledger detail and attachments you need before read-only access ends.
Control: a signed reconciliation package filed with the year’s audit or tax workpapers. What goes wrong: cancelling QuickBooks early and losing detail an auditor later requests.
Metrics to track
- Trial balance variance by account at cutover, with a target of zero.
- AR and AP aging tie-out: totals and document counts by customer and vendor.
- Clearing account balance: zero after the opening load and after corrections.
- Record counts: active customers, vendors, items and accounts in QuickBooks versus Business Central.
- Defects per trial load: should fall between the first and final load.
- Entries missing a required dimension: zero if Code Mandatory is set where it should be.
- Days to close the first month: compared with your last QuickBooks close.
How software supports each stage
Business Central covers most stages natively. The migration extensions load master data, beginning balances, inventory and open documents; configuration packages handle newer Desktop files and anything the extension skips; dimensions and Value Posting rules carry the class structure; and the journal functions build opening lines. Classes, order history and partial payments need partner work or manual entry.
If you are still choosing a system, our QuickBooks to NetSuite migration guide covers the Oracle tooling and its approach to history, and our QuickBooks to Sage Intacct migration guide covers Intacct’s dimension-based setup. Business Central lists at $80 per user per month for Essentials and $110 for Premium, paid yearly (Microsoft, checked November 4, 2026), up from $70 and $100 before November 1, 2025 (Microsoft, May 6, 2025).
How we researched this
We read Microsoft’s Business Central documentation on the QuickBooks Online and QuickBooks Desktop migration extensions, configuration packages, dimensions, posting groups, environments and opening balances, Intuit’s help pages on usage limits, class tracking, closing dates and cancellation, and IRS record retention guidance. We also reviewed the top-ranking pages for this search, mostly partner blogs, to see what they leave out. Partner cost and timeline figures are quoted as published and labeled as coming from firms that sell the service. Pages were checked on November 4, 2026.
Related guides
- Business Central Implementation: Phases and Timeline
- Business Central Pricing (2026): US License Costs
- Dynamics GP to Business Central Migration Guide
Frequently asked questions
Does Business Central have a built-in QuickBooks migration tool?
Yes. Business Central includes QuickBooks data migration extensions that you run from Assisted Setup by choosing Migrate business data. They move master data, the chart of accounts, beginning GL balances, on-hand inventory and open documents, but not sales or purchase orders, and partly paid invoices arrive at full amount.
Can I migrate QuickBooks Desktop 2023 or 2024 with the Microsoft tool?
Microsoft’s documentation says the Desktop data exporter tool only works with QuickBooks 2017 and 2018. For newer Desktop versions, plan to export reports and lists to Excel and load them through Business Central configuration packages, or use a partner’s migration service.
How do QuickBooks classes map to Business Central?
Classes usually become a dimension, and the most-used one is often set as a global dimension so reports can filter by it. Business Central allows two global dimensions and up to eight shortcut dimensions. Microsoft’s migration extension pages do not mention classes, so confirm with your partner how class data on open documents will be carried over.
When is the best time to cut over from QuickBooks to Business Central?
The start of a fiscal year is cleanest, because your opening balance is a post-closing trial balance and the full year sits in one system. A quarter start is the next best choice; avoid a mid-month cutover.
Sources
- Microsoft Learn, The QuickBooks Online Data Migration Extension, updated August 21, 2025. learn.microsoft.com
- Microsoft Learn, The QuickBooks Data Migration Extension (Desktop), updated August 21, 2025. learn.microsoft.com
- Microsoft Learn, Import business data from other finance systems, updated June 17, 2026. learn.microsoft.com
- Microsoft Learn, Work with dimensions, updated April 9, 2026. learn.microsoft.com
- Microsoft Learn, Set up posting groups, updated August 13, 2025. learn.microsoft.com
- Microsoft Learn, Production and sandbox environment types, updated April 15, 2026. learn.microsoft.com
- Microsoft Learn training, Create journal opening balances, October 2, 2026. learn.microsoft.com
- Microsoft, Business Central pricing (US), checked November 4, 2026. microsoft.com
- Microsoft Dynamics 365 Blog, New Business Central pricing effective November 2025, May 6, 2025. microsoft.com
- Intuit, Learn about usage limits in QuickBooks Online, updated August 5, 2026. quickbooks.intuit.com
- Intuit, Turn on class tracking in QuickBooks Online, updated August 3, 2026. quickbooks.intuit.com
- Intuit, Edit your closed books in QuickBooks, updated August 5, 2026. quickbooks.intuit.com
- Intuit, Cancel your QuickBooks Online subscription, published October 30, 2026. quickbooks.intuit.com
- IRS, How long should I keep records?, reviewed June 30, 2026. irs.gov
- Gestisoft (Business Central partner), QuickBooks to Business Central migration, April 7, 2026. gestisoft.com
- Microsoft Marketplace, Citrin Cooperman Advisors QuickBooks to Business Central migration offer, no date shown. marketplace.microsoft.com
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
