Deposit Detail Report

I'll share some insights about how the Deposit Detail report works in QuickBooks Online (QBO), @CFMC.

This report provides a comprehensive overview of your deposits made into your bank account. It includes information about each deposit, such as the date, amount, and associated splits. 

When you enter a transaction into the register, only one account can be associated with it. However, when you list multiple accounts or enter a split transaction, the report will accurately reflect this, including the respective amounts. 

Please see the sample image below that displays the report. Under the Amount column list the amounts for each account. The first one is the total amount of the transaction.

Please note that this doesn't indicate a duplicate deposit; instead, it simply presents a breakdown of the deposit's splits with their associated accounts. As long as the information entered in your register is correct, there's nothing to worry about. 

Moreover, learn more about customizing reports in QuickBooks Online to filter relevant details you want to see on the report. After that, I suggest saving the current settings by clicking Save Customization. That way, you no longer have to go through the customization process again if you need the same information in the future.

Please leave a reply if you have follow-up questions about the deposit detail report in QuickBooks. I'd be more than happy to answer them for you.

The way your example photo is laid out makes sense, but it's not quite the same as what I am seeing. The overall amount shows up as a "cleared" transaction while all the splits appear to be separate "uncleared" transactions. See photo for how it is showing up.

I can provide you with additional information about the transactions showing in your Deposit Detail report, @CFMC. 

The Cleared transactions are the amounts that have been downloaded from your connected bank account. On the other hand, the Uncleared transactions appearing in your report are transactions such as sales receipts and invoice payments that are under your Undeposited Funds account. To avoid any duplicates from your reports, you can match the downloaded transactions from your bank to your sales receipts or invoice payment transactions.

Here's how:

1. Go to the Transactions tab and then Bank Transactions.
2. Click the bank where these transactions are coming from. 
3. Find a downloaded record and click the Find Match radio button. 
4. Select the downloaded record to expand the view. Note the date, Description (or Bank detail), and amount spent or received.
5. Review the Matching records found in QuickBooks for the possible matching transaction already entered in QuickBooks.
6. If this is the correct match, close the open record and select Match.

Check out this article for more information about matching downloaded transaction with an existing transaction: Match online bank transactions in QuickBooks Online. 

From here, you can now match your bank and credit card statements with your accounts in QuickBooks: Reconcile an account in QuickBooks Online. 

Let me know if you need more information about your report by leaving a reply below. Keep safe, and have a wonderful day!

In regards to the uncleared transactions on the deposit detail report.

I have matched all my downloaded transactions to my sales receipts.  I still have a ton of uncleared transactions on my deposit detail report.

If they are all matched shouldn't they all be cleared?

I'm trying to find out if I have entered Sales Receipts twice, I want to make sure I don't have any duplicates as this will affect our total Profit.

Thanks for sharing your query here in this thread, joy2019. Allow me to help you handle uncleared entries showing on your Deposit Detail reports.

As mentioned by my colleague above, uncleared transactions are sales receipts and invoice payments showing under your Undeposited Funds account. Since downloaded entries are already matched to your sales receipts, you may want to review them on your reports and verify if each transaction are cleared from your bank.

In addition to that, to help you seamlessly locate duplicates in your file, you can utilize the Advanced Search feature in the program. To do this:

1. Click the Magnifying Glass at the top and click Advanced Search.
2. Choose Checks.
3. Enter the Check Number and hit Search.
4. Click to open the transaction.
5. Click More at the bottom and hit Delete.

However, if duplicates are found on your account, here's how to exclude or delete these entries:

1. Go to the Banking menu.
2. Choose Bank Feeds and then Bank Feeds Center.
3. In the Items Reviewed section, hit the account with the transactions you want to remove.
4. Click items to Delete.
5. Tap the transactions you want to delete.
6. Click Delete

Furthermore, I'm adding this guide to help review our account and make sure these match your bank and credit card statements: Reconcile an account in QuickBooks Online.

If there's anything else you need further assistance with, just let me know in the comments below. I'll be sure to get you covered whenever you have additional queries. Keep safe and have a good one!