Re: [GNC] Reply convention
On Tue, Jul 18, 2023 at 03:28:34PM -0500, R Losey wrote: > On Mon, Jul 17, 2023 at 3:37 AM Paul Feakins wrote: > > > On 15/07/2023 01:56, R Losey wrote: > > > Is there really a convention for replies? > > > > Indeed there is: > > https://wiki.openstack.org/wiki/MailingListEtiquette#Replies > > > > > Thanks for the link; it isn't specific to GnuCash, but that's okay. > > However, it does seem outdated - limiting a line to 72 characters when most > browsers and email clients are capable of doing line wrap? > Yes, but eyes aren't! Something around 80 characters (i.e. 72 plus a bit) is the best line length for our eyes to read. > And plain text only? > What else are you going to do? Anything more is likely to be differently interpreted by different users' software so the result you intend is likely to be lost on many users. There are standard ways of indicating emphasis and such using just plain text. -- Chris Green ___ 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.
Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'
On 7/18/23 1:07 PM, larry johnston wrote:
Hi,
I did not try to upgrade when I asked this question three years ago.
However my computer is on its last legs so I am trying to decide what to do
when I get the new computer.
We have been using GNUCash 2.6.15 and it has met our needs for our personal
finances. A key feature for us is Phil's YTD report. Per the discussion in
this string his report will not work in more recent versions. As a result I
have a few questions.
Will 2.6.15 run on Windows 11? Can it still be downloaded?
First a direct answer:
I don't know, but I'm sure It doesn't hurt to try. Maybe someone with
Win11 can try installing it to see and report back. (best I have is
access to Win10)
*note, the advice below sounds like a lot of work and reading. It is.
That's the tradeoff when you wait to upgrade. You don't put off the
work, you just scrunch it into 'one shot' later.
-
Second, about finding the older versions:
You can find it along with all other versions on SourceForge. (the
official location of all GnuCash Downloads)
https://sourceforge.net/projects/gnucash/files/
Click the '(stable)' folder, then the folder for the version you want,
then click the installer you need. ('.exe' in your case)
If you ever need to get back there again - simply go to GnuCash.org and
click the 'More downloads' link in the Download section at the top of
the page. That will take you to: https://gnucash.org/download.phtml
(there is also a Downloads section in the site menu, you can download
'program' or 'documentation' from there)
On that page, scroll to the bottom and choose the link for 'View all
GnuCash downloads' which takes you to the above SourceForge page.
Use this to find any old version. (necessary for your upgrade path
should you take it)
Despite the cutoff of old versions for old operating systems, there is
no hard rule that a *newer* version of GnuCash won't run on say, XP or
Win7, just that the devs don't support it and you are on your own
trying. I've never heard of any issue with old versions of *GnuCash*
running on *newer* operating system versions. (your case)
-
Third, upgrade path:
Read this over first:
https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade
With all that out of the way, and understanding it (ask back here on the
list if you have questions) you can proceed.
MAKE BACKUPS! (or at least some sort of copy of your data file in
between *each* upgrade) That way if you have any problems or notice any
sort of data corruption, you can step back and try again.
See this FAQ on Backups:
https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups
You may want to backup your 'environment' as well as your data - so
don't skip that section!
(yes, you will need to get familiar with the various file locations to
seamlessly pull this off)
now, to really proceed with the upgrade...
In your case, you would first want to upgrade to the last release of the
2.6.x series, 2.6.21
Then you would step to the last of the 3.x series, then last of 4.x,
then finally the current 5.x release which is 5.3.
Those releases in order would be:
2.6.15 -> 2.6.21 -> 3.11 -> 4.14 -> 5.3
Be sure (as noted in the above FAQ answer) to run Actions > Check &
Repair > Check & Repair All after first opening your file when you do
*each* upgrade. This is important. It should take only a few seconds,
but some data files might take longer. Report back here if you have any
issues.
-
Fourth, other options:
In a worst case, if you need to upgrade the computer to a new physical
machine running Win11, and 2.6.15 doesn't install or run, you could try
running 2.6.15 in a Virtual Machine. (either running your previous
version of Windows, or Linux) That is a tad bit technical, but not
terribly so these days. It is essentially running the old OS inside an
'app'. There are even ways to migrate your current computer
installation, software, data and all, to a Virtual Machine. I have set
up Virtual Machines (VMs) for several non-techy family members and they
use it with no problems.
If you end up needing that sort of solution, there are several of us
here who can help, even though that isn't specific to GnuCash. (and
there is plenty of help on the web for that too)
Lastly, don't rule that old rustbucket out. It may be possible to
'refresh' it simply by reinstalling Windows, possibly upgrading some
internal hardware, or switching to an appropriate version of Linux.
You'd be amazed how either of those approaches can revitalize aging
hardware to like-new performance. (or better in some cases!)
Does a later version have a report with the same functionality as Phil's
YTD report?
I think Chris answered this, but specifically we'd need Phil's report
(or at least a sample of its output) to know for sure.
To your more detailed question:
Does the current Budget Report give YTD figures?
Yes, using the 'accumulated amo
Re: [GNC] Reply convention
On 18 July 2023 at 15:32, R Losey said: [...] > I don't think the rules can be "imposed", but if there were something in > the header or if there was something in the monthly reminder about the > etiquette of posting, that would be a big help to users that there is a > "right" way to post. You might think so, but the Digests tell recipients | When replying, please edit your Subject line so it is more specific | than "Re: Contents of gnucash-user digest..." and that seems to be honoured more in the breach than the observance. One can always hope ... ___ 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.
Re: [GNC] Year to Date Budget Report
Larry, it was there. I answered in that existing thread. (and I see you replied there too) Regards, Adrien On 7/18/23 4:55 PM, larry johnston wrote: Hi, I thought I posted this question to the list earlier today but I did not see it come through on the feed. So forgive me if it is already out there. ___ 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.
Re: [GNC] Year to Date Budget Report
Adrien, The original thread was three years ago. Has there been any changes to 'use accumulated amounts' report? Larry On Wed, Jul 19, 2023 at 9:32 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Larry, it was there. I answered in that existing thread. (and I see you > replied there too) > > Regards, > Adrien > > On 7/18/23 4:55 PM, larry johnston wrote: > > Hi, > > > > I thought I posted this question to the list earlier today but I did not > > see it come through on the feed. So forgive me if it is already out > there. > > ___ > 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. > ___ 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.
Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'
Adrien,
Thanks for the information.
I think I will install the latest version and try the 'use accumulated
totals' report with a test file. If it works then make the jump. I have an
old laptop that is running 2.6.15 if I have to access the old files.
Rebuilding the Chart of Accounts seems easier than the upgrade process.
Larry
On Wed, Jul 19, 2023 at 9:27 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> On 7/18/23 1:07 PM, larry johnston wrote:
> > Hi,
> >
> > I did not try to upgrade when I asked this question three years ago.
> > However my computer is on its last legs so I am trying to decide what to
> do
> > when I get the new computer.
> >
> > We have been using GNUCash 2.6.15 and it has met our needs for our
> personal
> > finances. A key feature for us is Phil's YTD report. Per the discussion
> in
> > this string his report will not work in more recent versions. As a
> result I
> > have a few questions.
> >
> > Will 2.6.15 run on Windows 11? Can it still be downloaded?
>
> First a direct answer:
>
> I don't know, but I'm sure It doesn't hurt to try. Maybe someone with
> Win11 can try installing it to see and report back. (best I have is
> access to Win10)
>
> *note, the advice below sounds like a lot of work and reading. It is.
> That's the tradeoff when you wait to upgrade. You don't put off the
> work, you just scrunch it into 'one shot' later.
>
>
>
> -
> Second, about finding the older versions:
>
> You can find it along with all other versions on SourceForge. (the
> official location of all GnuCash Downloads)
>
> https://sourceforge.net/projects/gnucash/files/
>
> Click the '(stable)' folder, then the folder for the version you want,
> then click the installer you need. ('.exe' in your case)
>
> If you ever need to get back there again - simply go to GnuCash.org and
> click the 'More downloads' link in the Download section at the top of
> the page. That will take you to: https://gnucash.org/download.phtml
> (there is also a Downloads section in the site menu, you can download
> 'program' or 'documentation' from there)
>
> On that page, scroll to the bottom and choose the link for 'View all
> GnuCash downloads' which takes you to the above SourceForge page.
>
> Use this to find any old version. (necessary for your upgrade path
> should you take it)
>
> Despite the cutoff of old versions for old operating systems, there is
> no hard rule that a *newer* version of GnuCash won't run on say, XP or
> Win7, just that the devs don't support it and you are on your own
> trying. I've never heard of any issue with old versions of *GnuCash*
> running on *newer* operating system versions. (your case)
>
>
>
> -
> Third, upgrade path:
>
> Read this over first:
>
> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade
>
> With all that out of the way, and understanding it (ask back here on the
> list if you have questions) you can proceed.
>
> MAKE BACKUPS! (or at least some sort of copy of your data file in
> between *each* upgrade) That way if you have any problems or notice any
> sort of data corruption, you can step back and try again.
>
> See this FAQ on Backups:
> https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups
>
> You may want to backup your 'environment' as well as your data - so
> don't skip that section!
>
> (yes, you will need to get familiar with the various file locations to
> seamlessly pull this off)
>
> now, to really proceed with the upgrade...
>
> In your case, you would first want to upgrade to the last release of the
> 2.6.x series, 2.6.21
>
> Then you would step to the last of the 3.x series, then last of 4.x,
> then finally the current 5.x release which is 5.3.
>
> Those releases in order would be:
>
> 2.6.15 -> 2.6.21 -> 3.11 -> 4.14 -> 5.3
>
> Be sure (as noted in the above FAQ answer) to run Actions > Check &
> Repair > Check & Repair All after first opening your file when you do
> *each* upgrade. This is important. It should take only a few seconds,
> but some data files might take longer. Report back here if you have any
> issues.
>
>
>
> -
> Fourth, other options:
>
> In a worst case, if you need to upgrade the computer to a new physical
> machine running Win11, and 2.6.15 doesn't install or run, you could try
> running 2.6.15 in a Virtual Machine. (either running your previous
> version of Windows, or Linux) That is a tad bit technical, but not
> terribly so these days. It is essentially running the old OS inside an
> 'app'. There are even ways to migrate your current computer
> installation, software, data and all, to a Virtual Machine. I have set
> up Virtual Machines (VMs) for several non-techy family members and they
> use it with no problems.
>
> If you end up needing that sort of solution, there are several of us
> here who can help, even though that isn't specific to GnuCash. (and
> there is plenty of help on the web for that too)
>
> Lastly, don't rule that old rustbucket out. It may be possible to
> 'refres
Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'
I forgot about that option. For completeness, what you are describing is to start with the new version on a new computer with a fresh file, then just use your ending figures from the 2.6.15 file as 'opening balances' in the new file, correct? Note, you can start entirely fresh, or if you like, you can export just the Chart of Accounts from 2.6.15, import it to 5.3, and then manipulate it from there. The upgrade path isn't as terrible as it sounds, and it would allow you to preserve in-app access to historical data. But by all means, chart your own course. You have lots of options. Regards, Adrien On 7/19/23 12:57 PM, larry johnston wrote: I think I will install the latest version and try the 'use accumulated totals' report with a test file. If it works then make the jump. I have an old laptop that is running 2.6.15 if I have to access the old files. Rebuilding the Chart of Accounts seems easier than the upgrade process. ___ 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.
Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'
On 2023-07-19 09:25, Adrien Monteleone wrote: > On 7/18/23 1:07 PM, larry johnston wrote: >> Will 2.6.15 run on Windows 11? Can it still be downloaded? > > First a direct answer: > > I don't know, but I'm sure It doesn't hurt to try. Maybe someone with > Win11 can try installing it to see and report back. (best I have is > access to Win10) I have 2.6.19, and it runs just fine on Windows 10 and 11. I can't imagine 2.6.15 would be any different. (I've been very short of time for months, and haven't had time to follow through on my intention to move to 5.x.) Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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.
Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies
On 7/18/23 10:34 AM, John Ralls wrote: YahooJSON and now YahooWeb are already doing the GBX->GBP conversion (not my doing). Easy because both of those sources have the pricing currency in the data returned. I hope you are not suggesting that the conversion is removed from both of those modules? I'm not. I'm pointing out the disadvantages of handling the pricing issue on the client side. Okay. I think it would be reasonable assumption that Finance::Quote returns pricing in ISO-4217 currencies. But definitely a quagmire when faced with an issue like this one. Roger, but slowing AV down to 5 quotes/2 minutes will make it pretty useless for anyone with even a small number of LSE stocks. Users already gripe about the 5/sec throttling. Which is why I posed the original question. Aside from the two of us having this wonderful exchange of ideas, no one else stepped in to say "Hey! I get some LSE traded stock data from AlphaVantage, and doubling the time it takes to get quotes would annoy the heck out of me!". At this point, the only one to raise an issue is someone that could deal with it as is for all I care. To clarify, are you suggesting have AlphaVantage check for the additional (let's say ".X") suffix? Or any quote source? Much easier to accomplish on a per module basis, than F::Q in general. But as stated, that means the user needs to know to use GBP.L.X (Global Petroleum) for AV to return GBP, but YahooJSON does not need the extra ".X". Then again, that's what man pages are for... ;) Yes, I think that's the best alternative to asking AV for the currency. Another that we haven't discussed would be caching the results somewhere, but that conflicts with F::Q's stateless design. Alright. At some point I'll have AlphaVantage look for symbols supplied with an additional '.X' suffix. If it's given, divide the pricing info by 100. If not, leave it be. Of course I'll add info on this to the manpage/POD. I'll also ping AV support again. I was told they would look into adding the currency to the JSON returned from the GLOBAL_QUOTE API which would make my job a zillion times easier. Thanks again John. Bruce S. ___ 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.
Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'
Hi, Yes, I was thinking of starting over with 5.3. If I could import the Chart of Accounts from 2.6.15 that would be great. Larry On Wed, Jul 19, 2023, 11:17 a.m. Stan Brown (using GC 2.6.19) < stan+gnuc...@fastmail.fm> wrote: > On 2023-07-19 09:25, Adrien Monteleone wrote: > > On 7/18/23 1:07 PM, larry johnston wrote: > >> Will 2.6.15 run on Windows 11? Can it still be downloaded? > > > > First a direct answer: > > > > I don't know, but I'm sure It doesn't hurt to try. Maybe someone with > > Win11 can try installing it to see and report back. (best I have is > > access to Win10) > > I have 2.6.19, and it runs just fine on Windows 10 and 11. I can't > imagine 2.6.15 would be any different. > > (I've been very short of time for months, and haven't had time to follow > through on my intention to move to 5.x.) > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > ___ > 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. > ___ 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.
Re: [GNC] Reply convention
On Wed, Jul 19, 2023 at 11:30 AM Fred Bone wrote: > On 18 July 2023 at 15:32, R Losey said: > > [...] > > I don't think the rules can be "imposed", but if there were something in > > the header or if there was something in the monthly reminder about the > > etiquette of posting, that would be a big help to users that there is a > > "right" way to post. > > You might think so, but the Digests tell recipients > > | When replying, please edit your Subject line so it is more specific > | than "Re: Contents of gnucash-user digest..." > > and that seems to be honoured more in the breach than the observance. > > One can always hope ... > I agree with everything you said, but if they would say that there is a standard, others could note it in those that don't follow it (much as I see various people reminding people to include the group in replies). _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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.
Re: [GNC] Reply convention
On Wed, Jul 19, 2023 at 5:05 AM Chris Green wrote: > On Tue, Jul 18, 2023 at 03:28:34PM -0500, R Losey wrote: > > On Mon, Jul 17, 2023 at 3:37 AM Paul Feakins wrote: > > > > > On 15/07/2023 01:56, R Losey wrote: > > > > Is there really a convention for replies? > > > > > > Indeed there is: > > > https://wiki.openstack.org/wiki/MailingListEtiquette#Replies > > > > > > > > Thanks for the link; it isn't specific to GnuCash, but that's okay. > > > > However, it does seem outdated - limiting a line to 72 characters when > most > > browsers and email clients are capable of doing line wrap? > > > Yes, but eyes aren't! Something around 80 characters (i.e. 72 plus a > bit) is the best line length for our eyes to read. > > > > And plain text only? > > > What else are you going to do? Anything more is likely to be > differently interpreted by different users' software so the result you > intend is likely to be lost on many users. There are standard ways of > indicating emphasis and such using just plain text. > > This doesn't appear to be plain text... perhaps I'm associating plain text with fixed-width fonts. But if this works, that's fine. Regarding line length, I thought you could set your browser or email client to wrap at whatever length one wishes. _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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.
[GNC] "Comparative" reports?
Hi all, I just got home from a very positive meeting with my CPA (showing them my books, since I took over my own bookkeeping, and thereby also showing them GnC, with which they were impressed). They raised a question; Is there a built in mechanism for "comparative" reporting? For example, showing income from Jan 1 to date, alongside income over the same months in the previous year? Clearly not a big deal, since I can just create two reports and print them then look at them side by side, but it's what that "other" program does, and it makes them feel cozy. Currently I'm using v4, but now I know they're happy I will be upgrading to 5.x in the next month or so. TIA, Simon -- Simon Roberts (303) 249 3613 ___ 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.
Re: [GNC] "Comparative" reports?
Not only can you create the two reports, export them, and print them to look at side by side. But you can also use your favorite full function editor to place them side by side. And do not that some editing might be necessary in any case because the reports from consecutive periods might not line up line by line (the CoA might have changed). And that also lets you annotate any unusual items. And level of detail could be different in different versions depending on audience. Mind I was Treasurer of a number of orgs and current year vs past year customary. Since at the time I was a recently retired pro, and although not fluent, could at least read/understand LISP (scheme is a LISP dialect) I asked the fellow board member of one org who was a lawyer/accountant should I create such custom reports. He said, "Mike, don't bother. Export the raw reports and assemble the finished product using a full function editor." Besides what has already been mentioned, can pretty print, insert logos, insert fixed text depreciation policy> Built in is good if/f it does exactly what you want/need. Michael D Novack On 7/19/2023 7:00 PM, Simon Roberts wrote: Hi all, I just got home from a very positive meeting with my CPA (showing them my books, since I took over my own bookkeeping, and thereby also showing them GnC, with which they were impressed). They raised a question; Is there a built in mechanism for "comparative" reporting? For example, showing income from Jan 1 to date, alongside income over the same months in the previous year? Clearly not a big deal, since I can just create two reports and print them then look at them side by side, but it's what that "other" program does, and it makes them feel cozy. ___ 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.
Re: [GNC] "Comparative" reports?
On 2023-07-19 07:00 PM, Simon Roberts wrote: They raised a question; Is there a built in mechanism for "comparative" reporting? For example, showing income from Jan 1 to date, alongside income over the same months in the previous year? In GnuCash 5.1 (not sure when feature first showed up, but I think it was recent), you can do this for nice divisions such as year, half-year, quarter, month, 2-weeks, and week. Reports > Income & Expense > Income Statement (Multicolumn) or Reports > Assets & Liabilities > Balance Sheet (Multicolumn) In Options > top tab General, choose Period Duration of how you want the info split, then choose start and end dates appropriately. For example, if you choose Half Year with Start Jan 1 2021 and End Dec 31 2023, it will show you columns for the six months ending on / as of date: 2021 June 30 2021 Dec 31 2022 June 30 2022 Dec 31 2023 June 30 2023 Dec 31 - though this one won't have much activity yet! It is an excellent pair of reports. You can of course paste them into a spreadsheet program and remove whatever columns you don't find useful :) If you want some odd period that doesn't line up with your fiscal year like February 23 - April 5, then you'll have to run separate reports and not use these nice ones. Enjoy! NoobAlice ___ 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.
[GNC] Income Statement versus Transaction Report
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 end was 4846. For Report Options, I am picking: Commodities: Price Source: Last up through report date. It appears that the Income Statement sums up all the COP for the year and uses the year end COP/USD value. While the Transaction Report uses the month end COP/USD value for the transactions in that month. I believe that the US tax people want foreign transaction values converted to USD at the time of the transaction (not use the year end COP/USD value). So, I think the Transaction Report has the correct values. Is there a way to have the Income Statement use values like the Transaction Report? ___ 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.
Re: [GNC] Income Statement versus Transaction Report
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: > 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 end was 4846. > > For Report Options, I am picking: > Commodities: Price Source: Last up through report date. > > It appears that the Income Statement sums up all the COP > for the year and uses the year end COP/USD value. > > While the Transaction Report uses the month end COP/USD value > for the transactions in that month. > > I believe that the US tax people want foreign transaction values > converted to USD at the time of the transaction (not use the > year end COP/USD value). So, I think the Transaction Report > has the correct values. > > Is there a way to have the Income Statement use values like the > Transaction Report? > ___ > 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. ___ 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.
Re: [GNC] Income Statement versus Transaction Report
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 beginning and end dates and the account settings. > > David Cousens > > On Wed, 2023-07-19 at 19:26 -0700, Fred Tydeman wrote: > > 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 end was 4846. > > > > For Report Options, I am picking: > >Commodities: Price Source: Last up through report date. > > > > It appears that the Income Statement sums up all the COP > > for the year and uses the year end COP/USD value. > > > > While the Transaction Report uses the month end COP/USD value > > for the transactions in that month. > > > > I believe that the US tax people want foreign transaction values > > converted to USD at the time of the transaction (not use the > > year end COP/USD value). So, I think the Transaction Report > > has the correct values. > > > > Is there a way to have the Income Statement use values like the > > Transaction Report? > > ___ > > 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. > > ___ > 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. > ___ 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.
Re: [GNC] Income Statement versus Transaction Report
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. > Both reports are: Start of previous year and End of previous year Both reports select all the Income accounts. In playing around, if I change Commodities: Price Source: to Weighted average of all transactions in the past, then the two reports match. But, the Transaction report is using the same COP/USD conversion for each month (instead of the proper monthly conversion rate). ___ 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.
Re: [GNC] "Comparative" reports?
In addition to the new multi-column ability of some reports as NoobAlice pointed out, you can also run old-school 'Custom Multi Column' reports which lets you put multiple reports into 'one'. You can of course further manipulate this in a spreadhsheet app as Michael noted. Regards, Adrien On 7/19/23 6:00 PM, Simon Roberts wrote: Hi all, I just got home from a very positive meeting with my CPA (showing them my books, since I took over my own bookkeeping, and thereby also showing them GnC, with which they were impressed). They raised a question; Is there a built in mechanism for "comparative" reporting? For example, showing income from Jan 1 to date, alongside income over the same months in the previous year? Clearly not a big deal, since I can just create two reports and print them then look at them side by side, but it's what that "other" program does, and it makes them feel cozy. Currently I'm using v4, but now I know they're happy I will be upgrading to 5.x in the next month or so. ___ 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.
Re: [GNC] Income Statement versus Transaction Report
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 enormous amount of work.) In such a case, trading splits are added to cross-currency transactions when they are entered. Regards, Adrien On 7/19/23 11:32 PM, Fred Tydeman wrote: Both reports are: Start of previous year and End of previous year Both reports select all the Income accounts. In playing around, if I change Commodities: Price Source: to Weighted average of all transactions in the past, then the two reports match. But, the Transaction report is using the same COP/USD conversion for each month (instead of the proper monthly conversion rate). ___ 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.
Re: [GNC] Income Statement versus Transaction Report
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 when you entered > them. (or turn them on and re-create/edit each one, but that could be an > enormous amount of work.) > > In such a case, trading splits are added to cross-currency transactions > when they are entered. > I have Trading turned on. The income accounts in question are using COP as their currency. Transactions in those accounts do not show any splits for Trading. Income in those accounts is coming from an Asset account that also is in COP. So, there is no conversion between COP and USD involved in that transaction. ___ 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.
Re: [GNC] Income Statement versus Transaction Report
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. Yet reports differ. ___ 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.
