The Giving Detail report includes totals of revenue received, such as payments. If revenue has not been received, it will not reflect in this report. If your query is showing duplicates and the date ranges match the Giving Detail report, this is typically due to the query including payments and orders. The Giving Detail report only shows payments received, so you query should reflect only payments as well.
 
  • If using a revenue source view: From the left column, select Revenue. From the middle column, drag Transaction Type into Include Records where. Set Equal to Payments.
  • If using a designation source view: From the left column, expand Revenue Splits, then select Revenue. From the middle column, drag Transaction Type into Include Records where. Set Equal to Payments.