interesting Figures (Shouldn't They Match?) **CLOSED THREAD**

[Jay Ridgley]

I am closing this thread.

The point remains the Balance Sheet Unrealized Gains/Losses and the 
Advanced Portfolio Unrealized Gains/Losses DO NOT MATCH.

I understand why the Investment Totals WILL NOT MATCH, since Cash is NOT 
included in the Advanced Portfolio Report.

However, the sum of all the cash accounts and the investment accounts 
from the Advanced Portfolio Report should balance between the two reports.

Regards,
Jay

On 02/28/2017 08:56 AM, Michael Churchill via gnucash-user wrote:
> Jay, I believe you are correct about US IRA rules.  I have similar
> reports and have finally decided I need to get the cash values
> separately and combine it all in a little spreadsheet. Mike
>
>
> On 02/28/2017 04:13 AM, Jay Ridgley wrote:
>> On 02/27/2017 10:45 PM, Chris Good wrote:
>>>> -----Original Message-----
>>>> From: Jay Ridgley [mailto:jridgley2 at austin.rr.com]
>>>> Sent: Tuesday, 28 February 2017 1:36 PM
>>>> To: Chris Good <chris.good at ozemail.com.au>; gnucash-user at gnucash.org
>>>> Subject: Re: interesting Figures (Shouldn't They Match?)
>>>>
>>>> On 02/27/2017 07:26 PM, Chris Good wrote:
>>>>>> Message: 1
>>>>>> Date: Mon, 27 Feb 2017 10:07:09 -0600
>>>>>> From: Jay Ridgley <jridgley2 at austin.rr.com>
>>>>>> To: Derek Atkins <warlord at MIT.EDU>
>>>>>> Cc: gnucash-user <gnucash-user at gnucash.org>
>>>>>> Subject: Re: interesting Figures (Shouldn't They Match?)
>>>>>> Message-ID: <957f2aee-b3cc-b946-06fc-ac34026bdb10 at austin.rr.com>
>>>>>> Content-Type: text/plain; charset=windows-1252; format=flowed
>>>>>>
>>>>>> On 02/27/2017 09:43 AM, Derek Atkins wrote:
>>>>>>> Jay Ridgley <jridgley2 at austin.rr.com> writes:
>>>>>>>
>>>>>>>> Good afternoon,
>>>>>>>>
>>>>>>>> Just ran a Balance Sheet and an Advanced Portfolio and found
>>>>>>>>
>>>>>>>>
>>>>>>>> Account                Balance Sheet     Advanced Portfolio
>>>>>>>> Total Investments        $553,856.78    $541,590.70
>>>>>>>>
>>>>>>>> Unrealized Gain/Loss        $130,684.25    $171,555.97
>>>>>>>>
>>>>>>>>
>>>>>>>> Both reports were run with the same report options, why are they
>>>>>> different?
>>>>>>>
>>>>>>> Are you sure both are using the same "Quote Source"?
>>>>>> Thanks Derek,
>>>>>>
>>>>>> They should be; how would I check?
>>>>>>
>>>>>> I did discover one thing - CASH is NOT included in the Advanced
>>>>> Portfolio...
>>>>>>
>>>>>> Cheers,
>>>>>> Jay
>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> Jay
>>>>>>>
>>>>>>> -derek
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Jay Ridgley
>>>>>> jridgley2 at austin.rr.com
>>>>>> Registered Linux User ID - 9115
>>>>>> https://linuxcounter.net/cert/9115.png
>>>>>> Registered Ubuntu User ID - 23320
>>>>>
>>>>> Hi Jay,
>>>>>
>>>>> 'Quote Source' is one of the report options. You probably should use
>>>>> 'Nearest in Time'.
>>>>
>>>> I used 'Most Recent' for both reports. Is that a problem?
>>>>
>>>> All my investments are currently held, there are none that are not
>>>> active
>>>> and
>>>> updated daily.
>>>>
>>>>>
>>>>> Cash dividends may not be included as 'income' in the Advanced
>>>>> Portfolio Report unless you add a dummy split to the stock account in
>>>>> the dividend transaction.
>>>>> Please see
>>>>> https://www.gnucash.org/docs/v2.6/C/gnucash-help/report-
>>>> classes.html#r
>>>>> eport-
>>>>> assets
>>>>
>>>> I am talking about accounts that contain CASH (not invested), those
>>> accounts
>>>> are not included in the report. I have several in my portfolio of
>>>> investments.
>>>> For example Investments:Retirement:IRA:Cash
>>>>
>>>>>
>>>>> Regards, Chris Good
>>>>>
>>>>
>>>> Cheers,
>>>> Jay
>>>> --
>>>> Jay Ridgley
>>>> jridgley2 at austin.rr.com
>>>> Registered Linux User ID - 9115
>>>> https://linuxcounter.net/cert/9115.png
>>>> Registered Ubuntu User ID - 23320
>>>
>>> Hi Jay,
>>>
>>> AFAIK, Advanced Portfolio Rpt is only for accounts of type 'Stock' or
>>> 'Mutual Fund'.
>>> Cash is usually under Assets:Current Assets, not Assets:Investments.
>>>
>>> Regards, Chris Good
>>>
>> Good Morning Chris,
>>
>> I understand that cash is an asset, however, AFAIK to make my IRA
>> correct and to satisfy the IRS (United States). The cash that is held
>> in that account MUST be included there, the account is of type cash.
>> It contains money that is available to be invested, proceeds from sell
>> transactions and funds that may be transfered to my bank as a
>> distribution from the IRA. I will verify that is correct with my
>> accountant when we next meet.
>>
>> Cheers,
>> Jay
>
> _______________________________________________
> 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.
>


-- 
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320