Skip to main content
G
grudgemom
January 14, 2022
Question

Transaction missing in Find Match

  • January 14, 2022
  • 1 reply
  • 0 views

I have a sales receipt for $5.00, dated 12/23/2021. I am trying to match it to the bank feed transaction for $4.55 ($5.00 less the $0.45 Stripe processing fee - I typically find the match to the gross amount then add a Resolve Discrepancy to subtract the processing fee). When I click on Find Matches, no matches are found. My date range is 9/24/2021-1/2/2022.

However, when I click on a $9.10 transaction dated 12/22/2021 and click on Find Matches, five $5.00 matches are listed, including the one that is missing on the 23rd.

I have double checked everything. The dates are within range. The account is Undeposited Funds. It is not matched to anything in the register, nor does it have a C or R. I have cleared my cache and restarted my browser. The discrepancy in amounts should have no bearing, especially at less than $4. I've had larger discrepancies show up before.

I am pulling my hair out here. What am I doing wrong?

 

Sales Receipt:

 

Matching options for 12/22/2021 transaction:

 

Matching options for 12/23/2021 transaction:

 

1 reply

Angelyn_T
Angelyn_T
January 14, 2022

Hi there, @grudgemom. Thank you for sharing your concern in here the Community and for adding screenshots for me to visualize your transactions. I want to ensure your concern is taken care of firsthand so you can match your entries successfully.

 

QuickBooks offers smart suggestions when matching downloaded transactions to speed up the work for you. The system will see this as a possible Match as long as the needed requirement is met. If no transactions are reflected on the Match transactions window, it can be caused by the following:

 

  • The transaction is older than 180 days.
  • The dollar amount in QB is different than what cleared the bank.
  • The type is different in QB than at the bank. The system wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • 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 located with the Find Match tool because the dollar amount in QB is higher than the bank transaction. If this is the case, edit the original transaction and refresh the Bank feed window.
  • The transaction from the bank is a payment/deposit.

 

Based on your third screenshot, I can see that the downloaded amount is $4.55 and you're trying to find the $5.00 transaction. In QBO, the banking entry must be greater than or equal to the manually added transaction so you can match them. If it's lesser than the manually created transaction, then no transactions will show up on the page. 

 

To isolate the issue, you can update the sales receipt amount to $4.55 so you can match them seamlessly. Once done, record the processing fee in a separate transaction using a check or an expense.

 

  1. Go to the +New icon, then click on Check or Expense.
  2. Fill in the information, including the expense account used to track your bank or processing fees.
  3. Click on Save and close.

 

When everything is in place, you're now ready to reconcile your account to keep your books and balances correct.

 

If you have any other follow-up questions about your banking entries, let me know by adding a comment below. I'm more than happy to help. Have a good one!

C
cargodyn
July 13, 2023

Was there ever an actual solution to this problem? I'm having the same issue and QBO support team has been ZERO help. 

I've also checked all of these and it's not any of these:

 

  • The transaction is older than 180 days.
  • The dollar amount in QB is different than what cleared the bank.
  • The type is different in QB than at the bank. The system wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • 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 located with the Find Match tool because the dollar amount in QB is higher than the bank transaction. If this is the case, edit the original transaction and refresh the Bank feed window.
  • The transaction from the bank is a payment/deposit.

 

T
Trish_T
July 13, 2023

Hi cargodyn,

 

Thanks for joining us here.  It's important that you're able to match your transactions effortlessly in QuickBooks Online.  To ensure success, I recommend following the steps provided above, to ensure associated bank fees have been recorded.  Once this process is complete, QuickBooks will be able to match the transaction automatically.  Here's a helpful guide for your reference.

 

If you require additional assistance, please don't hesitate to contact us outside of Community.  We would love the opportunity to work with you personally, and ensure you're able to match your transactions without delay!

 

Feel free to reach back out if you have other questions.  We're always happy to help!

Terms & ConditionsAccessibility statement