Sorting options for Credit Card account

[John Rogers]

I have a rather active credit card account (approximately 6 charges per day)
that I'm trying to keep in sync with my bank.   I enter the transactions as
I see the receipts.   I also mark the transaction in the Reconcile column
from n to c when I see it has cleared my bank's website.   I have the sort
order set to Statement Date.  This seems to do what I want in that it does
move the transactions that have been cleared to the top and the ones that
are not cleared to the bottom.   However, the issue is that let's say that I
put in 6 transactions for 12/22/2017 in the register in a random order.   2
of them have cleared and I have set them to a c.   They show at the top.
However, the Balance that shows on the right side shows the balance in the
order the transactions were entered, not by the cleared status.   Is there
any way to show the transaction AND balance by the cleared status ?

 

See attached screenshot.   The balance after adding in 26.34 to 1089.83
should be 1116.17.   However, it shows 1250.34 which I'm assuming is several
of the other [un-cleared] transactions as well.

 

Thanks in advance for any assistance,

 

Sincerely,

 

John

 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2017-12-23 09_07_19-gnuCash.png
Type: image/png
Size: 32547 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20171223/f6ac20e7/attachment-0001.png>