Scouting Forums

Service Star Report?

Hi there,

Is there a easy way to run a report that sees how long each scout in your unit has been registered so you can purchase the appropriate service stars for your scouts? I can’t find anything in Scoutbook and this feels like a major oversight. thanks.

1 Like

A very small percent of units use service stars so this has not been implemented. It is in the backlog though

1 Like

I had a similar question, and someone suggested running a report on when bobcat was awarded. Not perfect, but it was close enough for us.

Bobcat would short them an entire year if they were a Lion

Personally I did service stars on my first year as advancement chair and never again. The pack is such a fluid environment that the expense outweighs the ROI.

Another idea is to Export / Backup the Scout Advancement csv file in a spreadsheet program, and sort / filter based on the first advancement that a Scout earned. This would probably get you in the ballpark.

I track it on a spreadsheet.

We award service stars at the June pack meeting, the January pack meeting (the first one after we recharter, so we know everyone getting one has just paid), the Blue & Gold dinner and whenever a Scout is crossing over (even if the Scout earning the service star is not someone crossing over).

I’ve attached a template of the spreadhseet I use with the names changed. It illustrates what we are doing.

First, we had not presented service stars in recent memory before our June pack meeting. So, the first column simply calculates which star was to be presented at that meeting. The date I used for the end date in the calculations was the last day of school in our school district. The actual pack meeting was a few days before. I wanted to make sure I was bringing everyone current through the end of the Scouting year (if you regard the summer as the start of the next year).

Back in the old days, when service stars were more common, they were ordinarily presented at the final pack meeting or court of honor in the spring. Without the benefits of spreadsheets, If you joined in September 1974, then you got a one-year service star in May/June 1975, even though a full year hadn’t elapsed yet.

There was actually some justification for this - at least I am 90% sure of this. There was a blurb - I believe in a 1970s Insignia Control Guide that for Scouts crossing over, the service star awarded by the unit from which the Scout was departing should be rounded to the nearest full year. The difference as a result of rounding is adjusted by the new unit which the Scout is joining.

So, a Cub Scout joins on September 4, 1974. He crosses over to a Boy Scout troop on May 27, 1977. The pack should give him a three-year service star, since his service rounds to three years. The troop should start crediting him with time toward service stars on September 4, 1977, not May 27, 1977.

Another example: A Cub Scout joins a pack on January 2, 1975 and crosses over to a Boy Scout troop on May 27, 1977. When he leaves the pack, he gets a two-year service star, because he was a Cub Scout for more than two but less than 2 1/2 years. His time for determining Boy Scout service stars is calculated using a start date of January 2, 1977.

I really wish I could say exactly where I saw this, but I don’t remember. I need to find it somewhere in my storage closet.

I had always understood service stars to be awarded based on months. So, joining on September 28 is the same as joining on September 1. I think, but I’m not sure, that the old blurb explaining the rounding used months rather than days to determine half a year. I think it said the unit from which the Scout is departing should round up six months or more and otherwise round down. But I’m really not certain.

Nevertheless, an article from modern times in Bryan on Scouting specifically says that you start counting your time from the date (not month) you join Scouting. I had much more complicated formulae in my spreadhseet that treated any date in a calendar month as having been a member for the entire month, but I changed those after discovering the article. The formulae now evaluate the actual dates and finds whether the x year and 6 month anniversary of the Scout’s joining date has been reached. The formulae in the first column are different from the other columns, because service stars were to be awarded through that date for everyone with 6 months or more of service. In the columns that follow, the formulae evaluate which service star the Scout has reached and then check whether that star has already been awarded. If it has, the cell is blank.

I did the best I could to figure out the join dates before 2019. I don’t really know if they’re all correct. I combed Scoutbook to see what the earliest date a requirement was marked completed.

The formulae will return an error is the join date is after the calculation date. So, those formulae need to be deleted. I gray them out. I also gray out future dates of Scouts who transfer out or otherwise leave the pack. The bottom of each column gives me a count, so I know how many service stars are to be presented on that date. After I award the physical service star, I turn the cell green, so I know who hasn’t received their yet.

I’m expecting we will have “Al” cross over on December 16, so I put a calculation in for that date. He will probably have the Arrow of Light by then, and he is already 11. It makes sense to him to be on troop’s charter in 2020, not the pack’s. Oddly, he won’t be getting a service star on that date, but others will. The purpose of doing the calculation on the date of a crossover is to make sure a Scout doesn’t leave the pack, and you still owe him or her something.

