use automated payment matching rules
MYOB and Xero both have smart matching and rules.
Customers bank account names are consistent so the system learns (or allows you to create a rule) that matches the customer name with the payment reference. It will either match the payment automatically, or only suggest invoices from the right customer.
Or if one payment doesn't match an invoice amount they look to see if multiple invoices from the same customer may equal the amount of the payment. This is a common situation that customers make more than one purchase over a month.
Tim
shared this idea
-
Andriy Sunford
commented
Hello!
I am confused you still don't have this option. And got reply from support:"The bank feeds of a few banks only share the descriptions. Yes, your bank can have a unique order number. But most of the other banks don't share the same."
I am sorry! But all Europe banks supports XML SEPA statement (CAMT.053) and it's include a description field <Ustrd>Payment 2019-01-03 13:13:09 PAYPAL *OVH, 50003, 3500000001, FR CD 3443 (70005)</Ustrd>. Paypal, Autorize.net, or any merchant account supports description field.
But you remove the field <Ustrd></Ustrd> and that why automatically transactions matching are almost impossible (sum or date matching is very inaccurate).
So, I am 100% sure automatically transactions matching is a cool thing you should add. And yes, Xero already has it!