cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Torquil
Level 2

Auto matching invoices?

My question is about matching bank payments coming into QBO with invoices. In order for QBO to auto match the transaction it seems to need the Customer name to be identical to the name coming from the Bank detail. i.e John Smith has to be John Smith. If it's slightly different (e.g. Mr. J Smith) it gets confused and just finds me a load of similarly priced invoices as a choice to match it to. 

 

Is there any way of getting QBO to match them from the Invoice number which is also used as the Reference coming in with the BACS bank payment. These should match identically for every transaction but QBO seems to ignore these and just give me 5-10 invoices to choose from when it should be obvious which one to choose. I end up having to go through every transaction and matching them when it should be easy to automate.

 

Hopefully I'm missing something obvious and this isn't just a limitation of the app. Is it possible to use a Rule to match Invoice number to Bank Detail Reference? 

 

Thanks

Solved
Best answer May 21, 2022

Accepted Solutions
JessT
Moderator

Auto matching invoices?

Hi Torquil,

 

The number one reference for automatic matching is the amount, the movement of money, and the bank details.

 

I also like the idea of ​​using invoice numbers as an additional basis. This will indeed help to filter out matching entries, especially when there are multiple transactions with the same amounts. However, such an option is not available at this time. You may want to consider creating bank rules to refine the process of finding a match.

 

On the other hand, I want to add these articles for your reference for your next steps:

 

 

Feel free to send some comments if you have other concerns about your transactions. I'm just around to continue to help.

View solution in original post

1 REPLY 1
JessT
Moderator

Auto matching invoices?

Hi Torquil,

 

The number one reference for automatic matching is the amount, the movement of money, and the bank details.

 

I also like the idea of ​​using invoice numbers as an additional basis. This will indeed help to filter out matching entries, especially when there are multiple transactions with the same amounts. However, such an option is not available at this time. You may want to consider creating bank rules to refine the process of finding a match.

 

On the other hand, I want to add these articles for your reference for your next steps:

 

 

Feel free to send some comments if you have other concerns about your transactions. I'm just around to continue to help.

Need to get in touch?

Contact us