Re: [GNC] Need Transaction Report on Checking to show only Debits
Matt, thanks for the reply. Note that all withdrawals from Checking are not charged to Expense Accounts so that wouldn't pick up all withdrawals. I can export the checking range I want to work on and do all this in a spreadsheet however so no worries. Thanks On Wednesday, May 12, 2021, 4:43:51 AM EDT, Maf. King wrote: On Tuesday, 11 May 2021 13:41:04 BST Fran_3 via gnucash-user wrote: > How can I create a Transaction Report on the Checking AccountAnd show only > Debits?Or show only Credits? Thanks for any help. > ___ Hi, use the Filter... settings on the "accounts" tab of the report options. so run the report on the Checking account, and then in the lower half of the accounts tab Filter by say only Expense accounts. HTH, 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 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] Need Transaction Report on Checking to show only Debits
This almost worked for what I wanted but it gave me a double line for each transaction... line 1: the goes in account line 2: and the goes out account As opposed to when I simply run a Transaction Report on Checking... I can get one line per transaction. I can, of course, export the checking account and do this in a spreadshet... but I thought I could previously do it via a Transaction Report. That said, I've been away from gnuCash for months... maybe a year... and just got called back to do some work... so I'm learning all over again. I do appreciate the help folks. Thanks! On Tuesday, May 11, 2021, 10:44:24 PM EDT, Geoff wrote: Hi Fran Since it is only for a single account, here is a slightly long winded way to do it: 1. Open the Account 2. Do a Find specifying Debit (or Credit) values only 3. Run the Account Report on the search results. See attached screenshot. Hope this helps. Regards Geoff = On 12/05/2021 9:22 am, Fran_3 via gnucash-user wrote: > What are txns? Transactions? > I sorted the Transaction Report by "amount" but I don't know how to limit the > output to values greater than zero... or to values less than zero. > Do I do that on the Filter tab? And if so how? > If its Regular Expressions my eyes just rolled back in my head :-) > Thanks for the help. > > > On Tuesday, May 11, 2021, 12:17:52 PM EDT, Fred Bone > wrote: > > On 11 May 2021 at 12:41, Fran_3 said: > >> How can I create a Transaction Report on the Checking AccountAnd show only >> Debits?Or show only Credits? Thanks for any help. > > Start by selecting only the relevant txns, perhaps? > e.g. Value has debits greater than 0.00 > > > > ___ > 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] Need Transaction Report on Checking to show only Debits
On Tuesday, 11 May 2021 13:41:04 BST Fran_3 via gnucash-user wrote: > How can I create a Transaction Report on the Checking AccountAnd show only > Debits?Or show only Credits? Thanks for any help. > ___ Hi, use the Filter... settings on the "accounts" tab of the report options. so run the report on the Checking account, and then in the lower half of the accounts tab Filter by say only Expense accounts. HTH, 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 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] Need Transaction Report on Checking to show only Debits
What are txns? Transactions? I sorted the Transaction Report by "amount" but I don't know how to limit the output to values greater than zero... or to values less than zero. Do I do that on the Filter tab? And if so how? If its Regular Expressions my eyes just rolled back in my head :-) Thanks for the help. On Tuesday, May 11, 2021, 12:17:52 PM EDT, Fred Bone wrote: On 11 May 2021 at 12:41, Fran_3 said: > How can I create a Transaction Report on the Checking AccountAnd show only > Debits?Or show only Credits? Thanks for any help. Start by selecting only the relevant txns, perhaps? e.g. Value has debits greater than 0.00 ___ 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] Need Transaction Report on Checking to show only Debits
On 11 May 2021 at 12:41, Fran_3 said: > How can I create a Transaction Report on the Checking AccountAnd show only > Debits?Or show only Credits? Thanks for any help. Start by selecting only the relevant txns, perhaps? e.g. Value has debits greater than 0.00 ___ 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.
