[GNC] Can I produce a trial balance as a simple CSV file?
I was a bit concerned about the complexity of the CSV files exported from GnuCash, since they contain information my accountant does not want. I wrote to him and received this as a response (slightly edited from his reply) *Thank you for your email. Do not worry about sending me over complicated CSV files - we are very used to this. * *The way in which we normally work is that a client sends across the trial balance, we make relevant adjustments to which we use for the accounts and send these adjustments back to you to make within your software. * I can see I can produce the trial balance as a PDF, but I can't see a way to convert it to a CSV file, which I think he would prefer. I can find online converters for this, but can't see an open-source project to do it. There are sufficiently few entries that I could do this myself in a spreadsheet, but it would be a bit tedious. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I produce a trial balance as a simple CSV file?
On Tuesday, 21 November 2023 12:58:32 GMT David Kirkby wrote: > > I can see I can produce the trial balance as a PDF, but I can't see a way > to convert it to a CSV file, which I think he would prefer. The usual advice is the either: a. save the report as HTML b. select and copy the text of the report then open with / paste into a spreadsheet (LibreOffice Calc opens HTML just fine) and save as CSV from there, with any format / line-up tinkering needed first, of course,. YMMV Maf. ___ 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] Can I produce a trial balance as a simple CSV file?
On Tue, 21 Nov 2023 at 13:22, Maf. King wrote: > On Tuesday, 21 November 2023 12:58:32 GMT David Kirkby wrote: > > > > > I can see I can produce the trial balance as a PDF, but I can't see a way > > to convert it to a CSV file, which I think he would prefer. > > The usual advice is the either: > > a. save the report as HTML > b. select and copy the text of the report > > then open with / paste into a spreadsheet (LibreOffice Calc opens HTML > just fine) > and save as CSV from there, with any format / line-up tinkering needed > first, > of course,. > Thank you. I'll probably just give him the spreadsheet in that case - it will be easier to read than a csv file. ___ 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] Can I produce a trial balance as a simple CSV file?
David, It may take a bit of setup, but there are other options: 1. html2csv - a python CLI app that will extract the table in the report to a CSV 2. online converters (some may be simply using the above python script) The first option keeps everything on your machine. The second allows drag and drop of files for less technical overhead. Of course, a handful of clicks incorporating a spreadsheet app isn't too painful either. Regards, Adrien On 11/21/23 8:38 AM, David Kirkby wrote: Thank you. I'll probably just give him the spreadsheet in that case - it will be easier to read than a csv file. ___ 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] Import Bills & Invoices
Malformed CSV. See the Tutorial & Concepts Guide §18.1 Importing Bills and Invoices. The columns need to be in that exact order and format. Regards, Adrien On 11/21/23 9:02 AM, Mark at Lorimark wrote: I am trying to run File | Import | Import Bills & Invoices. The file-type to pick is *.csv and I've got a good-looking csv file with a bunch of invoices in it, and when I select it, nothing shows in the "preview" area. I've used other importers to grab transactions from my bank, but this one just seems to be not working? ___ 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] Can I produce a trial balance as a simple CSV file?
On 11/21/2023 7:58 AM, David Kirkby wrote: I was a bit concerned about the complexity of the CSV files exported from GnuCash, since they contain information my accountant does not want. I wrote to him and received this as a response (slightly edited from his reply) *Thank you for your email. Do not worry about sending me over complicated CSV files - we are very used to this. * *The way in which we normally work is that a client sends across the trial balance, we make relevant adjustments to which we use for the accounts and send these adjustments back to you to make within your software. * Check what he/she REALLY wants. Ask that question, "How would you really like them?" As opposed to asking "Could you accept the data in xyz format?" Also keep in mind that .cvs (comma separated variable) is a basic level description of the data. Thus typically a spreadsheet application is using this basic level format to store its data BUT that does not mean that any file in .cvs format would be meaningful data for a spreadsheet. Thus when he/she is saying "Do not worry about sending me overly complicated CVS files" perhaps saying don't worry about sending me the data from a spreadsheet that has additional, extraneous columns. The point here is that people are telling you that you can export into an HTML file that a typical spreadsheet app can open and then save that in a more normal format (for a spreadsheet). And THAT is perhaps what your accountant wants (because can edit in the changes as he/she described and send back to you) Michael D Novack ___ 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] Auto-complete of Memo field suffers short term memory
That would appear to be my case; it will remember previously entered data from the same session, but not across sessions (as it used to be able to do). On Mon, Nov 20, 2023 at 8:48 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Through further testing as I noted in the bug report followups, I have > narrowed this down to GnuCash only auto-filling whatever has been > previously entered in the same session. > > Restarting the app causes the amnesia. > > And this is for both Memo and Notes fields. > > My next two steps are to test a fresh book and to test that and my > existing book in Linux. (I'm on MacOS) > > Regards, > Adrien > > On 11/20/23 8:43 PM, R Losey wrote: > > Yes, I am running 5.3 and I have this same problem. I had hoped it was > > fixed in 5.4, and I'm saddened to learn that it is still with us. > > ___ > 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. > -- _ 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] Hidden and duplicated accounts.
I have a couple of questions related to accounts, and my ability to see them and delete them. 1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD) and bank fees. [image: image.png] I remember creating some more to include eBay fees, but since I so rarely use eBay, I think I set them to hidden. But when I tried to edit the Expenses account, I can see the other entries But I do I unhide these? I tried clicking on other accounts, but none show hidden, and all are marked as placeholder, so I don't think that's the way to edit their visability. [image: image.png] 2) As you can see I two accounts called Depreciation. Why I would have created two for this I have no idea. These are both shown if I edit the Expenses account, but not when I look normally. How can I delete one of the? -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I set accounts to read-only?
I have a few accounts that I will use very occasionally, but not normally. Can I set them to read-only, so I just mark them writable when I need to? This will avoid transactions accidentally getting put in there. I discovered something in the Travel account the other day that should not have been there. I will probably use that account once per year, so it makes sense to stop things accidentally going into them. I believe setting them to placeholder accounts will achieve the same effect, but I'm not sure. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Hidden and duplicated accounts.
Look for; View-> Filter by-> Other ~mark On 11/21/23 12:37, David Kirkby wrote: I have a couple of questions related to accounts, and my ability to see them and delete them. 1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD) and bank fees. [image: image.png] ___ 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] Can I set accounts to read-only?
You can set an account to 'placeholder' after you have transactions in it. This will prevent you from double-click in the accounts view to open it, you'll have to right-click to view it's contents. But, it will also remove it from your pick-lists in the registries. ~mark On 11/21/23 12:46, David Kirkby wrote: I have a few accounts that I will use very occasionally, but not normally. Can I set them to read-only, so I just mark them writable when I need to? This will avoid transactions accidentally getting put in there. I discovered something in the Travel account the other day that should not have been there. I will probably use that account once per year, so it makes sense to stop things accidentally going into them. I believe setting them to placeholder accounts will achieve the same effect, but I'm not sure. ___ 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] Hidden and duplicated accounts.
On 21 November 2023 at 18:37, David Kirkby said: > I have a couple of questions related to accounts, and my ability to see > them and delete them. > > 1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD) > and bank fees. > > [image: image.png] > > I remember creating some more to include eBay fees, but since I so rarely > use eBay, I think I set them to hidden. But when I tried to edit the > Expenses account, I can see the other entries But I do I unhide these? I > tried clicking on other accounts, but none show hidden, and all are marked > as placeholder, so I don't think that's the way to edit their visability. Have you tried setting View->Filter by, Other, Show hidden accounts? ___ 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] Account reconciliation -- Gnucash's beginning balance is incorrect.
Not sure how to use this help thread, but I have had a similar problem years ago which recently started happening again. I solve it by exiting the reconciliation window and then re-opening it. When the small reconcile information window opens, I click on the "Statement Date" drop-down and choose the correct date by hand. This forces some kind of re-computation of the beginning and ending balances. +-} ___ 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] Account reconciliation -- Gnucash's beginning balance is incorrect.
> On Nov 21, 2023, at 12:35 PM, Elven Decker wrote: > > Not sure how to use this help thread, but I have had a similar problem years > ago which recently started happening again. I solve it by exiting the > reconciliation window and then re-opening it. When the small reconcile > information window opens, I click on the "Statement Date" drop-down and > choose the correct date by hand. This forces some kind of re-computation of > the beginning and ending balances. You seem to have figured out the mailing list. No need to quit and restart the reconcile, though: You can edit the reconcile information with Reconcile>Reconcile Information... from the reconcile window's menu. Regards, John Ralls ___ 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] Account reconciliation -- Gnucash's beginning balance is incorrect.
Oops, I guess you don't *quite* get how to use the mailing list: Always use reply-all so that your reply goes to the list, not just to the person you're replying to. Regards, John Ralls > On Nov 21, 2023, at 4:23 PM, sailing wrote: > > Great! Thank you. > > > > +} > > > Original message > From: John Ralls > Date: 11/21/23 6:49 PM (GMT-05:00) > To: Elven Decker > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Account reconciliation -- Gnucash's beginning balance is > incorrect. > > > > > On Nov 21, 2023, at 12:35 PM, Elven Decker wrote: > > > > Not sure how to use this help thread, but I have had a similar problem > > years ago which recently started happening again. I solve it by exiting > > the reconciliation window and then re-opening it. When the small reconcile > > information window opens, I click on the "Statement Date" drop-down and > > choose the correct date by hand. This forces some kind of re-computation of > > the beginning and ending balances. > > You seem to have figured out the mailing list. > > No need to quit and restart the reconcile, though: You can edit the reconcile > information with Reconcile>Reconcile Information... from the reconcile > window's menu. > > Regards, > John Ralls > ___ 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] Can I find transactions into an account that has only one split?
I often receive PayPal transactions, which get put into the PayPal account as Credit: Assets: Accounts Receivable (£720.00) Debit: Assets:PayPal (£720.00) What I should then do is edit the PayPal account so the fees are put in the correct place - for one example transaction Credit: Assets: Accounts Receivable (£720) Debit: Assets:PayPal (£705.62) Debit: Expenses:PayPal Fees (£21.38) But I quite often forget to do this, so the PayPal account will not reconcile. Is there any way to search to find transactions going into accounts that don't have a second split, or some other way to weed out the ones that have gone into the PayPal account, but don't have an entry in PayPal expenses? -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I find transactions into an account that has only one split?
Maybe. That's a trial and error sort of situation. Certainly, you can craft a Find from the Accounts tab with multiple criteria, the first should likely find all transactions matching Assets:PayPal, then the next might exclude all other accounts, or specific accounts. (since it is most likely you would have had an extra split to Expenses:PayPal Fees, just exclude that match from the results) An alternative is to run the first find to get a list. Then with that resulting register list open, run another find to narrow it down as needed. Which is the best or shortest route - I have no idea. You'll have to try and then see what works best for you. - for the record, all transactions have at least two splits—a debit and a credit. I know why you used the terminology you chose, but I put this here for clarification. That will be important for you in the future. Regards, Adrien On 11/21/23 7:43 PM, David Kirkby wrote: I often receive PayPal transactions, which get put into the PayPal account as Credit: Assets: Accounts Receivable (£720.00) Debit: Assets:PayPal (£720.00) What I should then do is edit the PayPal account so the fees are put in the correct place - for one example transaction Credit: Assets: Accounts Receivable (£720) Debit: Assets:PayPal (£705.62) Debit: Expenses:PayPal Fees (£21.38) But I quite often forget to do this, so the PayPal account will not reconcile. Is there any way to search to find transactions going into accounts that don't have a second split, or some other way to weed out the ones that have gone into the PayPal account, but don't have an entry in PayPal expenses? ___ 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] Can I find transactions into an account that has only one split?
Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a TRANSACTION basis. So if you do a search on "Account == X AND Account == Y" you will get an empty set, because it is impossible to find anything where Split.account == X and Split.account ALSO equals Y. -derek On Tue, November 21, 2023 11:35 pm, Adrien Monteleone wrote: > Maybe. That's a trial and error sort of situation. > > Certainly, you can craft a Find from the Accounts tab with multiple > criteria, the first should likely find all transactions matching > Assets:PayPal, then the next might exclude all other accounts, or > specific accounts. (since it is most likely you would have had an extra > split to Expenses:PayPal Fees, just exclude that match from the results) > > An alternative is to run the first find to get a list. Then with that > resulting register list open, run another find to narrow it down as > needed. > > Which is the best or shortest route - I have no idea. You'll have to try > and then see what works best for you. > > - > for the record, all transactions have at least two splits—a debit and a > credit. I know why you used the terminology you chose, but I put this > here for clarification. That will be important for you in the future. > > Regards, > Adrien > > On 11/21/23 7:43 PM, David Kirkby wrote: >> I often receive PayPal transactions, which get put into the PayPal >> account >> as >> >> Credit: Assets: Accounts Receivable (£720.00) >> Debit: Assets:PayPal (£720.00) >> >> What I should then do is edit the PayPal account so the fees are put in >> the >> correct place - for one example transaction >> >> Credit: Assets: Accounts Receivable (£720) >> Debit: Assets:PayPal (£705.62) >> Debit: Expenses:PayPal Fees (£21.38) >> >> But I quite often forget to do this, so the PayPal account will not >> reconcile. >> >> Is there any way to search to find transactions going into accounts that >> don't have a second split, or some other way to weed out the ones that >> have >> gone into the PayPal account, but don't have an entry in PayPal >> expenses? > > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Can I find transactions into an account that has only one split?
Yeah, that's why I started off with this would be trial and error level effort. The OP wants transactions where at least one split appears in set A, but excludes any such transactions when *other splits* also appear in set B. I *think* this is possible, but I have to admit, I've never tried. I'm guessing that running two separate Finds, one from the Accounts page, and one from the Find results register is the way to go, but I could be mistaken. I'm guessing that trying it all in one go will fall into the trap you mention. But if the result register is somehow 'fixed' to the original splits found, this entire endeavor may not be possible. Regards, Adrien On 11/22/23 12:00 AM, Derek Atkins wrote: Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a TRANSACTION basis. So if you do a search on "Account == X AND Account == Y" you will get an empty set, because it is impossible to find anything where Split.account == X and Split.account ALSO equals Y. ___ 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] Can I find transactions into an account that has only one split?
Another option is to just open the Assets:PayPal register and look over them one by one to see if they contain an additional split to Expenses:PayPal Fees, then edit the ones that do not as needed. Regards, Adrien On 11/21/23 7:43 PM, David Kirkby wrote: I often receive PayPal transactions, which get put into the PayPal account as Credit: Assets: Accounts Receivable (£720.00) Debit: Assets:PayPal (£720.00) What I should then do is edit the PayPal account so the fees are put in the correct place - for one example transaction Credit: Assets: Accounts Receivable (£720) Debit: Assets:PayPal (£705.62) Debit: Expenses:PayPal Fees (£21.38) But I quite often forget to do this, so the PayPal account will not reconcile. Is there any way to search to find transactions going into accounts that don't have a second split, or some other way to weed out the ones that have gone into the PayPal account, but don't have an entry in PayPal expenses? ___ 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] Can I find transactions into an account that has only one split?
Check the Transaction Report's Account tab. On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Yeah, that's why I started off with this would be trial and error level > effort. > > The OP wants transactions where at least one split appears in set A, but > excludes any such transactions when *other splits* also appear in set B. > > I *think* this is possible, but I have to admit, I've never tried. > > I'm guessing that running two separate Finds, one from the Accounts > page, and one from the Find results register is the way to go, but I > could be mistaken. > > I'm guessing that trying it all in one go will fall into the trap you > mention. > > But if the result register is somehow 'fixed' to the original splits > found, this entire endeavor may not be possible. > > Regards, > Adrien > > On 11/22/23 12:00 AM, Derek Atkins wrote: > > Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a > > TRANSACTION basis. So if you do a search on "Account == X AND Account == > > Y" you will get an empty set, because it is impossible to find anything > > where Split.account == X and Split.account ALSO equals Y. > > ___ > 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] Can I find transactions into an account that has only one split?
(face palm!) Yes, thanks Chris! (not just for the suggestion, but for the awesome report work too!) Regards, Adrien On 11/22/23 12:43 AM, Christopher Lam wrote: Check the Transaction Report's Account tab. On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: Yeah, that's why I started off with this would be trial and error level effort. The OP wants transactions where at least one split appears in set A, but excludes any such transactions when *other splits* also appear in set B. I *think* this is possible, but I have to admit, I've never tried. I'm guessing that running two separate Finds, one from the Accounts page, and one from the Find results register is the way to go, but I could be mistaken. I'm guessing that trying it all in one go will fall into the trap you mention. But if the result register is somehow 'fixed' to the original splits found, this entire endeavor may not be possible. ___ 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.
