I am running into what appears to be a reporting bug in the Payment Log Summary and Final Balance reports, this is in Scoutbook plus of course.
When I generate a Payment Log report (date range alll), the charges are listed correctly. For example, my Detail report shows multiple summer camp charges that total $317.00, including:
“2026 Summer Camp Scout … $‑155.00”
“2026 Summer Camp Outpost – Adult … $‑36.00”
However, the Payment Log Summary Report and the Final Balance Report do not reflect the full outstanding balance. The Summary report shows:
“Net Change … $‑281.00”
And the Final Balance report shows:
“Balance … $‑281.00”
I would expect the Final Balance to show $-317
This does not match the actual total of the charges listed in the Detail report. It seems to be missing the last charge. The Detail report clearly shows a cumulative net change of $‑317.00, but the Summary and Balance reports are only showing $‑281.00.
It looks like the Summary and Balance reports are dropping one of the charges or not calculating the full total. I have this on several scout’s reports, some but not all and I can’t seem to find a pattern. The only thing i’ve noticed it is when it happens it always seems to be the last chagre on the detail report that is missed. When myself or the parent views the payment log balance in the Scout’s profile it’s correct. It’s only the reporting output that is not showing the correct balances.
Has anyone else seen this issue, or is there guidance on why the Summary and Balance reports would not match the Detail report? It seems like a calculation or filtering bug. Thank you for any help or clarification. Here is an example report I ran tonight and a screen shot of the profile view.
Example-paymentlog.pdf (129.3 KB)
Does it show the right balance if you click on all transactions?
@JaredRothbauer - I have run the report in various ways from the unit and all transactions and the final balance are correct. I have yet to replicate the issue.
ETA- I notice that your use date range section actually has NO date range at all.. perhaps this is the issue
@Stephen_Hornak @jacobfetzer It does show the correct balance when I select ALL TRANSACTIONS. The discrepancy is when I’m using the report builder to build a historical report. Here are my steps:
Under the scout’s profile, right side select run report then payment log report. (Note the payment log preview tile does show the correct balance I expect to see)
Then in report builder that opens I change the Quick Date Range to All, change sorting to Name, Then Transaction date (so it lists transactions in historical order), then click Run
The report runs, for some reason the Quick Date Range selector always resets to use date range but i assume it ran as All as that was what was selected when I clicked run. But the output shows that the summary does not match the net change running total. I would expect A to match B.
Here is another example of one that I used the same report options, All & sort by. This is a good example is shows a multiyear history and its correct. So not sure what’s going on.
I was only running reports for Scout’s with negative balances, so I haven’t done this for each pack. I wish there was a way to get the same PDF export detail and summary report broken down by each Scout instead of doing it one by one. But I did see this happen on I think 3 or 4 Scout reports that I ran last night, where their summary balance in the report building didn’t match the summary balance shown in the balance tile on their profile and didn’t match the net change balance in the log detail report.
@JaredRothbauer - so are you saying that choosing all dates presents a report with the correct ending balance for the individual ? Now as far as a unit wide report you need to go to the reports on the left side menu then under finance is the payment log report for the unit.
choosing all dates presents a report with the correct ending balance for SOME individuals, but not all. That’s what’s tripping me up.
Also, I do know where the unit wide report is, I was more talking about individual grouped reports, so each scout gets a page, but the whole unit at a time. so, I can just break the pdf down and not have to run 35 individual reports. But that’s not my issue anyways doesn’t want to distract 
@JaredRothbauer - I have tried but am unable to replicate the issue. I guess you could delete and re-enter the transaction that ends up missing from the report
I’m going to start a direct message so we can get some specifics to provide the developers.
