Skip to main content
J
jennifer-collier
December 19, 2022
Question

Is there a deposit summary report? I need a grand total of deposits year to date. The deposit detail report does not total...

  • December 19, 2022
  • 1 reply
  • 0 views
Or is a customization option to total the deposit detail report?

1 reply

R
Rea_M
December 19, 2022

Hello there. Welcome to the Community.

 

Let's pull up the Transaction Detail by Account instead so you can get the grand total of your year-to-date deposits in QuickBooks Online (QBO).

 

For the time being, there isn't a specific deposit summary report or a customization option to total the deposit detail report in QBO. Instead, you can pull up and customize the Transaction Detail by Account to get the data you need. To do this, here's how:

 

  1. Go to Business overview, then select Reports, or go to Reports.
  2. Use the Find report by name search bar to find and open the Transaction Detail by Account.
  3. Select Customize.
  4. Set the Report period.
  5. Go to the Rows/Columns section to change columns if necessary.
  6. In the Filter section, set the Transaction Type field to Deposit. Then, change the Distribution Account and Account fields if necessary.
  7. Click the Run Report button. 

     

 

You can read this article to learn more on how to get the most out of your financial reports in QBO: Customize reports in QuickBooks Online.

 

Also, you may want to check out this article as your reference to guide you through a few ways you can customize reports to fit your specific needs in QBO: Common custom reports in QuickBooks Online.

 

Please feel free to let me know if you have other reporting concerns or questions about managing deposits and income transactions in QBO. I'm always ready to help. Take care, and I wish you continued success.

H
Hope251
December 6, 2023

Hello, 

 

I am trying to run Deposit Detail Report from Quick books desk top. I want it to show the deposits plus any credits that were applied to those invoices that a payment was applied to. 

R
rvrfrf
December 6, 2023

Thanks for joining the Community and getting involved with this thread, Hope251.

 

You can set specific filters on your Deposit Detail Report to get it to display credit memos linked with invoices.

 

Here's how:
 

  1. In the top menu bar, go to Report, then Banking.
  2. Choose your Deposit Detail Report.
  3. Once it's opened, click Modify Report.
  4. From the Modify Report window, access your Filters tab.
  5. Specify which Transaction Type filter you'd like to report on. For credits, you can pick Credit Memo.
  6. Select OK to save the changes.

 

You can also memorize your report by using the Memorize option at the top of it.

 

I've also included a detailed resource about working with the Deposit Detail Report which may come in handy moving forward: Use Check or Deposit Detail Reports to show transaction links & mimic Cash Receipt Report

 

I'll be here to help if there's any questions. Have an awesome day!

Terms & ConditionsAccessibility statement