[GNC] moving stocks across accounts lost the basis price in the Portfolio report
Murugan Muruganandam
m.muruganandam at hotmail.com
Tue Apr 25 10:50:00 EDT 2023
hi Mattia
When moving securities across portfolio, if you do not want any profit/loss, then you have to register exact price which you have bought.
Expenses incurred earlier are what you paid for the transaction. This should not be grossed up in your pricing when you transfer; as this will result in Realized Loss in your original portfolio.
If you want to transfer the expenses also to a new expenses account, then you can add the following entries in the transfer transaction
Dr Investment:Stocks USD: AMZN: $1256.2 (Price $ 125.62, Qty 10)
Cr: Assets: Investments: Stock USD: AMZN : $1256.2 (Price $ 125.62, Qty -10)
Cr Expenses: fees:Investment: USD: $3.95
Dr Expenses: Fees: Stocks: USD: $3.95 (new expenses account)
Saludos Cordiales
Murugan
________________________________
From: Mattia Rizzolo <mattia at mapreri.org>
Sent: Tuesday, April 25, 2023 7:23 AM
To: Murugan Muruganandam <m.muruganandam at hotmail.com>
Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] moving stocks across accounts lost the basis price in the Portfolio report
Hello Murugan, and apologizes, it seems back in January I missed your
answer somehow!
So, I attached here a screenshot of just the AMZN stock which I moved
around. For the purposes of the move, I eneded up including the fees
into the basis price; normally I use the "gross pricing" method as I am
interested in tracking how much fees I pay and to whom. Do you think
this the correct way to handle this?
Incidentally, doing this also created a new entry in the price database,
with the price that I inserted there… (which is… wrong in this case,
isn't it? So I'll end up having to manually delete them all again?)
On Mon, Apr 24, 2023 at 02:42:51PM +0000, Murugan Muruganandam wrote:
>
> hi mattia
>
> this query was responded in January
>
>
> On the transfer transaction, you are transferring it with zero price.
> you need to transfer it with a cost price , then only system will recognize the profit/loss. in your transaction you are buying and selling at 0 price , so the system considers it as 100% loss
>
> please look at the sample images attached in the email
>
>
> Saludos Cordiales
>
>
> Murugan
>
> ________________________________
> From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of Mattia Rizzolo <mattia at mapreri.org>
> Sent: Monday, April 24, 2023 9:44 AM
> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Subject: [GNC] moving stocks across accounts lost the basis price in the Portfolio report
>
> Hello,
>
> A couple of weeks ago I had some stocks moved across different accounts.
>
> In gnucash, I tried recording them as this, for example:
>
> shares price debit credit
> A:Investements:Broker1:P1:USD:AMZN -10
> A:Investements:Broker1:P2:USD:AMZN 10
>
> I left price/debit/credit completely empty, and no other split.
>
> I noticed a few days later that these transactions (I moved roughly a
> dozen titles) generated some prices in the Price Database, adding a
> recorded price of $0 for all the stocks that were involved in this move;
> I noticed this when I had a glance at the net worth report and noticed a
> stupid downward peak. So I removed the faulty prices from the database
> and now that looks correct.
>
> Even more recently I was looking at the "Advance Portfolio" report, and
> realized now that all the stocks that were involved in this move seem to
> have a "Basis" of €0.00 (and also money-in/money-out).
>
> This seems to be caused by the fact that in the Advanced Portfolio each
> account is on its own, so unticking the "Include accounts with no
> shares" I noticed that, limiting to my example above, I have two AMZN
> lines:
> * one with 0 shares, 0€ money out, -100.00% realized loss.
> * one with 10 shares, 0€ money in/out, 0€ basis, and empty cells (due
> to the 0€ basis, which I guess would cause divide-by-zero errors)
> (I mentioned a related issue I had with this here:
> https://lists.gnucash.org/pipermail/gnucash-user/2023-January/105229.html
> )
>
>
> How do you recommend I fix this situation? Should I just add a price to
> the transactions to give them a basis, or what else? If I did that, how
> could I also "carry over" the fees accrued till now? Just manually
> compute them in the "new basis"?
>
>
> Thank you for your suggestions.
>
>
>
> PS: For some stocks I could potentially rename the accounts instead of
> doing this move, but this wouldn't be possible for all stocks, as both
> portfolios (in the same broker, yes) have shares of the same companies
> that I need to keep separate.
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
> More about me: https://mapreri.org : :' :
> Launchpad user: https://launchpad.net/~mapreri `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
> Date: Fri, 27 Jan 2023 02:16:03 +0000
> From: Murugan Muruganandam <m.muruganandam at hotmail.com>
> To: Mattia Rizzolo <mattia at mapreri.org>
> Subject: Re: [GNC] coalesce the stock accounts in the report
> Message-ID: <CP6P284MB16223DEEB2F6EB5BC0F5835B9CCC9 at CP6P284MB1622.BRAP284.PROD.OUTLOOK.COM>
>
> Mattia
>
> you can export the portfolio report as .html. Then you can import it into a spreadsheet and you can manipulate the data
>
> On the transfer transaction, you are transferring it with zero price.
> you need to transfer it with a cost price , then only system will recognize the profit/loss. in your transaction you are buying and selling at 0 price , so the system considers it as 100% loss
>
> attached 3 images for your review, hope it helps
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> ________________________________
> From: Mattia Rizzolo
> Sent: Thursday, January 26, 2023 5:07 PM
> To: Murugan Muruganandam
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] coalesce the stock accounts in the report
>
> Could you please tell me how to export this single report in something
> usable in a spreadsheet?
>
> Also, attached are 3 screenshots.
> I have this broker that I use to "try out" some things, and if I feel so
> I move them to anothe account later (this is mostly to take advantage
> of different fees and leverage options).
>
> So here are 2 ETFs, and then an excerpt of what the "advance portfolio
> report" shows of them.
>
>
>
> On Thu, Jan 26, 2023 at 07:27:12PM +0000, Murugan Muruganandam wrote:
> > Mattia
> >
> > a faster and less invasive solution is to extract the Advanced Portfolio into a spread sheet and create a Pivot table which can consolidate the data at Stock level
> >
> > I have a question though, when you moved your stocks between broker what was the operation you did which reflected 100% loss
> >
> >
> >
> >
> > Saludos Cordiales
> >
> >
> > Murugan
> >
> > ________________________________
> > From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of Mattia Rizzolo <mattia at mapreri.org>
> > Sent: Wednesday, January 25, 2023 6:27 PM
> > To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> > Subject: [GNC] coalesce the stock accounts in the report
> >
> > Hello,
> >
> > I own several stocks across multiple brokers, so I have an account
> > structure that, roughly, looks like this:
> >
> > Assets
> > |- Bank1
> > | |- EUR
> > | |- Stocks EUR
> > | |- AAA
> > | |- BBB
> > | |- CCC
> > |- Bank2
> > |- EUR
> > |- Stocks EUR
> > |- BBB
> >
> > So, in this simple case, I hold 4 different stocks across two brokers,
> > of which one (BBB) is held in two places at the same time.
> >
> > In this situation the "Advanced Portfolio" report lists:
> > AAA
> > BBB
> > CCC
> > BBB
> >
> > Duplicating BBB and listing it separately between the accounts.
> >
> > I get why this might be interesting in some cases, but for my uses I
> > have really have no interest in having a separated view in this report;
> > it's actually quite confusing right now as I had cases in the past where
> > I moved holdings across different brokers (without liquidating the
> > position, directly moving the titles), and this seems to be recorded
> > actually as a 100% loss (?!!) in the report. Sure I can tick the "hide
> > accounts with no shares" options, but I also had cases where I only
> > partially moved a position so I still hold some shares in both places.
> >
> > Any suggestion on what I could do?
> >
> > Clearly I can't unify the accounts as I do need to keep them separated.
> >
> > Thank you in advance for your insights!
> >
> > --
> > regards,
> > Mattia Rizzolo
> >
> > GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
> > More about me: https://mapreri.org : :' :
> > Launchpad user: https://launchpad.net/~mapreri `. `'`
> > Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
> More about me: https://mapreri.org : :' :
> Launchpad user: https://launchpad.net/~mapreri `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
More information about the gnucash-user
mailing list