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.
