![]() I think you want accounts for each security (ie Asset:Shares:REA).īroker_Securities_split.csv Date,Description,Note,Account,Deposit ![]() ![]() Date: d-m-y, Lines to Skip: 1, Fields: Date, Description, Notes, Account, Deposit.INCOME,Income:Dividend:Unfranked,Unfranked,AUD,CURRENCY,F,F,FĮXPENSE,Expense,Expense,AUD,CURRENCY,F,F,FĮXPENSE,Expense:Brokerage,Brokerage,AUD,CURRENCY,F,F,FĮXPENSE,Expense:Fee,Fee,AUD,CURRENCY,F,F,FĮXPENSE,Expense:Fee:Bank,Bank,AUD,CURRENCY,F,F,FĮQUITY,Equity,Equity,AUD,CURRENCY,F,F,FĮQUITY,Equity:Opening Balance,Opening Balance,AUD,CURRENCY,F,F,FīANK,Bank:MyBank,MyBank,AUD,CURRENCY,F,F,FīANK,Bank:Broker Funds,Broker Funds,AUD,CURRENCY,F,F,F INCOME,Income:Dividend:Franking Credit,Franking Credit,AUD,CURRENCY,F,F,F INCOME,Income:Dividend:Franked,Franked,AUD,CURRENCY,F,F,F INCOME,Income:Distribution,Distribution,AUD,CURRENCY,F,F,F LIABILITY,Liability:Contra,Contra,AUD,CURRENCY,F,F,F LIABILITY,Liability,Liability,AUD,CURRENCY,F,F,F ShareInvestment_AccountTree.csv Type,Full Account Name,Account Name,Account Code,Description,Account Color,Notes,Symbol,Namespace,Hidden,Tax Info,PlaceholderĪSSET,Asset:Shares,Shares,AUD,CURRENCY,F,F,F Your question is very confusing but I understand you are having problems importing your coa then your transactions. Sorry for the verbose post - I have other questions but this is my top priority so I will save the others for another day. ![]() Naturally, I would prefer that the stock information be imported with the rest of the account tree from the CSV file and I would very much appreciate any suggestions that I could implement to make this happen. I clear the dialog and see the new chart of accounts after the import of the CSV file: dummy ExpensesĪs a result of this behavior, I find it necessary to re-enter my set of securities information after each reload of my account tree. The number of Accounts added was 10 and 4 were updated. I see the following messages in the import window: Import completed but with errors! 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': dummy Expenses 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. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |