interesting Figures (Shouldn't They Match?)

Michael Churchill mjchurchil at aol.com
Tue Feb 28 09:56:18 EST 2017


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



More information about the gnucash-user mailing list