Unrealised losses

Wm... tcnw81 at tarrcity.demon.co.uk
Mon Nov 23 16:54:55 EST 2015


Mon, 23 Nov 2015 13:33:28 <56527AF8.5060200 at iinet.net.au>
Peter <p.hoban at iinet.net.au> wrote...

>I am using GnuCash 2.6.1 on Linux Mint 17.2 to manage a superannuation 
>fund with >$1.5M funds.  Annual reporting in Australia requires a 
>figure for Unrealised Gains/Losses which I see from reading the Forum 
>posts is a rather complex issue.

Depends if you're used to doing the basic sums yourself, of course.

>I have set the file to use currency trading accounts

They're just Trading Accounts really.  Currency transactions are one of 
the things they're useful for.

>and when I enter a sale of shares GnuCash generates a split transaction 
>with four lines of entry.  This must be adjusted to include brokerage 
>but appears to work correctly with Trading accounts for the change of 
>value.

Sounding good up to here.

>I am left with the question of EOFY reporting which is required to show 
>unrealised gains/losses - I can ensure that the Price Editor has an 
>appropriate value for the stock on the balance date but the Balance 
>Sheet shows the acquisition price when the price source is set to 
>'average value'.  When the source is set to 'Nearest in time' the 
>Balance Sheet shows a value much larger and clearly incorrect. It 
>appears something is not set up right.

I'm hoping I'm stating the obvious.

You want two balance sheets.

The first  is end of previous financial year using Nearest in time
The second is end of last     financial year using Nearest in time

>Can I get an accurate asset value into the Balance Sheet, and an 
>accurate Unrealised Gain for a periodic revaluation?

Comments and queries if the above doesn't help:

Q1: do you have holdings in currencies other than the fund's home 
currency?

Q2: do you have prices in Tools / Price Editor for any securities on the 
dates (or very soon before) required for the balance sheets?

Q3: ditto Q2 re exchange rates if Q1 applies

===

C1: two balance sheets are the basic requirement for this sort of 
reporting.  Add in

lots of transactions or
different currencies or
splits, mergers, acquisitions, etc
and things get more complicated.

but

your basic tools are balance sheets.  So it is a bit of a worry if they 
aren't correct.  You haven't said very clearly why the balance sheets 
aren't right but saying so would help us to help.

-- 
Wm...



More information about the gnucash-user mailing list