Quiff Icon 

Quiff Overview


Overview

Quiff allows you to easily preview and convert transaction files for use in QuickBooks and other financial management programs. Typically, these files are downloaded from your bank over the internet, but your bank may not offer a format supported by your financial management program. Quiff may be able to convert it to a suitable format. Export formats are determined by the version of Quiff used:

  • QIF files can be imported in older versions of Quicken (and many other programs)
  • IIF files can be imported in Quickbooks (and many other programs)
  • QFX, QBO and OFX files are based on the Open Financial Exchange standard* and can be imported by newer versions of Quicken and Quickbooks. These files can also be used in MS Money (and many other programs) by simply changing the converted file’s extension to 'OFX'

    *OFX 1.0.2 (SGML), tested with Intuit's OFX Test Tool.


Usage

Use the Open File... button to select the file to be converted. You may also drag your data file on the Quiff window to import the data. Supported import formats are determined by the version of Quiff used.

Quiff Screenshot

After processing, you will immediately see a preview of the data, similar to how you might see it in your financial management program. The preview does not allow editing, changes should be performed in your financial program after it has been imported.

Quiff Editor Bar

The following changes may be made to the data to prepare it for conversion:

  • Name➔Memo Payee names can be moved to the Memo field to avoid creating new payees.
  • 0̶0̶123 Reference Numbers can be stripped of any leading zeros.
  • DD⇄MM Quiff automatically scans transactions to determine the best date format for your location. However if the imported data is ambiguous, Quiff will allow you to swap the dates and months.
  • Destination Account is added to the data, based on information you provide. See the Options section below for more details.
  • Categories are also known as Income/Expense accounts. These are added when required by Quiff. See the Categories section below for more details.
  • Character Encoding When importing QIF and IIF files, it is recommended that text such as account names, payees and memo fields use only ASCII (U.S.) characters, but some programs do accept extended characters. Quiff does not enforce this conversion if the text conforms to UTF-8 encoding, otherwise invalid characters will be replaced with a question mark (?).

You may delete a transaction (or range of transactions) by right-clicking on it as shown. Your source file is not changed. This option was introduced in Quiff 5.

Use the Save As… button to export the transactions. You will be prompted to select a location to save the converted file. If you have not provided all the required information for the chosen format, you will be presented with the Options window.

For instructions on how to import the converted transactions, see your financial program's documentation.

NOTE: Importing the same transactions more than once into your financial program, regardless of format, may result in duplicate transactions!


Options

The Options window lets you adjust important settings for your conversion.
You can select from the available export formats and add any required and/or optional information.

Options Dialog

Depending on the selected format, you may have to supply additional information, as discussed in the following sections.

Click Save to use your latest settings. For items such as accounts, Quiff will remember up to 10 previous entries.


Destination Account

The term Destination Account refers a checking, savings or credit card account in which a transaction occurred. This is set using the Options button.

  • QIF files allow, but do not require a Destination Account.

    Programs generally import QIF data into the currently active account window. Refer to your finance program's documentation for details.

  • IIF files require a Destination Account.

    Specify the account by name; for Quickbooks, you must include any parent account(s) using the colon (':') character, for example: Account:Subaccount

  • OFX, QBO and QFX files require a Destination Account and Currency Code

    For OFX, QBO and QFX the account is identified by a Bank (Routing) or Branch ID and an account number. For a U.S. bank, you would provide the bank's 9-digit routing number. Other countries may use the 'Branch ID' option.

    You must specify a three-letter currency code (such as USD, EUR, JPY) for the transactions. You can find more information on currency codes online, for example at Wikipedia.

    Some financial programs may require an ‘institutional’ ID number that has been issued to your bank: Quiff allows the inclusion of a FID identifier.

NOTE: When importing the file into your financial program, a new account may be created if the specified account does not exist. If this happens unintentionally, you may be able to move the transactions by renaming/merging the new account with an existing account. See your financial program’s documentation for help with merging accounts.


Categories

The term Category refers to the income/expense account assigned to a transaction.
The term Split refers to having more than one category assigned to a transaction.

  • QIF files support, but do not require categories.
  • IIF files require categories.
    Quiff assigns transactions to Uncategorized Expenses and Uncategorized Income by default. You may select Preserve Categories if your source has category data.
  • OFX, QBO and QFX files do not support categories or splits.

NOTE: After importing your converted transactions, new categories may be created if they do not already exist in your financial program. In all cases, you can assign your transactions to the appropriate income and expense categories as required.


Importing Delimited-Text Files

Some versions of Quiff allow delimited text files such as CSV to be imported.
As with other formats, US-ASCII or UTF-8 encoding is strongly recommended. Quiff will try to determine the delimiter used. If successful, you will be presented with the Column Order window to select and assign the columns you wish to convert.

CSV Dialog

This window is divided into two areas:

Spreadsheet
Displays the source data in the file. Check Ignore Header if your data contains a header row that should not be included.

Register
Displays the row selected in the Spreadsheet as it will appear once the data is imported. To assign the columns, simply click and drag your data from the Spreadsheet view to the appropriate field of the Register view. In the above example, amounts will be taken from the 'net' column.

TIP: To quickly and accurately assign columns, drag column names from a header row to the Register before checking Ignore Header .

The following fields must be assigned a source column for data:

  • Date Unrecognized or missing dates default to the current date.
    Dates in your delimited-text files must conform to accepted numerical formats. For dates that include the time, only YYYY-MM-DD HH:MM:SS formats are supported (formatting characters are optional, position and length are not). Exporting to QIF and IIF formats will not preserve time data.
  • Name Missing names are not assigned a default value.
  • Amount Unrecognized or missing amounts default to zero.
    For simplicity, the Register displays a single column for amounts. Negative amounts are understood to be debits: if you need to treat them as credits, right-click on the Register and select Credit⇄Debit from the contextual menu.

The remaining fields are optional.

If something is not right and you want to start over, right-click on the Register and select Reset.

If you are satisfied with how your data appears in the Register, click OK to complete the import.


Troubleshooting

All of Quiff's supported import formats follow defined standards. However, how closely the standards are followed can vary widely depending on the source of your original files. Where possible, Quiff makes allowances for common variations such as number and date formats, but may report an error if the format's underlying structure is invalid. If you encounter such an error in a document, try these steps to isolate the problem:

  • Test a file in the same format from a different source and compare results
  • Test a file with minimal transactions and compare results
    Sometimes a specific transaction is causing the error. Smaller files make it easier to pinpoint the issue.
  • Advanced: Open the source file in a text editor to spot any obvious inconsistencies Some error messages may specify the general nature of the error to assist troubleshooting.
  • Encoding Issues: Verify that your source file(s) use US-ASCII, UTF-7 or UTF-8 before using Quiff. Text editors and encoding converters can be found on the internet.

If you have exhausted these options, contact your file's source for support first. If you do find an issue determined to be related to Quiff, contact support to submit a problem file for examination.