A wedding budget spreadsheet lists every cost category with a planned amount, an actual amount and the difference, and ties the total to the money you actually have: each partner's share plus any family contributions. Add a payments tab for vendor deposits and a guest tab for per-head costs, and you can see at any point what is spent, what is still due and how much buffer is left. The worked example below plans a $20,000 wedding for 90 guests with a $2,000 contingency line.
The layout works the same in Google Sheets and Excel. Google Sheets is the easier choice when two partners and a parent or two all need to edit the same file.
The layout: four tabs
| Tab | What it holds | Why it is separate |
|---|
| Budget | One row per category: planned, actual, difference | The one view you check every week |
| Who Pays | Each contributor and the amount they cover | Keeps the funding total honest |
| Payments | Every deposit and balance, with due dates | Stops a missed final payment |
| Guests | Names, RSVP status, meal choice | Drives every per-guest cost |
Put one cell at the top of the Budget tab: Total budget, which reads its value from the Who Pays tab. If the family contribution changes, the budget changes with it.
Budget tab columns
| Column | Example (row 2) | Notes |
|---|
| A: Category | Venue and catering | Keep categories broad, 10 to 12 is enough |
| B: Planned | 9,000 | What you agreed before booking |
| C: Actual | 9,350 | Sum of the Payments tab for this category |
| D: Difference | =C2-B2 | Positive means over budget |
| E: Share of total | =B2/$B$13 | Shows where the money goes |
Fill column C from the Payments tab instead of typing it: =SUMIFS(Payments!C:C, Payments!B:B, A2) totals every payment tagged with that category. Then the Budget tab never disagrees with what you have actually paid.
Worked example: a $20,000 budget for 90 guests
The numbers below are an illustration, not an average wedding cost. Replace them with your own quotes.
| Category | Planned | Share |
|---|
| Venue and catering | $9,000 | 45.0% |
| Photography and video | $2,400 | 12.0% |
| Attire and rings | $2,000 | 10.0% |
| Flowers and decor | $1,400 | 7.0% |
| Music and entertainment | $1,200 | 6.0% |
| Hair and makeup | $500 | 2.5% |
| Favors and gifts | $500 | 2.5% |
| Transport | $400 | 2.0% |
| Stationery | $300 | 1.5% |
| Officiant and licence | $300 | 1.5% |
| Contingency (10%) | $2,000 | 10.0% |
| Total | $20,000 | 100% |
Venue and catering is $9,000 for 90 guests, so each guest costs about $100 in that line alone. Put that per-guest figure in its own cell: =B2/COUNTIF(Guests!C:C, "Yes"). When the guest list grows from 90 to 100, the sheet shows roughly $1,000 more before you sign anything.
Planned vs actual, three months in
| Category | Planned | Actual | Difference |
|---|
| Venue and catering | $9,000 | $9,350 | +$350 |
| Photography and video | $2,400 | $2,400 | $0 |
| Attire and rings | $2,000 | $1,850 | −$150 |
| Contingency left | $2,000 | | $1,800 |
The venue came in $350 over after a menu change, and the attire came in $150 under. The contingency cell, =2000-SUM(D2:D11), nets the two: $2,000 minus $200 leaves $1,800. Because the overrun comes out of a named buffer, no other category has to be cut quietly.
Who pays: split the cost before you book
Money talks go better with numbers on screen. The Who Pays tab lists each contributor and the amount they cover, and its total must equal the Budget tab total.
| Contributor | Basis | Amount |
|---|
| Partner A | 60% of the couple's share | $8,400 |
| Partner B | 40% of the couple's share | $5,600 |
| Family gift | Fixed amount | $6,000 |
| Total | | $20,000 |
In this example the couple covers $14,000 between them and splits it by income, 60/40. With 14 months until the wedding that is $1,000 a month to set aside: $600 from Partner A and $400 from Partner B. The formula is =Share/MonthsLeft, so it updates as the date gets closer.
A 50/50 split, fixed amounts or a proportional split all work. What matters is that you agree on it first. If you already split everyday bills by income, the split expenses spreadsheet uses the same proportional formula for shared costs.
The payments tab: deposits, balances and due dates
Most vendors take a deposit at booking and the balance close to the date, so one category can have two or three payments. Give each payment its own row:
| Column | Example |
|---|
| A: Vendor | Riverside Hall |
| B: Category | Venue and catering |
| C: Amount | 2,700 |
| D: Due date | 2027-01-15 |
| E: Paid | Checkbox |
Two formulas do the work:
- Due in the next 30 days, unpaid:
=SUMIFS(C:C, E:E, FALSE, D:D, "<="&TODAY()+30)
- Total paid so far:
=SUMIFS(C:C, E:E, TRUE)
Add conditional formatting to column D (red when the date is within 14 days and the Paid box is empty) and the sheet warns you before a deadline passes.
Fund the savings from your real spending
The monthly savings figure only works if the money exists. Instead of guessing, look at your actual spending:
- Export the last three months of transactions from each partner's bank as CSV.
- Import them into one sheet with Date, Description, Amount and Category columns. The expense tracking spreadsheet template shows a simple layout.
- Categorize every row. The bank transaction categorization guide covers rules, formulas and AI options if this is the slow part.
- Total each category per month with
SUMIFS and decide which ones can shrink until the wedding.
Keep wedding payments in their own category, so they do not inflate your everyday spending totals. If you would rather keep the savings in separate buckets (wedding, honeymoon, rings), a sinking fund spreadsheet tracks each goal on its own.
When the budget does not add up
If the planned total is higher than the Who Pays total, the spreadsheet shows the gap; it cannot close it. The biggest lever is usually the guest count, because it drives venue, catering, stationery and favors at once. After that, compare the share of total column: a category taking a much larger share than you expected is the first place to look. Be careful with financing a wedding on a credit card. If you do, enter the card's APR and the monthly payment in the sheet so the interest cost is visible next to everything else.
For the everyday budget after the wedding, the Google Sheets budget templates Reddit recommends are a good next step.
FAQ
What should a wedding budget spreadsheet include?
Four tabs cover it: a Budget tab with planned and actual amounts per category, a Who Pays tab that records each contributor's share, a Payments tab with every vendor deposit and due date, and a Guests tab that drives the per-guest costs. A contingency line of about 10% of the total absorbs overruns.
How do we split wedding costs fairly between partners?
Agree on the split before you book anything. Common options are 50/50, proportional to income, or fixed amounts. In the worked example on this page the couple covers $14,000 at a 60/40 income split, so one partner pays $8,400 and the other $5,600, and a family gift covers the remaining $6,000.
How do I track wedding deposits and due dates in Google Sheets?
Give each payment its own row with vendor, amount, due date and a Paid checkbox. Then =SUMIFS(C:C, E:E, FALSE, D:D, "<="&TODAY()+30) shows how much is due in the next 30 days that you have not paid yet.
Does this wedding budget template work in Excel?
Yes. SUM, SUMIFS, COUNTIF and simple variance formulas work the same in Excel and Google Sheets. Google Sheets is easier when both partners and family members edit the same file, because sharing and live editing are built in.
How much contingency should a wedding budget have?
A common rule is 5 to 10% of the total. The example on this page uses 10%, or $2,000 of a $20,000 budget, as its own line so overruns come out of a visible buffer instead of out of another category.
