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!

These two reports don't match, the deposit detail match with the P&L and the deposit listing by bank is much higher.

Hi there, @Mechi.

Let me address your concern about matching reports in QuickBooks Online (QBO).

Beforehand, I'd like to clarify some details to help us get on the same page. Would you mind elaborating more about the deposit listing by bank? Is it from the bank register? If this isn't the case, I'd appreciate additional details you can provide.

Otherwise, you'll want to ensure that both reports have the same report period. I'll show you how:

1. Go to Reports from the left pane.
2. Find and open Deposit Detail and Profit and Loss report.
3. Go to the Report period and modify it according to your needs.
4. Click on Run report to save the changes.

From there, manually compare each transaction to determine the root cause of the discrepancy.

Furthermore, this article can give you more details about personalizing your reports based on your needed data: Customize reports in QuickBooks Online.

On top of that, I've added this great resource that helps you modify your reports and save its current customization settings for future use: Memorize Reports in QuickBooks Online.

Stay in touch if you have any other questions or concerns about your reports in QBO. I’ll be right here to answer them for you.

That does not help, I know how to run the reports. I'm selecting a year period from March 2023 to March 2024. the problem is totals don't match. "Deposit listing by bank account" matches P&L and "Deposit detail report" is much higher, in my case by about $20,000.

Thanks for returning to this thread, @Mechi. Let me clarify why the totals in the Deposit Detail report don't match the Profit and Loss (P&L) in QuickBooks Online (QBO).

The totals seen on the P&L consist of all deposits associated with the income and expenses accounts. However, the totals viewed on the Deposit Detail report are much higher since it includes all the deposits created into your bank account.

On the other hand, if you're referring to the amounts shown on a specific deposit on the Deposit Detail report, it reflects the particular breakdown of the deposit when multiple accounts are selected, or a split transaction is entered. This is why the amounts are displayed in detail.

I've attached screenshots for your reference:

The deposit amount is divided among associated accounts in the breakdown. There's no need to worry as long as the deposit amount is correct in the register.

For future reference, you can check out this article to learn how to reconcile your accounts, so they always match your bank statements: Start your reconciliation.

I'll be here to assist you more if you need further assistance with analyzing the difference in amounts between the Deposit Detail and P&L reports. Have a productive day.