Re: [GNC] Income Statement versus Transaction Report

2023-07-20 Thread John Ralls
See https://bugs.gnucash.org/show_bug.cgi?id=797796. It has a long and detailed discussion about handling foreign-currency investments. CDB-Man is a licensed accountant practicing in Vancouver, BC. My take-away from that discussion is that GnuCash has painted itself into a corner by not

Re: [GNC] Income Statement versus Transaction Report

2023-07-20 Thread Adrien Monteleone
Ah. Interesting conundrum. Many moons ago that there was issue with some of the code for the various price options in reports. I don't recall the details, but I seem to remember that 'average' was thought to be the most accurate at the time, and there was discussion of removing the other

Re: [GNC] Income Statement versus Transaction Report

2023-07-19 Thread Fred Tydeman
On Wed, Jul 19, 2023 at 9:09 PM Steve Butler wrote: > Look on the currency tab if I remember correctly. > Transaction Report: Options: Currency: Price source: Last up through report date. Income Statement: Options: Commodities: Price source: Last up through report date. So, they are the same.

Re: [GNC] Income Statement versus Transaction Report

2023-07-19 Thread Fred Tydeman
On Wed, Jul 19, 2023 at 9:44 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I could be mistaken, but if you wanted each and every transaction to be > converted to the FX rate at the time of each transaction, then the only > way to do that would be with trading accounts turned on

Re: [GNC] Income Statement versus Transaction Report

2023-07-19 Thread Adrien Monteleone
I could be mistaken, but if you wanted each and every transaction to be converted to the FX rate at the time of each transaction, then the only way to do that would be with trading accounts turned on when you entered them. (or turn them on and re-create/edit each one, but that could be an

Re: [GNC] Income Statement versus Transaction Report

2023-07-19 Thread Fred Tydeman
On Wed, Jul 19, 2023 at 8:24 PM David Cousens wrote: > Fred, > > You may need to look at the report options for the transaction report to > ensure > they match the settings used for the income statement report particularly > the > setting for beginning and end dates and the account settings. >

Re: [GNC] Income Statement versus Transaction Report

2023-07-19 Thread Steve Butler
Look on the currency tab if I remember correctly. On Wed, Jul 19, 2023, 20:25 David Cousens wrote: > Fred, > > You may need to look at the report options for the transaction report to > ensure > they match the settings used for the income statement report particularly > the > setting for

Re: [GNC] Income Statement versus Transaction Report

2023-07-19 Thread David Cousens
Fred, You may need to look at the report options for the transaction report to ensure they match the settings used for the income statement report particularly the setting for beginning and end dates and the account settings. David Cousens On Wed, 2023-07-19 at 19:26 -0700, Fred Tydeman wrote:

[GNC] Income Statement versus Transaction Report

2023-07-19 Thread Fred Tydeman
In looking at Income Statement versus Transaction Report for just Income accounts for all of last year, the numbers do not match. My main currency is USD. However, for this file, all the income was in COP. Now, during the year the number of COP / USD varied a lot: from around 3748 to 4846; year