- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
I've got steps to ensure you're able to convert your QuickBooks Online data to Quicken,@cicenhour.
First off, we're unable to directly convert QuickBooks Online (QBO) data to Quicken. As a workaround, we can download a QuickBooks Desktop (QBDT) trial version where we can export the data from QBO. Then, we can use QBDT to export your lists or transactions to Excel where you're able to manipulate it. Finally, we can now import it to Quicken.
You'll want to refer to this article for the links to download the QBDT trial versions: QBDT trial versions. Before you start, ensure that your computer meets the minimum requirements to install QuickBooks: What are the system requirements for QuickBooks Desktop?.
Let's begin by converting your QBO data to QBDT. Before you convert, here are a few things to remember:
- If you use Multi-currency in QuickBooks Online, you shouldn't convert to QuickBooks Desktop. Your data will not export correctly.
- You need a recent version of QuickBooks Desktop installed before you start. You can download a trial to use as an alternative.
- These steps explain how to convert to QuickBooks Desktop for Windows. You can also convert to QuickBooks Desktop for Mac.
- You need Internet Explorer 11 installed to complete these steps.
You may want to refer to this article for the data lists that can be converted from QBO to QBDT: Data lists that can be converted from QBO to QBDT.
Once everything's set, we can now proceed with converting your data form QBO to QBDT. We will need to set up Internet Explorer for the smooth export process. Here's how:
- Right-click the Internet Explorer icon and choose Run as administrator.
- Select the Tools ⚙ icon, then Internet Options.
- Pick Security, then Trusted sites.
- Click Sites then in the Add this website to the zone field, enter *.intuit.com, and *.qbo.intuit.com.
- Ensure Require server verification (https: ) for all sites in this zone is unchecked.
- Close the Trusted Sites window then make sure Enable Protected Mode is unchecked.
- Hit Apply, then Okay.
- Leave Internet Explorer open.
Then, you can follow the steps outlined in this article to continue the export process: How to export from QBO to QBDT?.
Once you're done, we can begin exporting the files to Excel. We can start with exporting your Chart of Accounts and Vendor lists. Below are the steps how:
- Go to the Vendors menu, then choose the Vendor Center.
- From the Excel drop-down, tap Export Vendor List.
- On the Export window, select Create a new worksheet: in a new workbook, then click Export.
- Save the Excel sheet.
After that, you can now import these data lists to Quicken. Here's how:
- From the File menu, choose Import.
- Pick Addresses, then click Tab.
- If the file name did not automatically populate, select Browse then locate your file. Choose Next.
- Hit Quicken Field, then Add.
- Repeat step 4 until you have selected all the fields you want to import, then select Done.
Please refer to this article for the detailed steps on how to import these data lists to Quicken: How do I import data from Excel to Quicken?.
For your future reference, you may want to convert your Quicken data to QuickBooks Desktop. Refer to this article for the details on how to achieve this: How to convert Quicken data to QBDT?.
Leave a comment below if you still need more help with converting your data in QuickBooks. I'd be happy to assist you further. Take care,@cicenhour.