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 <mat...@mapreri.org> Sent: Tuesday, April 25, 2023 7:23 AM To: Murugan Muruganandam <m.muruganan...@hotmail.com> Cc: gnucash-user@gnucash.org <gnucash-user@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....@gnucash.org> on behalf of > Mattia Rizzolo <mat...@mapreri.org> > Sent: Monday, April 24, 2023 9:44 AM > To: gnucash-user@gnucash.org <gnucash-user@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.muruganan...@hotmail.com> > To: Mattia Rizzolo <mat...@mapreri.org> > Subject: Re: [GNC] coalesce the stock accounts in the report > Message-ID: > <cp6p284mb16223deeb2f6eb5bc0f5835b9c...@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@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....@gnucash.org> on behalf of > > Mattia Rizzolo <mat...@mapreri.org> > > Sent: Wednesday, January 25, 2023 6:27 PM > > To: gnucash-user@gnucash.org <gnucash-user@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 `- _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
