Event budget spreadsheet UK: columns, VAT and a ready template

An event budget spreadsheet only works if every quote has the same columns: what was quoted before VAT, the VAT, the total you will pay, what has been deposited and what is still due. This guide shows a practical layout for Excel or Google Sheets, how to keep a VAT column honest, how contingency works as a method (not a magic percentage), and how the free event budget and VAT calculator pairs with a live tracker. It is a planning method, not tax or financial advice.

What this guide is (and is not)

Spreadsheet vs the live calculator

Use both for different jobs:

A common flow is: rough the numbers in the calculator → copy the agreed lines into the spreadsheet → update the spreadsheet whenever a quote or payment changes.

Columns that keep a UK event budget honest

One row per cost (or income) line. These column headings are a practical layout; rename them to match your organisation if needed.

ColumnWhat goes in it
CategoryVenue, catering, drinks, AV, entertainment, print, travel, staffing, insurance, gifts, contingency, other
SupplierWho you are paying (or the income source)
DescriptionWhat the line covers in plain English
Quote ex-VAT (£)The figure before VAT, if the quote is ex-VAT
VAT (£)Usually 20% of the ex-VAT amount when the supplier is VAT-registered; 0 if they are not, or if the supply is exempt
Total / inc-VAT (£)What you will actually pay the supplier (ex-VAT + VAT, or the inclusive quote)
Deposit (£)How much is due now to secure the booking
Balance due (£)What is left after the deposit
Due dateWhen the deposit and/or balance must be paid (use DD/MM/YYYY)
StatusQuoted / booked / deposit paid / balance paid / cancelled
NotesMinimum spend, service charge, cancellation terms, dietary deadlines, invoice number

At the top of the sheet (or on a dashboard tab), keep running totals: budget, committed (booked), paid, remaining, and cost per head (total ÷ confirmed guests). Update cost per head whenever guest numbers change.

Illustrative sample rows (made-up figures)

The rows below are made-up examples to show the layout. They are not typical prices, averages or a recommended budget.

CategorySupplierQuote ex-VATVATTotalDepositBalance dueStatus
VenueExample Hall Ltd£1,000£200£1,200£400£800Deposit paid
CateringExample Caterers£2,500£500£3,000£750£2,250Booked
Contingency—£350—£350——Held

The VAT column (keep it separate)

Many UK venue and catering quotes are given ex-VAT. At the standard rate of 20%, an ex-VAT quote needs a matching VAT amount so the person approving the budget sees the cash cost. Put ex-VAT and VAT in separate columns; never hide VAT inside a vague "extras" line.

Whether a VAT-registered business can reclaim that VAT depends on who the event is for. At a high level, HMRC's Business entertainment (VAT Notice 700/65) (checked 14 October 2026) blocks recovery on entertaining clients and other non-employees in the usual case, while staff entertainment such as staff parties is normally recoverable; mixed events need an employee/guest split. Do not treat this page as VAT advice — for cost lines, reclaim framing and worked corporate rules, use the corporate event budget UK guide and ask your accountant. For a quick add/strip of 20% on a quote, use the free event budget and VAT calculator.

Also watch service charge and minimum spend on venue quotes: note both in the Notes column and include them in the total you compare. Comparing halls? The free venue hire cost comparison and the hall hire cost UK guide help you put quotes side by side.

Contingency as a method (not a recommended %)

Contingency is a separate row you review when the brief changes — not a number buried inside another line. A simple method:

  1. List every known cost with a written quote.
  2. Add a contingency row under its own category.
  3. When guest numbers, the room or the catering package change, re-check whether the contingency still covers the open risks (late AV, extra staff hours, a minimum-spend top-up).
  4. If you spend from contingency, reduce that row and add a real supplier row so the trail stays clear.

We are not recommending a percentage here. How large the buffer should be depends on how settled the brief is; the corporate guide discusses contingency in a corporate framing if you need that context.

Wedding, corporate and Christmas party variants

Income, deposits and status

If the event sells tickets or takes sponsorship, add an income sheet (or section) with expected vs received, so the dashboard can show net position. On the cost sheet, status values such as Quoted → Booked → Deposit paid → Balance paid stop double-paying and missed due dates. The Event Supplier & Payment Tracker (£4.50) is built for chasing every deposit and balance across suppliers if you want that job in its own tracker; our supplier payment tracker UK guide shows the columns, status formula and a monthly cash-flow tab.

DIY spreadsheet vs a ready UK template

More: corporate event budget UK · event budget and VAT calculator · hall hire cost UK · staff party tax exemption checker · Christmas party cost per head · Christmas party checklist UK · supplier payment tracker UK · event run sheet template UK

Free tools for this

Frequently asked questions

What columns should an event budget spreadsheet have?

At minimum: category, supplier, description, quote ex-VAT, VAT, total (inc-VAT), deposit, balance due, due date, status and notes. Add a summary for budget, committed, paid, remaining and cost per head, and an income section if you sell tickets or take sponsorship.

Is there an event budget spreadsheet template for the UK?

Yes. You can build the columns in this guide yourself in Excel or Google Sheets, or use our Event Budget Planner (UK, with VAT) — a ready tracker with net, VAT and gross, income and break-even. The free event budget and VAT calculator is for quick totals, not a saved spreadsheet.

How do I add VAT to an event budget in Excel or Google Sheets?

Keep quote ex-VAT and VAT in separate columns. For a standard-rated 20% quote, VAT is 20% of the ex-VAT figure and total is ex-VAT plus VAT. If the quote is VAT-inclusive, put the full amount in total and note that in the Notes column. The free event budget and VAT calculator can sense-check a line quickly.

Should contingency be a percentage of the event budget?

Treat contingency as a separate row you review when the brief changes, not a figure buried inside another cost. How large it should be depends on how settled guest numbers, venue and catering are — this guide does not recommend a fixed percentage.

How does an event budget spreadsheet pair with the VAT calculator?

Use the free event budget and VAT calculator for quick add/strip VAT and break-even while you are still pricing options. Copy agreed lines into the spreadsheet and keep deposits, balances and status there until the event is paid off.

What is different about a corporate event budget spreadsheet?

The columns are the same; corporate budgets also need a clear note on staff vs client entertainment for VAT recovery, and often an approval trail. Our corporate event budget UK guide covers cost lines and HMRC Notice 700/65 at a high level — ask your accountant for your case.

Can I use the same spreadsheet for a wedding or Christmas party?

Yes. The same columns work. For wedding-specific budgeting see how to budget a UK wedding; for staff Christmas parties use the cost per head calculator, the staff party tax exemption checker and the Christmas party checklist alongside the spreadsheet.

Is the Event Budget Planner tax or financial advice?

No. It is a fill-in Excel and Google Sheets planning template for costs, VAT columns, income and break-even. It does not file returns or replace an accountant. This guide is not tax or financial advice either.

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.