Guide, 2026-11-04

How to make a wedding budget spreadsheet with a payment schedule

A wedding budget usually starts as a list of guesses and slowly turns into a list of contracts, each with a deposit, a balance and a due date. The hard part is not adding up the numbers. It is knowing, at any point, how far the real costs have drifted from the plan and which payment is due next. This guide shows a simple structure that handles both in any spreadsheet.

Step 1: set the total budget

Agree one total number before you book anything, and write down who is contributing what. Every line below is measured against this figure.

Step 2: list budget lines with an estimate and a booked cost

Give each category its own row: venue, catering, photography, flowers, music, attire, stationery and so on. Use three money columns:

• Estimate: your best guess before you have a quote.
• Booked cost: the contracted price, filled in once you sign. Include tax, service charges and delivery if the contract adds them.
• Planned cost: the booked cost if there is one, otherwise the estimate. In a spreadsheet: =IF(C2<>"", C2, B2).

The total of planned cost is your best current forecast of what the wedding will cost. Compare it with the total budget to see whether you are over or under.

Step 3: keep a payment schedule

Most vendors split payment into a deposit and one or more balances. Give each payment its own row: vendor, description, amount, due date and paid date. Status follows a simple rule: if there is a paid date, "Paid"; if the due date has passed, "Overdue"; if it falls in the next 30 days, "Due soon"; otherwise "Later". Sort by due date and you have a list of what to pay next.

A worked example

A couple has a $20,000 budget and a wedding date of 12 June 2027. On 1 March 2027 (103 days to go) the budget looks like this:

The original estimates matched the budget exactly, but the venue and photographer together came in $1,000 higher. Savings of $600 on catering and music cover part of that, so the plan is now $400 over. That is the moment to decide where the $400 comes from, while flowers and attire are still open.

The payment schedule on the same day:

$2,500 is paid, so $14,400 is still owed on booked contracts. The catering deposit is two weeks late and should be paid today, before the caterer releases the date.

Step 4: one row per guest

List every person, not every household: name, party or household, side, RSVP (yes, no, waiting), meal choice, dietary notes and table number. Plus-ones and children each get their own row. Counting confirmed guests and meals is then a COUNTIFS, and you can check each table's seats against its capacity.

Step 5: date the checklist back from the day

Write tasks with an offset in days before the wedding and let the spreadsheet calculate the date. "Send invitations, 56 days before" becomes 17 April 2027 for a 12 June wedding. If the date moves, every task moves with it.

Common mistakes

• Recording only estimates and never replacing them with contract prices.
• Forgetting service charges, tax, delivery and tips that are not in the headline quote.
• Tracking payments in the budget sheet, so deposits and balances get mixed up with costs.
• Giving a couple one guest row, which makes meal and seat counts wrong.

When a ready-made workbook saves time

All of this can be built by hand over a weekend. If you would rather spend the weekend on something else, WeddingBook is set up the same way: budget against planned cost, a payment schedule showing paid, overdue and due in the next 30 days, a guest list with RSVPs and meals, seating by table number for up to 40 tables, a pre-filled dated checklist and a dashboard.