Skip to main content
T
treasurerMLE
August 12, 2024
Question

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

  • August 12, 2024
  • 1 reply
  • 0 views
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. 

1 reply

A
AdonL
August 12, 2024

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 Show, Search, 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!

T
treasurerMLEAuthor
August 12, 2024

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 reconciled. They 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. 

Terms & ConditionsAccessibility statement