Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
MT2874
Returning Member

Bank Deposit Not Showing Individuall Transactions

Hello, 

 

I have a bank deposit showing inside of Quickbooks but it does not show each individual transaction. It's a combination of multiple deposits but I can't figure exactly which ones. I've tried adding up the credits around that date from the Bank Register but they don't match up exactly. The deposit was made on a Monday so I'm guessing there are a few days of transactions all batched into that one. 

Anyone run into this and/or know how to resolve this? 

 

Thank you!

Mark

4 Comments 4
Jayson_E
QuickBooks Team

Bank Deposit Not Showing Individuall Transactions

You can review the lump deposit transaction in the Chart of Accounts (COA) in QuickBooks Online (QBO) to see the details of each transaction that makes up the deposit, Mark.

 

To do this, open the register for the bank account where the deposit was made. Locate the lump deposit transaction, then click on it to drill down and view the individual payments included. This helps verify and reconcile the deposit against your bank statement, ensuring all payments are correctly recorded and matched in QBO.

 

Here's how:

 

  1. Hover your cursor over the My apps menu.
  2. Click the Accounting drop-down, then select the Chart of accounts.
  3. Locate the account where you deposited those transactions, and click View register.
    image.png
  4. In the register, locate the specific lump deposit transaction and click Edit to open the details.
    image.png
  5. From there, you will be able to see and review the individual transactions/payments that were combined into the lump deposit.
    image.png

 

You can also untick any of the combined transactions if you want to remove them from that deposit, and make separate bank deposits of those transactions individually, moving forward. This allows for better tracking and more accurate reconciliation.

 

Feel free to add a reply below if you have further questions.

MT2874
Returning Member

Bank Deposit Not Showing Individuall Transactions

Jayson - thanks for the response!

 

The lump deposit I mentioned appears both on the bank statement and the Pending tab of the Bank transactions page. Meanwhile I also have multiple, smaller deposits dated at around the same time as the lump deposit. These smaller deposits don't appear in my bank statement but are reflected on my Undeposited Funds. This makes me believe that the smaller deposits should be matched with the lump deposit. The problem however is that whatever combination of smaller deposits I try, they don't exactly add up to match with the lump deposit. 

 

Any recommendations? 

MT2874
Returning Member

Bank Deposit Not Showing Individuall Transactions

Thanks Jayson for the response!

 

The lump deposit I mentioned appears both on the bank statement and the Pending tab of the Bank transactions page. Meanwhile I also have multiple, smaller deposits dated at around the same time as the lump deposit. These smaller deposits don't appear in my bank statement but are reflected on my Undeposited Funds. This makes me believe that the smaller deposits should be matched with the lump deposit. The problem however is that whatever combination of smaller deposits I try, they don't exactly add up to match with the lump deposit. 

 

Any thoughts??

JoesemM
Moderator

Bank Deposit Not Showing Individuall Transactions

Thank you for your response and for providing additional details about your concern with the bank deposit, MT2874.

 

Before matching your deposits in QuickBooks, let's first identify why you're unable to match your transactions. Here are a few common reasons:

 

  • Deposits are recorded in different accounts than the bank account used.
  • Bank charges, fees, or adjustments may cause differences between bank statements and QuickBooks deposits.
  • Typos or incorrect amounts might have been entered during the recording of deposits.
  • A deposit might not have been entered into QuickBooks at all, or some transactions may have been missed.

 

Since you mentioned that the smaller deposits are not appearing in your bank statements, it’s possible they were deposited into a different account. Ensure that all smaller deposits are recorded in QuickBooks so they can be properly matched.

 

To trace and verify deposits, you can run the Invoice and Receive Payments report. This report allows you to track payments received for specific invoices. Then, filter for the correct Report period. Click on the invoice or payment within the report to review the transaction details.

 

If a bank or processing fee needs to be recorded, refer to the Add bank or processing fees section in this article: Record and make bank deposits in QuickBooks Online.

 

By the way, if you're using QuickBooks Payments, the system will automatically record invoice payments and deposits in QuickBooks Online (QBO). If you need to fix a payment for a bank deposit, you can open this article for guidance: Fix deposits to match your bank statements.

 

If you have further questions about deposits, feel free to reply to this thread. I’m here to assist and will always have your back.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us