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.