Migrating Data From QuickBooks Desktop to QuickBooks Online

Home > Blogs > QuickBooks > Migrating Data From QuickBooks Desktop to QuickBooks Online
Category : QuickBooks
Estimated read time : 05 Min

QuickBooks Online is a cloud-based accounting software that allows multiple users to work on the same company file at the same time. Also, it is a perfect software that gives access to top-notch features that makes the accounting process more convenient. But sometimes the users feel the need to Data Migration From Desktop to QuickBooks Online and find it a challenging task. Read this entire post attentively, and you will get to know the complete details regarding how to migrate the desktop data to the Online version. 

Didn’t have any clue on how to migrate data from QuickBooks Desktop to QuickBooks Online? Give us a call at @+1855-603-0490 and connect with our experts to get a quick resolution to your query. 

What is QuickBooks Data Migration?

QuickBooks Data Migration is a procedure that you perform when you need to expand your company on the software or are shifting to a newer version, or move your QuickBooks Desktop file to QuickBooks Online. When you go through this process, you transfer the latest data with you forward and save the rest.

When Is QuickBooks Data Migration Relevant?

Here is a list of circumstances that might lead you to go ahead with data migration:

  1. To start with, you transfer data if you are shifting to QuickBooks Online.
  2. When you have an irreversible error in the currently available data. Data migration provides the data with a newer and stronger foundation.
  3. In case you need to expand your workspace and there are years of data, all in one place.
  4. Also, when you are shifting to the latest QuickBooks version.
  5. This is also done if you are using QuickBooks from some other financial software or vice versa.

Manual Procedure To Get the Job Done

Go along this step-by-step ABC to understand the Data Migration From Desktop to QuickBooks Online process:

Step 1: Check Number of Targets

Let us first understand what targets are? Targets are the number of transactions that you make. Every line means one target. Well, if you have even done the transfer before, then you must be aware of the fact that QuickBooks only allow 3,50,000 targets to transfer at a time.

  1. To check the current number of targets, press Ctrl + 1 from your keyboard. This will launch the Product Information window on your screen. 
  2. In the Product Information window, you will get the Total Targets on the left side of the screen.

Now, if you notice that your file crosses the maximum of 350,000 targets then you have to condense it to reduce the file size. Apart from this, if the target number is more than 700, 000 for Canada and over 500, 000 for the UK and South Africa then you can only convert the balance and a list. 

Step 2: Make a Backup of All Your Data

By taking a backup of all your data, you ensure that it is ready to export.

  1. If you are presently working in the multi-user mode, move to the File menu > Switch to single-user mode. 
  2. Otherwise, go to QuickBooks Desktop and click on the File menu at the top left corner of the page.
  3. Following this, choose Create Backup and then hit the Local Backup option. 
  4. From the upcoming window, opt for the Local Backup followed by the Next button.
  5. Proceeding further, navigate to the Local Backup Only section, tap on Browse, and pick the location where you desire to store the file. 
  6. Afterwards, a test run to review whether the backup is done properly or not. 
  7. Once you are all set then you must choose the highlighted OK button to go further.
  8. Subsequently, select the Save it Now button and then click Next. As a result, it will show the message stating backup complete on your computer screen.

Step 3: Export Data To QuickBooks Online

Make sure that you have set up your QuickBooks Online profile. Once that is done, you can do Data Migration From Desktop to QuickBooks Online .

  1. In QuickBooks Desktop, head to the Company option from the menu bar.
  2. Now, scroll to the bottom of the drop-down list. This is where you will find the Export Company File to QuickBooks Online option.
  3. If the option is not available to you, go ahead and install the latest version of the QuickBooks Desktop application.

Step 4: Export the Lists

Now, make sure you export all your Lists to get the backup available when you switch to QuickBooks Online. The best way to do so is by creating an in-built Excel sheet of all your data.

Export Customers List

To make the Customers List ready to be exported, follow these steps:

  1. Head to the menu bar of QuickBooks Desktop application.
  2. There, locate the Customers menu and open the drop-down list.
  3. Here, go to the Customers Center. A new pop-up window will appear in front of you.
  4. Look for the Excel button, and there select Export Customer list.
  5. Make sure you save the Excel sheet in a save space.

Read Also : Transfer QuickBooks Desktop to Another Computer

Migrate Chart of Accounts

Now, let’s make the Chart of Accounts ready to go to QuickBooks Online.

  1. Right beside the Customers option, you will find Company.
  2. There, go to Chart of Accounts. You can also tap Ctrl + A to access this window.
  3. Here, you will see the Reports option.
  4. From there, click on Account Listing.
  5. The software will open up a new window for the same
  6. Finally, click on the Excel option here and choose to Create New Worksheet.
Export Products and Services

The process of exporting every item under the Lists is pretty much similar.

  1. From the menu, click on Customers again.
  2. In the list, look for Item List and hit that.
  3. You will see the list on your screen.
  4. Locate the Excel option at the Taskbar and click on Export All Items.
Make Excel Vendors List

For the Vendors list, these are the steps:

  • Go to the Vendors option located on the right side of Customers and go to the Vendors Center.
  • There, click on Excel and select Export Vendors List.

After you have prepared the Excel sheet of all these items, just go to QuickBooks Online and import them by clicking on the Import option under the Excel sheet instead of Export.

Wrapping Up

So, here we conclude this post and hope that now it has become much easier to Data Migration From Desktop to QuickBooks Online . However, if you still facing any issues while migrating the data, you can consult with our professionals anytime through the live chat facility. Otherwise, you can drop a message to our professionals mentioning your query and obtain a quick resolution within the least time applicable.

Frequently Asked Questions (FAQ’s) 

Q1. How much time will it take to migrate from QuickBooks Desktop to QuickBooks Online?

Ans. The time taken while migrating the QuickBooks Desktop data to the Online version will completely depend upon the file size. Also, it depends upon the speed of your internet connection. 

Q2. Does it charge anything while migrating from the Desktop version of QuickBooks to Online?

Ans. No, the users won’t charge anything while migrating QuickBooks Desktop data to the Online version. 

Q3. Do I have to cancel my QuickBooks Desktop subscription after switching to QuickBooks Online?

Ans. Yes, it is mandatory that you must cancel your QuickBooks Desktop subscription after switching to the Online version. Doing so will save you from getting charged for both of subscriptions. 

Q4. Why do companies prefer to switch from QuickBooks Desktop to Online?

Ans. Mostly, the companies choose to pick the QuickBooks Online version in comparison to the Desktop as it is more affordable. Also, the QBO version allows the users to work remotely on the same data file and integrate their software with other third-party applications. 

Leave a Reply

Your email address will not be published. Required fields are marked *