Welcome! This forum has a treasure trove of great info – Scouters helping Scouters! Just a heads up, though - all content, information, and opinions shared on this forum are those of the author, not the BSA.
The balance column on the Payment Log Report isn’t totaling correctly. You get to it by going to the individual scout’s page and running reports on the bottom and running the Payment Log Report. From there it redirects you to something that looks like the old internet advancement site and if you select either Detail or Both you’ll generate the report I need. I can’t figure out what it’s trying to total, but I’m very good at addition and I’m confident in my math.
@JWPlatt Yep, that seems to have fixed it. Thanks for correcting it.
@Christopher.Schuster The sort order was incorrect so it was throwing weird math like:
$0 balance + $118 credited = $ -22 (on 2/29/2020) AND
$102 balance - $140 owed = $ -140 balance (on 3/30/2021)