Let's start with the spreadsheet.

Not because it's the best tool for the job — we'll get to that — but because it's where every reunion organizer starts, and if you're going to use one, you might as well build it right.

Here's exactly what your reunion budget spreadsheet needs, why each category matters, and what to watch for as the numbers start moving faster than a static file can keep up with.

The Core Categories Every Reunion Budget Needs

A reunion budget isn't complicated, but it has more line items than most people expect when they sit down to build it for the first time. Here's the complete structure:

INCOME

Ticket sales — your primary revenue source. Estimate conservatively: take the number of people you expect to attend, multiply by your ticket price, and then subtract 20%. People always commit later than you expect and sometimes not at all.

Sponsorships — local businesses are often willing to sponsor reunion events in exchange for logo placement and a mention. A realistic sponsorship goal for a mid-size reunion is $1,000–$5,000 depending on your market and how hard you pursue it. Build this as a separate line from ticket sales so you always know which revenue source is carrying the event.

Donations — optional, but worth enabling. Some classmates can't attend but want to contribute. Others want to give above and beyond their ticket price. Even a modest fundraising goal ($500–$1,000) can cover a meaningful expense.

Merchandise — if you're selling class t-shirts or reunion merch, track revenue and cost separately. Merch can be a break-even play or a small profit center depending on your margin and volume.

EXPENSES

Venue — typically your largest single expense. Get the contract before you finalize this number. Venue costs often have minimums, fees, and add-ons that aren't visible in the initial quote.

Catering and food — price per head, multiplied by expected attendance. Build in a 10% buffer for late additions. If you're doing a buffet or family style, get a per-person quote from the caterer rather than estimating on your own.

DJ or entertainment — get this quote early. Good DJs in most markets book out months in advance and prices vary wildly. Budget $500–$1,500 for a mid-range DJ depending on your market.

Photography and video — optional but worth considering. Someone is going to wish there were better photos. Either hire someone ($300–$800 for a few hours) or designate a classmate with a good camera.

Decorations and supplies — easier to underestimate than overestimate. Include table centerpieces, banners, any custom signage, and a miscellaneous buffer of $100–$200 for things you forgot.

Name tags — if you're ordering printed name tags (which, for a reunion, you absolutely should — twenty years is a long time and faces change), budget per attendee. Printed name tags with school colors and maiden name support run a few dollars per tag depending on quantity.

Koozies and event supplies — custom koozies are a popular reunion keepsake. Budget based on quantity and design complexity.

Printing and postage — save-the-dates, formal invitations if you're sending physical ones, any printed programs for the event.

Miscellaneous buffer — add 10% of your total expense estimate as a buffer line. Something always comes up. A miscellaneous buffer isn't pessimism — it's experience.

How to Structure the Spreadsheet

Simple is better. Here's the structure that works:

Sheet 1 — Summary: Four cells at the top: Total Income (estimated), Total Income (actual), Total Expenses (estimated), Total Expenses (actual). These pull from sheets 2 and 3 automatically. This is the number you check every week.

Sheet 2 — Income tracker: Columns: Source, Estimated Amount, Actual Amount, Date Received, Notes. One row per income source. Ticket sales get one row with a formula pulling from your running total elsewhere — or a manually updated number if you're doing this all by hand.

Sheet 3 — Expense tracker: Columns: Item, Category, Estimated Cost, Actual Cost, Paid Date, Vendor, Notes. One row per expense. Color code by category if it helps you scan quickly.

Sheet 4 — Ticket revenue calculator: Expected attendance × ticket price = projected revenue. Update the attendance number weekly as RSVPs come in. This sheet feeds into your income tracker automatically.

That's it. Four sheets, no formulas more complex than SUM and basic multiplication. Anything more elaborate than this becomes a maintenance burden that stops getting updated.

The Part Nobody Warns You About

Here's what happens around week six of reunion planning with a spreadsheet-based budget: the numbers start moving faster than you update the file.

A ticket sale comes in. You mean to update the spreadsheet but you're in the middle of something. Then another one comes in. And a sponsorship payment. And someone pays cash at a committee meeting. By the time you sit down to update everything, you're not sure what's been recorded and what hasn't.

The spreadsheet becomes an approximation. And you start answering "where are we at?" with "somewhere around..." instead of an actual number.

This is not a discipline problem. It's a tool problem. Spreadsheets are static — they show what was true when you last updated them. A reunion budget in active planning needs to be live.

When to Move Beyond the Spreadsheet

The spreadsheet is a great planning tool. Use it in the early stages to model scenarios — what if we charge $30 vs. $40? What if we get two sponsors instead of five? What's our break-even attendance?

But once RSVPs open and money starts moving, you want a budget tracker that updates automatically. One that adds ticket revenue the moment someone pays, tracks sponsorship income as it comes in, and shows you your real-time total raised without requiring you to manually enter anything.

The difference in practice: instead of opening a spreadsheet and updating it, you open a dashboard and read it. The number is current because the system updated it — not because you remembered to.

For Tiffany, organizing the Mosley High School Class of 2006 reunion in Panama City, a live budget tracker meant she always knew exactly where things stood. $7,050 raised across tickets and sponsors, tracked automatically, without a single manual spreadsheet entry. When the venue asked for a deposit confirmation, she had the number in under ten seconds.

That's the goal — not better spreadsheet discipline, but a system that doesn't require discipline to stay accurate.

The Budget Numbers That Actually Matter

Whatever tool you use, these are the four numbers you need to know at all times:

Total raised to date — tickets plus sponsorships plus donations. This is your actual cash position.

Total committed expenses — everything you've signed a contract or made a deposit for. This is your floor.

Projected total expenses — your best estimate of what everything will cost if everything goes as planned.

Break-even attendance — how many paid tickets you need to cover your committed expenses, assuming no additional sponsorship income. Know this number. It's the one that tells you whether to worry.

If total raised is above committed expenses and you're on track toward break-even attendance, you're in good shape. If either of those is moving in the wrong direction, you know early enough to adjust — raise the ticket price, push harder on sponsorships, trim an expense.

Early visibility beats late surprises every time.

A Few Budget Mistakes to Avoid

Counting unconfirmed sponsorships as income. A sponsor who said "sounds interesting" is not a sponsor. Only count money that has been committed in writing or received.

Underestimating venue minimums. Many venues have food and beverage minimums that kick in at certain attendance levels. Read the contract carefully before signing.

Forgetting Stripe fees. If you're collecting payments online, payment processing fees affect your net revenue. Use a platform that grosses up the ticket price so you always net face value.

Setting your ticket price before you know your costs. Build the expense side of the budget first. Then work backward to the ticket price that covers costs at your expected attendance. Don't guess a ticket price and hope it works out.

Not building a buffer. Something will cost more than you expected. Add 10% to your total expense estimate and treat it as a real line item, not a hypothetical.

Start with the spreadsheet. Use it to model, plan, and pressure-test your numbers before RSVPs open. Then move to a live system the moment money starts moving — so your budget is always accurate, always current, and always available the moment someone asks where things stand.

Your treasurer will thank you. Your committee will thank you. And you'll thank yourself at 11pm when you don't have to open three spreadsheets to answer a simple question.

MyReunite includes a live budget tracker that updates automatically as tickets sell, sponsors pay, and donations come in — no spreadsheet maintenance required. Start planning your reunion free →

Related posts: