Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHello,
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
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:
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.
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?
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??
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here