How to make a wedding budget spreadsheet in Google Sheets
Updated 2026-10-17
A useful wedding budget spreadsheet has one row per item with columns for estimate, final cost, deposit, due dates, paid, who pays and status, plus a guest list whose count drives per-guest costs like catering. Build it yourself with SUMIFS and COUNTIFS, or start from a template.
The columns that matter
- Category and item (venue, catering, photographer…)
- Price is: total or per guest, so catering multiplies by your guest count
- Estimate and final cost (use the final cost once you sign)
- Deposit, 2nd payment, balance, each with a due date and a Paid? tick
- Who pays and status (estimate, booked, due soon, overdue, paid)
Link the guest list to the budget
Keep guests on their own tab with an RSVP column. Count the guests you’re paying for with COUNTIFS (for example, everyone except “No”), then multiply per-guest prices by that count. Now catering re-prices itself every time an RSVP changes.
Formulas to use
=SUMIFS(cost, category, "Food & drink")for category totals=COUNTIFS(rsvp, "<>No", name, "?*")for head-count=SUMIFS(cost, who_pays, "Family 1")for each family’s share- Avoid FILTER, SORT and XLOOKUP if the file must work in older Excel.
Or start from a finished one
The Sorted Budget wedding planner has all of this built and tested in Google Sheets and Excel: a budget that prices itself from your total, a monthly pay plan, guest list with RSVPs and meals, a seating chart, a run sheet, a dated checklist and a tipping guide.
Questions
Is there a free wedding budget template?
Yes: our free starter sheet splits your budget by category and per guest. The full planner adds the guest list, payments and checklist.
Will it work in Excel too?
Yes, if you stick to standard functions like SUMIFS, COUNTIFS and INDEX/MATCH.