Importing QIF & QMTF Files

How to Import QIF & QMTF Files:

1. To import QIF or QMTF files into your transaction register start by selecting an account from the Account List and select the "Transactions" view for that account. Then from the program's "File" menu select "Import" -> "Transactions...".
2. Now find the QIF or QMTF file you would like to import in the "Open" file browser. Select the appropriate option from the drop down list for "File Was Created By:". Then click "Open". Wait for a moment while SEE Finance gathers the information from the selected file.
3. Next the import window will raise and show the transactions imported from the file. Check to verify whether or not you want to import any of these transactions. In the top table check the "Import" check box of the account(s) you wish to import data from. You can also check individual transactions to be imported or not using the "Import" column in the "Transactions in Selected Account:" table. Select the date format that specifically matches the transactions found in the file (see note below). You can choose whether the values in the number column are check numbers or transaction numbers. Select the kind of category matching you prefer. Check the "Run Imported Transactions through Filters" checkbox of you want to use your activated transaction filters. If you would like to have all these transactions set as reconciled (cleared), check the "Mark All Imported Transactions as Reconciled" (otherwise it will use the reconciled setting found in the file).

   Notes:

   • Make sure to check the checkbox(es) in the "Import" column to import the transactions for the accounts found in the QIF/QMTF file that you are wanting to import transactions from.
   • Make sure you have chosen the proper date format from the date format pop up button when importing the QIF file. If you don't the transactions will not have the proper dates and may be given a strange date or might not be imported at all. Note that formats showing "-" for separators are for all similar formats using any kind of separator. For example, the date format "MM-DD-YY" would be appropriate for dates such as: "12/31/10", "12 31 10", "12-31-10", "12.31.10", "12/31'10", etc. However, using the "MM-DD-YY" date format for a transaction with a date such as "12/31/2010" would result with the transaction having the year of 2020 (use the "MM-DD-YYYY" date format instead).
   • Make sure to select the type of category matching you prefer to be done once you click "Import". Select "Don't Match Categories" if you don't want these transactions to have categories. Select "Use Exact Match for Categories" if you only want transactions to have a category if they match up exactly to one currently in SEE Finance. Select "Use Closest Match for Categories" if you would like SEE Finance to try to match the imported transactions with the closest matching category.
   • Make sure you have selected the "Mark All Imported Transactions as Reconciled" checkbox if you want these transactions to be marked as reconciled. Otherwise you will have to mark each one as reconciled manually.
   • You can toggle the on/off status of the checkboxes using the space bar.

4. Select the "Import" button and you're done! If any possible duplicates are identified while importing these transactions you will be presented with the duplicate transactions check window in order to check for duplicates.

Notes:

• If you import accounts with transactions referencing transfers to accounts through the use of categories and these other accounts are not included in the QIF/QMTF file or already in your SEE Finance file the transactions will be marked with categories such as "*The Missing Account Name". If you later import this missing account these transactions will automatically be adjusted to use the account's category keeping the original transfer information intact.