Xero to Business Central Migration: When and How to Make the Switch

In a nutshell: Moving from Xero to Microsoft Dynamics 365 Business Central can help growing US businesses manage finance, inventory, purchasing, sales, and operations in one connected ERP system. However, successful migration requires careful data mapping, reconciliation, integration planning, and user testing. This guide covers when to make the switch, how the migration works, expected costs and timelines, and whether Microsoft’s BTC3 promotion applies to Xero customers.

Introduction

Xero can be an effective accounting platform for a small business, but growth can introduce requirements that go beyond day-to-day bookkeeping. Multiple warehouses, complex inventory costing, manufacturing operations, intercompany transactions, and tighter financial controls can make a more comprehensive business management system worth evaluating.

Microsoft Dynamics 365 Business Central combines financial management with purchasing, inventory, sales, project management, and, in its Premium edition, manufacturing and service management. Migrating from Xero can help a growing US business bring more of these processes into one connected system, provided Business Central fits its operational requirements.

However, Xero to Business Central migration is not a direct, one-click upgrade. The two products have different data structures, workflows, and configuration options. A successful transition requires decisions about which records to migrate, how to map financial information, which historical transactions to retain, and how to validate the new system before going live.

This guide explains when migration makes sense, how to plan and execute it, what it may cost, and whether Microsoft's Bridge to the Cloud 3 (BTC3) promotion applies.

Quick Overview: Xero vs. Business Central Migration

  • Why migrate? To support more complex financial, inventory, purchasing, and operational workflows as the business grows.

  • What moves? Depending on the migration approach, this may include chart of accounts, customers, vendors, open invoices and bills, inventory records, opening balances, and selected historical transactions.

  • How does migration work? Typically through data exports, mapping, supported imports or migration tools, third-party solutions, and custom development where required.

  • How long does it take? The timeline depends on data volume, historical reporting requirements, integrations, customizations, and the number of business processes being implemented. A simple financial transition differs substantially from a multi-entity ERP deployment.

  • Does BTC3 apply? Potentially, but eligibility depends on Microsoft's current promotion rules and the customer's existing Dynamics licensing. Moving directly from Xero alone does not automatically qualify a business for BTC3.

When Should a Growing Business Migrate from Xero to Business Central?

Xero may continue to meet your needs if your primary requirements are invoicing, bank reconciliation, expense tracking, and financial reporting. Migration becomes worth evaluating when accounting starts depending on operational data that lives in separate systems.

Common signs include:

Inventory complexity

You need better control over multiple locations, inventory valuation, replenishment, or item tracking.

Manufacturing requirements

You need production orders, bills of materials, capacity planning, or manufacturing cost visibility.

Disconnected operations

Sales orders, purchasing, fulfillment, and finance rely on separate applications and manual reconciliation.

More complex financial structures

You need stronger support for multiple companies, intercompany processes, or consolidated reporting.

Reporting limitations

Your finance team spends excessive time reconciling spreadsheets before it can produce reliable management reports.

Growing control requirements

You need more structured approval workflows, role-based permissions, and traceable financial processes.

Business Central is not automatically the better choice for every Xero customer. If your accounting needs remain simple, the cost and effort of an ERP migration may outweigh the benefits. The decision should be based on operational complexity, not business size alone.

Ready to Move Beyond Xero?

Upgrade to Business Central for smarter financial management and scalable growth. Connect with Dynamics Square USA to plan your migration today!

Book A Demo

What Data Should You Migrate from Xero?

The migration scope determines much of the project's complexity. Rather than transferring everything by default, decide which information is essential for day-to-day operations, financial continuity, and historical reporting.

Data category Migration considerations 
Chart of accounts Map Xero account codes to Business Central's general ledger structure. 
Customers and vendors Preserve identifiers, contact details, payment terms, and relevant tax information. 
Open sales invoices and credit notes Reconcile outstanding customer balances and document-level details. 
Open supplier bills Preserve outstanding liabilities and payment due dates. 
Bank and cash balances Reconcile balances at the agreed cutover date. 
Inventory items Map item numbers, units of measure, locations, costing methods, and opening quantities. 
Fixed assets Review acquisition cost, accumulated depreciation, useful lives, and remaining book value. 
Historical transactions Decide whether to migrate detailed history, summarized balances, or retain read-only access to Xero. 
Attachments and supporting documents Identify which invoices, receipts, and other records need to remain accessible. 

