Hi John. Thanks - you finally identified the cause of my issue. I'll try to set up my accounts differently, so that I will have both the "USD Cash" and the "VT" account under a placeholder account which is denominated in USD.
Thanks, F. https://www.instagram.com/boniforti_music https://soundcloud.com/boniforti_music https://bonny-j.bandcamp.com Am So., 10. Nov. 2024 um 20:05 Uhr schrieb John Ralls <[email protected]>: > Flavio, > > Your problem is that VT’s parent is IBKR and that’s denominated in CHF. > GnuCash sets the currency for non-currency accounts using the first parent > account that’s denominated in a currency. That has a couple of > consequences, the most significant being that if you start a transaction in > the VT register it will use CHF as the transaction currency that GnuCash > will use to balance the transaction, so when you buy in USD you’ll have to > price both the USD and VT into CHF, but if you start in the USD Cash > account the transaction currency will be in USD and so VT will be priced in > USD. Those prices will be reflected in the pricedb If you use > Finance::Quote GnuCash will ask it for VT prices in CHF. > > That’s not a situation GnuCash handles well. For an excruciatingly long > discussion see https://bugs.gnucash.org/show_bug.cgi?id=797796. One of > the commenters on that bug is CDB-Man, a licensed accountant in Canada. He > explains the formally correct way to account for investments denominated in > currencies other than the “book” currency. > > You’ll have less trouble if you put your non-CHF securities in sub > accounts denominated in the currencies they trade in, for example a > USD-Securities account denominated in USD for VT and recreating all of the > trading transactions so that they’re only in that currency. Make sure to > get a price for the security’s currency in CHF for the same day so you can > use the nearest-in-time price source to give reports the best chance of > converting things to CHF correctly—note that that doesn’t mean that they > will. The rollup of values on the Accounts page will always be at the > latest prices. > > Regards, > John Ralls > > > > On Nov 10, 2024, at 08:46, Boniforti Flavio <[email protected]> wrote: > > Hi Inma, thanks for your reply. > Indeed I see now where you got the "VT bought in CHF"! I now tried to buy > again 1 VT stock and looking at the price database, the new entry is also > in CHF. What does this depend on? I think this is the first thing I should > solve. Probably the fact that my VT purchases are registered in CHF, but > taken from an USD bank account, leads to them not appearing in the "USD > Cash" account in terms of numbers. > > Regarding the screenshot you shared with 4 entries: what accounts are "USD" > and "VT" there? I don't have these - I do have "Assets:Investments:IBKR:USD > Cash" and "Assets:Investments:IBKR:VT". > > Thanks again for your help, > F. > > > _______________________________________________ gnucash-user mailing list [email protected] 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.
