Automated Bank Reconciliation - Don't force a match
The attached screenshots show a case where we voided a check in August. In last night's bank feed, the payee cashed the check, but instead of showing the item as needing manual reconciliation, auto bank rec reconciled the check against a completely different payment to a different payee that was paid with a different check number. Needless to say, this would cause havoc later if that mismatched check was presented, and we only caught it today because the bank's Positive Pay flagged what it knew to be a voided check.
If a paper check's match to the bank feed is anything less than perfect (check number + amount), I'd rather deal with that manually than have to clean up issues like this later.
Sorry to hear the auto reconciliation isn't performing as expected Gregory. If you're experiencing performance issues, or something isn't working as you'd expect it to, it's best looked into with a closer lens. Please raise a case with our Xero Support team on Xero Central and our specialists can investigate with you and engage the Product team to look at this. Thanks!
-
Gregory Yorke
commented
additional screenshot of the mismatched checks