Balance sheet report (2)

[Derek Atkins]

Hi,

Bernard FUENTES <bernard_fuentes at yahoo.fr> writes:

> Hi,
>
> I do not believe that balance sheet report functions correctly.
> I have make a very simple example so that somebody explains me to what
> corresponds the XPF 1 999 332,00 at the line "Unrealized
> Gains(Losses)" of the report "Balance Sheet".

Well, when I run this report I don't get anything in the Unrealized
Gains(Losses) section, it's just zero...  However it's a known bug
that the balance sheet does not properly handle investment accounts.
As your basis here is a stock transaction it's not surprising that the
report isn't working right.

I tested this here and I assumed your report currency is XPF -- you
didn't specify but I assumed this to be the case based on the fact
that most of your currencies are XPF.  When I ran this I also noticed
a number of other issues.  In particular you'll also notice that you
get the following output on your terminal:

;;; WARNING (gnc:resolve-unknown-comm: can't calculate rate for  EUR 1,000.00  =  100 FIB  to  XPF 0.00)

;;; WARNING (gnc:resolve-unknown-comm: can't calculate rate for  EUR 1,000.00  =  100 FIB  to  XPF 0.00)

This implies that there are some missing conversion rates as well.
Either of these could be the cause of your problem.

For the record, I changed the report to use "Most Recent" instead of
"Weighted Average" and _NOW_ I get the Unrealized Gains(Losses) of XPF
1,999,332.00, which is probably the conversion of your FEB and FIB
investments to XPF minus your "initial investment".  But running
through the numbers... you have 20,000 shares of FEB (@ 95XPF/share)
and 100 FIB (@ 10 EUR/share -> 119.332XPF/EUR == 1193.32/share) which
equals 1,900,000 + 119,332 == 2,019,332...  So that matches your
equity, but not that number.

2,109,332 - 1,999,332 = 20,000 so where is that 20,000 coming from?

Unfortunately I don't know..  Indeed, based on the numbers you have
you should have '0' unrealized gain/loss.  However as I said the
system is a bit confused.  I suspect part of the problem is an
assumption about currency.  You're buying FEB with USD and FIB with
Euro but reporting in XPF, so I bet it's getting confused by this.

Can you submit a bug report to bugzilla.gnome.org?  Supply (attach,
not inline) your test data file and describe your report configuration
in the report...

> Thanks.
>
> Bernard FUENTES
>
> The file:
[snip]

-derek

-- 
       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