For those looking for a solution. I changed the ending balance to the credit available to the ending balance on the statement and I was able to reconcile.
View solution in original post
