For those interested by this feature providing a more permissive match in the transaction report to reduce the number of "split transaction", I have implemented this feature in my custom "Transaction Report Extended" here https://github.com/dawansv/gnucash-custom-reports
The option to enable the more permissive match is on the display tab: "Use More Permissive Match for Other Account Name and Code". The permissive match finds more matches by doing the following: + Splits on the same side as main split are ignored. + Splits with zero value are excluded unless main split is zero as well. + If there is still more than one other split, then split on the other side with same value is matched. It still shows "split transaction" when there is still more than one split left after these additional matches On Fri, May 19, 2023 at 4:37 PM Vincent Dawans <dawa...@gmail.com> wrote: > I have submitted a draft PR with changes that would address your use case > (as well as mine -- I have a set of books for a small nonprofit that I like > to export in a Google Sheet ledger for simple reporting to the board -- but > it shows a lot of sad looking "Split Transaction" as well). As you say it's > not a total deal breaker but essentially we can probably afford to have a > more aggressive "other account" match in the reports (where the data is > only read, not changed) while keeping a more conservative approach in the > register (where changes are made, hence it's better to work in the split > view to avoid errors at that point). See > https://github.com/Gnucash/gnucash/pull/1637 We will have to see what > form it takes at the end, but could also be done in a custom report if it's > considered too "risky" for the main report. > > On Fri, May 19, 2023 at 4:39 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> As Vincent noted, you probably can't get there in one report, but >> consider experimenting with the multi-column report where you can have >> multiple transaction reports in one screen. >> >> Another alternative would be to run the report for each owner, and >> copy/paste or export to a spreadsheet for further manipulation. >> >> Regards, >> Adrien >> >> On 5/16/23 3:24 AM, John Dimitriadis wrote: >> > Hello, >> > >> > I have a Gnucash file, which I use to track expenses for a jointly >> owned property. >> > >> > Under Assets, I have two accounts. One for myself and one for the other >> owner. >> > >> > Under Expenses, I have the Property, and under that I have sub-accounts >> for the various types of expenses (eg. Taxes, Service Charges, Maintenance, >> Bills etc). >> > >> > A number of the expenses transactions have split entries. Either >> because something was paid by both owners, or because I keep more detailed >> records. >> > >> > I am trying to come up with a Transaction Report that will summarise: >> > (a) Total Expenses >> > (b) Breakdown of Expenses per sub-Account (i.e. type of expense) >> > (c) How much was paid by each owner, of each type of expense >> > >> > The problem I am facing and have not managed to solve no matter what I >> have tried, is that for the Split Transactions, when Sorting with “Other >> Account”, I just get a groups for “Split Transaction”, and thus lose the >> transparency of the Sub-Account or if I structure the Transaction report >> differently, I lose the transparency/sum for the account from which the >> payment was made. >> >> _______________________________________________ >> 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.
