[GNC] Transaction Report - Split Transactions

[Vincent Dawans]

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