QuickBooks HelpQuickBooksHelpIntuit

Use Check or Deposit Detail Reports to show transaction links and mimic Cash Receipt Report

by Intuit1 Updated 2 years ago

Use the Check Detail Report or the Deposit Detail Report to show selected transactions and other transactions they are linked to, such as an invoice and its payment. Only the Check Detail report and the Deposit Detail Report show links between transactions. These reports are comparable to a Cash Receipts Journal and a Cash Disbursements Journal.

Important: Use the Check Detail Report if you need to see the paid amount on your report. The Deposit Detail Report does not have an option to add the Paid Amount column.

  1. Open the Check Detail and/or Deposit Detail Reports :
    1. Select Report at the top, then Banking.
    2. Select the desired report.
  2. Modify the Check Detail and/or Deposit Detail Report(s):Note: These two reports have one important difference: the Check Detail Report has an additional column for Paid Amount.
    1. Once the report is open, select the Modify Report. (Mac users: select Filters.)
    2. Within the Modify Report window, select the Filters tab.
    3. Select/Edit your filters to display the transaction type for which you wish to report:
      Transaction TypeFilter (s)
      Credit Memos linked to Invoices
      • Accounts = All A/R and include split detail
      • Amount = Any
      • Transaction Type = Credit Memo
      • Detail Level = All
      Payments linked to
      Invoices & Deposits
      • Accounts = All
      • Amount = Any
      • Transaction Type = Payment
      • Detail Level = All Except Summary
      Invoices linked to Sales Orders
      • Accounts = All
      • Amount = Any
      • Transaction Type = Sales Order
      • Detail Level = Summary Only
      Purchase Orders linked to
      Bills, Credit Card Charges
      and Checks
      • Accounts = All
      • Amount = Any
      • Transaction Type = Purchase Order
      • Detail Level = Summary Only
      Bill Payments linked to Bills
      • Accounts = All Bank Accounts
      • Amount = Any
      • Transaction Type = Bill Payments
      • Detail Level = Summary Only
      Components of Inventory Assembly Builds
      • Accounts = All
      • Amount = Any
      • Transaction Type = Build Assembly
      • Detail Level = Summary Only
  3. Once you have finished, select OK to save your changes and return to the report.
  4. You can also memorize the report for reuse.
    1. Select Memorize at the top of the report.
    2. In the Memorize Report window, enter a title for the report.
    3. If you want to assign the report in a Memorized Report Group, select the Save in Memorized Report Group checkbox, then an existing Report Group from the drop-down.
    4. Select OK. You can then access the saved report easily from Reports > Memorized Reports.
QuickBooks Accountant Desktop 2018QuickBooks Accountant Desktop 2019QuickBooks Accountant Desktop 2020QuickBooks Desktop Enterprise 2018QuickBooks Desktop Enterprise 2019QuickBooks Desktop Enterprise 2020QuickBooks Desktop Enterprise Accountant 18QuickBooks Desktop Enterprise Accountant 19QuickBooks Desktop Enterprise Accountant 20QuickBooks Desktop Premier 2018QuickBooks Desktop Premier 2019QuickBooks Desktop Premier 2020QuickBooks Desktop Pro 2018QuickBooks Desktop Pro 2019QuickBooks Desktop Pro 2020

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this