qif2qfx Convert | Help

Getting Started

QIF2QFX Convert is a single step financial data translator to convert QIF files into QFX format suitable for Quicken® software from QIF files. Use QIF2QFX Convert to import transaction data into Quicken Essentials for Mac or Quicken for Windows when you are only able to download QIF format from your bank or create it from another financial application.

To get started first export or download your QIF file from your bank, and set your Quicken account information with the Settings menu.

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

Read the QFX file from within Quicken using File, File Import, Web Connect File. Do NOT try to read as a Quicken Transfer File (.QXF) which is something else entirely.

Installation

  • Microsoft Windows® full install
    • Download QIF2QFX.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 QIF2QFX.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 QIF2QFX.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 QIF2QFXportable.jar should be in your user download folder.
      • If running on other operation systems run zip or winzip on QIF2QFX.zip and extract QIF2QFXportable.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 QIF2QFX.lic from the product confirmation e-mail to the same folder where you installed QIF2QFX Convert – i.e. C:\Program Files\MoneyThumb\QIF2QFX.

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 running QIF2QFX Convert:

  1. Create a QIF file. Most of the time this will be downloaded from a bank site, or perhaps created by another software application.
  1. Get the account number of the Quicken account into which you want to import transactions. If you are creating a new account, then any number will suffice. If you wish to import transactions into an existing account, then Quicken will match up the account numbers, and you will want to import into the correct account.

Running QIF2QFX Convert

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

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

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

Settings

Setting Quicken Account Info>

When the QFX file is created, first it needs to be of the correct type – Bank, Credit Card, or Investment. In addition there are four pieces of account information that may be inserted into the QFX file when it is created. The only one of these that is critical is the Quicken FID. This is a four or five digit number that Quicken uses to identify the financial institution. Quicken will validate the FID over the Internet when reading in the QFX file, and it must be correct and valid, or Quicken will abort the file import.

Set the Quicken account information with the Settings menu, and Set Quicken Account Info. This will bring up the dialog below. First, select the Account Type as Bank, Credit Card, or Investment in the drop down list.

Set Quicken Account Info

Select “Lookup…” in the dialog and it will bring up a window with all the Quicken Financial Institutions that are listed for that type of account. Type some or all of the name of your financial institution into the search box at the top to search within the list. Scroll down the list to find your bank and select it. The bank URL is also included to help resolve ambiguity if your bank has a name that is similar to other banks.

If your bank or brokerage is not listed, then Quicken will not import QFX files (Web Connect files) that are identified as being from that financial institution. The only workaround is to use an FID from some other bank. You can still name the account to include the name of your financial institution. So long as you as not also doing Quicken Direct Connect downloads into the same account, it will work just fine. There are some Financial Institutions that provide Direct Connect, but do not support Web Connect, and if you use one of these, you will have to create two accounts and move transactions from one to the other.

Just remember that the FID is critical, and although QIF2QFX Convert will run without one, it will give a warning, and Quicken will give an error when reading the QFX file.

QFX files are required to have account information. All files require an account number and bank accounts also require a bank routing number. If you don’t want to save your accounts numbers for security reasons, then you can skip entering this this information. If you do provide your account number to be inserted into the QFX file, then Quicken uses that number to automatically determine which account to import into. If you are always importing into the same account, then QIF2QFX Convert will save the information from session to session, so you do not have to re-enter it. For PayPal users, your account number is the email address you use to sign into PayPal. Note that QIF2QFX Convert does not access the Internet at all, so any information entered is only saved on your computer, and is not sent over other web or to any other computers.

To determine the account number to use in the QFX file, QIF2QFX Convert will look in the following locations, in order.

      1. Values from the Quicken Account Info dialog window (see above). Once again, if you are concerned about entering your account number, then don’t, and either manually edit the QFX file after it is created, or match up accounts when doing the Quicken import.
      2. The QIF file name, if it is a number without any letters.
      3. As a last resort, QIF2QFX Convert will use an arbitrary default number for the routing number and account number. You will then have to manually match accounts when reading the QFX file into Quicken.

