Split transaction sorting

David Jensen david.e.jensen at gmail.com
Wed Oct 19 10:23:16 EDT 2011


On Tue, Oct 18, 2011 at 11:13 AM, David Carlson
<carlson.dl at sbcglobal.net> wrote:
> On 10/18/2011 10:05 AM, David Carlson wrote:
>> On 10/18/2011 9:08 AM, Derek Atkins wrote:
>>> Hi,
>>>
>>> a <rig9919hd at gmail.com> writes:
>>>
>>>> Is there any way to sort a split transaction so it is more readable?
>>>> All my paycheck splits get unreadable and confusing because of the way
>>>> gnucash sorts them by default.
>>>>
>>>> I want my split transactions to look like this:
>>>>
>>>> Taxable Salary          118
>>>> Checking Acct     40
>>>> Disability Ins    60
>>>> Federal Tax       10
>>>> State Tax         5
>>>> Medicare          1
>>>> Social Sec        2
>>>> Pretax Salary           40
>>>> Health Ins        10
>>>> Dental Ins        10
>>>> Vision Ins        10
>>>> 401K              10
>>>> Employer Paid           20
>>>> Health Savings    15
>>>> 401K Contr.       5
>>>>
>>>> Instead it always pushes all the withdrawals (taxable salary, pretax
>>>> salary, and employer paid benefits) to the very bottom. I've tried
>>>> giving each split a number in the action box. Doing that and sorting
>>>> by number or action only sorted the top level transactions in the
>>>> ledger, the splits weren't sorted at all.
>>>
>>> Sorry, there's no way to fix that.  It will order each of the Debits and
>>> each of the Credits in the split on the order in which it was entered,
>>> but you cannot get it to mix debits and credits.
>>>
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>> -derek
>>>
>> Dumb question of the day:  Why is there no way to fix that?
>>
>> I would also like to see entry order sorts in splits.   That should be
>> possible even if another field needed to be added to the split record to
>> differentiate from actions used in some situations (like investments).
>>
>> David Carlson
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>>
> I forgot to reference splits involving multiple currencies.  I
> personally don't mix currencies, but many people do.
>
> David Carlson
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>

I it the standard format in accounting that for each transaction,
Debits are listed 'first' and then Credits.



More information about the gnucash-user mailing list