Unrealised losses

[Peter]

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 confess to a handicap - I was an engineer not an accountant and there has been a significant learning curve to mount.
> >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
In an endeavour to remove any historical errors I deleted all prior years from the data file. (The former file is preserved of course.) So the data 
has opening values equal to the audited balance sheet on that date.  The EOFY balance sheet (nearest in time) shows a value for Unrealised Losses but 
I cannot calculate the same value.
>> >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?
Only parcels of shares - no other currencies.
> Q2: do you have prices in Tools / Price Editor for any securities on the
> dates (or very soon before) required for the balance sheets?
Yes, well!!  I find a dogs breakfast.  Clearly I have work to do to set this right.
At this time my only suggestion is that the price editor show either the date or the price (or both) on the line of each entry - at present it shows 
only the name of the security which is the same on every line and only repeats the name at the top.  That makes it slow to find which are the prices 
to be removed as each item has to be opened then closed again to know before deleting.

Thank you Wm for your suggestions.

-- Wm... P..