Wedding Budget Spreadsheet: How to Set It Up, Track Vendors and Payments (Excel or Google Sheets)
Build a wedding budget spreadsheet: category allocation, estimated vs actual costs, guest-count driven catering costs, vendor deposits and payment schedule, contingency, and a worked $30,000 example.
Quick answer: a wedding budget spreadsheet has three parts. A budget tab lists every cost category with an estimated amount, the actual quoted or contracted amount, what you have paid so far and the balance due. A guest list tab drives the costs that scale per person, such as catering, bar and favors. A payment schedule tab lists every deposit and final payment by due date, so nothing is missed in the last busy weeks. A contingency line of 5–10% absorbs the surprises every wedding has.
Below is a layout you can build in Excel or Google Sheets in under an hour, plus a worked example for a $30,000 budget and 100 guests. The allocation is an example starting point, not a benchmark; your priorities decide the split.
Step 1: Set the total and allocate it
Start from the amount you can actually spend: savings, what you can set aside each month until the date, and any family contributions that are confirmed. Put it in one input cell (B2), then allocate it by percentage so the dollar amounts update if the total changes.
| Category | Example share | On a $30,000 budget |
|---|---|---|
| Venue and catering | 45% | $13,500 |
| Photography and video | 12% | $3,600 |
| Attire and beauty | 8% | $2,400 |
| Flowers and decor | 8% | $2,400 |
| Music and entertainment | 7% | $2,100 |
| Rings | 5% | $1,500 |
| Stationery and favors | 3% | $900 |
| Transportation and miscellaneous | 4% | $1,200 |
| Contingency | 8% | $2,400 |
| Total | 100% | $30,000 |
Formula for each row: =ROUND($B$2*C5,0). Add a check cell =SUM(C5:C13) that must show 100%. Before locking the split, each of you can rank the categories: if photography matters most to you and flowers least, move a few percent from one to the other now, not after the contracts are signed.
Step 2: The budget tab
Create a table (Ctrl+T) named Budget with one row per line item, not just per category, because a category like “Attire and beauty” contains several purchases:
| Column | Field | Formula or input |
|---|---|---|
| A | Category | Dropdown from the allocation table |
| B | Item | e.g. “Reception venue rental” |
| C | Vendor | Name and contact |
| D | Estimated | Your planning number |
| E | Actual | Contracted or final amount, including tax, service charges and tips |
| F | Paid to date | =SUMIFS(Payments[Amount],Payments[Item],[@Item],Payments[Status],"Paid") |
| G | Balance due | =IF([@Actual]="",[@Estimated],[@Actual])-[@[Paid to date]] |
| H | Over / under | =IF([@Actual]="","",[@Actual]-[@Estimated]) |
A category summary compares each category’s allocation with what you have committed: =SUMIFS(Budget[Actual],Budget[Category],A5) for contracted items plus =SUMIFS(Budget[Estimated],Budget[Category],A5,Budget[Actual],"") for items not yet booked. Highlight any category where that total exceeds its allocation.
Watch the extras that quotes often leave out: sales tax, service charges, gratuities, delivery and setup fees, overtime, cake-cutting or corkage fees. Ask each vendor what the final total will be, and enter that number as the actual.
Step 3: Let the guest list drive per-person costs
Catering, bar, rentals (chairs, place settings), favors and stationery scale with the guest count. On a Guests tab, list each guest with an RSVP column (Invited / Yes / No). Then:
- Planned headcount:
=COUNTA(Guests[Name])while invitations are out; switch to=COUNTIF(Guests[RSVP],"Yes")once replies come in. - Catering estimate:
=Headcount*PerPersonPrice, linked to the catering line in the budget tab. - Cost per guest overall:
=SUM(Budget[Actual])/Headcount— a useful number when deciding whether to add more guests.
Example: what 20 extra guests cost
In the example, venue and catering is a $4,000 venue fee plus $95 per person for food and drinks: $4,000 + 100 × $95 = $13,500, exactly the allocation. If the guest list grows to 120, catering rises by 20 × $95 = $1,900, and that is before extra rentals, favors and invitations. Almost the whole $2,400 contingency would be gone before the first unexpected cost. Seeing this number in the spreadsheet makes the guest-list conversation much more concrete.
Step 4: The payment schedule
Most vendors take a deposit at booking and the balance shortly before the date. On a Payments tab, record each planned payment as its own row: item, vendor, amount, due date, payment method, status (Planned / Paid) and paid date.
- Due in the next 30 days:
=SUMIFS(Payments[Amount],Payments[Status],"Planned",Payments[Due date],"<="&TODAY()+30) - Overdue:
=COUNTIFS(Payments[Status],"Planned",Payments[Due date],"<"&TODAY()) - Cash needed per month: a small table with months in rows and
=SUMIFS(Payments[Amount],Payments[Due date],">="&A2,Payments[Due date],"<="&EOMONTH(A2,0))
The monthly view shows whether your savings plan keeps up with the deposits. If several big balances fall due in the final month, plan for that now. If you are setting money aside from regular income, a monthly budget template helps you find the amount you can commit each month.
Step 5: A one-glance summary
At the top of the budget tab, show:
- Total budget (B2)
- Committed so far:
=SUM(Budget[Actual]) - Still estimated:
=SUMIFS(Budget[Estimated],Budget[Actual],"") - Projected total: committed + still estimated
- Remaining contingency:
=B2-Projected total - Paid so far and left to pay
If several people (partners, parents, a planner) use the file, share it in Google Sheets or OneDrive and protect the formula columns so only the inputs can be edited; see how to protect formulas in Excel.
Common mistakes
- Budgeting on quotes without tax, service charges and tips: the real total can be noticeably higher than the headline price.
- No contingency: something always changes: an alteration, a rental, a last-minute guest.
- Tracking only categories, not payments: the most common problem in the final weeks is not the total but a balance due on the wrong day.
- Treating family contributions as certain before they are confirmed.
- Forgetting post-wedding costs: thank-you cards, dress cleaning, final photo prints or albums.
FAQ
How much contingency should we keep?
Many couples plan 5–10% of the total. The more vendors and guests you have, and the further away the date, the more sense the higher end makes.
Should tips be in the budget?
Yes. Some contracts already include a service charge, others do not; check each one and add a separate line for gratuities so they do not come out of the contingency on the day.
Excel or Google Sheets?
Both work with these formulas. Google Sheets is easier when several people update the guest list and payments; Excel is fine if one person manages the budget.
More planning guides: Event & Wedding Planning.