Fw: gnucash displays dollars as shares
David T.
sunfish62 at yahoo.com
Mon Dec 19 07:46:58 EST 2016
Forwarding to the list , since I didn't originally.
On Mon, Dec 19, 2016 at 9:26, David T.<sunfish62 at yahoo.com> wrote: Hi James,
Start by reading the investments chapter of the Guide, which explains how to enter these transactions.
I am not sure why you have so many levels in your account hierarchy; in my own set up, I would have:
Assets
Investments
Brokerage A (USD)
Mutual Fund A (FNDA)
Mutual Fund B (etc.) (FUNDB)
(Note: the currency designations are in parentheses)
In my experience, Brokerage A sends me one statement for all my funds, and my account structure mimics this. I use the main Brokerage account to track the cash balance, although you could have a separate subaccount for that if you want.
Your problem is as I suggested. The way Quicken handles this sort of thing and the way that GnuCash does is different.
If this were me, I would:
Open Fund:Fidelity Fund A Account (the actual Mutual Fund account in GnuCash).
Change your register view to Transaction Journal for the time being.
Go to the the Balancing Cash Adjustment transaction and change it to read “Opening Balance".
Tab to the Shares column and make sure it says 841.043.
Tab *past* the Price column and enter 10000 in the left column.
Tab through to the next line (which should have Mutual Fund A Account (in your system; Brokerage A in mine) and enter 10000. If this is actually setting up an opening balance, I would change this to use an Equity account.
That should leave you with one transaction that correctly tracks the situation. Any other transactions related to this can be deleted.
David
> On Dec 18, 2016, at 9:38 PM, James Brown <JHLHBrown at verizon.net> wrote:
>
> Followup to below:
>
> For 10/2/2012 Quicken shows 841.043 shares @ 11.889998. Share Bal 841.043. Inv Amount 10,000.
>
> -----Original Message-----
> From: James Brown [mailto:JHLHBrown at verizon.net]
> Sent: Sunday, December 18, 2016 11:35 AM
> To: 'David T.'
> Subject: RE: gnucash displays dollars as shares
>
> Hello David - thanks.
>
> My account hierarchy is as follows:
> Assets
> Investments
> Brokerage Account A
> Mutual Fund (just a label)
> Mutual Fund A Account (top level for fund)
> Mutual Fund A Account Sublevel
>
> Double click Mutual Fund Account A Top Level, gnucash shows:
>
> Date Num Description Transfer R Shares Price Buy Sell Balance
> 10/02/2012 Equity:Retained Earnings n 0
> 10/02/2012 -- Split Transaction n (10,000) 1 10,000.00 (10,000)
> 10/02/2012 Balancing Cash Adjustment Fund: Fidelity Fund A n (10,000) 1 10,000 (20,000)
> 10/02/2012 Balancing Cash Adjustment Fund: Fidelity Fund A n (10,000) 1 10,000 10,000 (10,000)
>
> Quicken Shows:
>
> Date Action Transaction Price Shares $ Amount C Cash Balance
> 10/2/2012 Cash 0 0.00
> [Fidelity Fund A
> 10/2/2012 Bought Fidelity Fund A 11.889998 841.043 10,000.00 -10,000.00
> 10/2/2012 XIn Balancing Cash Adju 0 10,000.00 0.00
> [Fidelity Fund A 10,000.00
> 10/2/2012 Added Fidelity Fund A 0 0.00
>
> So, I'm not sure what to correct.
>
> Jim
>
> -----Original Message-----
> From: David T. [mailto:sunfish62 at yahoo.com]
> Sent: Saturday, December 17, 2016 11:54 PM
> To: JHLHBrown at verizon.net
> Cc: gnucash-user at gnucash.org
> Subject: Re: gnucash displays dollars as shares
>
> I assume you’re talking about the Chart of Accounts display.
>
> I am going to assume that when you say “displays dollars as shares in the top level account,” you mean that it is displaying the number of shares as a dollar amount, like this:
>
> My Top Level Account $500
> My Mutual Fund 500 MFNDX
>
> If this is the problem, then your buy transaction is incorrect; you need to adjust the total dollar amount to reflect the amount you actually paid for the shares. If your holdings are complex (i.e., you have multiple buy and sell transactions for the account), it should suffice to use the aggregated cost basis of your account as the overall price. When you go to edit this transaction, tab into the share price column, delete the price, then tab to the amount column, and enter your total basis. Tabbing to the next split in the transaction will automatically fill in the share price; just be sure to adjust the second split (the one that probably should be assigned to Equity—but may be set to Imbalance-USD, which you might also change) to include the total new amount as well.
>
> If I have misunderstood, write back and fill in more details so that we can try to get at what’s really going on.
>
> HTH,
> David
>
>
>> On Dec 17, 2016, at 10:08 PM, James Brown <JHLHBrown at verizon.net> wrote:
>>
>> I imported a QIF file into gnucash.
>> For my mutual funds, gnucash displays dollars as shares in the top
>> level hierarchy.
>> The level below the top level in the hierarchy displays correctly
>> (shares as shares, etc).
>>
>> James H. Brown
>>
>> _______________________________________________
>> 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.
>
More information about the gnucash-user
mailing list