How To Convert QuickBooks Desktop to Online in 7 Steps

Looking for:

Quickbooks desktop transfer to online 













































   

 

Quickbooks desktop transfer to online



 

Step 3. Visit QuickBooks Online and subscribe to your preferred version of QuickBooks Online prior to starting the conversion process. Setting up your QuickBooks Online account. Select Update QuickBooks from the Help menu and follow the instructions. Once the update is complete, export the company file as shown above. You may need to close and reopen QuickBooks Desktop for the update to take effect. Tip: QuickBooks stops supporting desktop programs after three years, so you may not be able to update older programs.

One workaround is to get a free day trial subscription to the latest QuickBooks Desktop Pro. You should be able to export your company file to QuickBooks Online after you open it in the new program. Step 5. Preparing to move your data to QuickBooks Online. If you currently track inventory, QuickBooks will ask whether or not you want to import inventory into QuickBooks Online. If you say yes to this, your inventory will be recalculated in QuickBooks Online using the first in first out FIFO inventory method from the start date provided.

Identify whether or not to import inventory to QuickBooks Online. For that reason, we recommend consulting a tax professional before bringing over your inventory to QuickBooks Online. Since you already set up a QuickBooks Online account, select Yes, sign me in :. After selecting Yes, sign me in , a log-in screen for your QuickBooks Online account will appear on your QuickBooks Desktop account, as shown below:.

When signing into your QuickBooks Online account through QuickBooks Desktop, there will be a prompt to verify your identity. Check your phone or email and then enter the code to proceed:. Identity verification in QuickBooks Desktop. After successfully logging in to your QuickBooks Account, select the QuickBooks Online company that you want the data to import to from the drop-down list. If you have multiple companies, be careful to select the correct one, as the conversion will replace any existing data.

After you select your company, QuickBooks will work for a few minutes and then give you a confirmation screen similar to this:. QuickBooks data file transfer confirmation. QuickBooks emails you when your QuickBooks Online company is ready, but this could take several hours for a large file. Once you receive an email similar to the one below, click on the Complete your setup button to log in to QuickBooks Online and review your data:.

Tip: Exporting lists from Desktop and importing them into Online is only necessary if you were unable to convert your Desktop file using the seven steps above. For instance, this may happen if you have over , targets or your desktop file is corrupt. An alternative to converting your Desktop file to an Online company is to export important lists from your QuickBooks Desktop company and import them into your QuickBooks Online company.

This will transfer your chart of accounts, customers, vendors, products, and services. First, export the lists from Desktop as an Excel spreadsheet. Second, import the Excel spreadsheet into your QuickBooks Online company. By exporting the following lists from QuickBooks Desktop to Excel, you can save hours of data entry in your new QuickBooks Online company:.

Tip: When importing Excel workbooks, QuickBooks Online only imports the first worksheet within a workbook. After exporting Excel workbooks from QuickBooks Desktop, be sure your data is in the first worksheet, or tab, at the bottom of the Excel screen. First Excel worksheet will import into QuickBooks Online. Navigate to your chart of accounts by clicking on Company from the top menu bar and then selecting Chart of Accounts:.

Display a list of your accounts by clicking on Reports at the bottom of the screen and selecting Account Listing :. Export the Account Listing report as an Excel spreadsheet by selecting Excel , then Create New Worksheet , and following the prompts to save the worksheet to your computer:.

Make a note of where you saved the spreadsheet so you can import it into QuickBooks Online later. Navigate to the Customer Center by selecting Customers from the top menu bar and then clicking on Customer Center :.

Follow the prompts to save the new worksheet on your computer so you can import it into your QuickBooks Online company later. Navigate to the Vendor Center by clicking on Vendors in the top menu bar and selecting Vendor Center :. Follow the on-screen prompts to save the worksheet so you can import it into QuickBooks Online Later. Go to the Item List screen by selecting Customers from the top menu bar and then clicking on Item List :.

QuickBooks Online will only import the item types Inventory Part, Non-inventory Part, and Service because other item types are part of workflows that differ slightly between Desktop and Online. Open the Excel workbook you created in the prior step and delete all line entries for items other than the three that will be imported into QuickBooks Online.

Tip: Sort your Excel worksheet by the Type column to group your items by type and make deleting lines faster. The three lessons below will teach you how to import the worksheets you created above as well as how to input items manually into your QuickBooks Online company:. Fit Small Business has also created a free QuickBooks Online course that includes 46 video tutorials and written step-by-step instructions. Be sure to check out a few of our video tutorials to learn the basics of using QuickBooks Online.

Find Timothy On LinkedIn. It even gives you around the clock access: With QuickBooks Online, you can work from anywhere, plus, you or your accounting firms can access secure data at a time and place of convenience.

Secondly, it leaves you with Reduced manual data entry , as it automatically categorizes bank and credit card transactions, reducing clerical errors while boosting productivity. This brings us to import data from QuickBooks Desktop to online. Here are some key differences:. Add-ons : One of the differences is that there are s of cloud-based applications available and more being developed all the time for QuickBooks Online.

Security: With QuickBooks Online, your data will be hosted on high-grade servers in protected environments instead of on your local network or drives.

More users: QuickBooks Online allows you to sign up as many as five users, whereas QuickBooks Desktop allows only one user. Easy Access: With a QuickBooks Online account, you have your data at your fingertips wherever you go, eliminating the need for you to cut-short your holiday or rush to the office computer when need be.

It also works with any PC, Mac, smartphone, or tablet. The list goes on, but by now you get the picture when it comes to the importance of QuickBooks data migration. Most of the time, the conversion process is quick and easy. Finally, you will receive a confirmation email notifying you that the data was converted. You also need to reconcile all bank accounts, process payroll, and adjust inventory before getting started.

Go through the list of options to select the appropriate plan, and review the system requirements before you start.

Do this to make sure you have what you need for the best QuickBooks Online experience. Before the QuickBooks migration process begins, make sure your QuickBooks is up-to-date. Then follow these steps:. If it exceeds, send your file to the QuickBooks Data Migration team so they can help convert your file. Then, click the box indicating that you want to bring in your data from QuickBooks Desktop.

Click on the gear icon and select Sign Out. After selecting the data that needs to be migrated from QuickBooks Desktop to an online program will verify whether the company is ready for the export.

It will then ask you to sign in using your QuickBooks Online email and password so keep it handy. QuickBooks Desktop decides the cost of inventory using the average cost method. Whereas QuickBooks Online uses the first-in, first-out FIFO inventory method, this may have a significant impact on the book value of your inventory. You can import your inventory later via an Excel spreadsheet. Select the QuickBooks Online company that you want, from the drop-down list.

 


Move your QuickBooks Desktop file to QuickBooks Online



  QuickBooks provides a list of Desktop features and a description of how those features will transfer to QuickBooks Online. You can save them in Desktop for later access and continue reconciling in QBO from where they were left off. You quickbooks desktop transfer to online import your inventory later via an Excel spreadsheet. Importing inventory? Also, if you are using the Advanced Features of Enterprise, more of your data onlins fail to convert.    


Comments