qfx2qif Convert | Help

Getting Started

QFX2QIF Convert is a single step financial data translator to convert QFX files (suitable for Quicken® software) into QIF files that can be read by other financial applications or earlier versions of Quicken. Use QFX2QIF Convert to translate transaction data downloaded from your bank or credit card company into standard QIF format so that you can import into any financial application that accepts QIF format. This included versions of Quicken that have had their online services expire and can not longer read QFX format. QFX2QIF Convert will process bank, credit card, and brokerage transactions.

To get started first download a QFX file from your bank or brokerage. Use the Setting menu to set the name of the Quicken account into which you want to input. Also verify your desired date format with the Settings menu.

Then use the File menu, Open QFX File to run the conversion and create your QIF file in a single step.

Installation

      • Microsoft Windows® full install
        • Download QFX2QIF.exe for Windows, save the file to your computer, and run the installation program by double clicking the file.
        • If you do not have have Java installed it will be automatically downloaded during the installation.
      • Mac OS X® full install
        • Download QFX2QIF.dmg for Mac OS X, save the file to your computer. Locate the file in the download area, open it by double clicking, then and run the installer.app by double clicking it.
        • If you do not have have Java installed it will be automatically downloaded during the installation.
      • Portable Installation
        • Download QFX2QIF.zip and save the file to your computer.
          • If running on Mac OS X the unzip will be done automatically as part of the download, and QFX2QIFportable.jar should be in your user download folder.
          • If running on other operation systems run zip or winzip on QFX2QIF.zip and extract QFX2QIFportable.jar to a suitable folder such as C:\Program Files\MoneyThumb.
        • Make sure you have Java installed on your computer. If you do not have Java already installed, download it for free at www.java.com.

Entering License Information

On Microsoft Windows, the easiest way to enter the license is to copy the license file QFX2QIF.lic from the product confirmation e-mail to the same folder where you installed QFX2QIF Convert – i.e. C:\Program Files\MoneyThumb\QFX2QIF.

Otherwise enter the license by copying the license string (CTRL-C) from the confirmation e-mail and pasting it (CTRL-V) into the license dialog. To enter the license string manually from within the program select Help, and Enter License, and paste (or type) the full license code into the dialog.

After you enter your license, your license email will be shown in the program title bar, and in Help, About.

Preparation

There are two things to do before actually running QFX2QIF Convert:

      1. Create a QFX file

This will almost always be downloaded from a bank or brokerage web site.

      1. Determine the name of the Quicken account into which you want to import transactions

If you downloaded a QFX file from a bank or other web site, then either:

        • Name the file to be the Quicken account name, with a QFX extension – for example MyBank Checking.qfx.
        • While running QFX2QIF Convert, select File, Set Quicken Name and specify the Quicken account name in the dialog.

Running QFX2QIF Convert

On Windows or Mac OS X, double click the QFX2QIF Convert icon on your desktop.

You may also run QFX2QIF Convert from the Windows Start Menu, or run QFX2QIF.exe on Windows or QFX2QIF Convert.app on Mac OS X.

If you are running the portable version, run QFX2QIFportable.jar by double clicking it, or starting it as a Java program.

Settings

Date Formats

QFX2QIF Convert can create dates in your QIF file in either in US format (month-day-year) or European format (day-month-year). Use the Settings menu to select the date format is expected in your financial application such as Quicken. Quicken always expects US format dates.

Converting the QFX File

Select the File menu, the Open menu entry, and this will bring up a file chooser dialog. Navigate to the folder containing the QFX file, select the file, and then select Open at the bottom of the dialog.

QFX2QIF Convert will run, generating a log and giving some statistics on how many lines were processed and create a QIF file with the same name. If a QIF file with that name already exists you will be prompted to overwrite it. The QIF file can now be read directly into Quicken or other personal financial software such as AceMoney, GnuCash, or Moneydance.

Automation

To run QFX2QIF Convert from the command line or a script simply invoke it on Windows as:

QFX2QIF inputfile.qxf

Or for the portable version

QFX2QIFportable.jar inputfile.qxf

There is no need to specify an output file name, QFX2QIF Convert will use the same name and an QIF extension. The log will be written to a file with the same name and a .log extension, or ERROR.log if the input file name is invalid.

Note that if the output file already exists, it will be overwritten. And if your input file name has any spaces in it, remember to use quotes – for example:

QFX2QIF “input file.qxf”

Importing QIF files into Quicken

To read the QIF file into Quicken, open Quicken, select File, then from the pull-down menu select File Import, and then QIF File… This will bring up a dialog window.


QIF Import

In the box for Location of QIF file, browse to get the name of the file generated by CSV2QIF Convert. In the line for Quicken Account to import into, select the pull-down and select <All Accounts>. Selecting an individual account will not work. Ignore the warning about not being able to import checking, savings, or credit cards etc. The QIF files created by CSV2QIF Convert contain the account name in a format that Quicken does read. Select the appropriate check boxes for the type of QIF file being read. To read transactions for a single account the only box selected should be Transactions.
After importing the QIF file, you will likely need to go to the account register and accept the downloaded transactions into the account.

Saving the QFX2QIF Convert Log

After QFX2QIF Convert has run, you may wish to save the log information to a file. Select the File menu, and the Save Log menu entry. This will bring up a File Save dialog. Simply specify a file name and select Save.