Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
(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>

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Christopher Lam
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 >

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
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,

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
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.

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Derek Atkins
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

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
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

[GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread David Kirkby
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:

Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect.

2023-11-21 Thread John Ralls
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. > > > > +} > > >

Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect.

2023-11-21 Thread John Ralls
> 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 >

Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect.

2023-11-21 Thread Elven Decker
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

Re: [GNC] Hidden and duplicated accounts.

2023-11-21 Thread Fred Bone
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

Re: [GNC] Can I set accounts to read-only?

2023-11-21 Thread Mark at Lorimark
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,

Re: [GNC] Hidden and duplicated accounts.

2023-11-21 Thread Mark at Lorimark
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]

[GNC] Can I set accounts to read-only?

2023-11-21 Thread David Kirkby
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

[GNC] Hidden and duplicated accounts.

2023-11-21 Thread David Kirkby
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

Re: [GNC] Auto-complete of Memo field suffers short term memory

2023-11-21 Thread R Losey
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

Re: [GNC] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Michael or Penny Novack
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

Re: [GNC] Import Bills & Invoices

2023-11-21 Thread Adrien Monteleone
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

Re: [GNC] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Adrien Monteleone
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

Re: [GNC] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread David Kirkby
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: >

Re: [GNC] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Maf. King
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

[GNC] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread David Kirkby
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