Glade glade C True True False False False False GnomeDialog QIF Import Account Picker GTK_WINDOW_TOPLEVEL GTK_WIN_POS_NONE False 300 400 True True True False False GtkVBox GnomeDialog:vbox vbox1 False 8 1 True True GtkHButtonBox GnomeDialog:action_area hbuttonbox1 GTK_BUTTONBOX_SPREAD 8 85 27 7 0 0 False False GTK_PACK_END GtkButton button1 True True GNOME_STOCK_BUTTON_OK GtkButton button2 True True GNOME_STOCK_BUTTON_CANCEL GtkVBox vbox2 False 0 0 True True GtkFrame frame1 Select or add a GnuCash account 0 GTK_SHADOW_ETCHED_IN 0 True True GtkScrolledWindow scrolledwindow24 GTK_POLICY_AUTOMATIC GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS GtkCTree account_tree True 2 214,48 GTK_SELECTION_SINGLE True GTK_SHADOW_IN GtkLabel CTree:title label847711 Account GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CTree:title label847712 New? GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkButton button78 True clicked gnc_ui_qif_account_picker_new_cb QIF_Import_Account_Picker Sat, 10 Feb 2001 21:26:10 GMT New Account (child of selected) ... GTK_RELIEF_NORMAL 0 False False GtkWindow QIF Import Druid GTK_WINDOW_TOPLEVEL GTK_WIN_POS_NONE False False True True GnomeDruid qif_import_druid cancel gnc_ui_qif_import_cancel_cb QIF_Import_Druid Wed, 30 Aug 2000 15:11:02 GMT GnomeDruidPageStart start_page next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 17:04:30 GMT 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 "Finish" at the end of the process. Click "Next" to start loading your QIF data, or "Cancel" to abort the process. 255,255,255 0,0,0 153,191,153 255,255,255 255,255,255 GnomeDruidPageStandard load_file_page next gnc_ui_qif_import_load_file_next_cb QIF_Import_Druid Wed, 30 Aug 2000 14:30:37 GMT back gnc_ui_qif_import_load_file_back_cb QIF_Import_Druid Sat, 04 Jan 2003 05:05:30 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox8 25 False 0 0 True True GtkLabel label822 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. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 5 False False GtkHBox hbox69 False 0 0 False False GtkLabel label821 QIF Filename: GTK_JUSTIFY_CENTER False 1 0.5 0 0 4 False False GtkEntry qif_filename_entry True True True True True 0 0 True True GtkButton button71 True clicked gnc_ui_qif_import_select_file_cb QIF_Import_Druid Wed, 30 Aug 2000 17:33:50 GMT Select... GTK_RELIEF_NORMAL 3 False False GnomeDruidPageStandard date_format_page next gnc_ui_qif_import_date_format_next_cb QIF_Import_Druid Wed, 04 Oct 2000 15:56:16 GMT back gnc_ui_qif_import_default_acct_back_cb QIF_Import_Druid Wed, 04 Jul 2001 22:27:27 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox22 25 False 0 0 True True GtkLabel label841 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-year-day. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GtkCombo date_format_combo True False False True False 0 False False GtkEntry GtkCombo:entry date_format_entry True False True 0 GtkLabel label847713 Click "Back" to cancel the loading of this file and choose another. GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 0 False False GTK_PACK_END GnomeDruidPageStandard account_name_page next gnc_ui_qif_import_default_acct_next_cb QIF_Import_Druid Fri, 08 Sep 2000 14:03:17 GMT back gnc_ui_qif_import_default_acct_back_cb QIF_Import_Druid Mon, 18 Sep 2000 16:36:41 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox9 25 False 0 0 True True GtkLabel label823 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. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 4 False False GtkHBox hbox70 False 0 0 False False GtkLabel label824 Account name: GTK_JUSTIFY_CENTER False 1 0.5 0 0 4 False False GtkEntry qif_account_entry True True True 0 0 True True GtkLabel label847714 Click "Back" to cancel the loading of this file and choose another. GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 0 False False GTK_PACK_END GnomeDruidPageStandard loaded_files_page prepare gnc_ui_qif_import_loaded_files_prepare_cb QIF_Import_Druid Wed, 30 Aug 2000 22:42:22 GMT next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Fri, 09 Feb 2001 17:04:25 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:08:05 GMT 255,255,255 153,191,153 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox1 25 False 4 0 True True GtkFrame frame33 QIF Files 0 GTK_SHADOW_ETCHED_IN 0 True True GtkScrolledWindow scrolledwindow10 GTK_POLICY_ALWAYS GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS GtkCList selected_file_list True select_row gnc_ui_qif_import_select_loaded_file_cb QIF_Import_Druid Wed, 30 Aug 2000 23:00:57 GMT 1 80 GTK_SELECTION_SINGLE False GTK_SHADOW_IN GtkLabel CList:title label827 label827 GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel label816 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. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 3 False False GtkHBox hbox68 False 0 0 False False GtkButton button69 True clicked gnc_ui_qif_import_load_another_cb QIF_Import_Druid Wed, 30 Aug 2000 15:32:12 GMT Load another file GTK_RELIEF_NORMAL 0 True True GtkButton button70 True clicked gnc_ui_qif_import_unload_file_cb QIF_Import_Druid Wed, 30 Aug 2000 15:34:33 GMT Unload selected file GTK_RELIEF_NORMAL 0 True True GnomeDruidPageStandard account_doc_page next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 17:08:41 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:08:52 GMT 255,255,255 153,191,153 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox13 25 False 0 0 True True GtkLabel label830 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, 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. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GnomeDruidPageStandard account_match_page prepare gnc_ui_qif_import_accounts_prepare_cb QIF_Import_Druid Thu, 31 Aug 2000 14:19:54 GMT next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 17:09:25 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:09:37 GMT 255,255,255 153,191,153 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox3 25 False 0 0 True True GtkScrolledWindow scrolledwindow11 GTK_POLICY_NEVER GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS 0 True True GtkCList account_page_list True select_row gnc_ui_qif_import_account_line_select_cb QIF_Import_Druid Thu, 07 Sep 2000 22:35:06 GMT 3 281,242,53 GTK_SELECTION_SINGLE True GTK_SHADOW_IN GtkLabel CList:title label834 QIF account name GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label835 GnuCash account name GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label836 New? GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel label828 Click "Next" to check matchings for QIF categories. GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 3 False False GnomeDruidPageStandard category_doc_page next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 17:10:09 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:10:35 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox18 25 False 0 0 True True GtkLabel label840 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 clicking on the line containing the category name. If you change your mind later, you can reorganize the account structure safely within GnuCash. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GnomeDruidPageStandard category_match_page prepare gnc_ui_qif_import_categories_prepare_cb QIF_Import_Druid Thu, 31 Aug 2000 14:21:48 GMT next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Fri, 09 Feb 2001 17:04:56 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:12:18 GMT 255,255,255 154,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox4 25 False 0 0 True True GtkScrolledWindow scrolledwindow12 GTK_POLICY_AUTOMATIC GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS 0 True True GtkCList category_page_list True select_row gnc_ui_qif_import_category_line_select_cb QIF_Import_Druid Thu, 07 Sep 2000 22:35:38 GMT 3 243,250,72 GTK_SELECTION_SINGLE True GTK_SHADOW_IN GtkLabel CList:title label837 QIF category name GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label838 GnuCash account name GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label839 New? GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel label829 Click "Next" to enter information about the currency used in your QIF files. GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 3 False False GnomeDruidPageStandard memo_doc_page next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Fri, 09 Feb 2001 16:17:27 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Fri, 09 Feb 2001 16:17:45 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox39 25 False 0 0 True True GtkLabel label847707 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. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GnomeDruidPageStandard memo_match_page next gnc_ui_qif_import_memo_next_cb QIF_Import_Druid Fri, 09 Feb 2001 17:05:14 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Fri, 09 Feb 2001 16:18:32 GMT prepare gnc_ui_qif_import_memo_prepare_cb QIF_Import_Druid Fri, 09 Feb 2001 16:39:58 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox40 25 False 0 0 True True GtkScrolledWindow scrolledwindow25 GTK_POLICY_AUTOMATIC GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS 0 True True GtkCList memo_page_list True select_row gnc_ui_qif_import_memo_line_select_cb QIF_Import_Druid Fri, 09 Feb 2001 16:28:31 GMT 3 285,228,72 GTK_SELECTION_SINGLE True GTK_SHADOW_IN GtkLabel CList:title label847708 QIF payee/memo GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847709 GnuCash account name GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847710 New? GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GnomeDruidPageStandard currency_page next gnc_ui_qif_import_currency_next_cb QIF_Import_Druid Wed, 06 Sep 2000 15:12:05 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:12:42 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox16 25 False 0 0 True True GtkLabel label831 The QIF importer cannot currently handle multi-currency QIF files. All the accounts in the QIF file(s) you are importing must be denominated in the same currency. This limitation should be removed soon. Select the currency to use for transactions imported from your QIF files: GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GtkCombo currency_combo True False False True False 0 False False GtkEntry GtkCombo:entry currency_entry True True True 0 GtkLabel label832 Click "Next" to enter information about stocks and mutual funds in the imported data. GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 0 False False GTK_PACK_END GnomeDruidPageStandard commodity_doc_page prepare gnc_ui_qif_import_commodity_prepare_cb QIF_Import_Druid Wed, 06 Sep 2000 17:24:11 GMT next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 17:13:29 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:13:38 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox17 25 False 0 0 True True GtkLabel label833 In the next pages, you will be asked to provide information about stocks, mutual funds, and other tradable commodities that appear in the QIF file(s) you are importing. GnuCash requires more information about tradable commodities than the QIF format can represent. Each stock, mutual fund, or other commodity must have a type, which is the exchange or listing that it is found on (NASDAQ, NYSE, US Mutual Funds, etc), a full name, and an abbreviation. Check to see if there is an existing Type that is appropriate; if not, you can enter a new Type name by hand in the box. Make sure that the abbreviation you enter matches the ticker symbol used for the commodity on the exchange or listing for its type. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GnomeDruidPageStandard match_doc_page next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 20:54:18 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:14:04 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox34 5 False 0 0 True True GtkLabel label847694 If you are importing a QIF file downloaded from a bank or other financial institution, some of the information in the QIF file may duplicate information already in your GnuCash accounts. GnuCash will try to detect duplicates of existing transactions. On the next page, you will be asked to confirm that an existing transaction matches an imported transaction. Imported transactions are shown on the left side of the page, and possible matches for the selected left-hand transaction are shown to the right. There may be several old transactions that could match an imported transaction; you will be able to select the correct one by clicking in the "Dup?" column of the correct transaction. You can control the rules used by GnuCash to find duplicate transactions in the "QIF Import" section of the GnuCash Preferences dialog. Click "Next" to find duplicate transactions. GTK_JUSTIFY_LEFT False 0.5 0.5 0 0 0 False False GnomeDruidPageStandard match_duplicates_page next gnc_ui_qif_import_generic_next_cb QIF_Import_Druid Tue, 06 Feb 2001 17:15:14 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:15:23 GMT 255,255,255 153,191,154 255,255,255 GtkVBox GnomeDruidPageStandard:vbox druid-vbox35 5 False 0 0 True True GtkHBox hbox94 True 2 0 True True GtkFrame frame45 Imported transactions with duplicates 0 GTK_SHADOW_ETCHED_IN 0 True True GtkScrolledWindow scrolledwindow22 GTK_POLICY_AUTOMATIC GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS GtkCList new_transaction_list True select_row gnc_ui_qif_import_duplicate_new_select_cb QIF_Import_Druid Mon, 05 Feb 2001 18:28:49 GMT 3 53,172,56 GTK_SELECTION_SINGLE True GTK_SHADOW_IN GtkLabel CList:title label847700 Date GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847701 Description GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847702 Amount GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkFrame frame46 Possible duplicates for selected new transaction 0 GTK_SHADOW_ETCHED_IN 0 True True GtkScrolledWindow scrolledwindow23 GTK_POLICY_AUTOMATIC GTK_POLICY_AUTOMATIC GTK_UPDATE_CONTINUOUS GTK_UPDATE_CONTINUOUS GtkCList old_transaction_list True select_row gnc_ui_qif_import_duplicate_old_select_cb QIF_Import_Druid Mon, 05 Feb 2001 18:29:59 GMT 4 50,133,55,32 GTK_SELECTION_SINGLE True GTK_SHADOW_IN GtkLabel CList:title label847703 Date GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847704 Description GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847705 Amount GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GtkLabel CList:title label847706 Dup? GTK_JUSTIFY_CENTER False 0.5 0.5 0 0 GnomeDruidPageFinish end_page finish gnc_ui_qif_import_finish_cb QIF_Import_Druid Wed, 30 Aug 2000 15:07:20 GMT back gnc_ui_qif_import_generic_back_cb QIF_Import_Druid Tue, 06 Feb 2001 17:16:05 GMT Click "Finish" 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. 154,191,154 255,255,255 255,255,255 1,1,1 255,255,255