Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
As when I originally replied to this thread, it seems there was some special non printable character in the subject ( from when I copy/pasted/edited the subject on my iPad) that caused the subject to become "(no subject)", I am reposting this with (hopefully) the correct subject so the posts appear together in the mail archive. Regards, Chris Good Message: 11 Date: Sun, 10 Nov 2019 06:31:07 +1000 From: David H To: Chris Good Cc: Gnucash Users Subject: Re: [GNC] (no subject) Message-ID: Content-Type: text/plain; charset="UTF-8" Chris, You are correct, highlight tab you want in a new window and click Windows >> New Window with Page. Cheers Dave H. On Sun, 10 Nov 2019 at 06:24, Chris Good wrote: > Hi Fran, > > Something I didn't realize you could do for a long time was to open 2 > reports in separate side by side windows so you can easily visually compare > them. I'm not at my computer now but I think the options to do this are > under the Window or View menus. > > Regards, > > Chris Good > --- > > > > Message: 8 > > Date: Sat, 9 Nov 2019 18:17:02 + (UTC) > > From: Fran_3 > > To: Gnucash Users , Adrien Monteleone > > > > Subject: Re: [GNC] How to compare 2 Transaction Reports to find orphan > >transactions > > Message-ID: <1766876513.1811024.1573323422...@mail.yahoo.com> > > Content-Type: text/plain; charset=UTF-8 > > > > Adrian, you said... "instead do a Find operation then run an Account > Report instead of a Transaction Report. (since Find can filter on more > fields)" > > My comment: > > I did not know about the "Account Report"? option... It seems it only > appears under the Reports Menu if you are looking at a register (aka > account)... like the check register or AP or AR register... or after you do > a Ctl F (Find) operation... > > This is very useful. > > Thanks for this tip Adrian ! > > Fran3 > > > >On Saturday, November 9, 2019, 10:14:16 AM EST, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > I would say consider the criteria you used to create the set of > transactions for each report, then try to craft a report using the options > that gives you only those that don?t lie in the joint set. > > > > If *every* transaction on both reports is between two and only the *same > two* accounts then you might do better with using regex and/or instead do a > Find operation then run an Account Report instead of a Transaction Report. > (since Find can filter on more fields) > > > > My personal mileage is better with running Find operations from the > Accounts tab rather than a particular register. > > > > If however, the two reports have transactions all sharing one account in > common (say checking) but not other splits, you might want to investigate > the Account Filter option. So while filtering on other data might appear to > get you what you want, sometimes filtering by the ?other? split narrows > things down much faster. With a Transaction Report (as opposed to Find then > Account Report) you can filter based on including or not including > transactions which have splits in other accounts. > > > > Otherwise, the spreadsheet approach is likely the simplest. If you know > how to use command-line tools, you could use the spreadsheet step just for > saving in CSV format, then using a cli `diff` tool to show you what is > different between the two files. (MacOS as well as most if not all BSD & > Linux distributions have this built-in. I?m not sure about Windows) > > > > Such tools are very fast and each one has its own features. The output > takes some getting used to as most are not super ?clean? on screen, but > once you do it enough, you?ll be able to use them more effectively. > > > > You could jump straight to using `diff` and get used to it, and it will > help get the job done, but the better option is to think carefully about > what you are trying to find and then crafting a Find or Report that gets > you there from within GnuCash. > > > > Regards, > > Adrien > > > > > > > >> On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> > >> I want to compare Transaction Report A to Transaction Report B > >> and find transactions that appear on one report but not on the other... > aka orphan transactions > >> In past I have either... > >> - Done a screen capture of each, pasted them side by side in PC Paint > and marked off matching transactions one by one... > >> - Or printed them out and done the same with pen
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
You’re welcome. Note as well, the Help Guide documents each menu in each context. While it may seem rather mundane at first, there are a few gems to glean from looking it over. This was one I stumbled on a while back and noticed that the menu entries change depending on the current tab. (rather than having them greyed out but always present) Regards, Adrien > On Nov 9, 2019 w45d313, at 12:17 PM, Fran_3 wrote: > > Adrian, you said... "instead do a Find operation then run an Account Report > instead of a Transaction Report. (since Find can filter on more fields)" > > My comment: > I did not know about the "Account Report" option... > It seems it only appears under the Reports Menu if you are looking at a > register (aka account)... like the check register or AP or AR register... or > after you do a Ctl F (Find) operation... > This is very useful. > Thanks for this tip Adrian ! > > Fran3 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
Christopher said "You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report." My Question: Wikipedia list numerous definitions for SFX... in this case what? (Self Extracting Software or what?) Greg Francis suggested NotePad++ My Response: Yes, I am a longtime user of NP++ but for a number of reasons it didn't do the trick in this particular case. In this case I ended up having to use a spreadsheet ... I won't go through the blow by blow but I (finally) got it done :-) Fran3 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
Adrian, you said... "instead do a Find operation then run an Account Report instead of a Transaction Report. (since Find can filter on more fields)" My comment: I did not know about the "Account Report" option... It seems it only appears under the Reports Menu if you are looking at a register (aka account)... like the check register or AP or AR register... or after you do a Ctl F (Find) operation... This is very useful. Thanks for this tip Adrian ! Fran3 On Saturday, November 9, 2019, 10:14:16 AM EST, Adrien Monteleone wrote: I would say consider the criteria you used to create the set of transactions for each report, then try to craft a report using the options that gives you only those that don’t lie in the joint set. If *every* transaction on both reports is between two and only the *same two* accounts then you might do better with using regex and/or instead do a Find operation then run an Account Report instead of a Transaction Report. (since Find can filter on more fields) My personal mileage is better with running Find operations from the Accounts tab rather than a particular register. If however, the two reports have transactions all sharing one account in common (say checking) but not other splits, you might want to investigate the Account Filter option. So while filtering on other data might appear to get you what you want, sometimes filtering by the ‘other’ split narrows things down much faster. With a Transaction Report (as opposed to Find then Account Report) you can filter based on including or not including transactions which have splits in other accounts. Otherwise, the spreadsheet approach is likely the simplest. If you know how to use command-line tools, you could use the spreadsheet step just for saving in CSV format, then using a cli `diff` tool to show you what is different between the two files. (MacOS as well as most if not all BSD & Linux distributions have this built-in. I’m not sure about Windows) Such tools are very fast and each one has its own features. The output takes some getting used to as most are not super ‘clean’ on screen, but once you do it enough, you’ll be able to use them more effectively. You could jump straight to using `diff` and get used to it, and it will help get the job done, but the better option is to think carefully about what you are trying to find and then crafting a Find or Report that gets you there from within GnuCash. Regards, Adrien > On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user > wrote: > > I want to compare Transaction Report A to Transaction Report B > and find transactions that appear on one report but not on the other... aka > orphan transactions > In past I have either... > - Done a screen capture of each, pasted them side by side in PC Paint and > marked off matching transactions one by one... > - Or printed them out and done the same with pen & paper > - Or exported the reports and then imported them into a spreadsheet and > marked matching transactions one by one > All of this is a bunch of work... > > Is there an easier way? > Thanks for any help - Fran3 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
Oops. The regex filter is a late addition from 2017. Unfortunately regex negate string match (I.e. match not containing a string) is a general weakness of POSIX regex. May I suggest file an enhancement request in Bugzilla? On Sat, 9 Nov 2019, 23:38 Christopher Lam, wrote: > Hi Fran > > You've stumbled upon a limitation SFX of regular expressions on filtering > the transaction report. > > You may be aware that the transaction report was, for many years, the most > versatile report to extract information from a Gnucash data file. It had > severe limitations and bugs and > > On Sat, 9 Nov 2019, 22:55 Fran_3 via gnucash-user, < > gnucash-user@gnucash.org> wrote: > >> I want to compare Transaction Report A to Transaction Report B >> and find transactions that appear on one report but not on the other... >> aka orphan transactions >> In past I have either... >> - Done a screen capture of each, pasted them side by side in PC Paint and >> marked off matching transactions one by one... >> - Or printed them out and done the same with pen & paper >> - Or exported the reports and then imported them into a spreadsheet and >> marked matching transactions one by one >> All of this is a bunch of work... >> >> Is there an easier way? >> Thanks for any help - Fran3 >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
If the reports you're interested in comparing are text based, and your computer's OS allows you to use Notepad++, you might consider using Notepad++ to compare the two files. Notepad++ is a free open source text editor that has a great file comparison tool. Kind regards, Greg Feneis On Sat, Nov 9, 2019 at 7:41 AM Christopher Lam wrote: > Hi Fran > > You've stumbled upon a limitation SFX of regular expressions on filtering > the transaction report. > > You may be aware that the transaction report was, for many years, the most > versatile report to extract information from a Gnucash data file. It had > severe limitations and bugs and > > On Sat, 9 Nov 2019, 22:55 Fran_3 via gnucash-user, < > gnucash-user@gnucash.org> > wrote: > > > I want to compare Transaction Report A to Transaction Report B > > and find transactions that appear on one report but not on the other... > > aka orphan transactions > > In past I have either... > > - Done a screen capture of each, pasted them side by side in PC Paint and > > marked off matching transactions one by one... > > - Or printed them out and done the same with pen & paper > > - Or exported the reports and then imported them into a spreadsheet and > > marked matching transactions one by one > > All of this is a bunch of work... > > > > Is there an easier way? > > Thanks for any help - Fran3 > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
Hi Fran You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report. You may be aware that the transaction report was, for many years, the most versatile report to extract information from a Gnucash data file. It had severe limitations and bugs and On Sat, 9 Nov 2019, 22:55 Fran_3 via gnucash-user, wrote: > I want to compare Transaction Report A to Transaction Report B > and find transactions that appear on one report but not on the other... > aka orphan transactions > In past I have either... > - Done a screen capture of each, pasted them side by side in PC Paint and > marked off matching transactions one by one... > - Or printed them out and done the same with pen & paper > - Or exported the reports and then imported them into a spreadsheet and > marked matching transactions one by one > All of this is a bunch of work... > > Is there an easier way? > Thanks for any help - Fran3 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
I forgot to mention, when trying to craft a better resulting report, ask yourself, “What makes the transactions on either report not show up on the other?” Then use *that* info to craft the intended report. (as it is the set of transactions you are looking for) Regards, Adrien > On Nov 9, 2019 w45d313, at 9:13 AM, Adrien Monteleone > wrote: > > I would say consider the criteria you used to create the set of transactions > for each report, then try to craft a report using the options that gives you > only those that don’t lie in the joint set. > > If *every* transaction on both reports is between two and only the *same two* > accounts then you might do better with using regex and/or instead do a Find > operation then run an Account Report instead of a Transaction Report. (since > Find can filter on more fields) > > My personal mileage is better with running Find operations from the Accounts > tab rather than a particular register. > > If however, the two reports have transactions all sharing one account in > common (say checking) but not other splits, you might want to investigate the > Account Filter option. So while filtering on other data might appear to get > you what you want, sometimes filtering by the ‘other’ split narrows things > down much faster. With a Transaction Report (as opposed to Find then Account > Report) you can filter based on including or not including transactions which > have splits in other accounts. > > Otherwise, the spreadsheet approach is likely the simplest. If you know how > to use command-line tools, you could use the spreadsheet step just for saving > in CSV format, then using a cli `diff` tool to show you what is different > between the two files. (MacOS as well as most if not all BSD & Linux > distributions have this built-in. I’m not sure about Windows) > > Such tools are very fast and each one has its own features. The output takes > some getting used to as most are not super ‘clean’ on screen, but once you do > it enough, you’ll be able to use them more effectively. > > You could jump straight to using `diff` and get used to it, and it will help > get the job done, but the better option is to think carefully about what you > are trying to find and then crafting a Find or Report that gets you there > from within GnuCash. > > Regards, > Adrien > > > >> On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user >> wrote: >> >> I want to compare Transaction Report A to Transaction Report B >> and find transactions that appear on one report but not on the other... aka >> orphan transactions >> In past I have either... >> - Done a screen capture of each, pasted them side by side in PC Paint and >> marked off matching transactions one by one... >> - Or printed them out and done the same with pen & paper >> - Or exported the reports and then imported them into a spreadsheet and >> marked matching transactions one by one >> All of this is a bunch of work... >> >> Is there an easier way? >> Thanks for any help - Fran3 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
I would say consider the criteria you used to create the set of transactions for each report, then try to craft a report using the options that gives you only those that don’t lie in the joint set. If *every* transaction on both reports is between two and only the *same two* accounts then you might do better with using regex and/or instead do a Find operation then run an Account Report instead of a Transaction Report. (since Find can filter on more fields) My personal mileage is better with running Find operations from the Accounts tab rather than a particular register. If however, the two reports have transactions all sharing one account in common (say checking) but not other splits, you might want to investigate the Account Filter option. So while filtering on other data might appear to get you what you want, sometimes filtering by the ‘other’ split narrows things down much faster. With a Transaction Report (as opposed to Find then Account Report) you can filter based on including or not including transactions which have splits in other accounts. Otherwise, the spreadsheet approach is likely the simplest. If you know how to use command-line tools, you could use the spreadsheet step just for saving in CSV format, then using a cli `diff` tool to show you what is different between the two files. (MacOS as well as most if not all BSD & Linux distributions have this built-in. I’m not sure about Windows) Such tools are very fast and each one has its own features. The output takes some getting used to as most are not super ‘clean’ on screen, but once you do it enough, you’ll be able to use them more effectively. You could jump straight to using `diff` and get used to it, and it will help get the job done, but the better option is to think carefully about what you are trying to find and then crafting a Find or Report that gets you there from within GnuCash. Regards, Adrien > On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user > wrote: > > I want to compare Transaction Report A to Transaction Report B > and find transactions that appear on one report but not on the other... aka > orphan transactions > In past I have either... > - Done a screen capture of each, pasted them side by side in PC Paint and > marked off matching transactions one by one... > - Or printed them out and done the same with pen & paper > - Or exported the reports and then imported them into a spreadsheet and > marked matching transactions one by one > All of this is a bunch of work... > > Is there an easier way? > Thanks for any help - Fran3 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to compare 2 Transaction Reports to find orphan transactions
I want to compare Transaction Report A to Transaction Report B and find transactions that appear on one report but not on the other... aka orphan transactions In past I have either... - Done a screen capture of each, pasted them side by side in PC Paint and marked off matching transactions one by one... - Or printed them out and done the same with pen & paper - Or exported the reports and then imported them into a spreadsheet and marked matching transactions one by one All of this is a bunch of work... Is there an easier way? Thanks for any help - Fran3 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.