Skip to content

Settings and activity

1 result found

  1. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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
    JOHN KALLINICOS commented  · 

    I have had situations where the payment was mismatched simply because another customers payment of the same amount popped up first. Once i corrected the error the matching lined up correctly with the correct payment on the correct invoice. I have also had many instances where the payment matches the total of two correct invoices but they are disregarded in favour of an amount that matches. There is no question that the amount of the payment should never override a customer reference number or an invoice number because these numbers should be unique. In fact the amount should never be used as a matching tool. I have also seen the system match a more recent invoice for the correct customer instead of an older invoice for the same customer with the same amount. The mismatching is often very difficult to detect once its happened.

    An error occurred while saving the comment
    JOHN KALLINICOS commented  · 

    It has now been over 31/2 years since this problem was first flagged. This flaw in the system makes a 30 second job into an all day job and if you get it wrong or more to the point fail to pick up the xero mismatch the error can persist until a customers complains. From a programming perspective it cannot be a complex matter you simply select a different field as your primary matching criteria. We have to reconcile about 400 receipts every month so we are well versed on the problem. Computerization is supposed to improve productivity not reduce productivity and create problems. I am certain that in many cases suers don't even know that this programming error is even happening. Please attend to this matter urgently.

    An error occurred while saving the comment
    JOHN KALLINICOS commented  · 

    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.

    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  ·