Girl Scout Cookie Tracking Spreadsheet Template

My daughter is in Girl Scouts and her troop wanted to sell Girl Scout cookies for the first time this year. In order to sell Girl Scout cookies you need an adult to be the TCPC: Troop Cookie Program Coordinate. Or as my daughter said, "We need you to be the Cookie Daddy!" I figured all this meant was they needed someone to manage an Excel spreadsheet for all the cookie sales so I agreed.

Little did I know what was in store as there is much more to it. First is all the training and webinars, background check, volunteer forms, etc. Then when it comes to finally sell cookies, there are no spreadsheets; they've got Digital Cookie online selling platform and eBudde management system. While the eBudde system and tools seem to have all the information needed on the backend, the front end is very confusing for a new user. It's very confusing and cumbersome and the key information the TCPC needs to know is spread out over different pages. Seriously, if you have to have numerous training sessions to explain how everything works and people are still asking tons of questions, your system is too complicated.

So I decided to make a spreadsheet!

Introducing the Girl Scout Cooking Tracking Template:

With this spreadsheet you still have to manually input all the cookie sale information from eBudde but now all the information you need to know is shown visually on just two sheets and is easy to understand. Here's how to use the cookie tracker:

On the sales summary page, copy and paste your Girl Scouts. Then input each of their Digital Cookie sales, which are broken into four categories: 

1. Cookies to be hand delivered (from the Initial Orders page in eBudde)

2. Donated cookies for Operation Salute

3. Any cookie sales from paper order forms that need to be input manually

4. Orders that will be shipped direct from the bakery (from the Girl Orders page)

Next, you can input each Girl Scout's goal for how many packages they want to sell. These will add up at the bottom to show the overall Troop Cookie Goal. There is a donut graph to show the troop's progress towards their goal.

On the right it shows the Instant Rewards and how many packages it takes to reach. Once a girl has reached the goal, the formula automatically shows as having achieved it.

On the next sheet, we have a breakdown of how many of each type of girl scout cookie has been sold (thin mints being the most popular, obviously). As the cookie daddy and the person responsible for picking up the cookies from the cookie cupboard to distribute to the troop, the most important info is the number of cases of each type of cookie I need to pickup. 

There is another sheet in my template that explains some of the terminology, the key being the word "box" is never used. The girls sell "packages" of cookies and 12 of those packages make up a case. The cookies are never mixed up in different cases and if you only sell one package of LemonUps, you have to pickup an entire case of LemonUps.

The Girl Scout Cooking Tracking Spreadsheet shows you exactly how many cases of each cookie you need and how many unsold packages in each case. The unsold cookies from the initial order can be used to sell in-person during the booth phase.

I added a sheet you can use as a template for booth signups.

Download the Girl Scout Cookie Tracking Spreadsheet Template here.