Solution guide · Business Central
Moving from QuickBooks to Microsoft Dynamics 365 Business Central: A Guide for US Businesses
When inventory, warehouses and approvals outgrow QuickBooks, Business Central is often the next step. Here's how we plan the move, what data comes across and how long it takes.
- Business Central
- QuickBooks
- Microsoft 365
- Power BI
- Shopify
- Avalara
This is a solution guide: it shows how we design and build this kind of system. It is not a client case study. See a related case study →
Signs you've outgrown QuickBooks
QuickBooks is great for getting started. Many US companies hit its limits once they add warehouses, users, assembly or approvals. In 2024, Intuit also stopped selling several QuickBooks Desktop editions to new US customers, which pushed many teams to choose a new path.
- Inventory lives in spreadsheets or add-ons, because bins, lots and multiple warehouses are hard to run in QuickBooks.
- Month-end takes too long because data is copied between systems.
- You need approvals, user permissions and audit trails that QuickBooks doesn't offer.
- Sales tax across many states is getting harder to manage.
- Your team already works in Microsoft 365 and wants the ERP inside Outlook, Excel and Teams.
What we build in Business Central
We set up Business Central as one system for finance, inventory, purchasing, sales and, when needed, light manufacturing.
Finance and reporting
A general ledger with dimensions for departments, locations or product lines, bank reconciliation and Power BI dashboards.
Inventory and warehouses
Multiple locations, bins, lot and serial numbers, reorder points and cycle counts.
Purchasing and approvals
Approvals by amount or department, vendor price lists and invoices matched to receipts.
Sales tax and 1099s
A sales tax engine such as Avalara AvaTax for multi-state tax, and 1099 vendor reporting from Business Central.
E-commerce and EDI
Shopify through Microsoft's built-in connector, and EDI partners for big-box retail orders.
Microsoft 365 and Copilot
Quotes and orders from Outlook, data in Excel and Teams, and Copilot features where your plan includes them.
How the migration works
- AssessWe review your QuickBooks file, add-ons and reports, and list what must move and what can stay archived.
- DesignWe map your chart of accounts, dimensions, items, locations and approval rules in Business Central.
- MigrateCustomers, vendors, items, open invoices and bills, and opening balances move across. Detailed history can stay in a searchable archive.
- TestYour team runs a parallel month: orders, receipts, invoices, payments and a trial close.
- Go liveWe cut over at the start of a month or quarter, train each role and support the first close.
- ImproveAfter go-live, we add dashboards, automation and integrations in small steps.
The system at a glance
| Area | Tool | What it does |
|---|---|---|
| ERP | Business Central Essentials or Premium | Finance, inventory, sales, purchasing. Premium adds manufacturing and service. |
| Data migration | Built-in migration tools and configuration packages | Master data, open items, balances |
| Sales tax | Avalara AvaTax connector | Multi-state tax calculation |
| E-commerce | Shopify connector | Orders, stock and prices |
| Reporting | Power BI | Dashboards for owners and managers |
| Automation | Power Automate | Approvals, alerts, document flows |
Typical rollout plan
- 1–2 weeksAssessFile review, process mapping and a fixed migration scope.
- 3–6 weeksBuildSetup, data mapping, integrations and test migrations.
- 2–4 weeksParallel runA full month processed in both systems, with differences fixed.
- 2–4 weeksGo-liveCutover, training and support through the first close.
What to prepare
- Admin access to your QuickBooks company file
- A list of the add-ons and spreadsheets you use
- Your chart of accounts and the reports you rely on
- Your item list with units, locations and costing method
- Your sales tax setup and the states where you collect tax
Common questions
Can we move all our QuickBooks history?
We usually move master data, open transactions and opening balances, plus monthly summary history. Full detail can stay in an archive you can still search. This keeps the new system clean and the project faster.
How much does Business Central cost?
Microsoft licenses Business Central per user per month, with Essentials and Premium plans and lower-cost Team Member users. Check Microsoft's current price list, and we'll help you size the right mix of users.
Is Business Central overkill for a small company?
Not if you have inventory, several locations or a growing team. If you only need invoicing and bookkeeping, QuickBooks Online may still be enough, and we'll tell you so.
Can we keep our online store?
Yes. Shopify connects through Microsoft's connector, and other platforms connect through apps on Microsoft AppSource or a custom integration.
Outgrowing QuickBooks?
Send us a short list of what's slowing you down. We'll tell you if Business Central is the right move and what it would take.
More solution guides
AI Document Processing for Freight and Logistics
A private AI pipeline on AWS with NVIDIA NIM that reads BOLs, rate confirmations, PODs and invoices, checks them and posts the data to your TMS and accounting.
AWS · NVIDIA NIM · NeMo RetrieverAI Speed-to-Lead with Zapier, Make and Your CRM
Connect forms, ads and calls to an AI assistant that replies in seconds, qualifies leads and books meetings in your CRM, built with Zapier or Make.
Zapier · Make · CRM · AIOdoo Manufacturing for Food and Beverage Producers in Africa
Recipes, batch and expiry tracking, quality checks, distributor sales and multi-currency finance for African food and drink producers, in one Odoo system.
Odoo MRP · Inventory · Quality · AccountingProduct and company names are trademarks of their respective owners.