Tracking Holiday Party Expenses with Google Forms

It's that time of year again, time to plan for the company holiday party!  Whether you have a committee of people helping you plan for the party or you're going at it solo, Google Forms can be a great way to assist in tracking any expenses associated with the party. 


Over the coming weeks, you have directed your Party Planning Team to pick up a few items for the holiday party.  These items could include party favors, gifts for attendees, food and drink items, and decorations.  


As your team begins to purchase these items, you need to be informed of what was purchased and how much the item(s) cost.  This is where the Google Form comes in to play.  A few questions that you may want to have on the form are:
We know that organizing your holiday party is not your only job and you may not always be available to discuss the purchases when they are made.  With the Google Form, your party planning team can easily enter what they picked up from the store, it's cost, and submit the form.  Note the multiple page function that we used in the example below.  When the person chooses 'Food,' a new page will appear specifying what type of food has been purchased.  


Please take a few minutes to fill out our example form below.






After the users submit the form, the entries can be found on the corresponding spreadsheet where you can easily track what was purchased and how much the item cost.  Most companies have a budget in mind when the chatter begins around the holiday party.  As the party planning director, you can take the sum of the total amount spent on all items at the end of each day or week prior to the party to ensure that you're on track to stay within the budget, exceed the budget, or best of all -- stay under budget!  You can also use this spreadsheet to see if your party planning team members are purchasing to many of one type of item and suggest they purchase a different item.


Below is the data we have gathered internally after sending the form out to the Dito Team.




One last feature we recommend enabling is having the ability to automatically collect your team members name so you can track who is purchasing what.  Simply check the box in the upper left hand corner next to 'Require <company name> sign in to view this form' which will by default enable the check box next to 'Automatically collect respondent's <company name> username' when editing the form. 



How will you be using Google Forms this holiday season?  Let us know if the comment section below!