Bank Reconciliation - Matching by invoice number rather than amount
Reconciliation to be matched by INVOICE NUMBER rather than amount
The way suggested matches work atm is based on the amounts of the statement line and transaction being the same and also looking at most of the fields of a statement line and comparing with transactions entered to show a preferred match.
However, if I understand the idea here correctly you're asking for a suggested match to be shown if the invoice number matches but the amounts of the statement line and transaction differ?
-
JOHN KALLINICOS commented
On further consideration I have to agree invoice number is definitely the best option because it’s unique. It’s a shame Xero seems to think this is not a big deal. The current match based on amount creates a lot of work and errors. It’s a shame they do not understand the problem.
-
JOHN KALLINICOS commented
Invoice number will not necessarily fix the problem but it’s better than basing the matching on amount. In reality it should match in the following order reference, name, invoice number. Amount should never be used as it’s too remote.