A family of four can receive one invitation, send three acceptances and still have one reply outstanding. That means four individual guest records, one invitation group and three confirmed attendees. It does not mean four invitations or four confirmed meals.
Keeping these totals separate makes your list easier to update when families reply in stages, children need a different meal or someone changes their plans. Start with people, then group them for invitations and count confirmed arrangements from their individual records.
Give every person their own row
Use one row per person, including children and plus-ones. A single “Taylor family — four people” row cannot clearly record which person has replied, chosen a meal or received a table assignment.
If a plus-one’s name is not yet known, use a clear temporary label, such as “Jordan’s guest — name to confirm”, and replace it before finalising arrangements. A blank name can disappear from named-guest counts. Do not put two people in one row to save space.
This fictional family shares Household ID H001. The meal labels are examples that the couple has agreed to use in their own plan.
| Person | RSVP | Meal |
|---|---|---|
| Alex Taylor | Accepted | Standard |
| Sam Taylor | Accepted | Vegetarian |
| Noah Taylor | Accepted | Children’s meal |
| Mia Taylor | Pending | To confirm |
The list contains four people, one household invitation group and three accepted guests. It has three confirmed meal selections. Mia’s pending response stays visible as a follow-up; it is not quietly treated as either an acceptance or a decline.
Use a household reference for invitations
A Household ID is a practical grouping for people receiving one invitation. It does not have to describe who lives at the same address. Two people sharing a home may need separate invitations; relatives at different addresses might choose one shared contact. Group them according to your actual invitation plan.
- Assign the group. Give everyone receiving the same invitation the same Household ID. A person receiving an individual invitation still needs their own group ID.
- Choose a contact. Check the contact name and address you will actually use. In the Wedding Planner workbook, the Invitations sheet shows the first matching guest’s contact, so review that guest record.
- Track sending separately from replies. One invitation sent is not proof that every person in the group has replied. Keep the household’s sending and follow-up dates alongside individual RSVPs.
- Check duplicates before counting. Use one invitation record per Household ID. Adding the same group twice can make an invitation list look more complete than it is.
Build the meal count from confirmed people
Use a short, consistent set of meal labels. “Vegetarian”, “Veg” and “Vegetarian option” may look equivalent to a person but can become three categories in a tracker. In the workbook, set your labels in Setup and select the matching choices in Guests.
Keep meal choice and dietary information distinct. A person selecting a vegetarian meal may also have additional requirements. Record their wording accurately and confirm the practical arrangements with the caterer; a spreadsheet category does not resolve those requirements.
Ask your venue or caterer which categories they need in the final numbers, including children and any supplier meals. Your guest list and their order categories may differ. Reconcile them deliberately instead of assuming one headline total answers every question.
Check seats as another separate view
A confirmed attendee can have a recognised meal but no table yet. A table can also be over capacity even when the overall guest total looks right.
Before sharing the plan, check accepted guests without a table, accepted guests without a recognised meal, and each table’s capacity. In the Wedding Planner workbook, Guests holds the RSVP, meal and Table ID; Seating and Meals summarise named Accepted guests. Keep its fixed Guest IDs and Table IDs unchanged.
Share a dated version with the people who need it, and say which arrangements are still provisional. Give a caterer the meal and dietary details they need rather than automatically forwarding every private contact in your planning file.
Common questions
Can one household have mixed responses?
Yes. Keep the household invitation group together, but record each person’s reply individually. That is why one row per person is useful.
Do pending guests count towards confirmed seats?
In this workbook, no: seating and meal summaries count named Accepted guests. Keep pending guests in your follow-up list and review how many places you may still need.
What happens if somebody changes their meal?
Update their individual record, check the revised totals and communicate the change to whoever already has an older version. Editing your file does not send an update to a supplier.
A connected list, with clear boundaries
The Wedding Planner Bundle includes the workbook’s Guests, Invitations, Meals and Seating sheets, plus separate browser planning tools. The workbook and those tools do not automatically synchronise. Keep one main list and follow the guide when transferring or checking arrangements.
For the next part of your plan, see how to separate wedding costs from deposits and final payments. Once names and table assignments are settled, explore the Wedding Stationery Studio for coordinated place cards and table signs.