Tip: Sort your Excel worksheet by the Type column to group your items by type and make deleting lines faster. How to Export Lists From QuickBooks Desktopīy exporting the following lists from QuickBooks Desktop to Excel, you can save hours of data entry in your new QuickBooks Online company: Second, import the Excel spreadsheet into your QuickBooks Online company. First, export the lists from Desktop as an Excel spreadsheet. Transferring lists from QuickBooks Desktop to QuickBooks Online is a two-step process. However, you can’t transfer past transactions in this manner, so you’ll need to input beginning balances. This will transfer your chart of accounts, customers, vendors, products, and services. If your conversion was successful, you’re done.Īn 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. For instance, this may happen if you have over 350,000 targets or your desktop file is corrupt. 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. Use the following seven steps to convert QuickBooks Desktop to QuickBooks Online: If you use QuickBooks Enterprise, Intuit also has conversion instructions for QuickBooks Enterprise. For QuickBooks Mac, you can follow Intuit’s conversion instructions for QuickBooks Mac. The steps discussed in this article are for converting a QuickBooks Desktop file to QuickBooks Online from QuickBooks Desktop Pro, Premier, and Accountant. QuickBooks provides a list of Desktop features and a description of how those features will transfer to QuickBooks Online. Most information from QuickBooks Desktop will transfer automatically to QuickBooks Online, although some features in Online are named differently and might not work exactly the same.

If you’re unsure about whether the switch to QuickBooks Online is right for your company, read our article that compares QuickBooks Online to Desktop to find out more. QuickBooks Desktop is usually faster for experienced bookkeepers, has more options available for dealing with inventory, and can report estimated versus actual job costs. Things To Consider Before You Convert QuickBooks Desktop to OnlineĪlthough we rated QuickBooks Online as the best small business accounting software, there are a few distinct advantages to QuickBooks Desktop over QuickBooks Online.

Quickbooks upgrade from 2014 to 2016