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)
- Is: how to build and maintain an event budget spreadsheet — column headings, category rows, VAT, deposits, status and a simple contingency method — for parties, weddings, corporate days and Christmas staff dos.
- Is not: a full corporate cost-line and VAT-reclaim walk-through (use our corporate event budget UK guide and HMRC VAT Notice 700/65 for business entertainment), a wedding-only budget method (see how to budget a UK wedding), or a Christmas party tick-list (see the Christmas party checklist UK).
- Product note: the Event Budget Planner (UK, with VAT) (£4.95) is a ready tracker template, not tax, legal or financial advice, and it does not connect to HMRC or your accountant.
Spreadsheet vs the live calculator
Use both for different jobs:
- Live calculator (event budget and VAT calculator): quick totals, add or strip 20% VAT, and a break-even ticket price when you are still pricing options. Nothing is saved.
- Spreadsheet: the ongoing tracker — every supplier row, deposit and balance dates, income (tickets, sponsorship), and the running cost per head. Keep it open until the final invoice is paid.
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.
| Column | What goes in it |
|---|---|
| Category | Venue, catering, drinks, AV, entertainment, print, travel, staffing, insurance, gifts, contingency, other |
| Supplier | Who you are paying (or the income source) |
| Description | What 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 date | When the deposit and/or balance must be paid (use DD/MM/YYYY) |
| Status | Quoted / booked / deposit paid / balance paid / cancelled |
| Notes | Minimum 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.
| Category | Supplier | Quote ex-VAT | VAT | Total | Deposit | Balance due | Status |
|---|---|---|---|---|---|---|---|
| Venue | Example Hall Ltd | £1,000 | £200 | £1,200 | £400 | £800 | Deposit paid |
| Catering | Example Caterers | £2,500 | £500 | £3,000 | £750 | £2,250 | Booked |
| 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:
- List every known cost with a written quote.
- Add a contingency row under its own category.
- 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).
- 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
- Wedding: the same columns work; guest numbers drive catering and often the venue size. Use the wedding budget calculator and how to budget a UK wedding for the wedding-specific method, and the wedding budget spreadsheet UK guide for a wedding-only layout, then keep deposits in the spreadsheet.
- Corporate / client / conference: add a note on whether VAT may be reclaimable (staff vs client entertainment) and track approval. Full cost lines and Notice 700/65 framing: corporate event budget UK.
- Christmas / staff party: track cost per head including partners if the business is paying, and check the annual events exemption with the staff party tax exemption checker and Christmas party cost per head calculator. Tick-box jobs: Christmas party checklist UK.
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
- DIY: create the columns above in Excel or Google Sheets, add a summary and an income section if needed. Costs nothing except your time.
- Ready template: the Event Budget Planner (UK, with VAT) (£4.95) already has VAT options per line, income, cost per guest and break-even laid out for UK events. Still a planning tool, not advice.
- Bundle: if you also need a run sheet, supplier tracker and related sheets, the Event Planner Pro Bundle (7 templates) (£24.95) groups several event templates.
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
- Event VAT Calculator UK (Budget & Break-Even)
- Venue Hire Cost Comparison (UK)
- Office Christmas Party Cost Per Head Calculator
- Staff Party £150 Tax-Free Calculator (HMRC)
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.