Unrealized Gains in Balance sheet wildly out of proportion

Wm wm+gnc at tarrcity.demon.co.uk
Mon May 18 01:39:49 EDT 2015

Sat, 9 May 2015 17:46:32 
<CAHKUnFdBRwtvG9F04CV60YtRnWaVbGmTu=+kjSo6oeoGj+FfQw at mail.gmail.com> 
Jobjörn Folkesson <jobjorn at jobjorn.se>

>First of all thank you for the software. I often recommend it to local
>chapters of the non-profit organisation I work for, and I use it myself
>both for my private economy and for smaller non-profit associations whose
>books I keep.
>With my own money I sometimes travel abroad and thus introduce foreign
>currencies to my GnuCash file. This works fine, except for one detail.
>According to my balance sheet I have unrealized gains of 6,7 million SEK,
>which is more than 20 times more than my total assets. A screenshot is
>I have googled a bit and read part of a discussion on this list from 2008,
>but alas I can't understand what is going on. I am running GnuCash 2.6.4 on
>Debian stable (jessie), so my copy was built from rev 29bcdf1+ on
>2014-11-15. Does anyone know if it is something I can fix?

GBP / SEK looks most wrong.

Try some things for us first.

gnc has two balance sheets, run them both again making sure
Price source is Nearest in Time
choose Today as the bal sheet date.
and ensure
Show Foreign Currencies tick / check / Swedish equivalent (tak?)
Show Exchange Rates tick / ditto

Now you should have numbers you can make sense of with a calculator in 
your hand.

If things are still looking very wrong compare the exchange rates on the 
bal sheets with those on your favourite exchange, if you want quick and 
easy just type "gbp.06 in sek" into google, it works and should be 
around .8 krowns, but you probably already know that!

If the exchange rates are way out you should fix them by going through 
the transactions again to get more realistic rates attached to the 
actual transactions.  If you don't have much in the way of non-SEK you 
don't necessarily need to get up to date prices.

In this case I'm guessing there has been a more basic mistake like so 
much of this currency ended up as so much of another and a decimal was 
wrong or something.

Regards what DavidC said I am in favour of people using Trading Accounts 
if they are going to be dealing with "strange money" more than once a 
year.  That "strange" includes all sorts of financial instruments other 
than currencies.

Anyway, I'm sure David and I would both like to help you so see what 
you've got after you try out the recipe above.


More information about the gnucash-user mailing list