Answers.Body: <p>This looks like an error. The bookkeeping report is based on records in two different tables than the contribution report. From this report it seems the algorithm for ensuring the series sums to the proper figure used by contributions by having one value different is not properly setting the financial line item values. IIRC there have been some recent changes in this area. Please open an issue at <a href="https://lab.civicrm.org/dev/financial/issues" rel="nofollow noreferrer">https://lab.civicrm.org/dev/financial/issues</a> and assign it to me.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-28T23:28:17.430Z
Answers.Text: Thanks @Martin Fuggle. I've opened the right edge of the page to expose the assign widget and completed the assign.
Answers.UserDisplayName: Joe Murray
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-27T22:50:20.383Z
Answers.Text: I've created the issue but couldn't see how to assign it.
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-27T23:57:50.523Z
Answers.Text: Do I need to raise an issue with the developers of the Extended Reports extension?
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-27T11:21:55.327Z
Answers.LastActivityDate: 2019-04-27T11:21:55.327Z
Answers.UserDisplayName: Joe Murray
Body: <p>I am using Drupal 7.66 and CiviCRM 5.10.4. There is a small difference between the total of a Contribution report and a Bookkeeping report using the same filters and therefore intended to produce an identical result. However under certain circumstances there are small rounding errors between the two reports.</p>
  
  <p>Take the following example. A payment of $155.00 is paid via a payment gateway in three monthly instalments. The first instalment is $51.68 and shown in the contribution report correctly (as an aside the next two payments will be $51.66).</p>
  
  <p>However in the Bookkeeping report the first payment is shown as $51.67 which is the rounded up value of $155.00 divided by three which gives $51.66 recurring. In the following month the contribution report will no doubt show the payment to be $51.66 and the Bookkeeping report will display $51.67.</p>
  
  <p>This error also finds its way into the Extended Reports extension. I realise that this is not a big issue but it would be nice if the reports displayed identical totals.</p>
  
Tags: <civireport>
Title: Rounding differences between Contribution and Bookkeeping reports
ThreadText: # Rounding differences between Contribution and Bookkeeping reports
  
  (Asked by: username_0 on 2019-04-27)
  
  I am using Drupal 7.66 and CiviCRM 5.10.4. There is a small difference between the total of a Contribution report and a Bookkeeping report using the same filters and therefore intended to produce an identical result. However under certain circumstances there are small rounding errors between the two reports.
  
  Take the following example. A payment of $155.00 is paid via a payment gateway in three monthly instalments. The first instalment is $51.68 and shown in the contribution report correctly (as an aside the next two payments will be $51.66).
  
  However in the Bookkeeping report the first payment is shown as $51.67 which is the rounded up value of $155.00 divided by three which gives $51.66 recurring. In the following month the contribution report will no doubt show the payment to be $51.66 and the Bookkeeping report will display $51.67.
  
  This error also finds its way into the Extended Reports extension. I realise that this is not a big issue but it would be nice if the reports displayed identical totals.
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-04-27. Score: 2
  
  This looks like an error. The bookkeeping report is based on records in two different tables than the contribution report. From this report it seems the algorithm for ensuring the series sums to the proper figure used by contributions by having one value different is not properly setting the financial line item values. IIRC there have been some recent changes in this area. Please open an issue at <https://lab.civicrm.org/dev/financial/issues> and assign it to me.
  
  > **Comments:**
  > **username_0**: I've created the issue but couldn't see how to assign it.  
  > **username_0**: Do I need to raise an issue with the developers of the Extended Reports extension?  
  > **username_1**: Thanks @username_0. I've opened the right edge of the page to expose the assign widget and completed the assign.  
  
  ---
  
  