Skip to main content
The Best QuickBooks Prices & Service, Since 2001

Call Today 352.742.0800

11313 Davison Lane Tavares, FL 32778
Home

Speak to An Expert

  • Home
  • Bookkeeping
  • About Us
      1. News
      2. Our Team
      3. Enix & Associates, LLC
      4. Enix/Mendelson
      5. Industries Served
  • Tips & Articles
  • Contact Us

QuickBooks Report: Deposit Listing By Bank Account

  • April 2014
  • Reporting
QuickBooks Deposit Listing Report

Q - How can I generate a deposit report for a particular time period by grand total?  I do not need details per customer.  I'm looking for more of a global report.

A - I get this question often because frequently there are significant discrepancies between the net income on the P&L and the amount of deposits made to the bank. There is one standard report that gets you close to this objective but not quite. This is the Deposit Detail report.

Generating the Deposit Detail Report

Reports > Banking > Deposit Detail.  An example is shown below.  As you can see this report gets you the deposits for the period requested but does not total them for you. You could export this to Excel and get what you need but there is a much easier way.

Deposit detail report in QuickBooks

Let me introduce you to "Contributed Reports."  These are custom reports that are created by end users all across the country as well as Intuit personnel.  This is a little known great resource for custom reports.  If someone has already done it why reinvent the wheel?

Contributed Reports

You get to these reports by going to the Report Center.  Click on the Contributed tab and choose the appropriate category from the listing on the left hand panel.  You can also view reports by Industry or even based on their rating from the community.  In our case we are looking for a report that shows total deposits in a period with a grand total.  This is the Deposit Listing By Bank Account report that I have highlighted below.  Scroll down to see the report generated for the same period as the standard report above and you'll also see the grand total that was missing from the standard report.

QuickBooks deposit listing by bank account contributed report

Deposit Listing by Grand Total

This report is concise and gives our client exactly what they were looking for.  Now the question ultimately led to why their deposits were so much less than their net income.  That was because they had significant open receivables, so tighter cash flow policies were needed to ensure collections were being made in a timely manner.  That's a subject for another post on another day.

Categories

  • Agiliron (1)
  • Enterprise (16)
  • Inventory (8)
  • Payroll (2)
  • PCI Compliance (2)
  • Point of Sale (21)
  • QuickBooks (38)
  • QuickBooks Online (15)
  • Reporting (7)
  • Taxes (8)

Recent Posts

  • Accounting for contractors
    Utilizing QuickBooks Online Advanced for the Construction Industry
  • accounting software for law firms
    The Best Accounting Software for Law Firms
  • streamlined processes
    Streamline Business Operations with QuickBooks Enterprise Platinum with The Diamond Package
  • QuickBooks 2020
    New and Enhanced Features in QuickBooks Enterprise 2020

Footer Logo

A multi-national award winning Intuit Premier Reseller and 3-time named Top 100 ProAdvisor serving Tampa & Orlando, Florida. Specializing in QuickBooks Point of Sale, QuickBooks Pro & Premier, Enterprise Solutions and QuickBooks Online.

Services

  • QuickBooks Support
  • QuickBooks Consulting
  • QuickBooks Data Conversion
  • QuickBooks File Review
  • QuickBooks Reporting
  • Software Needs Assessment
Intuit Premier Reseller - Advisory Council Member
Intuit Quickbooks Certified ProAdvisor - Online
Intuit Quickbooks Certified ProAdvisor - Point of Sale
Intuit Quickbooks Certified ProAdvisor - Desktop
Intuit Quickbooks Certified ProAdvisor - Advanced Desktop
Intuit Quickbooks Certified ProAdvisor - Enterpriser
Top 100 ConsultantCertified Consultant500K Club

© 2021 Enix & Associates, LLC   |   Website: Precision Pages Inc.