Unbalanced balance sheet

[Derek Atkins]

Hmm, I guess it's more broken than I thought.  Can you try the
Balance Sheet from CVS HEAD?

-derek

Derrick Ashby <daeroncs at fastmail.fm> writes:

> Derek,
>
> I didn't have any share sales.  I have now created a new file, and
> entered the details of my share consolidation as the only transaction.
> I entered the opening balance for the share - I had 13,900 shares that
> at the time of the consolidation were worth about $0.08 each.  The
> consolidation removed 12,510 shares, leaving me with 1,390, initially
> worth $0.80.  Before the consolidation both the Assets and Equity were
> $2,085.  After the consolidation Assets were $109.74, if a Weighted
> Average price is used, or $750.60 if the Most Recent price is used.
> In the latter case there is an unrealised gain of $640.86.  Without
> the consolidation, the balance sheet shows an unrealised gain of
> $5,421.00, due to movements in the share price.  I also tried selling
> the 12,510 shares at a price of $0, and selling 13,900 at $0.08 and
> buying back 1,390 at $0.80.  In no case could I get the balance sheet
> to balance.  Which method would you suggest I use, and how would you
> recommend I "manually account for  the gain/loss".  It seems to me
> that while gnucash can cope with price movements in a share, if you
> also vary the number of shares over time it throws in the towel.
>
> Derrick
>
>> No, a stock split shouldn't do it.  However if you've bought and then
>> sold a stock it will cause an imbalance unless you manually account
>> for the gain/loss.
>>
>> -derek
>>
>> Derrick Ashby <daeroncs at fastmail.fm> writes:
>>
>>
>>
>>> Derek,
>>>
>>> I was suspecting that the problem had something to do with the share
>>> portfolio.  I think the problem may have to do with a "stock split" I
>>> entered - actually a 10 to 1 consolidation.  This involved the number
>>> of issued shares being reduced by 90%, which effectively revalued the
>>> shares by a factor of 10.  I followed the instructions provided, but
>>> given what you say,   do I have to do something else to get the
>>> balance sheet to balance? I might say that I experimentaly removed all
>>> the share portfolio transactions from the file, but the balance sheet
>>> still did not balance.  Are there hidden transactions involved that
>>> can't be undone?
>>>
>>> Derrick
>>>
>>>
>>>
>>>> Mark Eackloff <meackloff at cox.net> writes:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> This happened to me recently.  I determined that it was caused by an
>>>>> unbalanced entry.  Yes, that's right.  Apparently it is possible to
>>>>> enter only one side of a transaction.  I'm not sure if that's a
>>>>> "feature" or a bug.
>>>>>
>>>>>
>>>>>
>>>>
>>>> The only way I know of to enter unbalanced transactions is via the OFX
>>>> Import process.  I (still) consider that a bug, but it has not (yet)
>>>> been fixed.  :(
>>>>
>>>> However, that's not the only way to cause a balance-sheet imbalance.
>>>> Another way is not accounting for capital gains/losses when you sell a
>>>> commodity other than your report-currency.  Gnucash 1.8 does not
>>>> properly account for the change-in-value of commodities, which means
>>>> your balance sheet will be out of balance.
>>>>
>>>> -derek
>>>>
>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available