[GNC] When importing an account tree from a csv file, account type information disappears

hakon at finne.net hakon at finne.net
Wed Jan 8 17:52:12 EST 2025


I am a new GnuCash user. I have several problems when trying to import 
an account tree from an accounting program (Mamut Datax) I have used 
before. One of these problems can be described as follows.

I export the account structure from my MD system to a csv file. I then 
use MS Excel to restructure the information to fit the input 
requirements for a csv file that will define a GnuCash account tree. 
During the import to GnuCash, I assign my MB Account Type field to the 
Type field of GnuCash. Once imported, the account tree looks ok, except 
that the Type field for each account is empty. It does not matter 
whether I use the original US Type typology or the built-in Norwegian 
Type typology. I understand that a subaccount cannot be assigned a Type 
that is not compatible with the account above it in the tree, all the 
way up to the five fundamental account types. And I make sure the 
sequence of accounts in the csv file defines the hierarchy top-down 
(should it matter). Please help me sort this out. Assigning account 
Types manually after the import is possible, but I would rather solve 
this in a more automatic manner.

-- HÃ¥kon


More information about the gnucash-user mailing list