HomeControlBanking/CC
                    TransactionsInvestment
                    TransactionsCSVMenusPreferences

QIF Wizard allows you to set a number of preferences. You can edit the preferences anytime you are not processing a file or clipboard. Select the Preferences... menu item under the QIF Wizard menu. You will get the dialog shown at the right.

The preferences are divided into eight categories:

Control Preferences

You can optionally specify that QIF Wizard automatically check for program updates upon startup. If an update is available, you will be given the option to download it.

By default, each QIF transaction is stored in their own output file. You import the file into your financial software specifying the account for which the transactions are intended. If you would prefer to append output transactions to the same file you used the previous time you produced output, then check the Give me the option to append output to the same file used last time. This will allow you to specify in the Control dialog that you want to append to the previous file used. It will also require that you specify the account associated with each file or clipboard processed. This also requires that you export your accounts from your financial software into a QIF file and then take the resulting file and dropping it on the QIF Wizard icon or opening it from within QIF Wizard.

If you check this preference, you will be given the option to check the Let me choose from all bank/credit card account names preference. Some credit card companies produce QIF with a type of "Bank" instead of "Credit Card". In this case, if you are trying to specify your credit card account, it will not normally be available because it does not match the type of the QIF file. If you have such a credit card company, or suspect this applies to you, turn on this preference. With this preference specified, all accounts can be chosen for all QIF file types, and the type of the resulting QIF file will match that of the account selected.

You can also specify the behavior when you Cancel out of processing transactions.

Marking Transactions As Cleared

By default, the cleared status of transactions is unchanged when processed by QIF Wizard. You can select the preferences in this group to specify that each type of transaction should be marked as cleared, marked as uncleared, or left unchanged in the QIF that is produced. You can also specify how transactions not identified by their website as either banking or credit card should be marked.


Preferences That Apply Only To QIF/QFX/OFX Input

