Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.