Rounding differences between Contribution and Bookkeeping reports
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.
civireport
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
add a comment |
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.
civireport
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
add a comment |
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.
civireport
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
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.
civireport
civireport
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
edited 4 hours ago
Martin Fuggle
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
asked 5 hours ago
Martin FuggleMartin Fuggle
35917
35917
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "605"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f30424%2frounding-differences-between-contribution-and-bookkeeping-reports%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
add a comment |
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.
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
add a comment |
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.
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
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.
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
answered 2 hours ago
Joe Murray♦Joe Murray
5,84411242
5,84411242
add a comment |
add a comment |
Thanks for contributing an answer to CiviCRM Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f30424%2frounding-differences-between-contribution-and-bookkeeping-reports%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