Normally, the Control dialog is displayed for each QIF/QFX/OFX file processed. If you check Process transactions with as little human input as possible, the Control dialog will not be displayed unless you need to specify an account name. Note that this means that your previous selection for which transactions to be processed (All, Last Month's, or a specific date range) will be used.

If you check Allow me to confirm all transactions, you will be shown a confirmation dialog for each bank or credit card transaction processed. This preference is not available for transactions extracted using an input format because it is possible that the extract process could produce erroneous output, so you are forced to confirm all extracted transactions.

If you check Interpret dates with day before month (e.g., dd-mm-yy), the input dates will be converted to the mm-dd-yy order.  This preference also appears in the Non-US preferences, along with other preferences related to non-US date and amount formats.

The My QFX/OFX has positive amounts for debits option should be checked ONLY if you experience positive amounts for debits in QFX or OFX input.  This option is intended to work around a bug with a particular bank that produces OFX that does not follow the OFX specification in this regard.


Preferences That Apply Only To Banking or Credit Card Transactions

Some banks produce QIF/ QFX/ OFX with blank descriptions and instead put transaction identification information in the memo field. In this case, check If description is blank, treat memo as description, which will replace the contents of blank descriptions with the memo field.  If you want blanks description left blank (even after they have been swapped with a blank memo) check Leave blank descriptions blank.

If your financial institution puts description information in either the description or memo you can use the popup menu with options as shown at the right to specify how "description" matching should be performed when applying instructions to transactions.

By default, instructions match the description in transactions with a string that must start the description. This works well is most cases, but not for descriptions that start with reference numbers. The Match description with CONTAINS instead of STARTS WITH preference causes the instructions to match descriptions as long as the string in the instruction is contained anywhere in the description. If you have already saved instructions that match the start of descriptions, they will continue to work if you turn on this preference.

By default, instructions match descriptions with the shortest match found, Thus, if your description is "Withdrawal Franchise Tax" it will match the description for "Withdrawal", even if an Instruction for "Withdrawal Franchise Tax" exists. You can change this behavior with Match description with longest match.

In the default mode, as shown here, categories are placed into output QIF transactions using instructions that base the category on the description of the transaction. In this default mode, any categories that appear in the input QIF are completely replaced by the instructions. If you have selected this option, you can optionally specify that categories in confirm dialogs are automatically updated (per instructions) as you change the description.

Some credit card companies produce QIF that contains categories. But these categories may not be the same as the ones you use. If you find it more convenient to base your output categories on these categories rather than the description, then select the "based on the category in the QIF if present, else on the description" preference. Of course, if a category is not present, the description will be used as in the default mode.

If you do want to use the categories present in the input QIF, then select the "Categories in the output QIF should be the category in the QIF if present, else based on the description" preference. If you specify this and you don't specify Allow me to confirm all transactions, and your input contains categories, then the input is processed automatically without any confirmations or use of any instructions. This mode is probably useful in several situations, but was designed to accommodate CSV data that contains categories, to make it faster to process CSV.

If you do want to add any categories to the input QIF at all, then select the "Categories in the output QIF should be the category in the QIF if present, else blank" preference.

Some banks and credit card companies produce descriptions and/or memos in all capital letters. If you don't like the looks of this, you can specify the Change descriptions and memos containing all capital letters to initial caps only preference. If you do this, only the first letter of each word will be capitalized. Thus, "CHECK PAID" would be changed to "Check Paid". Note however, that this will also change acronyms to initial caps. Thus, "CVS STORE #345" becomes "Cvs Store #345", not "CVS Store #345".

Some banks and credit card companies produce transactions with numbers (e.g. check numbers or credit card transaction numbers) too long for some financial software. In this case, your financial software may truncate or garble the numbers, possibly resulting in duplicate numbers. You have the option to have QIF Wizard remove numbers that are too long from output QIF by checking the Remove numbers longer than 5 characters from output QIF preference. If you choose this, the numbers will still appear in confirmation dialogs, but will be removed before QIF is output.


Preferences That Relate To Number Precisions

You can specify the precision for amounts, prices, and shares in investment transactions, as shown here.


Preferences That Apply To Extracting Transactions Via An Input Format

If you intend to import QIF into Quicken 2003 or later or some other financial software, then you may want to take advantage of some new transaction types that Quicken introduced in 2003 to allow banking transactions to appear in investment account registers. These new transaction types (Return of Capital, Sell Short, Cover Short, Margin Interest, ATM, Point of Sale, Deposit, Withdrawal, Check) are supported when extracting QIF from text only if you check Allow banking transactions within investment QIF.

By default, you will have to confirm all extracted transactions before their are placed in the output file. With some web sites, extracting can produce erroneous transactions that you will want to skip. For example, if the web site contains a phrase like "Transactions from 5/1/2003 to 5/31/2003" it is possible that QIF Wizard will think that one of those dates starts a transaction. Even if your web site does not normally produce bad transactions, it could in the future if its format changes and you have not redefined its format. Therefore, you are encouraged to confirm all transactions.

However, if you are extracting from highly formatted input that you trust, such as a comma-separated values file, you might want to turn off Allow me to confirm all extracted transactions so the transactions can be processed automatically.

By default, when the Control dialog guesses the format that applies to the input text, it chooses the format whose match string has the longest match in the input text. This scheme works well in many cases when extracting from web sites. If you find that this scheme does not work well for you, you can turn on the Match formats with FIRST MATCH instead of LONGEST MATCH preference. With this preference on, the format whose match string matches nearest the beginning of the input text is guessed.

Preferences That Apply To All Output

Sometimes transactions are produced with Description information in the Memo field, or split between Description and Memo fields.  The Output preferences--which apply to ALL output transactions, allow custom manipulation and formatting of output Description and/or Memo fields, as described in the Preference panel to the right.


Preferences That Apply To Using Non-US Date and Amount Formats


By default, QIF Wizard produces US format dates (e.g. mm/dd/yyyy) and amounts (e.g. 1,000.23). This is fine if you are using financial software that requires US formats. However, if you are using other programs (such as iCash) that can be localized for non-US usage, or just producing csv to be imported into a spreadsheet, you may want output with non-US dates (e.g. dd/mm/yyyy) and/or amounts (e.g. 1.000,23). Furthermore, if you may want to interact with QIF Wizard using non-US Dates. The first two preferences at the right deal with this situation.

The third preference replicates one that also appears in the QIF/QFX/OFX Input preferences (to group all non-US preferences together). This preference controls how dates in QIF/QFX/OFX are interpreted. This preferences is independent from the first because you may want to interpret non-US dates, but then produce QIF output in the US format.

The fourth preference allows you to produce QIF dates with dashes instead of slashes (e.g. mm-dd-yyyy).

When you define a format for extracting transactions you can specify there how dates are interpreted for that format.

When you define a non-QIF output format you can define how dates are output when using that format.

Note that there is no preference for interpreting non-US amounts because they are automatically detected in all types of input.