unbalanced balance sheet

Mark Johnson mrj001 at shaw.ca
Sun Feb 20 18:20:01 EST 2005


I just imported some of my wife's Quicken 98 data into gnucash.  This 
gnucash file already had my data in it.  Before I started, the balance 
sheet was balanced.

After I finished, the balance sheet was unbalanced.  I was able to track 
this down to a single transaction.  It is in my wife's share purchase 
plan.  I set this up with an account hierarchy like this:
Asset (type asset)
 - Stephanie (type asset)
   *SPP (type Bank)
      ~CompanyShares (Type Stock)

The SPP accounts holds cash deducted from her paycheck.  Once we receive 
statements telling us how many shares were purchased, we enter buy 
transactions to convert them into shares in the CompanyShares account.

Naturally, I wanted to enter an Opening Balance transaction in the 
CompanyShares account.  The balancing account was Equity:Retained 
Earnings.  However, whenever I enter this single transaction, the 
balance sheet becomes unbalanced.  If I delete the transaction, the 
account is once again balanced.  If I re-enter the transaction, the 
imbalance re-appears.  I tried this several times.  (Not sure why I 
thought that would make a difference. :-)

I tried deleting the CompanyShares account and the commodity for the 
shares.  I re-entered them, and re-entered an Opening Balance 
transaction.  The balance sheet was still unbalanced.

Out of curiousity, I decided to "Jump" to the other side of this 
transaction to see what it looked like in Equity:Retained Earnings.  To 
my surprise, the transaction was there, but all amounts were blank!

Once again, I deleted the transaction.  Once again, the balance sheet 
was balanced.  This time, I decided to enter it from the Equity:Retained 
Earnings register.  Gnucash popped up a dialog noting that the 
commodities for the two accounts were different and asking for an 
exchange rate (or number of shares purchased).  I opted to enter the 
number of shares purchased rather than the exchange rate.

Now, there is no problem.  Both ends of the transaction have amounts.  
The balance sheet balances.

Clearly, there is some sort of bug here.  Is this one anyone else has 
encountered?  If not, I will enter a report.

I am using gnucash 1.8.11 on Slackware 10.0.

Mark



More information about the gnucash-user mailing list