Answers.Body: <p>Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!</p>
  
  <p>So if you select column ‘Credit Card Type’ a non-credit card contribution like this chq are aggregated over the number of financial transactions associated with the contribution, b/c the field ‘Credit Card Type’ lives in the Financial Tables. </p>
  
  <p>So this is definitively a different bug from the one referenced here as well; this bug is related to (unnecessary) financial transactions.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-06T22:17:56.577Z
Answers.LastActivityDate: 2019-03-07T21:58:17.960Z
Answers.LastEditDate: 2019-03-07T21:58:17.960Z
Answers.UserDisplayName: KarinG - Semper IT
Answers.Body: <p>There is a known bug (<a href="https://lab.civicrm.org/dev/core/issues/655" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/issues/655</a>) in the Contribution Detail report right now that will multiply gifts by the number of soft credits. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-06T21:21:10.093Z
Answers.Text: There are no soft credits on this contribution; I’ve updated the question.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-06T21:37:15.203Z
Answers.Text: The linked issue suggests it might not be limited to soft credits, i.e. `it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID`. Unless I'm misreading that.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-08T15:25:14.020Z
Answers.Text: Isn't a Memoriam Donation a soft credit?
Answers.UserDisplayName: guyiac
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-06T20:59:58.740Z
Answers.LastActivityDate: 2019-03-06T21:05:16.110Z
Answers.LastEditDate: 2019-03-06T21:05:16.110Z
Answers.UserDisplayName: guyiac
Body: <p><strong>Version:</strong> CiviCRM 5.7.4/5 (patched for Contact images)</p>
  
  <p>A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:</p>
  
  <p><a href="https://i.sstatic.net/MeHAY.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/MeHAY.png" alt="enter image description here"></a> </p>
  
  <p><strong>Issue:</strong> in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.</p>
  
  <p><a href="https://i.sstatic.net/uPTOi.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/uPTOi.png" alt="enter image description here"></a></p>
  
  <p><strong>Question:</strong> why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country</p>
  
  <p>Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only</p>
  
Tags: <civicontribute><financial-accounts>
Title: Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?
ThreadText: # Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?
  
  (Asked by: username_0 on 2019-03-06)
  
  **Version:** CiviCRM 5.7.4/5 (patched for Contact images)
  
  A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:
  
  [![enter image description here](https://i.sstatic.net/MeHAY.png)](https://i.sstatic.net/MeHAY.png)
  
  **Issue:** in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.
  
  [![enter image description here](https://i.sstatic.net/uPTOi.png)](https://i.sstatic.net/uPTOi.png)
  
  **Question:** why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country
  
  Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only
  
  **Tags:** civicontribute, financial-accounts
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2019-03-06. Score: 4
  
  Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!
  
  So if you select column ‘Credit Card Type’ a non-credit card contribution like this chq are aggregated over the number of financial transactions associated with the contribution, b/c the field ‘Credit Card Type’ lives in the Financial Tables.
  
  So this is definitively a different bug from the one referenced here as well; this bug is related to (unnecessary) financial transactions.
  
  
  ---
  
  ### Answer by username_1 on 2019-03-06. Score: 3
  
  There is a known bug (<https://lab.civicrm.org/dev/core/issues/655>) in the Contribution Detail report right now that will multiply gifts by the number of soft credits.
  
  > **Comments:**
  > **username_0**: There are no soft credits on this contribution; I’ve updated the question.  
  > **username_2**: The linked issue suggests it might not be limited to soft credits, i.e. `it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID`. Unless I'm misreading that.  
  > **username_1**: Isn't a Memoriam Donation a soft credit?  
  
  ---
  
  