How to make a wedding budget spreadsheet
Seven steps, about twenty minutes, and a budget that counts itself.
Rather not build it? Get our free UK budget spreadsheet.
- Agree the total first. Type it in one cell at the top and name it Budget. Every formula can then point to it.
- Add your categories. Venue, food and drink, ceremony, suppliers, outfits and rings, stationery and extras, insurance, buffer. A drop-down (Data > Data validation) keeps them consistent.
- One row per cost. Keep a row for each thing you will pay for, not each supplier. The venue might have hire, food and drinks on separate rows.
- Three money columns. Planned, Quoted, Paid. Never overwrite the plan with the quote; the gap tells you where you overspent.
- Work out what is left. Cost is the quote if there is one, otherwise the plan. Left to pay is cost minus paid.
- Add due dates. Add a column for the next payment's date. A rule turns it red when the date has passed and the line is unpaid.
- Share it. In Google Sheets: Share, add your partner as an editor. In Excel: save to OneDrive, then Share.
Useful extras
- A Payments tab, with one row per deposit or balance. An item paid in three parts still adds up.
- A by category summary with SUMIF, and a simple bar chart of where the money goes.
- A who pays column if family are contributing.
Protect the big payments
Pay at least part of any large deposit directly on a credit card where you can. Under Section 75 of the Consumer Credit Act, the card company can be jointly liable. It applies if a supplier fails. The single item or service must cost over £100 and up to £30,000. See our Section 75 guide.
Or skip the build: our UK Wedding Planner Spreadsheet has all of this. It links to guests, seating and a dated checklist.
The formulas, written out
Say Planned is column E, Quoted column F, Paid column G and Due date column J. Start on row 2. Then:
- Cost (column H):
=IF(F2>0,F2,E2), the quote once you have one, otherwise the plan. - Left to pay (column I):
=H2-G2. - Total cost:
=SUM(H:H). Under or over: your Budget cell minus that total. - By category:
=SUMIF(A:A,"Venue",H:H), one row per category, and a bar chart from those rows.
Copy each formula down the column and it adjusts for every row.
Making overdue payments stand out
Select the Due date column and add a conditional formatting rule. In Sheets it is Format > Conditional formatting; in Excel, Home > Conditional Formatting. Use a custom formula like =AND(J2<TODAY(),I2>0). A date in the past with money still owed then turns red. A second amber rule for dates in the next 30 days gives you a month's warning.
Mistakes worth avoiding
- Typing totals by hand. Every total should be a formula. Then it can never fall out of step with the rows.
- Mixing VAT in and out. Some quotes are given without VAT. Write every figure as what you will actually pay.
- One row per supplier. A venue might charge hire, food and drinks separately, with different due dates. Give each its own row.
- Overwriting the plan. Keep Planned as it was. It is the only record of what you expected to spend.
When to stop building
A wedding budget does not need macros or pivot tables. It needs the total, what is paid, what is left and what is due next. Then it is finished.
Sources
Questions
What formula works out what is left to pay?
Cost minus paid, where cost is the quote if you have one, otherwise the planned figure.
How many categories should a wedding budget have?
Six to eight is plenty. Venue, food and drink, ceremony and suppliers. Outfits and rings, stationery and extras, insurance and a buffer.
How do I flag overdue wedding payments?
Add a conditional formatting rule to the due date. It turns red when the date is before today and money is still owed.
The whole wedding in one spreadsheet
Our UK Wedding Planner Spreadsheet has the budget, payments, guests, seating and 39 dated tasks. It works in Google Sheets and Excel. Launch sale: 35% off until 1 December.
UK Wedding Planner Spreadsheet, £12.31 on EtsyPrefer Notion? Budget Planner, £7.02 on Etsy