qfx2qif Convert | Help

© Copyright 2019 MoneyThumb LLC

Contents

• QFX2QIF Convert
  • Getting Started
  • Installation
  • Entering License Information
  • Preparation
  • Running QFX2QIF Convert
    • Settings Dialog
      • Account Type
      • Quicken Account Name
      • Date Formats
    • Converting the QFX File
  • Importing QIF files into Quicken
  • Trouble Shooting
    • No transactions visible in Quicken when you import the QIF file
  • Saving the QFX2QIF Convert Log

QFX2QIF Convert

Getting Started

QFX2QIF Convert is a single step financial data translator to convert QFX files (suitable for Quicken® software) into QIF format 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 set your date formats with the Settings button. If you will be importing the .qif file into Quicken you should also set the Quicken account name in the Settings dialog.

If you have not already done so, download a .qfx file from your bank or brokerage.

Then either drag and drop your QFX file into the converter drop zone or select the Convert button to choose a file to convert. This will bring up a standard file chooser. Navigate to the folder containing your .qfx file, select the file, and then select the Convert to qfx button at the bottom of the file chooser. This will run the converter and create your .qif file in a single step. The .qif file will be created in the same folder as the .qfx file, and using the same file name but with a .qif extension.

See below for the correct procedure to read a QIF format file into Quicken.

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.

Entering License Information

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

On Microsoft Windows, you can 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 (x86)\MoneyThumb\qfx2qif Convert.

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. 1. 1. Create a QFX file

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

1. 1. 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:

1. 1. • • Name the file to be the Quicken account name, with a QFX extension - for example MyBank Checking.qfx.
        • While running QFX2QIF Convert, use Settings, Quicken Account 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.

Settings Dialog

Use the Settings button to bring up the Settings Wizard or the full Settings dialog. The Wizard will ask questions about the type of conversion. The Settings Dialog contains the same information in a single dialog. You can switch back and forth between the Wizard and the full dialog.

Account Type

Generally the account type will be taken from the input .qfx file, but it can overwritten. Use the Account Type pull-down menu to select the correct type for the .qif file - Bank, Credit Card, or Investment.

Quicken Account Name

If you are going to be importing into Quicken, you will need to set the Quicken account type and account name. Also see #2 above. For the Quicken Account Name enter the name of the account in Quicken that you want to import into. It must match exactly, although the matching is not case sensitive. If the account name is not set correctly in the .qif file, then Quicken will refuse to read the .qif file.

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

There are two ways to identify the QFX file to convert:

1. Select the file in your operating system file browser (Windows Explorer, Mac Finder), and then drag it into the converter "Drop Zone"

or

1. Select the Convert button in QFX2QIF Convert to bring up the file chooser and select the file to convert.

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.

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.

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 Format 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.

Trouble Shooting

No transactions visible in Quicken when you import the QIF file

The most common reason for this is that you need to accept the transactions into the Quicken account register. In Quicken, go to the account register, select the Downloaded Transactions tab at the bottom of the register, and accept the transactions. If there are transactions showing in the account list, but not at the bottom of the account register, you may need to modify your Quicken preferences. Under the preferences for Downloaded transactions uncheck the top checkbox on the right hand side for Automatically add to banking registers.

Saving the QFX2QIF Convert Log

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

To clear the log information select the Clear Log button.