Many thanks Geoff, It works perfectly, I now realise why I could not get CSV to work previously, as I assumed that "Transaction Commodity" should be the Stock, but I see now it should be the currency of the trade. The other thing that threw me was that when using a fraction for "Price" I had to add an equal sign " =7/100 " when I buy or sell stock.
So I now have Buy, Sell, Dividend & Fee working as multi line CSV import, all that is left now is to code it. :-) Many thanks Ove. On Sat, 22 Aug 2020 at 12:56, Geoff <cleanoutmys...@gmail.com> wrote: > Well, Ove, if you are prepared to roll up your sleeves and have a crack > at using the fancy newfangled "Import Transactions from CSV" > wizard/druid, then you can uncross your fingers and get to work > importing multi-split transactions including zero stock transactions. > > Attached are step by step screenshots and a sample CSV file. > > First time around you will need to specify the account mappings, but > gnucash remembers them: Tools / Import Map Editor / Non-Bayesian / CSV > Account Map. > > Don't forget to save your import settings after you map the import > columns - screenshot #01. > > Good luck! > > Geoff > ===== > > On 21/08/2020 8:20 pm, Ove Grunnér wrote: > > I would like to be able to do this as well, however I create QIF files > > from my investment account and then import it. > > I convert exports from DEGIRO programmatically into QIF to avoid having > > to enter transactions manually. > > The problem being that when I import the transaction as an investment, > > then GnuCash will not let me do a split, and when I import as a bank > > account, then it will not let me do a stock. > > > > Is there a way to import this using a QIF file and it ends up with a > > split containing a zero stock transaction and then the dividend? > > > > fingers crossed, > > > > Ove. > > > > On Thu, 20 Aug 2020 at 14:23, peterb <pet...@gmail.com > > <mailto:pet...@gmail.com>> wrote: > > > > Oh, I like that a lot, that's much more elegant than what I was > > experimenting with. Somehow it didn't occur to me that a zero-value > > split > > would still show up in the register...even though I've seen that > happen > > when I've included one by accident. > > > > Thank you! > > > > -Peter > > > > On Thu, Aug 20, 2020 at 3:40 AM Geoff <cleanoutmys...@gmail.com > > <mailto:cleanoutmys...@gmail.com>> wrote: > > > > > Peter, this is the way that I do it, and it doesn't require > > double entry > > > of the transactions. > > > > > > Simply "tag" all dividend payments when they arrive in the bank > > account > > > with the relevant stock account - you do this by entering a third > > (zero > > > value) split. > > > > > > The dividend will then automatically show up in the stock's > register. > > > > > > The "Advanced Portfolio" report will also automatically include > the > > > dividend income as part of its return calculations. > > > > > > Hope this helps - please see the attached screenshot. > > > > > > Regards > > > > > > Geoff > > > ===== > > > P.S. This is mentioned in Chapter 9.8: > > > > https://code.gnucash.org/docs/C/gnucash-guide/invest-dividends1.html > > > > > > On 20/08/2020 2:01 pm, peterb wrote: > > > > Let's say I have a security - could be a stock, or a bond - > which > > > > periodically yields some dividend or interest. Often it's > > convenient to > > > be > > > > able to see those dividends in a single register. > > > > > > > > The vanilla way to account for dividends or interest doesn't > > quite make > > > > this easy: the obvious way to do it will appear in your > brokerage > > > register, > > > > but not in the register for the stock. And that makes perfect > > sense - > > > the > > > > money isn't going in to your stock account! > > > > > > > > Description Account Debit Credit > > > > Dividend BIGCO Assets:Brokerage 50 > > > > Income:Dividend 50 > > > > > > > > If you're disciplined about your descriptions you can of course > > search > > > for > > > > these, but it feels potentially error prone when looking for > them. > > > > > > > > I'm on record as not liking the way GnuCash handles realized > > income/loss > > > > from sales in stock accounts (putting "zero share" dollar > > values in the > > > > share-denominated register instead of explicitly treating stock > > sales as > > > > return-of-capital plus gain/loss) but it occurs to me that you > > can do > > > > something similar for dividends and interest: > > > > > > > > Description Account Debit Credit > > > > Dividend BIGCO Assets:Brokerage:BIGCO 50 > > > > Assets:Brokerage 50 > > > > Income:Dividend 50 > > > > Assets:Brokerage:BIGCO 50 > > > > > > > > The idea here being: the income flows into the > > BIGCO-denominated account, > > > > but immediately flows out again into the cash-denominated > > account; if one > > > > looks at the BIGCO register, all of the dividend events will be > > clearly > > > > visible. > > > > > > > > Does anyone have either a more elegant way of accomplishing the > > goal of > > > > "all cash flows from a stock are visible on the stock's > > register", or a > > > > good reason *not* to do what I'm giving an example of here? > > > > (Alternatively, if this is in fact what everyone does as > > described in > > > > chapter 7853.633 of the user guide, and I just missed it, > > please let me > > > > know!) > > > > > > > > Thanks! > > > > > > > > -Peter > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > If you are using Nabble or Gmane, please see > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > > ----- > > > > 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@gnucash.org <mailto:gnucash-user@gnucash.org> > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > ----- > > 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
