Looking for:
Changing from quickbooks desktop to online
Convert from QuickBooks Desktop to Online (7 Easy Steps)
Mark has researched and reviewed accounting software at Fit Small Business since and has developed an extensive knowledge of accounting software features and how unique business needs determine the best accounting software. Changingg article is part of a larger series on Accounting Software.
Converting from QuickBooks Desktop to Online is quick and easy most of the time, and if you get stuck, you can contact QuickBooks support for free. Get QuickBooks Online. If 60 days have passed, changing from quickbooks desktop to online can cancel your current subscription and set up a new QuickBooks Online company.
Multiple companies can be set up under the same email address. Watch the tutorial video below or read the step-by-step instructions that follow. QuickBooks Desktop is usually faster for experienced bookkeepers, has more options available changing from quickbooks desktop to online dealing with inventory, and can report estimated versus actual job costs.
Most information from QuickBooks Desktop will transfer automatically to QuickBooks Online, although some features подробнее на этой странице Online are named differently and might not work exactly the same. QuickBooks provides a list of Desktop features and a ohline of how those features will transfer to QuickBooks Online.
Once your QuickBooks Desktop file and press F2 to determine the total target count. If your file exceeds the maximumtargets, you can try dedktop reduce the targets by condensing your QuickBooks file. Product information screen in QuickBooks Desktop. Make sure to reconcile all bank accounts, process payroll, and adjust inventory before getting started.
You can make a backup of the data file by going to Filethen Back Up Companyand then clicking on Create Local Backupas shown below:.
Creating a backup company file in QuickBooks Desktop. Tip: QuickBooks recommends your company file be located on a local drive before converting to QuickBooks Online. If you normally access the company file from a network drive, restore the backup file you just created onto your local drive and use that file for your Quickbooks desktop pay now button Online conversion. 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 chanying. You may need to close changing from quickbooks desktop to online 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 changing from quickbooks desktop to online 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 ina 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 changing from quickbooks desktop to online 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 fom.
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 vhanging. 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 Changnig Online and review your data:. Tip: Exporting lists from Changing from quickbooks desktop to online 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 overtargets 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, fdom, products, and download quickbooks desktop 2020 canada. 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, quikcbooks can save hours of data entry in your new QuickBooks Online company:. Tip: When importing Excel changing from quickbooks desktop to online, 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 Адрес worksheet will import into QuickBooks Online. Navigate to your chart chznging 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 Chagning :. Export the Account Listing report as an Excel spreadsheet by selecting Excelthen Create New Worksheetand 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, Changing from quickbooks desktop to online Part, and Service because changing from quickbooks desktop to online item types are part of workflows that differ slightly between Desktop and Online.
Open the Excel quickboois you created in the читать полностью 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. Changing from quickbooks desktop to online three lessons below will teach you how to import the worksheets you created above as well взято отсюда how to input items frm 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 Quicbooks On LinkedIn. Mark Calatrava is an accounting expert for Fit Small Business.
He has covered more than 50 посетить страницу software for small businesses and niche industries and has developed an in-depth knowledge of the important features of dsktop 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 changing from quickbooks desktop to online 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.
How To Convert QuickBooks Desktop to Online in 7 Steps
Choose a date. The tool will clear any unbilled costs before that date in one easy step. Now, the associated account in QBO can be made inactive. The reason checking reporting history is so important is that some clients may have been using the chart of accounts in interesting ways. For example, this may include inactive accounts or sub-accounts used in lieu of classes or vendor names as sub-accounts under Subcontractor Expense.
Doing a little homework here will be wise, but you should carefully consider if merging these accounts is an appropriate course. It could affect prior year financial reports if you do. Under this sub menu you will see:. Class reporting history: If the client has a long history of class tracking, you will want to look at the data to see if there are classes that may have been used differently or improperly in the past. You should verify how classes have been used over the history of the desktop file.
Inactive classes do not convert. If the client does not need the entire history from a desktop edition, you can condense the data prior to conversion. This will remove transactions prior to a designated date and post an opening balance entry at that same date.
When transactions are removed, the condense tool gives you the option to remove any unused list entries as well. This graphic shows which unused list entries you have the option to remove when condensing. Explain the conversion process and the effect on historical reporting, then suggest your solutions, if any. Once everyone decides to move forward, make a backup to keep the original detailed data intact before you start cleaning or condensing the file.
Start by setting up a new QuickBooks Online Advanced subscription for the converted data to upload to. You will be working from the QuickBooks Online Accountant dashboard. This is the Quick Create menu. Then, follow these steps. You will have days to import desktop data to this new QuickBooks Online Advanced subscription before it locks. First, make sure you are logged out of the QuickBooks Online Accountant file.
This will help when you are prompted to log into QuickBooks Online Accountant again. In QuickBooks Desktop, open the company and follow the steps below. These steps will verify the desktop database and prompt you to take additional action, if necessary. It will also rebuild the data as a cleanup step. Do not skip this process! You want to make sure well-structured data is moved over to QuickBooks Online Advanced.
NOTE : If the desktop software is more than two years old, you should download a free 30 day trial of the latest edition, install and open the company file in that latest desktop edition. You should already be in QuickBooks Desktop and have verified that the file is cleaned up and ready to move over to QuickBooks Online. You also have two complete backups filed away, one that you made before you started cleaning up the Desktop file and one that you made after the cleanup, but before conversion.
If your client is using Mac , click this link to review additional resources on converting from Mac. The conversion is now complete. As you can now see, most of the harder work was done prior to the conversion phase. Intuit has made the actual conversion part easy. The key is to be sure you do your homework before you convert; this will make it all go smoother overall.
You will now receive an email from Intuit letting you know the data has been converted and you can access an Import Summary report to get more insights on the conversion. Save it for your records. Just contact QBOA support for next steps.
You will need to have the QuickBooks desktop file open as well. Follow these steps below. You have successfully moved your client to QuickBooks Online Advanced. You can now collaborate and work with your client in real time. There are so many benefits to transitioning your clients to the cloud. Enjoy the new freedom that cloud accounting gives you and your clients! Some of these limitations include: Reconciliation history and reports. Recurring credit card charges. Memorized reports. Audit trail.
Once in QuickBooks Online, the average value will be divided by the quantity to determine the value of the first FIFO layer of that item. Some clients may need to continue the use of average costing.
Database analysis Older files with years of history need some consideration, especially if the client wants to convert ALL of the data. Create an Invoice for each Customer with unbilled costs. Click OK. To clean up classes: First check the Class list for inactive classes. Check the box at the bottom left to show any hidden classes that are no longer in use.
Then run a report to check the history of use for each class. Review the class columns on the report. See if there are any redundant or unnecessary classes. Decide how each should be addressed and use the following options to clean up the classes. Merge duplicates. Will reduce the number of classes that convert. Make unused classes inactive. Converting from QuickBooks Desktop to Online is quick and easy most of the time, and if you get stuck, you can contact QuickBooks support for free.
Get QuickBooks Online. If 60 days have passed, you can cancel your current subscription and set up a new QuickBooks Online company. Multiple companies can be set up under the same email address. Watch the tutorial video below or read the step-by-step instructions that follow. QuickBooks Desktop is usually faster for experienced bookkeepers, has more options available for dealing with inventory, and can report estimated versus actual job costs.
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.
QuickBooks provides a list of Desktop features and a description of how those features will transfer to QuickBooks Online. Once your QuickBooks Desktop file and press F2 to determine the total target count. If your file exceeds the maximum , targets, you can try to reduce the targets by condensing your QuickBooks file. Product information screen in QuickBooks Desktop. Make sure to reconcile all bank accounts, process payroll, and adjust inventory before getting started.
You can make a backup of the data file by going to File , then Back Up Company , and then clicking on Create Local Backup , as shown below:. Creating a backup company file in QuickBooks Desktop. Tip: QuickBooks recommends your company file be located on a local drive before converting to QuickBooks Online.
If you normally access the company file from a network drive, restore the backup file you just created onto your local drive and use that file for your QuickBooks Online conversion.
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.
No comments:
Post a Comment