Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI'm not understanding the Deposit Detail report in QuickBooks online. It seems to be doubling up our deposits. First it lists the total deposit, then it lists all the splits of that deposit. But all the splits seem to be separate deposits. So at the end of the report, the deposit is double what it actually is. Everything looks fine when I look at the Register for the account, there are no duplicate deposits showing there. Only this one report makes it look like our deposits are doubled.
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.
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:
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:
However, if duplicates are found on your account, here's how to exclude or delete these entries:
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!
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.