If Al doesn’t cross over in December, I can just delete the column, and everything else will adjust. Alternatively, I can change the date. For instance, there’s an outside shot he will cross over in November.

We want to present service stars in January, because it is the middle of the year, and everyone has just paid up, if they rechartered with us. As it stands, if Caleb is the only one with a service star on that date, I might wait until the Blue & Gold in February.

My approach to the Blue & Gold is that it should be festive, and the more awards you can give out, the better. Since Al is not getting a service star in December, I might push all those (along with Caleb’s) to the Blue & Gold. Then again, “Matt” was a couple of weeks short of a year and six months in June, so he got a one-year star instead of two, and I might not want him to wait until February.

At least with this spreadsheet, I can see everything and make choices like this.

If Al never earns the Arrow of Light, he, TJ and Isa will all age out in June 2020. TJ has not been seen in quite a while. He still hasn’t been presented his three-year service star from June. So, I’ll probably delete him when we recharter.

James and Mira transferred to another pack in July.

If I want to add more interim dates, I can insert more columns and copy the formulae, and they’ll work. I just need to check carefully which Scouts are greyed out.

Anyway, feel free to use my spreadsheet.Service Star Template.xlsx (18.5 KB)

My thinking on this is to wait until a scout is crossing over to the troop. This way, they will only receive a single service star with the total number of years of cub scout service (complete with the yellow color backing). It would serve as a reminder of their cub scout days throughout the remainder of their scouting career. Since its probably more important to me than most in my pack, its not worth tracking & purchasing year after year…

I still own service stars that my dad & grandfather used and I’m proud to be able to both wear them and pass these down to my son, albeit when he’s a bit older to appreciate it.

The bulk of the work needed in tracking the service stars is setting up a system to track it, which I’ve done already. It doesn’t take very much to add a new Scout each time one joins and then put in a date on which I want to make the calculation.

I do get your point. There is a cost associated with buying them. Last June, I really wanted the boy who was crossing over to get his “5” more than I wanted the rest of the Scouts to get theirs, but I felt like everyone should get one, if they earned it, not just the Scout who was leaving.

Our pack does not use the presentation cards with the service stars,

As a youth, my pack did not present service stars. I used to wear the actual “3” my Boy Scout troop presented to me for Boy Scout service to represent my Cub Scout service with a yellow back I purchased on my own. I gave that “3” to the Scoutmaster of a troop in which I was an ASM as a thank you for his guidance, when I was leaving to become SM of another troop. He had been a Cub Scout for three years growing up as a military brat. He had never received a youth service star and, for that reason, never felt right about wearing one. He was beaming after I gave him one, especially since it was old school. The digit is slightly larger than on modern ones.

I wear the “1” I received as a Boy Scout to represent my year as a pre-1998 Explorer with a red back I purchased. The “8” and the green back I wear on my uniform are the originals presented to me by my troop as a boy.

I would also like to see a service star log. Even just a place where we can enter when the last star was awarded would be great. Here is what scoutbook did:

As far as the cost goes, you can encourage families to trade in their previous star for the new number. You can only wear one at a time, anyway.

I agree that reusing service stars is a good idea. I have tried to do that in the units in which I have served.

Just as a clarification, a scout or scouter can actually wear one service star for each level at which he or she participated in scouting. A yellow background disk is used for Cub Scouts, a green one for Scouts BSA, a red(?) one for Venturing, a blue one for adult leadership. I forget whether or not there are/were backers for Exploring and Varsity. Adults may wear a single star “merging” all of their scouting years together. I believe all of this is in the Guide to Insignia somewhere.

1 Like


The red backing can be used for Venturing, Sea Scouting or pre-August 1998 Exploring. A brown disc is used for Varsity Scouting service. There was also an orange disc for pre-August 2001 Tiger Cub service. As I recall, an individual with pre-August 2001 Tiger Cub service may wear an orange disc with a one-year star for that service and a yellow disc for the rest of his Cub Scout service, or he may combine the two and wear a star for total Cub Scout service.


Bryan on Scouting: Pins with a point: How to properly wear BSA service stars

We have been doing stars for the last 3 years. Getting accurate start dates is the key. As mentioned before, a spreadsheet works best. This separate database also saved us during the Jan 2019 Scoutbook craziness (hope never to see that again). The way I have it setup is that I enter the next mtg date, scout cells turn red if due, enter what star they were issued, then it starts all over again. New scouts are entered as needed.

1 Like

Also to add the fact that our scouts really look forward to them now that there is some consistency in the awarding process. Would love Scoutbook to automate this!!!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.