Fw: gnucash displays dollars as shares
David T.
sunfish62 at yahoo.com
Mon Dec 19 23:00:02 EST 2016
My mail program hates me...
Forwarding to the list
On Tue, Dec 20, 2016 at 8:52, David T.<sunfish62 at yahoo.com> wrote: John,
I'm not sure which specific accounts you refer to when you say "top level account" and "subaccount", so it's difficult to advise except generically. (for what it's worth, Gnucash uses "top level account" specifically took revert to the first account level only, so "Assets" in your example)
Adding and moving accounts is not difficult, and is handled on the account edit page.
Using your initial account designations, and assuming that Mutual Fund Account A Sublevel is the account that has your fund shares in it, I would do the following:
1 - change the parent account of Mutual Fund Account A Sublevel to Brokerage A.2 - Edit the share purchase transaction to use Brokerage A as the source for the cash. Or Equity, as the case may be. 3 - check that Mutual Fund and Mutual Fund A Account are empty of transactions. If they are empty, I would then delete these accounts.
At this point, you can rename the fund account without conflict.
For what it's worth, the import routine creates accounts based on the qif that Quicken sends.
HTH,David
On Tue, Dec 20, 2016 at 0:14, James Brown<JHLHBrown at verizon.net> wrote: Thanks David. I was able to get the right shares, $/share, and balance but not the way you listed. I probably messed things up in the top account but at least the sub account still comes out correctly (with a long list of transactions). The problem is that the top and sub accounts add to the total value; whereas, the subaccount alone is the correct value. Only the subaccount should add to the total value.
The gnucash QIF import created the top/sub account structure. Ideally, I'd like to retain only the sub account and get rid of the top account but I can't figure out how to do that and ensure that the opening shares/balance are still correct in the subaccount. Also, since the top and sub accounts have the same name, gnucash will not let me change the sub account to a top account.
Jim
-----Original Message-----
From: David T. [mailto:sunfish62 at yahoo.com]
Sent: Sunday, December 18, 2016 11:26 PM
To: JHLHBrown at verizon.net
Subject: Re: gnucash displays dollars as shares
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