QuickBooks Online Data Migration Extension is included in the Data Migration assisted setup guide to help you migrate important business data from QuickBooks Online to Business Central. For example, this is helpful when your business is growing and you have decided to upgrade your business management app by starting to utilize MS Business Central.
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 Online.
QuickBooks Online Data Migration Extension Data Import
You can import the following data from QuickBooks Online to Business Central:
- Chart of accounts
- Beginning balance transaction in the 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 you migrate, to make sure things are easier later on.
Before you Start
An important part of the migration process is to specify 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 post transactions for:
- The sale of items or services to customers.
- The purchase of items or services from vendors.
- Adjustments in the general ledger.
If transactions in QuickBooks Online have tax amounts, you must setup a tax account for your tax jurisdictions in MS D365 Business Central before you can post transactions.
Getting started is easy. All you have to do is run the Data Migration assisted setup guide. Here is how:
- Choose the search icon, type Assisted Setup and then select Migrate business data.
- Follow the instructions on each step in the assisted setup guide.
There are a handful of things in particular that you should do:
- If the transactions in QuickBooks Online had markup or discount amounts, you must manually add the amounts to the related transactions in Business Central before you post them.
- If you are using value added tax (VAT), you may be required to add a business posting group and a product posting group to the posting setup so that you can post VAT amounts.
- Confirm the beginning balances for accounts in the general ledger. QuickBooks Online 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 analyze the transactions, go to the page where you would normally find them.
For example, to analyze the unposted sales invoices, go to the Sales Invoices page. To analyze payment journals, go to the Payment Journals page. For more information on Microsoft Dynamics 365 QuickBooks Online Data Migration Extension, please contact us.