Skip to main content
M
Malkia LLC
March 25, 2023
Question

Find Match not finding all Invoices

  • March 25, 2023
  • 1 reply
  • 0 views

I have been trying to Categorize Banking transactions in the "For review" section by using the "Find Match" feature and for some transactions the find transaction doesn't find Invoices that I know do not have a match. I've been using the "Find Match" feature since 2020 so I'm well aware on how to use it at this point, but I am starting to get annoyed that it doesn't find all invoices that are unmatched or unresolved.

 

For clarity, I have a Shopify store that is connected to QBO and auto-generates Invoices and Payments that are made through the Store and my Bank Account is connected to QBO and is fully updated. We get paid through Shopify and those payments have fees that get taken out prior to being deposited. So the deposit doesn't match the Invoice amount, which is fine because "Find Match" allows you to "Resolve" the difference which is a big help. But if the Invoice doesn't even show up in "Find Match" then I cant do anything. 

Here's an example (fake numbers for security):

I have a deposit on 3/15 For review for $55, I click Find Match and numerous unmatched Invoices show up dated from 1/4 - 3/25 for numerous amounts but the Invoice Payment that I need to match it too, dated 3/12 for $62, doesn't show up. However if I review another deposit dated 3/20 for $200 and click Find Match then the 3/12 for $62 Invoice Payment shows up. Again I know that Find Match can find Invoice Payments that don't match the exact amount of the deposit because another deposit I reviewed 3/8 for $86 was able to find the Invoice 3/4 for $92 then I Resolve the difference by adding a line for 3/8 Payee 'Shopify' Category 'Shopify Fees' for $-6.

1 reply

Angelyn_T
Angelyn_T
March 25, 2023

Thank you for adding your initial post and sharing detailed information regarding your banking concern, @Malkia LLC. Let me look into this for your so you can match your entries accordingly.

 

Usually, QuickBooks Online (QBO) offers smart suggestions to match your downloaded entries to speed up the work for you. If not, you can click on the Find match button to do it manually. From the Match transactions page, you can filter the transaction type you want to see and their date range to narrow down your result. There are a few reasons why certain transactions do not appear. Here are the following:

 

  • The transactions entered in QBO don't simply match the number, amount, date, or payee of the downloaded bank deposits.
  • The transactions you want to match have been reconciled.
  • The transaction was recorded in a different bank account.
  • Often, the transaction was recorded to the wrong bank account in QuickBooks. 

 

Sometimes, the match is not found with the Find Match tool because the dollar amount in QB is higher than the bank transaction. I'm adding this screenshot as your visual reference.

 

To fix this, edit the original transaction by adding the bank fee, then refresh the Bank feed window.

 

  1. Open the deposit or invoice payment transaction.
  2. Enter the fee as a negative amount on the second line item.
  3. Save and Close.
  4. Switch back to the Banking page to review the result.

 

I'm adding these articles for more hints while categorizing your banking transactions in QuickBooks:

 

 

 That should do it for you. If you have follow-up questions in mind, notify me by leaving a comment below. I'm just a few clicks away to help. Have a good one!

C
Cathyliu
April 4, 2023

My issue is that I received payments for really old invoices which is beyond half a year and I have to change the period start date every time, is there any way I can change the find match lookup start date and end date? I don't want to do it manually every time.

C
ChristieAnn 11
April 4, 2023

Hi there, Cathyliu.

 

Thank you for visiting the QuickBooks Community. Please know that we aim to deliver customer satisfaction at all times and fix an issue as soon as possible. With this, may I ask for additional information on which part of QuickBooks are you trying to change the find match lookup start date and end date? or, a screenshot of the area are you trying to update? I appreciate any further details so I can present accurate information and a solution.

 

For now, I'm adding this artilcle to see steps on how you can review downloaded transactions by matching or adding them to avoid double entries: Categorize and match online bank transactions in QuickBooks Online.

 

Don't hesitate to click the Reply button below and add extra details about your concern, I'm always around to help, Cathyliu. Have a good one!

Terms & ConditionsAccessibility statement