Conversion Process Microsoft Dynamics to QuickBooks
Start your conversion process by signing up for QuickBooks Online. Once you sign up, then log in to your QuickBooks Online account, create a company profile, and complete any of the welcome fields. Make sure not to enter any other data in this step.
Fix any existing errors and issues with your QuickBooks Desktop inventory before importing to prevent loss of data. The conversion process is automated, and there is nothing you can do in QuickBooks Online until the process is finished. During the conversion, data from QuickBooks Desktop will replace existing information in your QuickBooks Online. A warning message pops up on your screen before the process overwrites any of your data.
Run Payroll Data
You might need to run payroll and pay taxes before converting. Make sure to mark any employees who no longer work for your company as inactive and fill out all the crucial data about your current employees. However, gender and other personal data are not necessary for QuickBooks Desktop. However, QuickBooks Online needs all your data about your employees before you can be working with the payroll.
Run Reports
Before beginning the conversion process, run a Balance Sheet and a Profit and Loss Report in QuickBooks Desktop. You need to review these documents after the conversion is finished to make sure all data is transferred accurately.
Backup Your Data
You might need to create a backup of your file to restore your current data in case you need to start over with the conversion process, then click on the file, and then switch your QuickBooks Desktop to a sole user. Now that your computer is a single-user mode, click on Backup Company and select Create Local Backup.
Now specify where you want to save your data and follow other prompts on your screen before saving your information.
Export Your Company File
Now that you have updated your QuickBooks Desktop program and prepared and backed up your file, you are ready to start the conversion.
In your QuickBooks Desktop software, select the Company Menu. Then, click on Export Company File to QuickBooks Online, and a window pops up on your screen, asking you to log in to QuickBooks Online. Follow the prompts on your screen to import any inventory data.
Complete the Conversion Process
The conversion then starts automatically. In some instances, you can finish the conversion process in as little as an hour, depending on the size of your file. If your files are very large, then the process can take up to 24 hours. Make sure to select No if a “slow scripting error” shows on your system’s screen to avoid halting the whole process.
As you don’t have to do anything during the conversion, it is fine to let it run undisturbed while you take care of your other tasks outside of QuickBooks Online. You can expect to receive an email to confirm that QuickBooks Desktop’s conversion to QuickBooks Online is complete.
Check Your Data
Once the conversion is completed, make sure to check your pre-conversion and post-conversion Profit and Loss Reports to double-check that all the information is transferred successfully. Compare the statements looking for any discrepancies. Once everything is checked, you can then go through the guided tour to understand the navigation process and check how to add your accountant and customize your QuickBooks Online reports.
How to Convert Data From Microsoft Dynamics to QuickBooks Online
As with QuickBooks, make sure to back up your data before you start the conversion process from Microsoft Dynamics to QuickBooks Online.
How to Import MS Excel Files
You can import vendor, customer, charts of accounts, and inventory data from an Excel spreadsheet. You can do a full backup of your company or client’s files before importing and converting files to avoid losing critical information. While importing Excel files from your system, QuickBooks automatically opens an Excel spreadsheet where you can enter your business information.
Let’s dive into the steps below to import items:
- First of all, go to the File Menu.
- Then click Import under Utilities.
- Next, select Excel Files.
- Then choose the type of data you’re importing.
- Enter your information, save your file, and close it.
- Now review the results and view your saved files in QuickBooks.
- Close the window once you are done.
Note: You can go back to this window if you want to import and convert additional information.
Microsoft Dynamics to QuickBooks Versions Supported
- Dynamics Accounting to QuickBooks Online.
- Dynamics Accounting to QuickBooks Premier, Pro, Accountant, or Enterprise.