Answers.Body: <p>Likely due to <a href="https://issues.civicrm.org/jira/browse/CRM-19940?filter=-2" rel="nofollow noreferrer">this issue</a>.
  Looks like there is a PR to correct this with a milestone of 5.4.0, so I guess this problem persists in the current 5.2.1 release.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-26T18:29:35.713Z
Answers.LastActivityDate: 2018-06-26T18:29:35.713Z
Answers.UserDisplayName: BobS
Body: <p>For recurring contributions, I am getting unusual results in the <code>civicrm_financial_trxn</code> table. Three very similar entries are created for each contribution, two of which cancel one another out.</p>
  
  <p>Am I failing to grasp something about double-entry accounting, or are two of these records simply unnecessary?</p>
  
  <p>Or perhaps my financial types are configured to do weird things. Perhaps there <em>should</em> be three entries, but at least one account code other than 1150 and 455-11 should be in play. If this is the case, how do I go about identifying the culprit financial account?</p>
  
  <p>Below is a screenshot from the Bookkeeping Transactions Report:</p>
  
  <p><a href="https://i.sstatic.net/Q65yy.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Q65yy.png" alt="Bookkeeping Transactions Report"></a></p>
  
  <p>Some notes:</p>
  
  <ul>
  <li>It's probably not sensitive, but I've changed the transaction number out of an abundance of caution. Note that the original number was the same for all three rows.</li>
  <li>Note that the first and second rows cancel one another out (the amount in the second row is negative).</li>
  <li>Note that the payment method is blank for the third row.</li>
  </ul>
  
  <p>Below is a screenshot of the <code>civicrm_entity_financial_trxn</code> entities that feed into the report:</p>
  
  <p><a href="https://i.sstatic.net/UECr9.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/UECr9.png" alt="Database view"></a></p>
  
  <p>Possibly of note:</p>
  
  <ul>
  <li>There is a four-second delay between the first record and the other two.</li>
  </ul>
  
  <p><strong>System Details:</strong><br>
  CiviCRM verion: 4.7.29<br>
  CMS: Drupal... ahem... 6<br>
  Payment processor: Authorize.net</p>
  
Tags: <accounting><financial-accounts>
Title: Three self-canceling financial transactions for a single recurring contribution?
ThreadText: # Three self-canceling financial transactions for a single recurring contribution?
  
  (Asked by: username_0 on 2018-06-26)
  
  For recurring contributions, I am getting unusual results in the `civicrm_financial_trxn` table. Three very similar entries are created for each contribution, two of which cancel one another out.
  
  Am I failing to grasp something about double-entry accounting, or are two of these records simply unnecessary?
  
  Or perhaps my financial types are configured to do weird things. Perhaps there *should* be three entries, but at least one account code other than 1150 and 455-11 should be in play. If this is the case, how do I go about identifying the culprit financial account?
  
  Below is a screenshot from the Bookkeeping Transactions Report:
  
  [![Bookkeeping Transactions Report](https://i.sstatic.net/Q65yy.png)](https://i.sstatic.net/Q65yy.png)
  
  Some notes:
  
  * It's probably not sensitive, but I've changed the transaction number out of an abundance of caution. Note that the original number was the same for all three rows.
  * Note that the first and second rows cancel one another out (the amount in the second row is negative).
  * Note that the payment method is blank for the third row.
  
  Below is a screenshot of the `civicrm_entity_financial_trxn` entities that feed into the report:
  
  [![Database view](https://i.sstatic.net/UECr9.png)](https://i.sstatic.net/UECr9.png)
  
  Possibly of note:
  
  * There is a four-second delay between the first record and the other two.
  
  **System Details:**  
  CiviCRM verion: 4.7.29  
  CMS: Drupal... ahem... 6  
  Payment processor: Authorize.net
  
  **Tags:** accounting, financial-accounts
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-06-26. Score: 2
  
  Likely due to [this issue](https://issues.civicrm.org/jira/browse/CRM-19940?filter=-2).
  Looks like there is a PR to correct this with a milestone of 5.4.0, so I guess this problem persists in the current 5.2.1 release.
  
  
  ---
  
  