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)

Spreadsheet vs calculator vs method guide: which to use 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.

ColumnWhat goes in it
CategoryVenue and ceremony, registrar, wedding breakfast, drinks and corkage, evening food, photography and video, outfits, rings, flowers and decor, entertainment, stationery, cake, transport, contingency, other
ItemWhat the line covers, such as "venue hire (exclusive use)" or "evening buffet"
SupplierWho 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 dateWhen the next payment is due (DD/MM/YYYY)
StatusNot paid / Part paid / Paid (or Quoted / Booked if you want to log quotes too)
NotesMinimum 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

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.

CategorySupplierEstimateTotalPaid so farBalance dueDue dateStatus
Venue and ceremonyExample Hall£4,000£4,200£1,000£3,20001/05/2027Part paid
PhotographyExample Photo Co£1,500£1,400£300£1,10015/05/2027Part paid
StationeryExample 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:

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:

  1. Add one row per payment, not per supplier: the venue deposit, the venue balance and any interim payment are separate rows.
  2. For each row, record the due date, supplier, what it is for, the amount, whether it is paid and the date you paid it.
  3. Sort by due date, then add up what is due each month and compare it with what you will have saved by then.
  4. Highlight anything due in the next couple of weeks (conditional formatting on the due-date column does this) and anything overdue.
  5. 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

DIY spreadsheet vs a ready UK template

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

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.