Hi Adrien, Your first suggestion works like a charm. The created report is exactly what I need. I'll have to work on the layout, as the options are more limited, but that's a minor detail.
Your second suggestion, through the Transaction Report, indeed does not operate on the NUM field: what is available is a filter on the Account Name, or apply a regex on fields Description, Notes or Memo. Thank you! Kind regards, Bregt On 1/11/22 11:51 PM, Adrien Monteleone wrote: > Do the bill#'s show up in the NUM field (or elsewhere) in your expense > account registers? > > If so, my first suggestion would be to do a Find (from the CoA tab) > filtering for the string you want. > > Then run an Account Report (or File > Export > Active Tab to CSV) on the > Find results tab. > > Let us know if that works. > > Also, while the P&L/Income Report filtering is somewhat limited, the > Transaction Report gives much more flexibility and *should* operate on > the NUM field if I am not mistaken. If not directly in the Filter > option, then try the Regex option. > > Regards, > Adrien > > On 1/11/22 6:29 AM, Bregt - ICTgroup.be via gnucash-user wrote: >> Hi all! >> >> I live in Belgium and am using GnuCash and its business features for my >> (small) company accounting. >> >> I'm running GnuCash 4.4 on Ubuntu Mate 20.04 LTS. >> >> I've composed a custom CoA in compliance to local accounting laws. My >> accountant told me to register all transactions through one of 4 >> *theoretical* journals: "incomes" (linked to invoices and an A/R), >> "expenses" (linked to bills and an A/P), "bank", and "others". >> >> So, for instance, the new coffeemachine we bought for the office is >> booked through the "expenses" journal: an expenseaccount + a taxaccount >> are debited, and a (general) vendoraccount (A/P) is credited. These type >> of transactions (through bills) are numbered by GnuCash, I set the >> numbers to be BILL-21001, BILL-21002, etc through the Counters feature. >> >> Some other expenses, however, are booked through the "others" journal as >> they have nothing to do with an A/P and there's no tax involved in the >> expense (so my accountant says, it has to do with quarterly VAT >> declarations). So, these transactions are also expenses, but are not >> registered as bills and thus not numbered by GnuCash, so I number them >> manually: OTH-21001, OTH-21002, etc. >> >> As the year ended and we're to close the books for 2021, my accountant >> is now asking for a listing of these 4 journals. If I create a report >> with a listing of all the expenses-accounts, this report contains >> transactions from both the "expenses" and the "others" journal. My >> question: is there a way in GnuCash (besides selecting each and every >> expense account individually, or exporting the report to a spreadsheet) >> to create 2 separate reports filtered by the "Number" field? Idealy, I'd >> filter on the string in the transaction number field, similar to the >> currently available filter on account name, but this functionality is >> currently not implemented. > _______________________________________________ > 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.
