To be clear, while reporting hours is required by JTE, the service hour totals themselves don’t help much for unit JTE because the only number that matters for Req #8 for Packs or Troops is the number of events. (For District’s it’s much more complicated, because is the ratio of hours per scouts that matters.)
My guess is that the original question is more about all the other “bean counting” requirements, which are not always easy to figure out.
The worksheets are a big help, but for Retention, Webelos-to-Scout transition, Advancement and Camping, I find I have to calculate them manually, looking at each individual scout.
Basically, I flag each scout as:
- New - Not on last charter
- Continuing - On last charter and this one
- Drop - On last charter but not continuing
- Age Out - On last charter but no longer eligible for the program
- Crossover - Moved to the Troop
- Transferred - Moved to another Unit
And then for all rechartering scouts, I figure out if they advanced in the year (which you can see by running a report for the date of their last advancement), and if they went to camp.
One of the biggest challenges with this is that none of the existing Scoutbook or my.scouting.org reports can help, especially when figuring out the Crossovers, Transfers or Age-outs, because running a present-day report might not include them.
Calendar event-based requirements (service projects, pack meetings, outings) are a bit easier to figure out by just flipping through past events.
Bottom line, the workbooks are great. But you have to open them up a few times throughout the year. And you also need a good tracking system to figure out how your scouts are doing for the Membership and Program requirements, that is, until a developer has time to write a custom report, but I don’t see that happening soon.