cancel
Showing results for 
Search instead for 
Did you mean: 
CFMC
Level 1

Deposit Detail Report

I'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.

11 Comments 11
Nicole_N
QuickBooks Team

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.

CFMC
Level 1

Deposit Detail Report

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.

MJoy_D
Moderator

Deposit Detail Report

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!

joy2019
Level 1

Deposit Detail Report

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.

 

 

FateCandylaneT
QuickBooks Team

Deposit Detail Report

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!

Mechi
Level 2

Deposit Detail Report

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

Carneil_C
QuickBooks Team

Deposit Detail Report

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.

Mechi
Level 2

Deposit Detail Report

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.

CarlSJ
QuickBooks Team

Deposit Detail Report

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:

 

image.png

 

image.png

 

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.

 

image.png

 

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.

nanabea
Level 1

Deposit Detail Report

why are these deposits showing as uncleared. What does this mean.

Erika_K
QuickBooks Team

Deposit Detail Report

Thank you for taking the time to join this conversation, bea. I truly appreciate your engagement and interest in discussing financial processes. I’m here to provide detailed information regarding the deposits showing as unclear in your financial records.

 

The uncleared status in the Deposit Detail report means that the transaction has not been matched with any corresponding transaction on your bank statement. On the other hand, the cleared status indicates that the deposit reflects your actual bank activity. If you have a downloaded bank transaction on the Bank transactions page, you can match it to mark it as cleared. If your bank account isn't connected to QuickBooks, you can manually mark it as cleared in your bank register in your Chart of Accounts. You can refer to the image below. 

image.png

Finally, if you have discrepancies with your deposits, you can use your bank statement as a reference to help verify your business activities. Your bank statement serves as an official record of all transactions, providing a detailed overview of your financial inflows and outflows. It’s also important to ensure your bank statement aligns with the financial records maintained within your accounting software. This alignment is essential for accurate financial reporting and effective cash flow management.

 

If you have any additional inquiries or require further assistance regarding the management of deposits or related accounting tasks, please feel free to comment below, bea. Our team is available 24/7 and is dedicated to provide you with the support and guidance you need to effectively manage your financial records and ensure the accuracy of your accounting processes.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us