cedayiv at gmail.com
Mon Jun 30 11:37:19 EDT 2008
On Mon, Jun 30, 2008 at 7:09 AM, Derek Atkins <warlord at mit.edu> wrote:
> Are you mixing Realized and Unrealized gains? Unrealized gains
> (or losses) occur every day when the value of an asset changes.
> However you don't record unrealized gains. You record REALIZED
> gains, when you actually exchange one asset for another.
Recording only the realized gains will put the books out of balance. When
you sell, you have a realized gain on the quantity sold and an unrealized
gain on the quantity remaining. You have to record them both.
Try removing the unrealized gain splits from either of the examples I
attached previously and look how it throws off the trial balance.
I just want to make sure you're using the correct terms before
> we continue this discussion.
> "Charles Day" <cedayiv at gmail.com> writes:
> > On Sun, Jun 29, 2008 at 3:46 PM, Charles Day <cedayiv at gmail.com> wrote:
> >> I have attached a couple of examples of how messy it can become in the
> >> current version of GnuCash when you sell currency or investments for a
> >> and keep the books in balance.
> >> The first file, 2eur, is an example of currency gains. The "home"
> >> is USD and there is a bank account named "USD Bank" that starts with
> >> $700 is converted to Euros and transferred to "EUR Bank". The remaining
> >> is also converted to Euros and transferred to "EUR Cash". What happens
> >> the exchange rate changes slightly, and we spend some of that Euro cash
> >> buy a nice dinner? It turns out that to keep the books in balance, I had
> >> enter quite a complicated transaction involving a complete revaluation
> >> all Euros held, regardless of which account they are held in. That
> >> transaction was tough to key in, too, as I had to fight with the
> >> and on some of the splits the exchange rate had to be zero! (I wonder
> >> this might cause a divide-by-zero crash at some point.) If any of these
> >> splits are removed, the trial balance will fail. Imagine the nightmare
> if I
> >> had Euros in asset accounts instead of just two.
> > ... that should have been "ten accounts instead of just two."
> >> Just in case I did this the really hard way, if anyone has a suggestion
> >> how to enter this transaction more easily and without changing the
> >> that each account is denominated in, please let me know. Of course,
> >> would have been no need to calculate any gains if Expense:Dining was
> >> denominated in EUR instead of USD, but that assumes that you are happy
> >> manage separate expense accounts for each currency you use.
> >> The second file, 2brokers, is an example of accounting for investment
> >> gains. Stock in XYZ corporation has been purchased in two separate
> >> accounts. At one broker, a few of the shares are then sold for a profit.
> >> keep the books in balance, the sell transaction needed 8 splits. Again,
> >> a look at the trial balance. Remove any of those splits and the books
> >> unbalanced.
> >> In both these examples, if trading accounts had been used there would be
> >> need to calculate unrealized gains, as that would happen automatically.
> >> Putting in the realized gain would just be a transfer from the
> >> gains account to the realized gains account (essentially just
> >> some of the unrealized gain as realized, which also avoids doing your
> >> subtraction).
> >> Cheers,
> >> Charles
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 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
More information about the gnucash-user