How To Convert QuickBooks Desktop to Online in 7 Steps.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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. He then taught tax and accounting to undergraduate and graduate students as an assistant professor at both the University of Nebraska-Omaha and Mississippi State University.

He most recently spent two years as the accountant at a commercial roofing company utilizing QuickBooks Desktop to compile financials, job cost, and run payroll. Find Mark On LinkedIn. Mark Calatrava is an accounting expert for Fit Small Business. He has covered more than 50 accounting software for small businesses and niche industries and has developed an in-depth knowledge of the important features of accounting software and how the importance of these features vary by business.

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Fit Small Business content and reviews are editorially independent. For purchase transactions, all components of the group items are converted.

Each item of the group will appear on a detailed line when you view the transaction. The zero amount lines are at the start and end of where the group item was so you can see which items were part of the group.

The top line shows the group name and the bottom line shows the group description. Group totals will show on the last line of the invoice in the description field. When you select the option to import inventory, it will ask you to choose a date, which we will use to recalculate your inventory based on FIFO calculations. Intuit will bring over your current item quantities, item accounts and details, and you will not need to do any work to your inventory after importing.

Subtotals do not compute, but are included in the description field for that line on the invoice. Progress Invoices invoices based on estimates and their extra fields are not converted.

These include estimate quantities, estimate rates, estimate amounts, prior quantities, prior average quantities, prior average rates, rate, prior amounts, prior percentages, current percentages and total percentages. In rare instances, transactions such as checks and invoices in your QuickBooks file are converted into general journal transactions.

This translation occurs only if QuickBooks Online cannot recreate the original transaction; for example, a check that uses an income account instead of a bank account as its source account.

QuickBooks Online allows you to memorize reports, but none of the reports you memorized in QuickBooks Desktop are converted. You need to recreate the reports in the Online version and memorize them again. However, there are certain ways to create transactions in Desktop that are not supported by Online.

Transactions with three different currency types do not convert to Online at this time. Bank and credit card accounts set up for Bank Feeds lose their connection once converted.

Bank rules are also not converted. However, you can use an app to continue paying bills online. QuickBooks Online requires each user who has access to a company file to provide a password when logging in. Usernames and passwords do not convert. You need to fill out an interview in QuickBooks Online to complete setup after importing before you can create your first pay check.

Payroll information is limited during the conversion process and payroll checks will come over as regular checks, so you will need to enter past payroll totals year-to-date payroll information for each employee.

Since Desktop has more payroll features, some of the information may be dropped, including pay types and employee personal information. Transactions and the payroll account are converted in order to balance your books, but details behind the transactions such as payroll item breakdown and employee year-to-date numbers do not convert. Purchase orders are only available in QuickBooks Online Plus.

Imported purchase orders that are closed will not be linked to their corresponding bills. You will have to create a new QuickBooks Merchant Service account and will have to close your Desktop one when ready. All the ways you can receive items in QuickBooks Desktop are converted as bills. See bills and bills payments above for details. Data will import if you have QuickBooks Plus and Essentials accounts support recurring transactions. Lower versions of QuickBooks Online does not support recurring transactions, so before importing delete all recurring transaction templates to avoid system errors.

However, in Online, you need to specify the markup percentage when creating the purchase instead of when you create the invoice. Reimbursable expenses and time that have not yet been billed in QuickBooks Desktop is converted as billable expenses in QuickBooks Online. QuickBooks Online has its own set of reports in the system. While some are similar, others are slightly modified. Although your accrual basis reports will match in both products, your cash basis reports may not. This is because cash basis calculations are somewhat subjective and there are several differences in how the two products calculate what is considered paid.

Report customizations are limited in QuickBooks Online, but it does allow for extensive filtering and supports exporting to Excel for further filtering, if necessary. If you’re an accountant, learn how to set up your clients for success with their move to QuickBooks Online. To watch more how-to videos, visit our video section. Note : You have 60 days from the time you create your QuickBooks Online account to move your data. Note: If the file exceeds the target limit , it can’t be converted to QuickBooks Online.

The only option is, you can only import lists and balances into QuickBooks Online or start fresh. Note: If you’re QuickBooks version is or older, use the QuickBooks Desktop file restoration tool to upgrade your file. You can then move your data to QuickBooks Online.

 
 

 

Migrating data from quickbooks desktop to online.Fix errors when you move from QuickBooks Desktop to QuickBooks Online

 

For more resources, check out our Getting Started guide. Need to make changes or updates to your accounts or subscriptions? Visit the Account Management Page. QuickBooksHelp Intuit.

Watch or follow the steps to get it done:. Was this helpful? Yes No. Underneath are the universal steps for the procedure.

Note that you will only be able to export the list substance and the present open balances with this technique. The dealings will not get exported mechanically. Similarly, if you are moving crop and services, you will first have to set up list tracking before import.

While users who lately switch from QuickBooks Desktop to QuickBooks Online might still be talented to re-open the import files and add the absent transactions physically, others may have to use third-party tools in the QuickBooks Apps to convert their information.

While QuickBooks Online superior users can generate online backups of their corporation records, and save their secretarial data to DropBox or Google Drive, and reinstate it in QuickBooks Desktop.

The Online endorsement and reinstate app is not accessible for other QuickBooks Online users , who will have to use go-between apps for backing up and restoring information. February 3, Posted by Jignasha. Convert QuickBooks online to desktop. What is QuickBooks? Compensation of QuickBooks Desktop over QuickBooks Online QuickBooks Desktop is an improved alternative for conglomerate and accounting services that need to uphold multiple company books.

Higher inventory management : While QuickBooks Online provides only the first in first out FIFO technique for list management, and that too only on select editions, there are two methods for track inventory with QuickBooks Desktop.

The adding standard cost technique is obtainable with the higher Inventory add-on module. Industry-specific customizations : QuickBooks Desktop include customizations for business in sure industries like developed and wholesale, constricting, retail, nonprofit, expert services, and general business.

Batch invoicing technique : It is likely to issue invoices in batch with QuickBooks Desktop which simplifies customer servicing when there are manifold businesses concerned.

Run multiple accounts : A solitary QuickBooks Desktop fitting ropes multiple company files. This is, though, not factual for QuickBooks Online which can grab only one corporation file per subscription.

He then taught tax and accounting to undergraduate and graduate students as an assistant professor at both the University of Nebraska-Omaha and Mississippi State University. He most recently spent two years as the accountant at a commercial roofing company utilizing QuickBooks Desktop to compile financials, job cost, and run payroll. Find Mark On LinkedIn. Mark Calatrava is an accounting expert for Fit Small Business. He has covered more than 50 accounting software for small businesses and niche industries and has developed an in-depth knowledge of the important features of accounting software and how the importance of these features vary by business.

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Fit Small Business content and reviews are editorially independent. We may make money when you click on links to our partners. Learn More. Published April 11, Table of Contents. Step 1. Step 2. Step 4. Step 6. Step 7. Copy Data File 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.

Display Account Listing. Export Account Listing. Navigate to the Customer Center. Export Customer List. Navigate to the Vendor Center. Export Vendor List. Navigate to Item List. Export All Items.

Or, try it free for 30 days – no CC required. Visit QuickBooks No, thanks. Was this article helpful? Yes No. Feedback Yes No. Human Resources. Real Estate Agents. Real Estate Investing. Starting a Business. Your Email Address.