Account Reconciliation import

SUGGESTED

I am trying to figure out this bank reconciliation process in Sage. I'm coming from Xero so I think I am having a hard time due to having the old systems' process stuck in my head.

When importing a bank statement, Sage attempts to 'Autoclear' records but none do so. As a result Id have to either 'Manually Match' or 'Create a new' entry?

I am used to having a bank statement list and an Account transaction list of live system transactions, then I match the two.

Currently, Sage shows all of my imported transactions with the red flag as a 'new bank record' showing the source as 'bank'. BUT.... it won't (90% of the time) match  records to existing transactions. Many times I have a deposit with prepayments as well as payments for live invoices so I have to make 2 separate 'receive money' entries.

What am I missing? 

Is there just a lot to be desired in the account reconciliation functionality?

-Collin