Wedding budget spreadsheet UK: columns, deposits and a ready template
A wedding budget spreadsheet is where the plan becomes real: every quote, every deposit, every balance and every due date in one file you keep open until the last supplier is paid. This guide shows practical columns for a UK wedding budget in Excel or Google Sheets, a few simple formulas, how to log deposits as a payment schedule, and when to use a spreadsheet, the free wedding budget calculator or our how to budget a UK wedding method guide. It is a planning method, not financial advice.
What this guide is (and is not)
- Is: the spreadsheet method: column headings, a dashboard, formulas, a payment schedule and how to keep the file up to date, whether you build it yourself or use a template.
- Is not: how to set your total, work out cost per guest or split the money by category (that is how to budget a UK wedding), or a quick split of a total you have not committed yet (that is the free wedding budget calculator).
- Product note: the UK Wedding Budget Planner (£5.50) is a ready tracker template. It does not set your budget for you, and it is not legal, tax or financial advice.
Spreadsheet vs calculator vs method guide: which to use when
- Method guide (how to budget a UK wedding): read once at the start. It covers setting a total you can actually pay, cost per guest, VAT on quotes, comparing venues and planning deposits.
- Live calculator (wedding budget calculator): play with a total, guest numbers and category percentages before anything is booked. It updates instantly and nothing is saved.
- Spreadsheet (this page): the working record from the first quote to the final balance. Every supplier row, what you have paid, what is still due and when.
A simple flow: read the method, try a split in the calculator, then copy the agreed category amounts into the spreadsheet as your estimates and update it every time you get a quote or make a payment.
Columns for a UK wedding budget spreadsheet
Use one row per cost line. These headings are a practical layout for a DIY sheet; rename them if you like.
| Column | What goes in it |
|---|---|
| Category | Venue and ceremony, registrar, wedding breakfast, drinks and corkage, evening food, photography and video, outfits, rings, flowers and decor, entertainment, stationery, cake, transport, contingency, other |
| Item | What the line covers, such as "venue hire (exclusive use)" or "evening buffet" |
| Supplier | Who you are paying |
| Estimate (£) | Your planned amount for the line, before you have a quote (copy it from the calculator split) |
| Quote ex-VAT (£) | Only if the supplier quotes before VAT |
| VAT (£) | The VAT on that quote, if the supplier charges it; 0 if they are not VAT-registered or the line is exempt |
| Total (£) | What you will actually pay the supplier, VAT included |
| Deposit (£) | What is due to secure the booking |
| Paid so far (£) | Everything you have paid on this line |
| Balance due (£) | Total minus paid so far |
| Due date | When the next payment is due (DD/MM/YYYY) |
| Status | Not paid / Part paid / Paid (or Quoted / Booked if you want to log quotes too) |
| Notes | Minimum spend, service charge, corkage, cancellation terms, final-numbers deadline, contract signed |
The UK Wedding Budget Planner (£5.50) works in totals rather than a separate VAT column: its budget sheet compares estimate with actual/quoted price, then tracks paid so far, still to pay and a Paid / Part paid / Not paid status that fills itself in. If a supplier quotes ex-VAT, enter the VAT-inclusive figure and note "ex-VAT quote + VAT" in Notes. If you want a VAT split for every line, the DIY layout above or the Event Budget Planner (UK, with VAT) (£4.95) has one.
The dashboard: five numbers to keep at the top
- Total budget: the figure you set using the method guide.
- Forecast spend: the sum of actual quotes where you have them, and estimates where you do not yet.
- Paid so far and left to pay: the cash position.
- Under / over budget: total budget minus forecast spend.
- Cost per guest: forecast spend divided by day guests. Update it whenever the guest list changes (our wedding guest list template UK guide covers the list itself).
Illustrative sample rows (made-up figures)
The rows below are made-up examples to show how the columns fit together. They are not typical UK wedding costs, averages or a recommended budget.
| Category | Supplier | Estimate | Total | Paid so far | Balance due | Due date | Status |
|---|---|---|---|---|---|---|---|
| Venue and ceremony | Example Hall | £4,000 | £4,200 | £1,000 | £3,200 | 01/05/2027 | Part paid |
| Photography | Example Photo Co | £1,500 | £1,400 | £300 | £1,100 | 15/05/2027 | Part paid |
| Stationery | Example Print | £300 | £250 | £250 | £0 | — | Paid |
| Contingency | — | £500 | — | — | — | — | Held |
Simple formulas for Excel and Google Sheets
Both programs use the same formulas for this. Assuming quote ex-VAT is in column E, VAT in F, total in G, paid so far in I and balance in J:
- VAT on a standard-rated quote:
=E2*0.2. GOV.UK lists the standard rate as 20% (VAT rates, checked 14 October 2026), but not every supplier or line is charged VAT, so only use it where the quote says "plus VAT". - Total:
=E2+F2, or type the inclusive price straight into the total column if that is how it was quoted. - Balance due:
=G2-I2. - Status:
=IF(I2=0,"Not paid",IF(I2>=G2,"Paid","Part paid")). - Totals row:
=SUM(G2:G60)for forecast spend and=SUM(I2:I60)for paid so far.
Excel or Google Sheets? Excel is fine if one person keeps the budget. Google Sheets is easier if you both want to update it from your phones. An .xlsx template opens in both: upload it to Google Drive and use File › Save as Google Sheets.
VAT and service charges (high level)
Keep VAT visible. If a quote says "plus VAT", the total you pay is higher than the headline, and that gap is a common way for a wedding budget to go over. Service charges, minimum spends and corkage belong in the total or the Notes column, not left out. Whether venue hire carries VAT depends on the venue, so ask in writing. For the detail on venue hire vs catering, see how to budget a UK wedding and the hall hire cost UK guide. If a business is paying for part of an event, the corporate event budget UK guide covers the business side. This page is not VAT advice.
Deposits and the payment schedule
A budget sheet tells you what each supplier costs. A payment schedule tells you when the money has to leave your account. Keep it as a second tab:
- Add one row per payment, not per supplier: the venue deposit, the venue balance and any interim payment are separate rows.
- For each row, record the due date, supplier, what it is for, the amount, whether it is paid and the date you paid it.
- Sort by due date, then add up what is due each month and compare it with what you will have saved by then.
- Highlight anything due in the next couple of weeks (conditional formatting on the due-date column does this) and anything overdue.
- Copy the cancellation terms for each deposit into Notes, so you know what is refundable before you change plans.
The method behind this, including why balances bunch up towards the end, is in how to budget a UK wedding (step 6). If you also want contracts signed, insurance seen and a 12-month cash-flow table for every supplier, the Event Supplier & Payment Tracker (£4.50) is built for that job, and our supplier payment tracker UK guide shows the columns and formulas.
Keeping the spreadsheet honest
- Update it the same day you get a quote or make a payment.
- Replace estimates with real quotes as soon as you have them; keep the original estimate so you can see where you drifted.
- Keep contingency as its own row. If you use some of it, reduce that row and add a real line, so the trail stays clear.
- Recheck cost per guest whenever the guest list changes, and before you sign the venue contract.
- Comparing venues before you book? Put the quotes through the free venue hire cost comparison first, then add only the chosen venue to the budget. Logging several venue enquiries? See the venue booking spreadsheet UK guide. The Venue Comparison Scorecard & Viewing Checklist (£2.99) helps you score viewings, and the free FREE Venue Viewing Checklist (Lite), UK Wedding & Event Venues (£0) covers the questions to ask.
DIY spreadsheet vs a ready UK template
- DIY: build the columns, formulas and payment tab above in a blank Excel or Google Sheets file. It costs nothing except an evening.
- Ready template: the UK Wedding Budget Planner (£5.50) already has the UK categories, example lines, dashboard, automatic status and payment alerts, with a Start Here tab. Overwrite or clear the example rows.
- Bundle: if you also want the venue scorecard, guest list and allergen tracker, supplier tracker, run sheet, planning checklist and seating planner, the UK Wedding Planner Bundle (7 templates) (£21.95) includes the budget planner and six more templates.
More: how to budget a UK wedding · wedding budget calculator · venue hire cost comparison · wedding planning checklist UK · venue booking checklist · wedding guest list template UK · event budget spreadsheet UK · supplier payment tracker UK
Free tools for this
- Wedding Budget Calculator UK
- Venue Hire Cost Comparison (UK)
- Wedding Planning Timeline (UK)
- Table Seating / Venue Capacity Calculator
Frequently asked questions
What columns should a wedding budget spreadsheet have?
Category, item, supplier, estimate, total (VAT included), deposit, paid so far, balance due, due date, status and notes. Add quote ex-VAT and VAT columns if some suppliers quote before VAT. Put total budget, forecast spend, paid, left to pay, under/over and cost per guest at the top.
Is there a UK wedding budget spreadsheet template?
Yes. You can build the columns in this guide yourself, or use our UK Wedding Budget Planner: an Excel and Google Sheets template with a dashboard, 13 UK wedding categories, estimate vs actual, paid vs still to pay and a payment schedule with due-date alerts, in £ with UK dates.
Should I use Excel or Google Sheets for a wedding budget?
Either works and the formulas are the same. Google Sheets is easier if you both want to update it from your phones; Excel suits one person keeping the file. An .xlsx template can be uploaded to Google Drive and saved as Google Sheets.
Can I make a free wedding budget spreadsheet?
Yes. Copy the columns and formulas from this guide into a blank Excel or Google Sheets file, and add a second tab for the payment schedule. The free wedding budget calculator will give you starting amounts per category to use as estimates.
How do I track wedding deposits and balances in a spreadsheet?
Use a payment schedule tab with one row per payment (deposit and balance separately): due date, supplier, what for, amount, paid, date paid and status. Sort by due date, total each month and highlight anything due soon or overdue.
Should wedding quotes go in the spreadsheet with or without VAT?
Budget on what you will actually pay, so the total column should include VAT where the supplier charges it. If a quote says "plus VAT", record the ex-VAT figure and the VAT separately, or enter the inclusive total and note it. Not every supplier charges VAT.
What is the difference between a wedding budget spreadsheet and the wedding budget calculator?
The calculator splits a total across categories and shows cost per guest instantly, but saves nothing. The spreadsheet is the working record of every quote, payment and due date until the wedding is paid for. Use the calculator first, then the spreadsheet.
Is the UK Wedding Budget Planner financial advice?
No. It is a fill-in Excel and Google Sheets planning template that tracks what you enter. It does not set your budget or replace financial advice, and this guide is not financial or tax advice either.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.