After year after year we take field trip and year after year I am collecting money and permission slips, but not always at the same time. While most tend to turn in both there is always someone who turns in the slip on time but doesn't have the money until the last minute.
This spreadsheet is designed to help you keep track of who turned in what. It even has a column for additional notes. Since we often take our trips closely together I designed it to track 2 filed trips at the same time but if you only need to track one you can simply put a zero in the Cost Box for the second trip. Or you can track the parents who have paid for the trip in the Trip 2 column.
It will calculate the total monies that you should have collected for the number of permission slips turned in as well as the amount you actually collected. If there is any difference between the two it will appear in red.
I hope this makes planning for your next field trip a little bit easier!