Fundraisers worksheet
PTO Fundraiser Profit Calculator
Subtract vendor costs, supplies, and payment fees from sales. Compare the profit with the goal before deciding whether to repeat the fundraiser.
Net profit $0.00
Review before sharing
- The fundraiser sheet needs at least one revenue or cost row.
More event sheets
You may need one of these too.
Example packet
Fall cookie dough fundraiser example
A PTO chair compares cookie kit revenue, extra donations, a spirit-night add-on, vendor costs, supplies, prizes, and payment fees.
- $2,668.62 net profit.
- $19.06 profit per participant or selling unit.
- $268.62 above the entered profit goal.
Assumptions
What the numbers assume
- Use summary revenue and cost totals, not buyer names, donor private contacts, student data, card details, bank details, or tax IDs.
- For each revenue or cost row, enter either a unit count with its price or cost, or one trusted row total.
- Blank numeric fields count as zero. Negative values are treated as zero and flagged for review.
- The participant or selling-unit count is for a rough per-participant or per-unit result; fractional counts are rounded down.
- This is a planning worksheet. Official accounting, tax decisions, deposits, receipts, and approvals stay in your normal systems.
Formula notes
How the totals are calculated
- An entered revenue row total replaces units sold times price per unit.
- An entered cost row total replaces units times unit cost.
- Percent fee amount is gross revenue times the entered percent fee divided by 100.
- Net profit is gross revenue minus direct costs minus flat and percent-based fees.
- Gross margin is net profit divided by gross revenue when revenue is greater than zero.
Check local rules
Sources for this worksheet
Use your group's current forms and procedures for deposits, approvals, and recordkeeping.
- Local school, PTA/PTO, booster, district, bank, and food-safety procedures : Local rules and treasurer procedures are the source of truth.
- PTO Today free printables and templates
- DoJiggy school fundraising examples
FAQ
Questions that come up
Enter sales, direct costs, payment fees, and the profit goal. The result shows net profit, margin, profit per participant or selling unit when entered, and the amount above or below the goal.
No. It is a local planning worksheet only. It does not process payments, store buyer lists, issue tax receipts, sync donor records, or replace official accounting.
Do not enter student private information, buyer names, donor private contacts, card details, bank account numbers, tax IDs, addresses, or official login credentials.
Related workflow
Other sheets for this event
Worksheet Concession restock
BackupPrintCSV
Concession Restock Worksheet
Enter current stock and expected sales, or close out a finished stand. Print the case-rounded shopping list for the next event.
Suggested order quantities
Upcoming-event shopping plan
Finished-event sales and profit summary
Supplier lead-time notes
Worksheet Volunteer shifts
BackupPrintCSV
Volunteer Shift Planner
List each job, shift time, and available helper. Print the open spots for the coordinator or check-in table.
Shift schedule
Role gaps
Volunteer load summary
Printable helper sheet
Worksheet Event budget packet
BackupPrintCSV
Event Budget Worksheet
Plan expected income and expenses before an event, or compare the approved budget with receipts and deposits after it ends.
Planned budget
Finished-event review
Variance notes
Meeting summary