Skip to main content
J
Jhanse121
December 9, 2021
Question

Missing transaction(s) to match to bank deposit.

  • December 9, 2021
  • 1 reply
  • 0 views

Hello, 

 

I am using QBO as an LLC with 2 employees. The imported banking transaction is correct when compared to that month's bank statement. I do not have QBO set up to automatically match. I manually match the transactions each month. It is usually straightforward. The banking transaction occurred on Nov 10, 2021. Usually, there will be two transactions on the day before to match to. The sum of their parts equals the Nov 10, 2021 amount. However, this is not the case for this particular transaction. I have undone all of that month's transaction matches, to start the process again. I checked for possible mismatches, but I did not have any luck. 

 

What is the problem here? Why are there no matching transactions, and what can I do to resolve?

1 reply

D
DebSheenD
December 9, 2021

Hi, Jhanse121. I'm here to help you match transactions to your bank deposit.

 

Have you checked your transaction list if there are records to match bank deposits? This way, we can verify if there are available items to match. 

 

Here are the steps on how to run the Transaction List by Date report:

 

  1. Go to Reports.
  2. Choose Transaction List by Date.
  3. Enter the date of the transactions.
  4. Hit Run Report.

If the transaction is unavailable on that report, you can enter those items again.

 

Just in case the transactions are missing, you can manually download transactions in QuickBooks Online.

 

Furthermore, here are some resources that'll help you in managing your bank feeds:
 

 

Feel free to comment down below if you have any other concerns or questions about managing transactions. I'm always glad to help in any way I can.

J
Jhanse121Author
December 13, 2021

Hello DebSheenD, 

 

Thanks for responding to my message in such a timely manner. 

 

I have indeed checked my transaction list for any records that matched the bank deposits. That is something I do once or twice a month. 

 

I have attached a few images to this post. One image is the bank deposit made on 11/10/2021 for $858.25. The next image is what I see after clicking on 'find match.' No transaction records that apply for that deposit appear. The last image is the 'transaction list by date' report. Again, nothing matching the charge is obvious. 

 

As I stated in the last post, the bank deposit usually corresponds to two transaction records dated the day before. So in this scenario, there should be two transaction records dated 11/9/2021 that would sum up to the 11/10/2021 bank deposit. 

 

This is a very odd problem. 

Terms & ConditionsAccessibility statement