User Support Forum

I am relatively new to PowerChurch. I so far, I am impressed with its capabilities.

The Board of my church likes the format of the built-in Fund Accounting report "Income and Expense by Month". However, I have discovered some problem with it. Specifically, the amounts displayed are all to whole dollar amounts. While I would prefer the complete dollars and cents be displayed, I understand this would take up more space on the printed page and would be difficult to fit on the page unless the font size were so minute the report would be unreadable.

I could tolerate the rounding to whole dollar amounts, but the rounding appears to always be up to the next whole dollar, independent of the "true" amount, instead of following conventional rules for rounding.

For example, in one of my reports:

an actual amount of 2718.55 appears in the report as 2719 (rounds up as would be expected)
967.33 appears as 968 (would expect to round down to 967)
653.08 appears as 654 (would expect to round down to 653)
708.34 appears as 709 (would expect to round down to 708)

Furthermore, the summation of amounts appears as the sum of the already rounded numbers, when it should be the rounded value of the summation of the actual amounts. For example, the sum of the four actual amounts above is 5047.30, which should round down to 5047, but the report summation is 5050 (=2719+968+654+709).

I find this surprising in an accounting program. Does this bother anyone else?

Barring writing my own custom report, is there anything that can be done to fix this?

is totallng ototals in the report are the sum of the rounded amounts instead of the rounded value of the sum of the actual amounts.
he summation of amounts in the report is the sum of the rounded amounts9expense itms

mgc1945 wrote:I am relatively new to PowerChurch. I so far, I am impressed with its capabilities.

The Board of my church likes the format of the built-in Fund Accounting report "Income and Expense by Month". However, I have discovered some problem with it. Specifically, the amounts displayed are all to whole dollar amounts. While I would prefer the complete dollars and cents be displayed, I understand this would take up more space on the printed page and would be difficult to fit on the page unless the font size were so minute the report would be unreadable.

I could tolerate the rounding to whole dollar amounts, but the rounding appears to always be up to the next whole dollar, independent of the "true" amount, instead of following conventional rules for rounding.

For example, in one of my reports:

an actual amount of 2718.55 appears in the report as 2719 (rounds up as would be expected)
967.33 appears as 968 (would expect to round down to 967)
653.08 appears as 654 (would expect to round down to 653)
708.34 appears as 709 (would expect to round down to 708)

Furthermore, the summation of amounts appears as the sum of the already rounded numbers, when it should be the rounded value of the summation of the actual amounts. For example, the sum of the four actual amounts above is 5047.30, which should round down to 5047, but the report summation is 5050 (=2719+968+654+709).

I find this surprising in an accounting program. Does this bother anyone else?

Barring writing my own custom report, is there anything that can be done to fix this?

is totallng totals in the report are the sum of the rounded amounts instead of the rounded value of the sum of the actual amounts.
he summation of amounts in the report is the sum of the rounded amounts/expense items

I just checked the ministry totals from the inc/exp by month, with the regular inc/exp report, and while it doesn't show the cents, it doesn't round the totals up either, the whole dollar totals are exactly the same. The final total is exactly the same also.

Have you tried the same comparison ?? Are you using the same report level in the month by month report as the regular inc/exp report ?

Neil,
I had run my report at summary level 4. When I ran it at summary level 6, I found that the rounding of all detail amounts was done correctly. The "error" comes in for summarized totals. Instead of adding the detail amounts (including cents) and then rounding the result, the summary total comes from the addition of the rounded detail amounts. The error in the summations could accumulate, depending on the detail amounts and number of levels. Here's an example:

Actual Report

Detail Item 1.1 405.01 405 correct rounding
Detail Item 1.2 342.51 343 correct rounding
Detail Item 1.3 192.60 193 correct rounding
Total Item 1 940.12 941 should be rounded to 940

Detail Item 2.1 123.15 123 correct rounding
Detail Item 1.2 315.60 316 correct rounding
Detail Item 1.3 275.54 276 correct rounding
Total Item 1 714.29 715 should be rounded to 714

Total Items 1 & 2 1654.45 1656 should be rounded to 1654

Can requests be made to Power Church for changes/enhancements to any of the features/reports?






Here'sIn my example, the sum of the rounded amounts was 5050, while the rounded value of the summation of the detail amounts would be 5047 (the actual sum, including cents, being 5047.30). For a different set of amounts, the error could be more or less.

The amounts I used in my example were for July 2014. I checked results using the report Income and Expense Statement for the month of July, and the correct amounts and total were displayed with the cents included. I also checked using the reports Income and Expense by Year (for just the month of interest) and Income and Expense by Fund. Both of these correctly display the amounts and totals (including cents).

I'm kinda surprised that this has not come up previously, since I don't believe that report has changed in any way.

What version of Powerchurch are you using, and are you at the most recent maintenance release??

I'm using version 11.55. I think this is the latest.

Regards.