cancel
Showing results for 
Search instead for 
Did you mean: 
treasurerMLE
Level 1

QB not finding transactions to match banking data (checks that were written and printed by QB)

I issued about 45 checks for the same amount on a single day. Those checks are now being deposited and are clearing in my bank account, but QB is not matching (or even showing possible matches) to these checks. I am positive these checks I can't find have not already been matched yet (in fact, some of the matches being suggested ARE checks/recipients that have already been matched)!  I cleared cookies, etc.  
 
So for example, Check 2135 was deposited and is showing in my "For Review"; it has not been matched to a transaction yet. When I click to see all possible matches in the screenshot AND when I click "Find other matches", QB skips over 2135. It's just not showing 2135 as an option to match.  
 
This is just an example, I currently have 12 checks in my "For Review" area of Banking that are not showing up.  Please advise. 
5 Comments 5
AdonL
QuickBooks Team

QB not finding transactions to match banking data (checks that were written and printed by QB)

We're pleased to have you in the Community space, TreasurerMLE. I'll share some details on why you're unable to match transactions in QuickBooks Online (QBO).

 

When utilizing the Find match option in QBO, some transactions can’t find their match from existing records because:

 

  • The amounts or dates don’t match.
  • The transaction is older than 6 months.
  • The bank account on the payment isn't the same as the bank where the match is located.
  • The payment has been reconciled.
  • The system will look for transaction(s) that fall within a 10% range of the bank transaction dollar amount when trying to match foreign currencies.
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different

 

After confirming everything, utilize the Find Match feature to show all potentially matched transactions. You can also adjust the fields for ShowSearch, and  From and To (Dates) to narrow down your searches.

 

To keep your accounts and bank data accurate from time to time, I recommend checking these articles for tips and guides:

 

 

If there's anything else you need from me, feel free to comment below. I'm always here to help in any way I can. Have a great rest of your day!

treasurerMLE
Level 1

QB not finding transactions to match banking data (checks that were written and printed by QB)

Thank you, unfortunately none of those answers solve with 12 of the checks aren't finding matches.

 

  • The amounts or dates don’t match. All TWELVE checks were issued for $250 and all were deposited by the recipient on the same day -- 7/31/24. 
  • The transaction is older than 6 months. Checks were issued within last two weeks (all of them were written on 7/22/24 and 7/23/24. 
  • The bank account on the payment isn't the same as the bank where the match is located. We only have one bank account on this account. 
  • The payment has been reconciledThey have not, I have been able to reconcile other checks that were deposited AFTER 7/31, but not any of the checks that were deposited on 7/31/24. 
  • The system will look for transaction(s) that fall within a 10% range of the bank transaction dollar amount when trying to match foreign currencies. All checks are for the same amount and in USD. 
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different All checks written in and deposited in USD.

 

As you can see for check 2135, the proper matched check is not shown. I will add screenshots to show that 2135 is also not in the additional matches or already reconciled. 

treasurerMLE
Level 1

QB not finding transactions to match banking data (checks that were written and printed by QB)

As you can see, it is also not included in my "Find Other Matches." 

treasurerMLE
Level 1

QB not finding transactions to match banking data (checks that were written and printed by QB)

And it is not included in already reconciled, as shown in the screenshot (all my reconciled transactions are in alphabetical order here). 

Carneil_C
QuickBooks Team

QB not finding transactions to match banking data (checks that were written and printed by QB)

I appreciate your reply, @treasurerMLE.

 

Let me connect you with our team, which specializes in resolving banking issues efficiently.

 

Since the checks aren't still finding their matches after reviewing the possible reasons for the issue, I recommend getting in touch with our QuickBooks Online (QBO) Support Team so they can review your account safely and investigate what's causing this matter. This way, they'll be able to guide you further on how to sort this out.

 

Here's how:

 

  1. Click Contact Us from the Help (?) menu.
  2. Please enter your question and select Let's talk.
  3. From there, review and choose from the following: Have us call you and Chat with us.

 

You'll want to check out this article that can aid you in organizing your transactions seamlessly: Categorize and match online bank transactions in QuickBooks Online.

 

Furthermore, it's recommended to reconcile your accounts so they always match your bank statements. This reference can give you further details: Reconcile an account in QuickBooks Online.

 

The Community space is still open for you. So, if you still have banking queries, let us know, and we'll be here to help. Take care always.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us