#GNUCASH IMPORT QFX INSTALL#
#GNUCASH IMPORT QFX TRIAL#

The number of Accounts added was 10 and 4 were updated. I see the following messages in the import window: I see the first 10 expected accounts in the preview, I click the 'apply' button in the import window Next, I do a File>Import>Import Accounts from CSV and select file 'flat account tree.CSV' Next, I do a File>New File and create a new Gnucash file with the one dummy Rent account Next, I do a File>Export>Export Account Tree to CSV and save to 'flat account tree.CSV' I perform an import of Vanguard QFX file, taking all default answers and assigning the top account tree level for each account.Īn illustration of the chart of accounts after the 'flat QFX import': I start with new Gnucash file with one rent expense account However, if I wipe my Gnucash file and then reimport this exported CSV file, I receive an error for each security and the above subaccounts are not imported, but the respective dividend, short term and long term income accounts are imported.Īs an exercise to assist in recreating this condition, I attempted an import using the same QFX file going into a completely flat Gnucash account tree (start with empty Gnucash file, with the one dummy account Expenses:Rent) and I received the same error messages.

#GNUCASH IMPORT QFX TRIAL#

If I export my account tree after a trial QFX import, I see my securities where I expect them to be, subaccounts under their respective brokerage accounts and stock accounts under the Investments:Stocks placeholder account. The Vanguard QFX file I used for my trials contains seven Vanguard accounts with a half dozen securities, some of which are held in multiple of the seven accounts.

#GNUCASH IMPORT QFX INSTALL#

I am working with a fresh install of Ubuntu desktop (minimal install) and a fresh install of Gnucash, both as of mid-August, 2021. I am working on my chart of accounts setup in an iterative manner: I make adjustments to my account tree CSV file, create a new Gnucash file with one dummy account (rent expense), import my adjusted account tree CSV into the new file, reimport my QFX file, evaluate the results, rinse and repeat. I am a corporate IT veteran from the financial industry with some QA experience and a Gnucash newbie.

Gnucash import qfx