QuickBooks Tip: Report of Bank Deposits with Total - Long for Success, LLC (2024)

QuickBooks FAQs: Help! How can I create a report that will show all bank deposits with a total for a specific month? If I go to Reports > Banking > Deposit Detail to get a report of deposits for the month there isn’t a total. I can export the report to Excel to calculate a total, but isn’t there an easier way to get the report from QuickBooks? Yes there is an easier method and I’ll show you how to do it. As usual in QuickBooks, there is more than one way to get the report, but here’s an easy method to get a report of monthly deposits with a total.

1. Go to Reports > Custom Transaction Detail Report

2. Change the date to This Month (or the dates you need)

3. On the Filters tab:

• Select Account — Checking (or all banking accounts or the accounts desired)
• Transaction Type — Deposits

On the report, I used the Header/Footer tab to change the name of the report to ‘Monthly Deposits’ and I eliminated some empty columns (Num, Name & Clr). You could also memorize this report for future use.

I hope this QuickBooks tip helps provide you with the information you need quick & easy!

1. Jeffrey 01/13/2015 at 3:34 PM

   Very helpful and so easy that I feel embarrassed. Thank you!!

   See Also

   30 Money Affirmations To Attract and Hold on to Money.

2. John Vaughn 08/13/2014 at 11:41 AM

   Just wanted to say thank you for the very helpful tip.

3. Suzanne 10/09/2013 at 3:14 PM

   I followed the insructions and the report came up but for some reason, I’m getting a zero for a total. Anyone have an idea as to why?

4. Chirs Bertolini 09/03/2013 at 12:50 PM

   This report does not include deposits made through credit card payments.

5. Paula 04/09/2013 at 9:19 AM

   I followed you directions. The date keeps reverting to custom and it lists every deposit with the date and not by total for that day. I don’t understand. I have Quick Books 2011. Confused

   1. Michelle Long Post author04/09/2013 at 10:32 AM

      You can click on the column headings to sort by different fields.

6. Teresa 03/14/2013 at 1:30 PM

   How do I get sub totals by class? When I did your report adding class, it doesn’t seem to recognize the class.

   1. Michelle Long Post author03/18/2013 at 6:18 PM

      You can’t get subtotals with this report and I’m not surprised the classes don’t work. Read QuickBooks Help to learn more about the Balance Sheet by Class and how classes work for balance sheet accounts — it isn’t perfect or seamless.

7. Izzi 07/25/2012 at 3:33 PM

   Thank you so much! Exactly what I was looking for and took no time to locate this article and create document. Thanks for helping me out while in a time crunch. Now why QB does not have this report already generated is beyond me but now I know and this is going in the Memorized category.
   Thanks again and have a good one…

8. SHARON PARKS 05/25/2012 at 12:36 PM

   I NEED TO SHOW THE TOTALS FOR ALL THE MONTHLY DEPOSITS AND MONTHLY TOTALS FOR CHECKS WRITTEN .NOT JUST BY CUSTOMER OR VENDOR BUT THE MONTH END TOTALS OR EACH REPORT

   1. Michelle Long Post author05/29/2012 at 1:07 PM

      This blog post shows how to get a report of monthly deposits with a total. To get a report of checks written, follow the same procedure but for Transaction type select all types of checks (including bill payments, payroll liabilities, etc.). You could also go to the chart of accounts, right click on the checking account and select QuickReport. Then, you could filter for the transactions types as needed.

9. Karen 09/26/2011 at 11:40 PM

   This is great and just in time. I have an existing client that changed from PeachTree to Quickbooks this year. The bookkeeper is having issues with what Quickbooks can or cannot do compared to PeachTree. To optimize Quickbooks, she’ll have to enter transactions without using JEs for most of it. Not only do I have an excellent resource for my own self, but now I can share this information with her so she gets more comfortable using Quickbooks, one of the best accounting systems I’ve used.

10. MJPettus 09/24/2011 at 3:34 PM

    This report is very useful in reconciling one of my clients bank rec. Thank you so much!

11. Nilesh Baxi 09/23/2011 at 5:29 PM

    I like it but why memo says deposit and not actual detail if any. (May be Memo field is blank)

12. Jeff 09/23/2011 at 9:11 AM

    What a great tip. I was looking for a simple way to do this. Thank you for sharing and I really find your blog an informative source of information.

13. Connie Whittemore 09/21/2011 at 12:09 PM

    You could also get a Quick Report on the checking account from the COA and filter the same way. That report eliminates the step of having to filter for the specific account and it does show fewer columns but the end result is the same. The Quick Report can also be formatted in whatever way the user would like and then memorized.

14. Pingback: Top 10 Tuesday QuickBooks Tips From Around the Web - 3/8/2011 | QuickBooks for Contractors blog

15. faye 03/03/2011 at 8:44 AM

    you are an angel to share your knowledge with others. thank you lady!

    I hope your day is a good one

    Faye