Settings and activity
1 result found
-
12 votes
Thanks for sharing this idea. I can see why matching by invoice number or reference, instead of relying on the amount first, would be really valuable for businesses dealing with instalments, part-payments, or payments that don’t exactly equal the invoice total.
Right now, suggested matches are based on the statement line and transaction having the same amount, with other statement details also considered, so I understand why this request would help reduce manual work and lower the risk of matching a payment to the wrong invoice.
If this would improve your workflow too, please add your vote and comment with a real example of when matching by invoice number or customer reference would save time or prevent errors. The more detail shared here, the easier it is to show the impact this has for customers.
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
·
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.