[GNC] Transaction Report - Split Transactions

[Vincent Dawans]

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.monteleone at 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 at 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.
>