Image Image Image Image Image Image Image Image Image Image

SoftwareMedia Blog | September 19, 2014

Scroll to top

Top

No Comments

How To Export Quickbooks Data Into Quicken Format

How To Export Quickbooks Data Into Quicken Format

accounting softwareStill trying to figure out how to convert your Quickbooks data into Quicken format? Both Quickbooks and Quicken are two of the world’s most popular types of business accounting software. By default, though, each type of software exports data in their own unique format. If you happen to save your accounting data in the default Quickbooks format, you won’t be able to open it up in Quicken. Thankfully, there’s a simple technique that allows users to get around this problem.

Export Chart of Accounts and Vendor Lists

First and foremost, you’ll need to export your chart of accounts along with the vendor list from your Quickbooks account to your desktop. This is done by selecting “File,” “Utilities,” “Export” and “Lists To IIF Files.” Simply choose the chart of accounts you wish to export and save them to your desktop. During the save confirmation, make sure the file extension is set to IFF. This will allow you to reopen the files later using Microsoft Excel.

Exporting the vendor lists from Quickbooks requires a slightly different approach. While you are logged in as the administrator, open up the vendor center and click on “Excel” in the header. From there, click on “Export Vendor List” followed by the “Export” button. Name your file and click on “Save” to send the vendor lists to your computer. As with the previous step, check to make sure the vendor lists save as IFF format; otherwise, you won’t be able to convert into Quicken format.

Transferring Data To Quicken Format

Now that you have your chart of accounts and vendor lists, you can begin transferring the account into Quicken format. Located the previously saved files on your desktop or hard drive and open them using Microsoft Excel. If this is your first time attempting to open files using this method, let me explain how it’s done: locate the file and right click on the icon using your mouse. You should then see a list of options appear, one of which should say “Open With.” Hover over the option and left click on Micosoft Excel. This will tell your computer to open the file using Excel.

With the excel file containing your Quickbooks data open, select “File” and “Export.” You will then be asked to select a format. Now, here’s the most important part of this entire process – you must save your accounts in QIF format in order for Quicken to read them. If you are simply saving addresses to open, however, you can save the file as “Names.” For accounts and charts, always save the file in QIF format.

After saving the file as QIF, you should now be able to open it like you normally would in Quicken. Fire up your Quicken software and import the file into your account. As long as the file was saved in QIF format, it should appear in your account. Of course, you can perform the steps to convert Quicken data into Quickbooks format as well.

Breanna is a content contributor for MyVAO. Breanna enjoys writing about computer software for accounting and much more. She suggests going here to hire the best virtual accounting office on the internet.

Submit a Comment

You know what's super awesome?
  • Crazy awesome discounts on software (crazier than Steve Ballmer).
  • The latest updates in software and tech news.
  • Software tips, tricks, tutorials, reviews and everything in between.