Importing into stock type gnucash accounts...

[David Carlson]

First, check whether that is still needed for release 2.6.8.  I think that
the report has been fixed so that the security account split line is no
longer needed.  If not...

A partial solution, and the one that I use is as follows.  Import the
oldest transaction then edit it to include the extra split line for the
security account with zero amount.  Then set one or four scheduled
transaction(s) from that transaction to create the rest of the historical
dividend transactions.  Set it to reminder type then when the Since Last
Transaction wants to enter them all at once change all but the first few
back to reminder status so that you can keep track when the company changes
the dividend amount.  Repeat tediously until all the history is in place.
Then the import of the other account transactions should work with the
importer offering to match to those existing dividend transactions.

David C

On Tue, Sep 29, 2015 at 8:31 PM, Allan <allanhasmail at gmail.com> wrote:

> I did experiment with the CALC2QIF creating a dividend import with
> something like this:
>
> !Type:Invst
> D04/01'15
> U37.41
> T37.41
> NDIVIDEND
> YMDU
> I1.00
> MMDU RESOURCES GROUP INC: CASH DIV  ON     205: AT $.1825   PER SHARE
> LAssets:Investments:Stock
> ^
>
> But I see no way to get it into the various sub accounts. The importer
> asks for a single account for the QIF.
>
> I wonder if I could add lines like:
>
>  !Account
> N/Account Name
>
> /into the QIF to create the proper split...
>
> If I could figure out the proper QIF file, it looks pretty easy to modify
> the CALC2QIF macro. To me, CALC2QIF makes GC much more useful, and this
> would add to that further.
>
> 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.
>>>
>>
>>
> _______________________________________________
> 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.
>