QuickBooks Data Migration Extension - Locus IT Services

QuickBooks Data Migration Extension

Locus IT ServicesNewsQuickBooks Data Migration Extension

QuickBooks Data Migration Extension

QuickBooks Data Migration Extension makes it easy to migrate customers, vendors, items and accounts from QuickBooks to Business Central. If your business utilizes QuickBooks, you can transfer the relevant information and then open an assisted setup guide to upload the data to Business Central.

MS D365 Business Central requires that general ledger accounts have account numbers allocated to them. Make sure that account numbers are allocated to your accounts in QuickBooks. If transactions in QuickBooks possess tax amounts, for the tax jurisdictions you must setup a tax account in MS D365 Business Central before you can post transactions.

QuickBooks Data Migration Extension from QuickBooks Desktop

You can import the following data from QuickBooks Online to Business Central:

  • Customers
  • Vendors
  • Items
  • Chart of Accounts
  • Beginning Balance transactions in General Ledger
  • On-hand Quantities for Inventory Items
  • Open documents for customers and vendors, such as invoices, credit memos and payments

Migration of only full amounts is performed on sales and purchase documents. Partially paid amounts are not updated. For example, if a customer has paid 300 of a total of 500 dollars on a sales invoice, the full migration is done for 500.

If you have received partial payments, you must update these manually, either initially or after you migrate the data. Make sure that you apply outstanding transactions before migrating, to make sure things are easier later on.

Before Starting

The key part of the migration process is to describe the accounts to migrate transactions to. It is a good idea to plan this mapping before you migrate data. For example, the accounts where you publish transactions for:

  • The sale of items or services to customers
  • The purchase of items or services from vendors
  • Adjustments in the general ledger

In order to get your data out of the QuickBooks desktop application you will have to download the Microsoft Data Exporter Tool. The instructions for the tool are in the Data Migration Wizard in MS D365 Business Central. The tool will connect to your QuickBooks application and export the applicable data to a .zip file.

Finding the QuickBooks Data Migration Extension

The QuickBooks Data Migration extension is installed and ready to go as the combined part of the Data Migration assisted setup guide. If you are ready to get started now, and have exported your data from QuickBooks, choose the search icon, enter Assisted Setup, and then choose the related link. Choose Migrate business data, and then follow the steps in the guide.

To review payment journals, go to the Payment Journals page. There are a few things in particular that you should do:

  • If the transactions in QuickBooks had markup or discount amounts, you must manually add the amounts to the related transactions in MS D365 Business Central before you post them.
  • If you are using value added tax (VAT), you may need to add a business posting group and a product posting group to the posting setup so that you can publish VAT amounts.
  • Confirm the beginning balances for accounts in the general ledger. QuickBooks does not store the current balance for all accounts, so you might need to correct beginning balances.

After you migrate data, transactions have the status Unposted, so you can review them and make adjustments. To re-check the transactions, go to the page where you would normally find them.

For example, to evaluate unposted sales invoices, go to the Sales Invoices page. For more information on Microsoft Dynamics 365 Business Central QuickBooks Data Migration Extension, please contact us.

Locus IT Project Management Office
What’s it?