Your réponse really didn't solve the problem. Attached are four transactions, three of which were correctly not coded with a class since no rule exists. The fourth transaction was arbitrarily assigned a class.

The second screenshot shows the format of rules, all of which are ordered in numerical (ascending order). The same format is used for all of our rules assigning classes (They are the last four digits of credit card assignments).

Also, when I try and sort transactions by bank detail order, the sort does not properly list the order of transactions, even though the first four digits are numbers. The sort works fine for the other columns, but not this one column.