Importing into stock type gnucash accounts...
Allan
allanhasmail at gmail.com
Wed Sep 30 00:01:43 EDT 2015
I'm stuck trying to build 2.6.8. I added to my /etc/apt/sources.list:
deb-src http://archive.ubuntu.com/ubuntu utopic main restricted universe
But I fail at:
sudo apt-get build-dep gnucash
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to find a source package for gnucash
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
> <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