Importing into stock type gnucash accounts...

[Allan]

On 09/29/2015 08:06 PM, David T. wrote:
> Unfortunately, the CSV importer doesn’t support both sides of a 
> transaction. See: 
> http://lists.gnucash.org/pipermail/gnucash-user/2014-August/055921.html and 
> http://lists.gnucash.org/pipermail/gnucash-user/2014-September/055970.html for 
> a recent discussion. There *are* numerous utilities to convert CSV 
> files to QIF, which will preserve the second account. There are recent 
> discussions on this list about some of them.

Yes, I've been using CALC2QIF which is a GC savior!!! And I used it to 
import seom BUY tx successfully.

>
> I’ll note that you probably won’t be importing dividend income into a 
> stock account, since the stock account is by definition denominated in 
> shares of stock. (of course, your example might be indicating a stock 
> dividend, in which case I commend you on receiving $7700 from your 
> investment, and then I’d shut up!)

Not so fast, lol. That was a $54 cash dividend, not reinvested shares 
on, lol, some 5000 shares anyway. :-)

I read up on this: In order for cash income to correctly contribute to 
the total return, I put the dividend into the stock account. And it 
seems to work. So I want to do it this way.

Allan


On 09/29/2015 08:06 PM, David T. wrote:
> Unfortunately, the CSV importer doesn’t support both sides of a 
> transaction. See: 
> http://lists.gnucash.org/pipermail/gnucash-user/2014-August/055921.html and 
> http://lists.gnucash.org/pipermail/gnucash-user/2014-September/055970.html for 
> a recent discussion. There *are* numerous utilities to convert CSV 
> files to QIF, which will preserve the second account. There are recent 
> discussions on this list about some of them.
>
> I’ll note that you probably won’t be importing dividend income into a 
> stock account, since the stock account is by definition denominated in 
> shares of stock. (of course, your example might be indicating a stock 
> dividend, in which case I commend you on receiving $7700 from your 
> investment, and then I’d shut up!)
>
> If your dividend is a dollar sum, however, usually, the solution I 
> know of is to have a currency-denominated income account for dividends 
> from which the dividends originate, and a currency account to receive 
> them. For me, I have transactions from Income:Dividends going into my 
> broker’s cash account (Assets:Current Assets:Broker). When I get the 
> broker’s statement, everything balances, and I can see the income at 
> the end of the year.
>
> David
>
>> On Sep 29, 2015, at 8:29 PM, Allan <allanhasmail at gmail.com 
>> <mailto:allanhasmail at gmail.com>> wrote:
>>
>>
>> Is there a way to import dividends into respective GC stock accounts 
>> (Asset:Stock:Symbol) from a CSV format?
>> i.e.
>> 1/1/15,IBM,Asset:Stock:IBM,54.56,Income:Dividend
>>
>> I read the discussion on "Importing Exported Data into Gnu Cash" and 
>> this doesn't seem to allow for stock accounts nor multiple accounts 
>> (both sides of a transaction in each line).
>>
>> I have several hundred at least transactions to get into GC and more 
>> coming...
>>
>> and would like to discover a faster way to enter them than re-typing 
>> them.
>>
>> Allan
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org <mailto: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.
>