[GNC] Tracking cash flows with balanced transactions
Ove Grunnér
write2ove at gmail.com
Sat Aug 22 12:17:18 EDT 2020
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 <cleanoutmyshed at 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 <peterb at gmail.com
> > <mailto:peterb at 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 <cleanoutmyshed at gmail.com
> > <mailto:cleanoutmyshed at 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 at gnucash.org <mailto:gnucash-user at 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 at gnucash.org <mailto:gnucash-user at 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.
> >
>
More information about the gnucash-user
mailing list