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:
 

• Tips for Working in QuickBooks Online’s Bank Feeds: Matching Transactions
• Categorize and match online bank transactions

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.

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. 

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?

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!

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.