The critical decision: Full history or opening balances?

A business does not necessarily need to recreate every historical Xero transaction in Business Central.

A smaller company may choose to migrate master records, open transactions, and verified opening balances while retaining Xero for historical reference. A business that needs detailed transaction-level reporting in its new ERP may require a more extensive migration.

These approaches are not equivalent. Opening balances can establish financial continuity, but they do not automatically recreate the underlying invoice history, inventory movements, or audit trail in Business Central.

Agree on the reporting and audit requirements before choosing the migration scope.

How to Migrate from Xero to Business Central

There is no universal one-click Xero-to-Business-Central migration wizard. Microsoft's documented migration options for other supported products should not be assumed to provide a direct Xero conversion path.

Microsoft supports importing data from other finance systems through Excel, configuration packages, templates, and suitable extensions. A migration partner can determine which method is appropriate for the required data and whether additional tooling is needed.

Step 1: Assess the existing Xero environment

Document the current chart of accounts, tracking categories, tax settings, currencies, bank accounts, inventory records, integrations, and reporting requirements.

Identify manual workarounds as well. For example, if your team maintains inventory adjustments in spreadsheets because the current workflow does not meet its needs, simply importing the existing data will not resolve that process problem.

Step 2: Design the Business Central environment

Configure the new system around the way the business needs to operate.

This includes decisions about:

  • General ledger accounts and financial dimensions.

  • US tax setup and applicable state-specific requirements.

  • Customer and vendor posting groups.

  • Inventory costing, units of measure, and warehouse locations.

  • Approval workflows and user permissions.

  • Reporting, integrations, and any required extensions.

For US companies, review sales-tax processes carefully. State and local tax obligations vary, and migrating account balances does not configure the tax rules or validate tax treatment automatically.

Step 3: Export, clean, and map the data

Export the required information from Xero into suitable files. Remove duplicate records, resolve inconsistent identifiers, standardize dates and currencies, and identify inactive accounts that do not need to be transferred.

Then map Xero fields to their Business Central equivalents.

This step requires more than matching column names. A Xero tracking category, for example, may need to become a Business Central dimension or another reporting structure. The correct mapping depends on how the business uses that information.

Step 4: Import data using the appropriate method

Depending on the migration scope, the implementation team may use:

  • Excel imports and Business Central configuration packages.

  • A suitable third-party migration extension.

  • Custom data transformation and import tooling.

  • Journal entries or other controlled posting processes for opening balances and outstanding transactions.

Configuration packages are useful for supported tables and initial company setup, but they are not a universal mechanism for importing every type of posted historical transaction. Microsoft documents restrictions on importing data into tables containing posted entries.

Step 5: Reconcile the migrated information

Do not rely solely on successful import messages. Validate the resulting financial and operational records.

At a minimum, reconcile:

  • Trial balance totals against the agreed Xero closing balances.

  • Accounts receivable against open customer invoices.

  • Accounts payable against open supplier bills.

  • Inventory quantities and values against the approved inventory valuation.

  • Fixed-asset balances against the fixed-asset register.

  • Bank balances against reconciled statements.

  • Tax balances and other control accounts against supporting records.

Differences should be explained and approved before go-live, not carried forward as unexplained opening adjustments.

Step 6: Test business processes before cutover

Run realistic end-to-end scenarios in a test environment. Create a sales order, ship and invoice it, verify the accounting entries, receive inventory, process a supplier invoice, and review the resulting financial reports.

Test integrations and approvals as well. A successful data import does not prove that the complete business process works.

Step 7: Cut over and stabilize

Choose a cutover date, define when users must stop posting in Xero, reconcile final balances, and confirm that the Business Central opening position agrees with the approved closing position in Xero.

Assign responsibility for resolving issues after go-live. Retain access to historical records in accordance with your company's retention and compliance requirements.

