False 12 QIF Import Assistant True False start 12 12 GnuCash can import financial data from QIF (Quicken Interchange Format) files written by Quicken/QuickBooks, MS Money, Moneydance, and many other programs. The import process has several steps. Your GnuCash accounts will not be changed until you click "Apply" at the end of the process. Click "Next" to start loading your QIF data, or "Cancel" to abort the process. True intro Import QIF files True False True False 12 vertical True False Please select a file to load. When you click "Next", the file will be loaded and analyzed. You may need to answer some questions about the account(s) in the file. You will have the opportunity to load as many files as you wish, so don't worry if your data is in multiple files. True False False 5 0 True False True True True True False ● False False True True 0 _Select… True True True True False False 3 1 False False 1 Select a QIF file to load False True False 12 vertical 12 True False <span weight="bold" size="larger">Primary text</span> True True False False 0 True False Secondary text. True False False 1 True False vertical True False 0.10000000149 False False 0 True False <span style="italic">Sub-operation text</span> True True False False 1 True False end _Start True True True True False False 0 P_ause True True True True True False False 1 False False 2 False False 6 2 True True in True True 3 3 False word False False True True 3 Load QIF files False True False 12 vertical True False The QIF file format does not specify which order the day, month, and year components of a date are printed. In most cases, it is possible to automatically determine which format is in use in a particular file. However, in the file you have just imported there exist more than one possible format that fits the data. Please select a date format for the file. QIF files created by European software are likely to be in "d-m-y" or day-month-year format, where US QIF files are likely to be "m-d-y" or month-day-year. True False False 0 True False date_format_liststore 0 False False 1 True False Click "Back" to cancel the loading of this file and choose another. center True False False end 2 Set a date format for this QIF file False True False 12 vertical True False The QIF file that you just loaded appears to contain transactions for just one account, but the file does not specify a name for that account. Please enter a name for the account. If the file was exported from another accounting program, you should use the same account name that was used in that program. True False False 4 0 True False True False Account name center False False 4 0 True True ● False False True True 1 False False 1 True False Click "Back" to cancel the loading of this file and choose another. center False False end 2 Set the default QIF account name True False True False 12 vertical 4 True True in True True False True True 0 True False Click "Load another file" if you have more data to import at this time. Do this if you have saved your accounts to separate QIF files. Click "Next" to finish loading files and move to the next step of the QIF import process. True False False 3 1 True False spread _Unload selected file True True True True False False 0 _Load another file True True True True False False 1 False False 2 QIF files you have loaded True False True False 12 vertical True False On the next page, the accounts in your QIF files and any stocks or mutual funds you own will be matched with GnuCash accounts. If a GnuCash account already exists with the same name, or a similar name and compatible type, that account will be used as a match; otherwise, GnuCash will create a new account with the same name and type as the QIF account. If you do not like the suggested GnuCash account, double-click to change it. Note that GnuCash will be creating many accounts that did not exist on your other personal finance program, including a separate account for each stock you own, separate accounts for the brokerage commissions, special "Equity" accounts (subaccounts of Retained Earnings, by default) which are the source of your opening balances, etc. All of these accounts will appear on the next page so you can change them if you want to, but it is safe to leave them alone. True False False 0 Accounts and stock holdings False True False 12 vertical True False _Select the matchings you want to change True account_page_view False False 5 0 True True in True True True True 1 True False True False Matchings selected True False False 0 True False 0 True True True 3 1 Change GnuCash _Account… True False True True True False False 2 False False 2 Match QIF accounts with GnuCash accounts False True False 12 vertical True False GnuCash uses separate Income and Expense accounts rather than categories to classify your transactions. Each of the categories in your QIF file will be converted to a GnuCash account. On the next page, you will have an opportunity to look at the suggested matches between QIF categories and GnuCash accounts. You may change matches that you do not like by double-clicking on the line containing the category name. If you change your mind later, you can reorganize the account structure safely within GnuCash. True False False 0 Income and Expense categories False True False 12 vertical True False _Select the matchings you want to change True category_page_view False False 5 0 True True in True True True True 1 True False True False Matchings selected True False False 0 True False 0 True True True 3 1 Change GnuCash _Account… True False True True True False False 2 False False 2 Match QIF categories with GnuCash accounts False True False 12 vertical True False QIF files downloaded from banks and other financial institutions may not have information about Accounts and Categories which would allow them to be correctly assigned to GnuCash accounts. In the following page, you will see the text that appears in the Payee and Memo fields of transactions with no QIF Account or Category. By default these transactions are assigned to the 'Unspecified' account in GnuCash. If you select a different account, it will be remembered for future QIF files. True False False 0 Payees and memos False True False 12 vertical True False _Select the matchings you want to change True memo_page_view False False 5 0 True True in True True True True 1 True False True False Matchings selected True False False 0 True False 0 True True True 3 1 Change GnuCash _Account… True False True True True False False 2 False False 2 Match payees/memos to GnuCash accounts False True False 12 vertical True False The QIF importer cannot currently handle multi-currency QIF files. All the accounts you are importing must be denominated in the same currency. center True False False 0 True False _Select the currency to use for all imported transactions: True False False 5 1 True False False False 2 True False Book Options False False 3 True False Since you are creating a new file, you will next see a dialog for setting book options. These can affect how GnuCash imports transactions. If you come back to this page without cancelling and starting over, the dialog for setting book options will not be shown a second time when you go forward. You can access it directly from the menu via File->Properties. True False False 4 Choose the QIF file currency and select Book Options False True False 12 vertical True False vertical 6 True False 12 Below you are asked to provide information about stocks, mutual funds, and other investments that appear in the QIF file(s) you are importing. GnuCash needs some additional details about these investments that the QIF format does not provide. Each stock, mutual fund, or other investment must have a name and an abbreviation, such as a stock symbol. Because some unrelated investments have the same abbreviation, you also need to indicate what type of abbreviation you have entered. For example, you could select the exchange that assigned the symbol (NASDAQ, NYSE, etc.), or select an investment type. If you don't see your exchange listed, or none of the available choices are appropriate, you can enter a new one. True False True 0 True False start Enter Information about… False True 1 True True left True True True 2 True False start All fields must be complete to continue… False True 3 True True 0 Tradable commodities False True False 12 vertical 12 True False <span weight="bold" size="larger">Primary text</span> True True False False 0 True False Secondary text. True False False 1 True False vertical True False 0.10000000149 False False 0 True False <span style="italic">Sub-operation text</span> True True False False 1 True False end _Start Import True True True True False False 0 P_ause True True True True True False False 1 False False 2 False False 6 2 True True in True True 3 3 False word False False True True 3 QIF Import False True False 5 vertical True False If you are importing a QIF file from a bank or other financial institution, some of the transactions may already exist in your GnuCash accounts. To avoid duplication, GnuCash has tried to identify matches and needs your help to review them. On the next page you will be shown a list of imported transactions. As you select each one, a list of possible matches will be shown below it. If you find a correct match, click on it. Your selection will be confirmed by a check mark in the "Match?" column. Click "Next" to review the possible matches. True False False 0 Match existing transactions False True False 12 vertical True False vertical 6 True False 0 none True True in True True True False _Imported transactions needing review True new_transaction_view True True 0 True False 0 none True True in True True True False _Possible matches for the selected transaction True old_transaction_view True True 1 True True 0 Select possible duplicates False True False Click "Apply" to import data from the staging area and update your GnuCash accounts. The account and category matching information you have entered will be saved and used for defaults the next time you use the QIF import facility. Click "Back" to review your account and category matchings, to change currency and security settings for new accounts, or to add more files to the staging area. Click "Cancel" to abort the QIF import process. True confirm Update your GnuCash accounts False True False Summary Text True summary Qif Import Summary True False False