Skip to main content
C
CFMC
January 13, 2024
Question

Deposit Detail Report

  • January 13, 2024
  • 2 replies
  • 0 views

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.

2 replies

Nicole_N
Nicole_N
January 13, 2024

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.

C
CFMCAuthor
January 15, 2024

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
MJoy_D
January 15, 2024

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!

M
Mechi
July 2, 2024

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

C
Carneil_C
July 2, 2024

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.

M
Mechi
July 7, 2024

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.

Terms & ConditionsAccessibility statement