How Long Does Xero to Business Central Migration Take?

There is no fixed timeline for every Xero migration. The main variables are the number of records, the complexity of financial and inventory data, the required integrations, and how much of the business process needs to change.

Migration scenario Main considerations 
Financial data and opening balances Account mapping, reconciliations, open invoices, bills, and cutover 
Finance with inventory Item records, costing methods, locations, stock quantities, and valuation 
Multi-entity or integrated ERP Intercompany setup, consolidated reporting, integrations, and additional testing 
Manufacturing or customized workflows Production setup, bills of materials, operational data, extensions, and user acceptance testing 

Treat these as planning categories, not guaranteed delivery estimates. A partner should establish a realistic timeline after reviewing your Xero environment and requirements.

The project plan should include discovery, configuration, data preparation, test migrations, reconciliation, user acceptance testing, training, cutover, and post-go-live support. Compressing testing to meet an arbitrary deadline can create costly accounting and operational issues later.

What Does Xero to Business Central Migration Cost in 2026?

The total cost includes more than the new software subscription. Budget for implementation, data migration, integrations, extensions, training, testing, and ongoing support.

Microsoft's US pricing page currently lists the following Business Central subscription prices, billed annually:

License Published US price Typical fit 
Essentials $80 per user/month Core finance, purchasing, sales, inventory, and project management 
Premium $110 per user/month Essentials plus enhanced manufacturing and service management 
Team Members $8 per user/month Limited access for users who need to read data, approve workflows, or update select information 

These are published subscription prices, not a complete project estimate. Your actual cost depends on licensing eligibility, user types, partner services, required extensions, and implementation scope. Premium is not necessary for every business, and Team Members licenses do not provide the same permissions as full user licenses.

For budgeting, separate the costs into four categories:

  1. Licensing: Business Central subscriptions and any additional applications or services.

  2. Implementation: Discovery, configuration, data migration, testing, and deployment.

  3. Integration and customization: Connecting external systems and addressing requirements that standard functionality does not cover.

  4. Ongoing operations: Support, training for new employees, process improvements, and additional development.

Request a scoped estimate based on your data and business requirements instead of relying on a generic migration price.

Also Read: Business Central Pricing and Licensing

Does the BTC3 Promotion Apply to Xero to Business Central Migration?

Not automatically. Microsoft's Bridge to the Cloud 3 (BTC3) promotion is designed for eligible customers moving from qualifying Dynamics on-premises products to Dynamics 365 online. It is not a general discount for businesses switching from Xero.

Under Microsoft's published BTC3 terms, eligible customers can receive a 30% discount on qualifying three-year Dynamics 365 online subscriptions. The enrollment period runs from January 1, 2026, through December 31, 2027. Eligibility includes requirements concerning the existing Dynamics product, licensing history, active Enhancement Plan, target cloud product, and subscription commitment.

When could BTC3 be relevant?

  • Xero is your only accounting system: Do not assume you qualify. A direct Xero-to-Business-Central migration does not satisfy BTC3's existing Dynamics on-premises licensing requirement.

  • Your company also operates a qualifying Dynamics on-premises product: BTC3 may be worth investigating if the relevant licenses and other eligibility requirements are met.

  • You are comparing implementation incentives: Ask your Microsoft partner to check which programs apply to your specific customer and deployment. Microsoft has also announced a Business Central Migration Voucher program with separate eligibility rules.

The distinction between licensing promotions and implementation funding matters. A licensing discount does not necessarily pay for migration services, and an implementation voucher is not the same as discounted software licensing.

Microsoft's FY27 Business Central Migration Voucher terms cover July 1, 2026, through June 30, 2027, subject to program conditions and availability. The voucher cannot generally be combined with BTC3 for the same qualifying workloads, except for the stated Copilot Advantage combination.

For a business moving from Xero alone, the sensible approach is to budget for Business Central using standard licensing and implementation costs, then verify whether any other applicable offers are available. Do not include BTC3 savings in a business case until eligibility has been confirmed.

What Are the Most Common Xero to Business Central Migration Mistakes?

Several migration issues arise because businesses treat the project as a data transfer rather than a change to their financial and operational processes.

