Settings and activity
2 results found
-
9 votes
Hi community, appreciate the interest for being able to match based on the invoice number, even if the amount of the statement line and transaction in Xero differ. While this isn't something we have plans for at this stage, it'll be good to get a sense of the interest for this here.
Just to confirm for everyone coming across - The way suggested matches work currently 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.
An error occurred while saving the comment An error occurred while saving the comment 
JOHN KALLINICOS
commented
When importing bank statements from other programs Xero allocates the payments to the customers on the basis of amount in preference to other variables like customer code, invoice number or name of customer. This preference to amount creates a lot of miss matching of payments and requires extreme caution as payments end up being allocated to the wrong customer. The payment should default to invoice number then customer reference then customer name. It should never be allocated by amount owing as this is not unique.
An error occurred while saving the comment 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.
An error occurred while saving the comment 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.
JOHN KALLINICOS
supported this idea
·
-
1 voteJOHN KALLINICOS
shared this idea
·
I cannot believe that this issue is not taken seriously. I am an accountant with 45 years experience. I would suggest I have a fair idea of an accounting problem and this is a problem. I had a similar issue when I had to educate XERO as to what constitutes the fundamentals of a trial balance and they still got it wrong. When you produce software for accountants you would think a software company might take some notice of accountants.