This report shows you all of the payments you received and deposits you made within the selected time period, with a subtotal for each customer, and a grand total at the bottom of the report.

  1. From the QuickBooks Reports menu, select Custom Reports then click Transaction Detail.
  2. Enter the appropriate date range.
  3. In the Columns box, check off the following columns:
    • Type
    • Date
    • Num
    • Memo
    • Clr
    • Split
    • Amount
  4. Click the Total by drop-down and select Customer. If you want, you can also select different criteria, for example, Total by account or Total by month. 
  5. Go to the Filters tab and from the Filter list, select Transaction type.
  6. From the Transaction Type drop-down, choose Multiple transactions then check off the following:
    • Deposit
    • Sales Receipt
    • Invoice
    • Payment
  7. Choose the Detail level filter and select Summary only.
  8. Click OK.

Note that whenever there is more than one split account, the report will show the word SPLIT in the Split column. This report will not show each split account by name.

You may also want to see Create a Cash Disbursements Journal report.