This Assistant helps you import Quicken QIF files. It will appear if you choose in the Welcome to GnuCash! menu.
To start this assistant manually go to → → .
In the following all the screens that you can see in this assistant are described in order of appearance.
The Import QIF files assistant opens with a screen that briefly describes what this assistant does and requests the file(s) to import. The three buttons at the very bottom of the screen will not change while using the assistant.
exit the process and cancel importing QIF files.
Warning If you click this button, any selections you have made up to this point will be lost.
brings up the previous screen so that you can change a previous selection until the first screen.
brings up the next screen so you can continue through the assistant.
The next screen allows you to Select a QIF file to load. The button on this screen is used to access the list of files. The button brings up the Select QIF File dialog.
Navigate to where you have stored your QIF files and select the first one then click . The next screen will display it in the Select a QIF File to Load field.
Note If the file you are loading does not have an QIF date listed in it you will see the Set a date format for this QIF file screen. Select the proper format from the pull down list and continue.
Note If the file you are loading does not have an account name listed in it you will see the Set the default QIF account name screen. Otherwise you will skip this screen and go on to the screen in the next section that shows loaded QIF files.
The Account name: field is used to set an account name for this QIF file.
The next screen shows you the QIF files you have loaded. You can use this screen to return to the previous screen and load more QIF files. It will also let you unload any files you have loaded by mistake.
The top panel shows the list of QIF Files you have loaded.
The button takes you back to the previous screen to load another QIF file.
The button allows you to select a file from the top panel and remove it from the list.
When you have selected all the QIF files to be imported, click the button.
Depending on the type of data contained in the QIF files to be imported, you may see only one or all of the following screens:
- Accounts and stock holdings
This screen gives a description of the Accounts and stock holdings matching process on the following Match QIF accounts with GnuCash accounts screen.
Tip This and other informational screens in the Import QIF files assistant can be turned off in the Online Banking tab (see Section 10.2.7, “Online Banking”) under GnuCash Preferences.
The next screen lets you Match QIF accounts with GnuCash accounts. You will see a list of QIF account names on the left and suggested GnuCash account names on the right. The New? column indicates if the
GnuCashaccount name will be created by the QIF Import.To change the
GnuCashaccount to a different one select the QIF account. A screen will pop up to select another account or create a new one.Select an account from the list to choose a already existing account.
The button allows you to add a new account name as a sub-account (child of selected) of the selected account.
The button is used to confirm your selection.
The button is used to exit the dialog without using any changes you have made.
- Income and Expense categories
This screen gives a description of the Income and Expense categories matching process on the following Match QIF categories with GnuCash accounts screen.
Tip This and other informational screens in the Import QIF files assistant can be turned off in the Online Banking tab (see Section 10.2.7, “Online Banking”) under GnuCash Preferences.
The next screen lets you Match QIF categories with GnuCash accounts. You will see a list of QIF category names on the left and suggested GnuCash account names on the right. The New? column indicates if the
GnuCashaccount name will be created by the QIF Import.To change the
GnuCashaccount to a different one select the QIF category. A dialog will pop up to select another account or create a new one.Select an account from the list to choose a already existing account.
The button allows you to add a new account name as a sub-account (child of selected) of the selected account.
The button is used to confirm your selection.
The button is used to exit the dialog without using any changes you have made.
- Payees and memos
This screen gives a description of the Payees and memos matching process on the following Match payees/memos to GnuCash accounts screen.
Tip This and other informational screens in the Import QIF files assistant can be turned off in the Online Banking tab (see Section 10.2.7, “Online Banking”) under GnuCash Preferences.
The next screen lets you Match payees/memos to GnuCash accounts. You will see a list of QIF payee/memo names on the left and suggested GnuCash account names on the right. The default
GnuCashaccount used is called Unspecified. The New? column indicates if theGnuCashaccount name will be created by the QIF Import.To change the
GnuCashaccount to a different one select the QIF payee/memo. A dialog will pop up to select another account or create a new one.Select an account from the list to choose a already existing account.
The button allows you to add a new account name as a sub-account of the selected account.
The button is used to confirm your selection.
The button is used to exit the dialog without using any changes you have made.
The next screen allows you to Enter the QIF file currency. The drop down list defaults to the currency configured in the Accounts tab (see Section 10.2.2, “Accounts”) under GnuCash Preferences. If you wish the new accounts to use a different currency, select one from the list.
When you have selected the currency, click the button.
Depending on the type of data contained in the QIF files to be imported, you may or may not see one or more of the following screens:
- Tradable Commodities
This screen gives a description of the Tradable Commodities process on the screen.
Tip This and other informational screens in the Import QIF files assistant can be turned off in the Online Banking tab (see Section 10.2.7, “Online Banking”) under GnuCash Preferences.
A series of screens, one for each of the stock, mutual fund, or commodity, displays the exchange, full name, and symbol for each of the commodities listed in the QIF file you are importing so that you can check them before proceeding.
- Match duplicate transactions
This screen gives a description of the Match duplicate transactions process on the following Select possible duplicates screen.
Tip This and other informational screens in the Import QIF files assistant can be turned off in the Online Banking tab (see Section 10.2.7, “Online Banking”) under GnuCash Preferences.
The next screen lets you Select possible duplicate transactions. Imported transactions are shown on the left panel and possible matches to each selected transaction are shown on the right.
The left panel shows the list of Imported transactions to select from for matching duplicates
The right panel shows the list of possible duplicates for the selected imported transaction. Select the one that most closely matches
The last screen, , gives you a list of three choices to finish the assistant.
exit the process and cancel importing QIF files.
Warning If you click this button, any selections you have made up to this point will be lost.
brings up the previous screen so that you can change a previous selection until the first screen.
imports the data and creates the accounts you have specified.
You should now have successfully imported your accounts.
| Tip |
|---|---|
Imported transactions might need to be reconciled.
This process is described in the | |