The current default sorting order sorts the transactions by date. But when a transaction has a check number, it sends that transaction to the end of that day. This messes up the entire order and the only solution is to add numbers to the rest of the transactions made on the same date.

I suggest a sorting order which sorts the transactions as and when they're added. Even if a transaction has a check number, it should stay in the same order as it was added.