Importing into stock type gnucash accounts...
Allan
allanhasmail at gmail.com
Thu Oct 1 15:51:11 EDT 2015
I upgraded from 2.6.1 to 2.6.8 which I just installed from the getdeb
archive. The advanced portfolio report doesn't allow including the
Income:Dividend:<ticker> accounts in the income. The only way income is
included is to use the empty security account split line to tie it into
the report.
I see for basis calculations, it allows for avg, LIFO, FIFO but no way
to use specific lot identification. Perhaps you could create separate
accounts for each lot?
The beginning date range for the advanced portfolio report seems to be
fixed at a beginning of the current year. ? This is a huge limitation.
As for a way to get i.e. dividend data in without keyboarding
everything, I can import into a cash account without the empty security
account split line which can be added manually.
The tool at:
XLSM2QIF
<http://gnucash.1415818.n4.nabble.com/Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680333.html>
X
<http://gnucash.1415818.n4.nabble.com/Re-XLSM2QIF-Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680402.html>
http://wiki.gnucash.org/wiki/Published_tools
is improved to allow splits, and produces this QIF for the said dividend
entry, however, GC 2.6.8 crashes during the import (at the account
matching stage IIRC):
!Type:Cash
D01/04/2015
U37.41
T37.41
PMDU
MCash Div on 205 at .1825 per share
LIncome:Dividend:MDU
SIncome:Dividend:MDU
ECash Div on 205 at .1825 per share
$37.41
SAssets:Investments:Stock:MDU
$
^
Thanks David and everyone for your suggestions and help!!! I much
appreciate it!
Allan
On 09/29/2015 09:19 PM, David Carlson wrote:
> 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
> <mailto: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
> <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>
> <mailto: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 <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.
>
>
More information about the gnucash-user
mailing list