ROOT Type accounts

David T. sunfish62 at
Sat Oct 29 08:33:40 EDT 2016

OK, so I opened the SQLite file in GnuCash, went to the COA and selected Check and Repair All. No change, unfortunately.

I will try removing the rows manually and see what happens! This, of course is on a copy of my real data file. ;)


> On Oct 29, 2016, at 5:13 PM, Geert Janssens <geert.gnucash at> wrote:
> On Saturday 29 October 2016 15:14:55 David T. via gnucash-devel wrote:
>> Hi,
>> I am digging around in the SQL database, and I am noticing that the
>> accounts table for my data has 46 ROOT type entries.
>> Checking in GnuCash, I have 6 top level accounts (Assets, Equity,
>> Expenses, Income, Liabilities, and Special Accounts).
>> Back in the SQL, only one of the 46 has a name entry (“Root account”);
>> the remainder have nothing in the name field. Examining the entries a
>> little closer, I see that these empty root accounts seem to form a
>> single chain whose commodity for each is ‘template’. I am curious
>> what these other 45 ROOT accounts might be.
>> What is this chain, what purpose does it serve, and is it supposed to
>> be there?
>> TIA,
>> David
> These root accounts shouldn't be there. They are the side effect of a 
> bug that got fixed some time back. I can't immediately find the details 
> of this. In principle only one root account should be there and the 
> others can be removed (provided no other account is referring to these 
> bogus root accounts). Ideally the check & repair function should handle 
> this.
> Regards,
> Geert

More information about the gnucash-devel mailing list