QuickBooks HelpQuickBooksHelpIntuit

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

SOLVEDby QuickBooks5Updated over 1 year 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.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Desktop AccountantQuickBooks Desktop PremierQuickBooks Desktop ProQuickBooks Enterprise QuickBooks Enterprise AccountantQuickBooks Enterprise Diamond

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this