Band Trip Cost-per-Student + Parent/Admin Packet Builder
Add up the whole trip — buses, hotel nights, food, fees — then get a cost per student, a deposit schedule, and a packet you can hand to parents and admin.
Keep private student data, payment records, room assignments, bus rosters, medical details, and official records outside this worksheet.
No account required
So what does this trip actually cost per student?
Everything you type autosaves in your browser. When you're done, this BandBoosterKit worksheet can print a parent/admin packet, export a CSV, or download a backup file. Stick to group counts and labels — rosters, medical details, and payment records belong in your program's approved systems.
Not saved yet
Add logo to print packet
Your logo stays in this browser. It is resized locally before it appears in print packets.
Accepted: PNG or JPG up to 2 MB. SVG, PDF, TIFF, and HEIC are not supported. Animated PNGs are flattened to one still logo.
Total trip cost$0.00All cost rows added together.Offsets$0.00Program and fundraising offsets.Net family cost$0.00Total trip cost minus offsets.Cost per studentEnter student countCost per travelerEnter traveler countsDeposit scheduled$0.00Per student across deposit rows.Deposit remainderNo schedule yetCost per student minus scheduled deposits.
Print packetParent / admin trip summary
Band trip cost worksheet
Destination not set / depart date not set to return date not set
0 students, 0 adults on this worksheet.
Cost per studentPending
Trip cost rows
Line item
Category
Amount
Note
No rows entered yet.
Program and fundraising offsets
Line item
Category
Amount
Note
No rows entered yet.
Deposit schedule (per student)
Deposit
Due date
Amount per student
No deposit rows entered yet.
Parent summary: total trip cost $0.00 minus offsets $0.00 leaves $0.00 for families. Enter a student count for the per-student figure.
Prepared by__________
Director review__________
Admin approval__________
Review before the parent meeting
Add at least one trip cost row before sharing this packet.
Worked example
Spring trip packet worksheet example
Prepare a parent/admin packet with rough travel, lodging, meal, ticket, scholarship, and fundraiser notes before asking for deposits.
Trip cost worksheet for review
Parent summary checklist
Admin approval reminder list
Assumptions
Check these before sharing
Use group counts, section labels, bus labels, or initials instead of a private student roster.
Keep medical details, emergency contacts, full room assignments, addresses, parent phone lists, payment records, and deposits in approved school or booster systems.
Trip approval, supervision, transportation, lodging, medication, dietary, refund, and payment rules must be checked with official school, district, booster, and travel sources.
Blank numeric fields count as zero. Negative values are treated as zero and flagged for review.
Formula notes
How the worksheet math works
Total trip cost sums the cost rows. Net family cost subtracts program and fundraising offsets. Cost per student divides net family cost by the student count; cost per traveler divides by students plus adults. The deposit schedule totals per-student deposit rows and shows the remainder against cost per student.
Cost and offset rows are dollar totals; blank fields count as zero and negative amounts are treated as zero with a review warning.
Cost per student = (total trip cost - offsets) / student count, rounded to cents. Counts are whole numbers.
Cost per traveler divides the same net amount by students plus adults for shared-cost sanity checks.
Deposit rows are per-student amounts; the tool warns when the schedule over- or under-collects against cost per student.
Sources and local checks
Where these worksheet checks come from
These references help set the worksheet's boundaries. Your current school, district, booster, director, treasurer, venue, and event instructions still come first.
Local school, district, booster, travel, payment, safety, and music-program procedures : Official policy, payment records, and required forms stay outside BandBoosterKit.
Local district travel approval and chaperone procedures : Trip approval, deposits, transportation, rooming, and supervision requirements are local.
FAQ
Common questions
What can I do with the Band Trip Cost-per-Student + Parent/Admin Packet Builder?
Enter your numbers and notes, save in this browser, print the packet, export CSV, or download a backup file. Official records, payments, and approvals stay in the systems your group already uses.
Do I need an account?
No. There is no account to create and nothing to log into. Your work saves right in this browser when local saving is available.
What should I avoid entering?
Leave out full private rosters, student account balances, medical details, emergency contacts, room assignments, addresses, parent phone lists, payment records, card or bank data, tax IDs, credentials, and anything you would not put in a shared booster packet.
