Convert From QuickBooks to Quicken

You may want to convert your information from QuickBooks into Quicken, but Intuit does not have an automated method to convert QuickBooks data into Quicken data.

If you are comfortable with exporting information from QuickBooks and manipulating data in excel, you could export your lists and/or vendors from QuickBooks, copy/paste the data into the Quicken interface files and import the data into Quicken.

The following steps are a guideline to how the data can be exported from QuickBooks, manipulated in Excel and imported into Quicken.

Export your Chart of Accounts (COA) and Vendor List  to your desktop.

This is a sample of the data exported for the chart of accounts.

This is a sample of the data exported for the vendor list..

Note: In the QuickBooks export  file, Hidden = N is an active account, Hidden = Y is in inactive account.

Or you can export your vendor list to excel.

• Open the Vendor Center
• Click on Excel in the header
• Click on Export Vendor List
• In the Export window, click on the “EXPORT” button.
• In Excel, click on the save icon, name and save your file.

 This is a sample of the data exported for the vendor list using excel.

• Then you should copy/paste your QuickBooks information into the Quicken .QIF file.
• To open an .IIF file you will need to right-click on the file, left click on open with, click on choose program and select Microsoft Office Excel.
• Note:  The QIF import is not available for checking, savings, credit cards, 401(k) and other brokerage   accounts. This was replaced with a .QFX import file.
• To export your account list
  1. Click on File.
  2. Select Export.
  3. Select .QIF File  (for accounts).
  4. Select Address (for names).

This is a sample of the data exported for account list.

• a. Then you should copy/paste your QuickBooks information into the Quicken address file.
• To export your address
  1. Click on Tools
  2. Select Address Book
  3. Highlight at least one payee.
  4. click on File.
  5. Select Export.
  6. Select Addresses.
  7. click on Tab.
  8. enter file name.
  9. click the Next button.
  10. Select a quicken field.
  11. Click the ADD button.
  12. Repeat Steps x and xi until you have selected all fields you want to import.
  13. Click the Done button.

Note. You will need to enter at least one address before you can export.

This is a sample of the data exported for account list.

Then you will map the fields to be imported by matching Quicken fields to QuickBooks fields.

To import your addresses:

1. Click on File.
2. Select Import.
3. Select Addresses.
4. Click on Tab.
5. If the file name is not populated, click the BROWSE button to locate your file.
6. Click the NEXT button.
7. Select a Quicken Field
8. Click the ADD button
9. Repeat steps x. and xi. until you have selected all the fields you want to import.
10. Click the DONE button