Free · Excel + Google Sheets · No macros

Free Family Reunion Budget Template (Excel)

This free family reunion budget template runs in Excel and Google Sheets. Track estimated versus actual cost per line item, and a linked Fund Setup tab divides total cost by confirmed headcount for cost per person. A Contributions tab tracks each household's amount due, collected, and balance.

Download free template

What's in the family reunion budget template

Reunion Budget logs up to 40 line items across venue/lodging, food & catering, activities, decorations, transportation, T-shirts/keepsakes, photography, and other, with estimated cost and actual cost columns and automatic totals.

Fund Setup pulls total actual cost from Reunion Budget automatically and divides it by the confirmed headcount you enter (RSVP count), giving you cost per person - the number every family actually wants to know.

Contributions tracks up to 60 families/households: enter attendee count per household and amount due (attendees times cost per person) calculates automatically, alongside amount collected and balance due, so you always know who still owes what.

Household-level cost splitting versus a single global budget

The one specialized free template found for this niche offers a single global budget - total cost in, total cost out - with no per-household or per-attendee breakdown at all.

This template's Contributions tab is what turns a global reunion cost into an actual collection plan: each family's amount due is calculated from their own attendee count and the reunion's real cost per person, and updates automatically as headcount or spending changes.

It won't manage RSVPs or send payment reminders - it's the spreadsheet math behind the collection, not the collection process itself.

Who this template is for

Family reunion organizers - often one designated household or committee - who need to plan reunion costs, confirm a fair cost-per-person split, and track which families have paid their share.

It's a single-event budget and collection tracker. If your family reunion happens annually, duplicate the file each year to build a multi-year cost history rather than overwriting the same workbook.

How to use it

  1. On Reunion Budget, enter estimated and actual cost for each line item.
  2. On Fund Setup, enter your confirmed headcount once - cost per person calculates automatically.
  3. On Contributions, log each family/household and attendee count - amount due, collected and balance due calculate automatically.

Frequently asked questions

How is cost per person calculated?

Total actual cost (pulled automatically from Reunion Budget) divided by the confirmed headcount you enter on Fund Setup. It's IFERROR-protected, so it stays blank until headcount is greater than zero.

Can I use this in Google Sheets?

Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All three tabs and every formula keep working.

Does amount due update if headcount changes?

Yes. Amount due per household is attendees times cost per person - as you update headcount on Fund Setup while RSVPs come in, every household's amount due recalculates automatically.

How many families and line items does it support?

Up to 40 budget line items on Reunion Budget and up to 60 families/households on Contributions - add more rows if you need additional capacity.

Does this send payment reminders or collect money?

No. This tracks amounts due, collected, and balance per household based on numbers you enter - it doesn't process payments or send reminders.

What's the usage license?

Personal use or use within one business. It's not meant to be resold or redistributed as a template product.

Related free templates