Importing into stock type gnucash accounts...

[David T.]

Unfortunately, the CSV importer doesn’t support both sides of a transaction. See: http://lists.gnucash.org/pipermail/gnucash-user/2014-August/055921.html <http://lists.gnucash.org/pipermail/gnucash-user/2014-August/055921.html> and http://lists.gnucash.org/pipermail/gnucash-user/2014-September/055970.html <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> 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
> 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.