Migrating dirty data without fixing it

Duplicate customers, inconsistent item codes, and inactive accounts can create problems in the new system. Clean and validate records before importing them.

Assuming account balances are enough. 

Opening balances can establish the financial position, but they do not recreate invoice-level history, inventory movements, or supporting documentation. Decide what your reporting and audit requirements demand.

Overlooking inventory costing

A correct stock quantity does not necessarily mean a correct inventory value. Validate the costing method, inventory valuation, units of measure, and opening stock by location.

Recreating Xero workflows without reviewing them

Business Central has different structures and capabilities. Reassess approval processes, dimensions, posting groups, and reporting rather than reproducing every workaround from the old system.

Underestimating integrations

Bank feeds, e-commerce applications, payroll systems, tax tools, and reporting platforms may require replacement connectors, configuration, or custom development. Confirm compatibility before committing to a go-live date.

Skipping reconciliation and user testing 

Successful imports do not guarantee accurate financial statements or functioning business processes. Require signed-off reconciliations and realistic end-to-end testing.

What Should You Do After Migration?

The first few weeks after go-live are important for identifying issues that may not appear during testing.

  • Reconcile the first bank statements and financial reports.

  • Review customer and vendor balances, inventory valuation, and tax postings.

  • Monitor failed integrations, posting errors, and approval delays.

  • Provide additional training where employees struggle with new workflows.

  • Review whether reports and dashboards meet management's requirements.

  • Keep a documented process for investigating and resolving migration-related discrepancies.

Avoid making unexplained adjustments simply to force reports to agree. Investigate the source of any difference and document the correction.

Make Your Xero to Business Central Migration a Strategic Move

Moving from Xero to Business Central is an opportunity to address the operational limitations that have emerged as your business has grown. The best outcome is not simply a new accounting system. It is a more reliable way to connect finance, inventory, purchasing, sales, and reporting.

At Dynamics Square USA, we help businesses evaluate their requirements, plan data migration, configure Business Central, and prepare teams for the transition. As a Microsoft Solutions Partner founded in 2011, we bring more than 14 years of experience, 150+ Microsoft Certified Consultants, and a track record of 500+ clients across 500+ implementations, with a presence in the USA, UK, and Canada.

Contact us to assess your migration scope, identify data and integration risks, and build a practical implementation roadmap with transparent cost and licensing considerations.

Frequently Asked Questions

Yes, but the approach depends on your data and requirements. You can use supported imports, configuration packages, suitable extensions, or custom migration tools. There is no universal one-click migration wizard for every Xero-to-Business Central scenario.

Possibly, depending on the migration method and the data involved. Historical transactions may require custom transformation and posting processes. Some businesses migrate only essential history and retain read-only access to Xero for older records.

Not necessarily. Each integration must be checked for Business Central compatibility. You may need a replacement app, a connector, or custom development.

It can be, particularly if the business needs more advanced inventory, purchasing, financial controls, or operational integration. If your requirements remain limited to basic accounting, evaluate whether the additional capabilities justify the cost and implementation effort.

Not based on Xero alone. BTC3 targets eligible customers migrating from qualifying Dynamics on-premises products to Dynamics 365 online. A Xero customer would need to meet the program's separate existing-Dynamics licensing requirements to qualify.

A financial-year boundary can simplify opening balances and reporting, but it is not mandatory. Choose a cutover date that gives your team enough time to reconcile records, test the new system, and prepare employees.

Darshan Mungekar - Author
Darshan Mungekar

Darshan Mungekar is a Principal Solution Architect with more than 20 years of experience in Microsoft Dynamics 365 solution consulting and enterprise business a...

Financial Close Automation for Multi-Entity Companies: What Business Central Can and Cannot Do

Discover how Business Central supports financial close automation for multi-entity companies, including consolidation, capabilities, limitations, and AI opportunities.

Lot Traceability Software for Food Manufacturers: What Business Central Covers for FSMA 204

Improve food safety with lot traceability software in Business Central. Track batches, monitor expiration dates, simplify recalls, and gain AI-driven insights.

Phone