How to Import QuickBooks Desktop to QuickBooks Online

We all know that QuickBooks online is the best solution for small business accounting software. There are some advantages of QuickBooks Desktop over QuickBooks online. QuickBooks desktop is much faster and it presents many options to cater to needs pertaining to inventories, reporting of actual job costs, etc. 

Most of the information will transfer automatically from QuickBooks desktop to QuickBooks Online. QuickBooks also provides a list of desktop features that will help in transferring QuickBooks online.

Get a Free User Guide “Why to Upgrade to QuickBooks 2022”

Headache🥺. Huh, Looking to Upgrade from Your Current Version of QuickBooks?. But frustrated which version will be best suited according to your need. Don’t worry, Get a comprehensive list of reasons, why you should upgrade to the QuickBooks 2022 version.

Get these 20 tips on why to Upgrade to QuickBooks 2022.

    Convert QuickBooks Desktop to QuickBooks Online

    There are seven steps that are used to convert QuickBooks Desktop to QuickBooks Online. So, the following are the steps  in order to convert QuickBooks Desktop to QuickBooks online:

    • Check for the requirement of the file size.
    • Preparing the QuickBooks desktop data in order to export it to QuickBooks online.
    • Create the online account by signing up in order to create the QuickBooks online account.
    • Export all of the company files that you want to export to the QuickBooks Online account.
    • Now sign in to your QuickBooks online account with the help of a log-in ID and Password through the desktop version.
    • Now search for your company in QuickBooks online in order to transfer it.
    • Now you have copied the data file in the account.

    Transferring list instead of converting

    The other way of converting your desktop file to the online company you have to export important data from QuickBooks Desktop and import it to the QuickBooks online company. With the help of this you are able to transfer the entire list like the chart of accounts, customers, vendors, products and services. In order to transfer you always need to input beginning balances.

    1. Steps to Transfer lists from QuickBooks Desktop to QuickBooks Online

    There are two steps in order to transfer the list from QuickBooks Desktop to QuickBooks Online. So, the following are the two steps in order to transfer:

    • First, you have to export the list from the desktop in the form of an excel spreadsheet.
    • Now you have to import that excel spreadsheet in your QuickBooks online company.

    Importing of QuickBooks Desktop Data to QuickBooks Online


    Following are some instructions that we use to import QuickBooks desktop data to QuickBooks Online:

    • Hit on the setting button in order to import the entire QuickBooks desktop company file.
    • Select the import desktop data file in order to open the page which contains all the video lessons and instructions in order to import the data from the QBD version.
    • Follow all the on-screen instructions in order to process it.
    • If you need to update your system then update it and then make sure that you can export it to QuickBooks online.
    • Now import it, once it is done then follow the on-screen instruction and verify your QuickBooks desktop data that it is imported correctly in the QuickBooks online.

    Process of Exporting QuickBooks Desktop Data

    1. Steps to Exporting of list from QuickBooks Desktop

    In order to export the following list from QuickBooks Desktop to excel. With the help of this, you can create a new online company, and still, it is very useful in saving hours of performing data entry jobs.

    • Chart of accounts.
    • Customers 
    • Vendors
    • Product and services.
    Steps to Exporting of list from QuickBooks Desktop

    2. Steps to Exporting the chart of accounts 

    Following are some steps in order to export the chart of accounts from the QuickBooks Desktop:

    • Select the company tab from the menu bar at the top of the screen.
    • From the drop-down menu of the company hit the chart of accounts option.
    Steps to Exporting the chart of accounts
    • The chart of accounts shows the list of your accounts.
    • Select one of the accounts from all of the accounts.
    • Once you select you will see the report option at the bottom of the screen.
    • Now select the accounting list from the drop-down menu of the report option.
    Steps to Exporting the chart of accounts 2
    • In the Account listing report, you can view the excel spreadsheet by clicking on the excel sheet from the options of the menu.
    • Hit the click on the create new worksheet option from the list of menu and then follow all the instructions in order to save the worksheet to your computer.
    Steps to Exporting the chart of accounts 3

    3. Steps to Exporting customers from QuickBooks Desktop

    Follow the following steps in order to export the customers from the QuickBooks Desktop:

    • Select the customer option from the top of the menu.
    • Click on customer center from the drop-down list of customers.
    Steps to Exporting customers from QuickBooks Desktop
    • Select the excel sheet option from the toolbar of the customer center.
    • From the drop-down menu of excel select the export customer list.
    Steps to Exporting customers from QuickBooks Desktop 2
    • Follow all the instructions in order to save the new worksheet on your computer.
    •  Once you are done with the above steps then you can easily import this sheet into your QuickBooks Online company later on.

    4. Steps to Exporting vendors from QuickBooks Desktop

    Follow the following instruction in order to export vendor from the QuickBooks Desktop:

    • Click on the vendor tab in the top menu bar of QuickBooks.
    • Select the vendor center from the drop-down list of the vendor.
    Steps to Exporting vendors from QuickBooks Desktop
    • Select the excel sheet from the top bar and click on the export vendor list option.
    Steps to Exporting vendors from QuickBooks Desktop 2
    • Now you have to follow on-screen instructions in order to save the worksheet in order to import it in QuickBooks online later.

    5. Steps to Exporting products and services from QuickBooks Desktop

    Following is the procedure for exporting the products and services from the QuickBooks Desktop:

    • Navigate to the customer tab in the top menu bar.
    • From the drop-down list of the customer hit the item list.
    Steps to Exporting products and services from QuickBooks Desktop
    • Now select the item from the list of items.
    • As you select the item then at the bottom you can view the option named excel, click on it.
    • Now select export all items from the list of options in excel.
    Steps to Exporting products and services from QuickBooks Desktop 2
    • Now you have to follow on-screen instructions and save the items as an excel worksheet.

    Process of Importing Data from QuickBooks Desktop to QuickBooks Online

    1. Importing the list in QuickBooks Online

    Small businesses have an online tutorial that will help you in learning that how to use QuickBooks online efficiently in order to manage your business. There are three steps that will help you import the file which you have created in the previous steps:

    A. Setting up of customers

    Follow the following steps in order to import the customer file which you have exported previously:

    • First, you have to gather all the detailed Information about the customer.
    • Information about the customer is like:
      • Name of the company
      • The name of the contact person.
      • Address of the person
      • Email Address
      • Address of the website
      • Telephone numbers
      • The opening balance

    B. Setting up of the vendor

    Follow the following steps in order to set the vendor:

    • Now first you have to provide the correct and detailed information about the vendor.
    • Now you have to navigate to the vendor center.
    • Now create the new vendor
    • Enter the vendor detail in the desired field.
    • Now review the vendor setup according to the:
      • Setting up of vendors
      • Setting up of products and services.

    C. Setup of product and services

    Follow the following steps in order to set up the product and services :

    • Enter the detail of the products which you buy and sells.
    • Some of the important detail are:
      • Name of the product.
      • Select the product in order to print the sales form.
      • Select the product in order to print the purchasing forms.
      • Number of stock keeping unit.
      • Price of the selling products;.
      • Current price of the product which customer purchased or purchased.
      • Prefer vendor of the product.
      • Product sale is subject to the sales tax.
      • Keep the track of the Quantity of the items.

    D. Information for service to sell

    You need to fill in the following information for all the services which you sell.

    • Service name.
    • Service description in order to print on the sales form
    • Sales price or the rate you can charge as per your requirement.
    • The service of the sale is subject to the sale tax.
    • In case you purchase the service from the subcontractor.
      • Describe the service which is to be print on the form.
      • Cost changed by the subcontractor
      • Name of the subcontractor.
    • Go to the product and the service list.
    • Now create new item.
    • Select the type of item.

    2. Importing of Data from QB Desktop to QB Online

    Following are the steps in order to import the data from QuickBooks Desktop to QuickBooks Online:

    • First, you have to log in to your QuickBooks account with the help of a login ID and Password.
    • From the menu bar click on the company tab and then select the export company file in QuickBooks online option from the list of options.
    • Now from the other screen open your QuickBooks online account by adding your user ID and Password.
    • Now you have to choose whether you want to import your inventory data or not.
    • Navigate to the company name from the drop-down menu. In this, you have to select the company whose data you want to import.
    • You also have the option to create the new one if you want by clicking on the Create a new company option.
    • Hit the continue button and then OK or agree.
    • The email notification is sent on your registered mail ID that the importing is done successfully from QuickBooks Desktop to Online.

    Get Expert Advice to Fix All Accounting & Bookkeeping Problems

    5138226

    FAQ

    How can I import transactions from QuickBooks Online to QuickBooks desktop?

    Follow the following steps in order to import the transaction from QuickBooks Online to QuickBooks Desktop:

    1. First, you have to navigate to the file menu in the menu bar.
    2. Select the import button in order to import the data.
    3. Select the transaction and from the list of options select the type of transaction which you want to import.
    4. Navigate to the gear menu and select the export table template.
    5. Now you have to enter the name of the template and hit the OK button in order to save it. 
    6. Now open the temple in the spreadsheet application.
    7. Add the transaction to your template and save your work.
    8. Once you are done with the above steps just follow these in order to import it:
    9. Navigate to the file menu. And select the import button.
    10. Click on the transaction which you want to import.
    11. Now you have to copy the transaction from your spreadsheet and paste it in the import Window.
    12. Select the bank in which you want to deposit the account.
    13. Once you are done with all the above steps. Check if everything is fine then click the save button in order to save the data.

    How can I import the QuickBooks file into QuickBooks data?

    In order to import the QuickBooks file in the QuickBooks tab you have to follow the following steps:

    1. Open your QuickBooks with the help of a login ID and Password.
    2. Select the file tab from the top menu bar.
    3. Select import and then the next button in order to move forward.
    4. Now hit the web. Connect the button and then select the .qbo file which you want to import.
    5. Click on the Open tab in order to open the file.

    How can I manually import bank transactions into the QuickBooks desktop?

    In order to import bank transactions on the QuickBooks desktop you have to follow the following steps:

    1. First, you have to go to the file menu.
    2. Now select the utilities.
    3. Select the import button.
    4. Select the file which is connected to the web.
    5. Now select the QBD file which you want to open.
    6. In case the account is already created then it is good but if it is not already created then you have to create it by clicking on the new QuickBooks account.
    7. Hit the continue button in order to move forward and save the changes.

    So, in the above article, we have read how we can import QuickBooks Online files to QuickBooks Desktop. We are hopeful the above article will help you in importing the file successfully. But in case you are not able to import then you can call our helpdesk team or drop an email. Our technical experts will help you in resolving the issue and import your data from one system to other in no time. 

    Phone

    +1800-961-4963

    Toll Free: 800-961-4963 user