Importing Accounts
Importing accounts is a quick and simple process. These instructions are for importing accounts from OFX, QFX, and QIF files.
Import Accounts:
- Importing accounts can be done by either creating a new SEE Finance file and selecting "Get Started by Importing Account(s) from File" OR by opening an existing file and from the Menu Bar selecting "Accounts" and then select "Import Accounts...".
- You will then be shown a file browser window. Select the appropriate option from the drop down list for "File Was Created By:". Navigate to the OFX, QFX, QIF, or QMTF file you would like to import in the file browser and then click "Open". Wait for a moment while SEE Finance gathers the information from the selected file(s).
- Depending on the file type you chose you will prompted with a particular import window:
QIF & QMTF file Importing:
For QIF & QMTF files you will first be prompted with an import categories window if a category list is present in the file and then prompted with an import accounts window.
If you are prompted with the import categories window, verify the categories you want to import and select or deselect the import checkboxes as desired. Select the import type, either "Import & Delete Existing" or "Import & Merge With Existing". Click "Import" and the categories selected will be imported.
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 accounts. In the top table check the "Import" check box of the account(s) you wish to import. Also in the top table you need to set the name, account type, and currency of the accounts to be imported by clicking on the table rows. 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).
OFX & QFX file Importing:
Next the OFX/QFX import window will raise and show the transactions imported from the file. Check to verify whether or not you want to import these accounts. In the top table check the "Import" check box of the account(s) you wish to import. Also in the top table you need to set the name, account type, and currency of the accounts to be imported by clicking on the table rows. You can also check individual transactions to be imported or not using the "Import" column in the "Transactions in Selected Account:" table. Check the "Run Imported Transactions through Filters" checkbox if you want to use your activated transaction filters. If you would like to have these transactions set as reconciled (cleared), check the "Mark All Imported Transactions as Reconciled".
Notes:
- Make sure to check the checkbox(es) in the "Import" column to import the accounts found in the file.
- For QIF & QMTF files, make sure you have chosen the proper date format from the date format pop up button when importing the QIF or QMTF 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/99", "12 31 99", "12-31-99", "12.31.99", "12/31'99", etc.
- For QIF & QMTF files, 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.
- For QIF & QMTF files, 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 or 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.
- For OFX & QFX files, investment accounts created may setup "Position Adjustment" transactions in order to take the place of the transactions not available for download, but the list of positions indicates should be there. These "Position Adjustment" transactions may need additional information and/or adjustment.
- Make sure you have selected the "Mark All Imported Transactions as Reconciled" checkbox if you want the transactions for the imported accounts to be marked as reconciled. Otherwise you will have to mark each one as reconciled manually.
- Note: You can import multiple QIF files or multiple OFX/QFX files at the same time
- Select the "Import" button and you're done!
Notes:
- You may need to adjust your account balance using a balance adjustment transaction.
- Investment accounts created by import may setup or require you enter "Position Adjustment" transactions in order to take the place of the transactions not available in the imported information, but the list of positions in the imported information indicates should be there. These "Position Adjustment" transactions may need additional information and/or adjustment such as setting the "Price" for the transaction to be the cost basis per share of the shares held in the account prior to date of available transactions for download.
- When exporting a QIF or QMTF file from a previously used program, make sure to select to export all available information otherwise the missing information from the imported file could result in inaccurate account information. If you are exporting investment accounts, make sure to export the security list, security price list, and the entire investment transaction history into the QIF the file otherwise the imported information will not be correct. Also, due to SEE Finance's specific handling of bonds, make sure any bond funds listed in the previously used program were not listed with the "Bond" security type. Bond funds should be listed with the "Bond Fund" security type or another security type since these securities are not actual bonds.
See also
SEE Finance Accounts
Importing from Quicken®
Importing from MS® Money
Importing Accounts from MS® Money
Importing from Other Software
Which File Type to Import?
Web Connect Downloads
Importing QIF & QMTF Files
Importing OFX & QFX Files
Importing Category Lists
Auto-Categorizing Transactions
List of Importing & Exporting Topics
List of Account Topics