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

Missing transaction(s) to match to bank deposit.

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?

5 Comments 5
DebSheenD
QuickBooks Team

Missing transaction(s) to match to bank deposit.

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.

Jhanse121
Level 1

Missing transaction(s) to match to bank deposit.

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. 

Jhanse121
Level 1

Missing transaction(s) to match to bank deposit.

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 tried your suggestion and look at my transaction list by date, screenshot of which is attached. I see that there is a payment made on 11/9/2021 of $1714.11 that is the sum of the $858.25 and $855.86 transactions. However, there is also a bank deposit for the $855.86 transaction for 11/9/2021. 

 

I think the problem is that there should be one bank deposit for $1714.11 for 11/9/2021, for which I could attribute both transaction records to. 

 

Can I create an invoice for both or one transaction, since one of the transactions does have a matching bank deposit? Should i clear the payment on the $1714.11 line on the report?

Adrian_A
Moderator

Missing transaction(s) to match to bank deposit.

I appreciate you for trying the steps shared by my colleague, Jhanse121.

 

Yes, you can create an invoice for one transaction that doesn't have a match. From there, try running the report again to check and see if you'll still be having mismatch items.

 

You can also do a reconciliation to ensure that the transactions match to what your bank recorded. Here's an article as your guide: Reconcile an account.

 

Keep me posted if there's anything that I can help with. Keep safe!

Jhanse121
Level 1

Missing transaction(s) to match to bank deposit.

Ok,

 

I went to New+ -> payments, and created a new payment on 11/10 for $858.25. I was then able to match it in banking, and then i reconciled my november statement in chart of accounts. Seems like it worked. 

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

Need to get in touch?

Contact us