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. I'll happily take suggestions. Kind regards, Bregt _______________________________________________ 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.