The bank account routing number is required by QFX for bank accounts (but not for credit cards or investment accounts). However, it is not actually used by Quicken, so if you don’t specify one, QIF2QFX Convert will insert a default value and Quicken will accept it.

Lastly, the currency needs to be specified. US Dollars are the initial setting, use the drop down to select a different currency.

Date Formats

QIF2QFX Convert can read dates either in US format (month-day-year) or European format (day-month-year). Use the Settings menu to select the date format that is used in your QIF file. If your dates have the month name or abbreviation rather than a number, then this setting is not applicable. Note that there is no need to specify a date format for QFX files.

Converting the QIF File to QFX

Select File, Open QIF File and this will bring up a file chooser dialog. Navigate to the folder containing the QIF file, select the file, and then select Open at the bottom of the dialog. QIF2QFX Convert will run, giving some statistics on how many lines were processed and create a QFX file with the same name. If a QFX file with that name already exists you will be prompted to overwrite it.

All of the data in a QIF file will be converted directly into the QFX file. You can verify the transactions in the QIF2QFX Convert log.

Automation

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

QIF2QFX inputfile.qif

Or for the portable version

QIF2QFXportable.jar inputfile.qif

There is no need to specify an output file name, QIF2QFX will use the same name and an QFX 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:

QIF2QFX “input file.qif”

Importing QFX files into Quicken

The easiest way to import the QFX file is simply to double-click it from Windows Explorer or Max OS X Finder. You can also read the QFX file while running Quicken. Simply select File, then from the pull-down menu select File Import, and then Web Connect File… This will bring up the standard File Open dialog, select the file, and then select Open. The transactions should be read into Quicken.

Trouble Shooting


Cannot find your Financial Institution in the list of FID’s.

If your Financial Institution is not listed for the type of account your are imported (bank or credit card) then you will have to ‘fool’ Quicken by using the FID of some other Financial Institution. QuickBooks will NOT import transactions with FID’s from banks that are not QuickBooks affiliates. You can use pretty much any other FID you want, one would suggest a similar name to your Financial Institution and/or a large bank that is unlikely to drop QuickBooks support. See the following section for more details as well.

Quicken Error: “Quicken is currently unable to verify the financial institution for this download. Please try again later.

When you import the QFX file into Quicken, if you receive an error “Quicken is currently unable to verify the financial institution for this download. Please try again later.” then the FID is incorrect. Quicken is very picky about this. The financial institution must be currently in good standing with Quicken for Web Connect download, and the account must be of the correct type. Quicken distinguishes between financial institutions that support investment accounts versus those that support bank and credit card transactions.

QIF2QFX Convert will only display those FID’s that are listed as being able to import Web Connect files of the account type you selected. If you don’t see your bank or brokerage, Quicken will not accept Web Connect files from that financial institution. Quicken tends to have different names for banks and brokerages at the same financial institution and if your financial institution does not support web connect for the type of account you are trying to import, then even though you choose a bank with the same name as your brokerage, you will get the error listed above when trying to import into Quicken. Also, even though a bank may be listed, Quicken may still give this error. That problem seems mostly to occur with small banks, perhaps they did not stay current with Quicken.

If you are running into a brick wall with Quicken FID’s, one workaround is to use an FID for some other financial institution other than the one you actually use. However, if you already are downloading from your financial institution, then you would have to have two accounts and copy transactions from one to the other. Therefore, this is practical only if you don’t already download directly from that financial institutional, or you import transactions very infrequently.

If Quicken is refusing to link a QFX import to an existing account, then make sure that the account type was set correctly – see the section above on Setting Quicken Account Info. Quicken will only allow you to import credit card QFX files to credit cards accounts, bank account QFX files to bank accounts, and so forth. If the account number was not specified accurately in the Quicken Account Info, then Quicken will generally allow you to do a manual match, but it will also change the account number in Quicken.


No transactions visible in Quicken when you import the QFX 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.

Multiple Accounts in a singe file

Because a QFX file can only contain transactions from a single financial institution, QIF2QFX Convert will only process the first account found in a QIF file when creating a QFX file. However, QIF2QFX Convert will process a QIF file containing both a security list and an investment account, merging that into a single QFX file.

Saving the QIF2QFX Convert Log

After QIF2QFX 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.