Re: [GNC] Advanced Portfolio report - missing stocks

2024-08-31 Thread Ken Farley
Looking at the Advanced Portfolio report it seems that there are only two calculations done for a security that involve a division: Rate of Gain and Rate of Return. Both of these calculations use Money In as the divisor. So I'd suspect that something is amiss with the security you are having

Re: [GNC] Advanced Portfolio report - missing stocks

2024-08-31 Thread David Carlson
The Advanced Portfolio Report is not supposed to include cash balances. Your broker's report also puts cash, if there is any, in a separate section. However, if you have a Bank type 'sweep' account to accumulate uninvested cash, that could be included. I do not have multiple currencies, so I do n

[GNC] Advanced Portfolio report - missing stocks

2024-08-31 Thread Fred Tydeman
I am a USA based person/book. Part of my COA looks like: asset Assets asset Fidelity asset Intl cash CAD Canada dollar stocks stockEIF:CA cash GBP Great Britain pound stocks stockRIO:GB Those two foreign stocks do NOT show up in the Advanced Portfolio

Re: [GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread Michael or Penny Novack
On 2/3/2024 2:13 PM, Dan O'Brien wrote: (With screen shot attached this time). I can’t make heads or tails of scheme code, so I’m not sure where to even look for the issue here. LOL You would want to have experience with LISP or at the very least, some experience with some "functional"

Re: [GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread sunfish62--- via gnucash-user
Still nope on the screenshot. Images must be attached, not inline. ⁣David T. ​ On Feb 3, 2024, 10:14 PM, at 10:14 PM, Dan O'Brien wrote: >(With screen shot attached this time). > >I can’t make heads or tails of scheme code, so I’m not sure where to >even look for the issue here. > >I’m using th

Re: [GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread Dan O'Brien
(With screen shot attached this time). I can’t make heads or tails of scheme code, so I’m not sure where to even look for the issue here. I’m using the Advanced Portfolio report and want to include a GnuCash account for certificates of deposit. The account is set up as an Asset and the Securit

Re: [GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread Stan Brown (using GC 4.14)
On 2024-02-03 09:16, Dan O'Brien wrote: > I’ve attached a screen shot of the report Please try again. You need to _attach_ the image, not _embed_ it. (If you can see the actual image in your message before you hit Send, you have embedded it rather than attaching it.) Stan Brown Tehachapi, CA, U

Re: [GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread Mark at Lorimark
your screenshot didn't come through. ~mark On 2/3/24 11:16, Dan O'Brien wrote: I can’t make heads or tails of scheme code, so I’m not sure where to even look for the issue here. I’m using the Advanced Portfolio report and want to include a GnuCash account for certificates of deposit. The acc

[GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread Dan O'Brien
I can’t make heads or tails of scheme code, so I’m not sure where to even look for the issue here. I’m using the Advanced Portfolio report and want to include a GnuCash account for certificates of deposit. The account is set up as an Asset and the Security/Currency is set to USD. When I run th

Re: [GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-14 Thread Gilberto Reis Filho
erring the sale > > > proceeds directly to bank, place it in a temporary account, say $Cash. > > > > > > Now open the $Cash account register and make a transfer to your bank with > > > the net proceeds after including a split for the tax deducted. > > > > &

Re: [GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-14 Thread Michael or Penny Novack
No, it not YET a "tax expense" but an asset. Maybe confused because both debit? In my country it is a tax expense at the moment you sell shares of a mutual fund. You cannot compensate for it when filing your tax report even if you lose money in the future. It is gone. Government calls it "exc

Re: [GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-14 Thread Gilberto Reis Filho
nsferring the sale > > proceeds directly to bank, place it in a temporary account, say $Cash. > > > > Now open the $Cash account register and make a transfer to your bank with > > the net proceeds after including a split for the tax deducted. > > > > This shoul

Re: [GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-14 Thread Michael or Penny Novack
2. Record the tax split in the sell transaction directing it to a transitory asset account and then recording a separate tax transaction in the transitory account directing it to the tax expense account. No, it not YET a "tax expense" but an asset. Maybe confused because both debit? Only w

Re: [GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-14 Thread Gilberto Reis Filho
--- > > Date: Wed, 13 Sep 2023 19:13:19 -0300 > From: Gilberto Reis Filho > To: gnucash-user@gnucash.org > Subject: [GNC] Advanced Portfolio Report - Brokerage Fees > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Hell

Re: [GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-13 Thread devaps
: Wed, 13 Sep 2023 19:13:19 -0300 From: Gilberto Reis Filho To: gnucash-user@gnucash.org Subject: [GNC] Advanced Portfolio Report - Brokerage Fees Message-ID: Content-Type: text/plain; charset="UTF-8" Hello. In my country whenever a person sells shares of a mutual fund the b

[GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-13 Thread Paras Desai
Hi The tax deducted at source before payout is kind of advance tax, and it becomes your tax credit. So ideally you should create an asset account named "advance Tax" or "Tax deducted at source" and post the deducted amount by bank in this asset account. You need to identify the brokerage fee s

[GNC] Advanced Portfolio Report - Brokerage Fees

2023-09-13 Thread Gilberto Reis Filho
Hello. In my country whenever a person sells shares of a mutual fund the bank has to calculate and pay taxes, on behalf of the investor, on capital gains before making the funds avaliable to the investor. The investor receives the funds in the brokerage account liquid of taxes. I am recording the

Re: [GNC] Advanced Portfolio report: missing income

2023-04-24 Thread Fred Tydeman
il 24, 2023 4:08 PM > *To:* Gnucash Users > *Subject:* [GNC] Advanced Portfolio report: missing income > > In the Advanced Portfolio report, I select All Accounts. > I get a report. It shows zeros for most of the stocks in the Income > column. > Yet, those stocks are paying di

Re: [GNC] Advanced Portfolio report: missing income

2023-04-24 Thread Murugan Muruganandam
From: gnucash-user on behalf of Fred Tydeman Sent: Monday, April 24, 2023 4:08 PM To: Gnucash Users Subject: [GNC] Advanced Portfolio report: missing income In the Advanced Portfolio report, I select All Accounts. I get a report. It shows zeros for most of the stocks in the Income column

[GNC] Advanced Portfolio report: missing income

2023-04-24 Thread Fred Tydeman
In the Advanced Portfolio report, I select All Accounts. I get a report. It shows zeros for most of the stocks in the Income column. Yet, those stocks are paying dividends. I then go back to the Options: Accounts and none of Income, Expenses, Liabilities, Equity, or Trading are selected (it appear

Re: [GNC] Advanced portfolio report - same stock in multiple investment accounts

2021-04-10 Thread Evelyn Yamanaka
Hi Mike, I've modified my Advanced Portfolio report to show the Account Path (e.g. "Investments:My-Broker:Account-1234") in place of the Listing (e.g. "NASDAQ"). For me, this is more useful info, and perhaps it would help with your situation. On Windows, the Advanced Portfolio report is normally

Re: [GNC] Advanced portfolio report - same stock in multiple investment accounts

2021-04-08 Thread Geoff
Hi Mike As a workaround, if you structure your accounts like this: Person01 --SecurityA --SecurityB --SecurityC Person02 --SecurityA --SecurityC --SecurityD Person03 --SecurityA --SecurityD --SecurityE etc You can save a separate Advanced Portfolio report for each person by using the Options t

[GNC] Advanced portfolio report - same stock in multiple investment accounts

2021-04-08 Thread mike823
Hi everyone, I am using the advanced portfolio report for tracking multiple investment accounts for family members, less than 20. One major issue I am having is that reporting can be done only by "account" which is the security and no information about account hierarchy is available in the report

[GNC] Advanced Portfolio Report Issues

2021-01-04 Thread Dale Alspach
I am trying to use the Advanced Portfolio report (flatpak gnucash 4.4 on linux mint) but have noticed some issues. Some may be attributable to problems with handling transactions with splits. A few seem to be actual bugs. For mutual funds it appears that transactions from income accounts are being

Re: [GNC] Advanced Portfolio Report Price Display Error

2019-04-05 Thread Mike Alexander
This may bug 797106, https://bugs.gnucash.org/show_bug.cgi?id=797106 or at least related to it. Mike > On Apr 5, 2019, at 6:41 PM, Richard Ullger wrote: > > Running the report today has displayed a price of > £24 + 4539353056850/46797454

[GNC] Advanced Portfolio Report Price Display Error

2019-04-05 Thread Richard Ullger
Running the report today has displayed a price of £24 + 4539353056850/4679745419433 for one of my holdings. The price database has a price of £24.97 loaded from Finance Quote. Edit/Preferences/General/Numbers/Force prices to display as decimals is selected. Gnucash 3.5 Build ID: git 3.5+(2019-03-

[GNC] Advanced Portfolio Report

2019-01-06 Thread Andrew Clark
Is there an explanation somewhere of the various columns presented in the advanced portfolio report? -- Cheers, Andrew. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnuc

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-15 Thread hal.lol
Weird, I didn't receive the latest message sent (from Richard), I just saw it now while browsing the mailing list archive...Anyway, thank you both for your answers, I finally understand what I was doing wrong! When I first tried to do this, I was selling the shares with the proceeds going to the

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread Richard Ullger
On 11/09/2018 19:57, hal@tutanota.com wrote: > Unfortunately no, this doesn't work. > I also tried to create a dummy "buy" split for 0 shares + the fees. This > works well for the brokerage fees when buying new shares. But buying 0 share > simply doesn't work... > 11. Sep 2018 19:55 by sunfis

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread hal.lol
Unfortunately no, this doesn't work. I also tried to create a dummy "buy" split for 0 shares + the fees. This works well for the brokerage fees when buying new shares. But buying 0 share simply doesn't work... 11. Sep 2018 19:55 by sunfis...@yahoo.com : > > Does creati

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread David T. via gnucash-user
Whether a gain is taxable or not is a separate issue from whether a sale results in gain, and the usual way (AFAIK) of handling taxed versus untaxed anything is to have separate accounts for each (Income:Realized Gains:Taxable and Income:Realized Gains:Untaxed). Does creating a transaction that

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread hal.lol
Right,and I can agree with this. It is just a bit confusing because that'sa “realized gain” not subject to taxation (AFAIK), wheras if the moneyended up on my account instead, then it would be. But taxationis not my concern for now, and I can live with that. What I reall

Re: [GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread David T. via gnucash-user
While I have no comment on how to get the Advanced Portfolio Report to categorize your fees as such, I will note that when you sell a commodity—regardless of the reason for which you sell it—you will have (in most cases) a capital gain element. The gain is there, even if you immediately turn th

[GNC] Advanced Portfolio Report - Fund managment fees

2018-09-11 Thread hal.lol
Hello, I have a mutual fund account for which the management fees are paid for in shares. That is to say, every years, some of my shares are used to pay for the fees and my total amount of shares is therefore slightly reduced. I am trying to setup my accounts/transactions in such a way that early