Free UK Wedding Budget Spreadsheet: What to Include

How-to basics · Updated November 21, 2026

Yes. You can make a free UK wedding budget spreadsheet in Excel for the web or Google Sheets, then use it to compare your planned budget with supplier commitments, payments and outstanding balances. A useful sheet needs more than a list of prices: it should show when money is due, who is paying and whether each figure is an estimate or a confirmed cost.

What free can mean

A free spreadsheet does not necessarily mean a ready-made, UK-specific file that is checked or maintained by a particular publisher. You can create your own workbook at no cost in Excel for the web with a Microsoft account, or in Google Sheets with a Google account. Both run in a browser and can be used to build a practical budget tracker. Excel desktop is included with some Microsoft 365 plans or licences; it is not the same thing as the free web version.

Microsoft Create and other template libraries may offer budget or event-planning files, but what is available can change. Before using a downloaded template, check whether it is genuinely free, whether it opens in your spreadsheet app, and whether it uses pounds and UK-relevant categories. Avoid entering personal or payment details into a template website just to view a file. A blank workbook with clear headings is often easier to adapt than a complicated template with unfamiliar formulas.

The plan below is designed for Excel for Microsoft 365 on Windows. Excel for the web has many of the same basic spreadsheet features, although some controls and ribbon options can differ. Google Sheets is a reasonable alternative for browser-based collaboration; its menus and formulas are not identical to Excel’s, so do not assume an Excel-specific instruction applies there.

A simple layout that tracks the whole budget

Use one row for each cost category or supplier, and keep the headings consistent. For example, create columns A to H for Category, Planned budget, Agreed or final cost, Paid so far, Still to pay, Supplier, Next payment date, and Notes. Put your categories in rows 2 to 21 and reserve row 22 for totals. If you have more than 20 categories, add rows and adjust the formula ranges.

The distinction between planned, agreed and paid matters. The planned budget is your target for that category. The agreed or final cost is the amount you currently expect to owe, including known extras. Paid so far records money already sent. Still to pay is the difference between the agreed cost and payments made. Keeping those figures separate makes it harder to mistake a deposit for the full price.

Possible rows include venue hire, catering, drinks, photographer, videographer, clothing, alterations, flowers, music, celebrant or officiant, transport, stationery, cake, accommodation, hair and make-up, decorations, insurance and contingency. Add rows that suit your plans rather than treating any list as compulsory. If one supplier covers several services, you can use one row with a detailed note or separate rows if you want to monitor each service independently.

Formulas and a worked example

In Excel, enter headings in row 1 and your costs beneath them. Format the money columns as pounds so that estimates and payments are easy to scan. In Excel for Microsoft 365 on Windows, select the relevant cells and use Home > Number Format dropdown > Currency. The ribbon layout can vary slightly on Mac and in Excel for the web; the equivalent number-format control is available there too.

  • With the agreed cost in C2 and the amount paid in D2, put =C2-D2 in E2 to calculate the remaining balance. For a £7,800 venue with £2,000 paid, the result is £5,800. Copy the formula down the E column for the other supplier rows.
  • With planned costs in B2:B21 and the total cell in B22, enter =SUM(B2:B21) in B22. If the only non-blank planned amounts are £8,000 for the venue, £4,500 for catering and £1,800 for photography, the total is £14,300.
  • With agreed or final costs in C2:C21 and the total cell in C22, enter =SUM(C2:C21) in C22. If those three costs are £7,800, £4,650 and £1,700, the result is £14,150.
  • With payments in D2:D21 and the total cell in D22, enter =SUM(D2:D21) in D22. If the three suppliers have received £2,000, £1,500 and £500, the total paid is £4,000.
  • With remaining balances in E2:E21 and the total cell in E22, enter =SUM(E2:E21) in E22. In this example the unpaid amounts are £5,800, £3,150 and £1,200, so the total still to pay is £10,150.

To compare the agreed total with the original plan, use the total cells. With agreed costs in C22 and the planned budget in B22, enter =C22-B22 in a separate variance cell. The result is -£150 in this example, meaning the three agreed costs are £150 below their combined planned amounts. A positive result means commitments are above plan. This comparison is useful, but it does not predict whether future quotes or changes will raise the final bill.

UK-specific costs and planning details

Wedding costs and requirements vary around the UK, and a spreadsheet cannot tell you what a particular supplier or local authority will charge. Ceremony-related fees, venue arrangements and the process for giving notice depend on the nation and the relevant local authority or registration service. Check current details directly with the appropriate official service and include confirmed fees in your own budget rather than copying an old online figure.

Ask suppliers what is included in a quote and whether the amount includes VAT where applicable. Check the written terms for deposits, instalments, cancellation conditions, delivery, staffing, overtime and any optional extras. A low headline price may not include every service you need. Record the date of the quote and whether it is an estimate or a confirmed price, so you know which figures need checking again.

It is also useful to distinguish costs paid by you from contributions promised by relatives or others. Add a payer column or make the payer explicit in Notes, and record a contribution only when everyone understands whether it is a gift, a loan or conditional support. This is a practical record-keeping suggestion, not financial or legal advice; agree arrangements directly with the people involved.

Payment dates, deposits and cash flow

A wedding can appear to be within budget overall and still create a difficult month if several instalments fall due together. Use the payment-date column to record the next due date, and add separate rows for staged payments if that makes the schedule clearer. For a supplier requiring a booking deposit and a later balance, note both dates and amounts rather than entering only the deposit as the cost.

Check the supplier’s contract or invoice before recording a payment deadline. Keep a simple status such as Quote requested, Quote received, Booked, Part-paid, Paid or Cancelled, and update it when circumstances change. If plans change, retain a note of the old amount and why it changed instead of silently overwriting a figure; a brief change log can help explain the difference later.

Do not treat money expected from a contribution, refund or future income as available until it is actually confirmed and accessible. The spreadsheet is a planning aid, not a bank account or a substitute for reading payment terms. Do not store full card numbers, bank passwords or other sensitive credentials in it.

Set a realistic limit and leave room for changes

Start with the maximum total you are comfortable spending, then decide which categories matter most to you. The amount available is personal; there is no single correct UK wedding budget. A useful approach is to write down the total limit first and allocate tentative amounts to major categories, then revise those estimates after obtaining real quotes. If the first round of quotes exceeds the limit, adjust priorities or guest numbers before treating every increase as inevitable.

Keep a contingency line for unforeseen or newly identified costs. The right amount depends on your plans and risk tolerance, so there is no universal percentage that guarantees cover. You can label this row Contingency and leave its planned amount visible, rather than scattering all spare money across other categories. When you use some of it, record the reason so the remaining reserve is clear.

Separate optional ideas from confirmed commitments. For instance, a second outfit, extra floral installations or additional evening entertainment can be listed as unbooked possibilities with no agreed cost yet. This lets you compare choices without accidentally counting an idea as a promise to spend.

Make the workbook easier to use

Use consistent labels, one currency and clear dates. If you have multiple sheets, a practical set is Overview, Supplier details and Payment schedule. The overview can show planned, committed, paid and unpaid totals; the detail sheet can hold quote notes and contact details; the schedule can focus on dates. Avoid duplicating figures manually across several sheets unless you are prepared to keep them in sync.

In Excel, you can make a heading row easier to navigate with View > Freeze Panes > Freeze Top Row. To make over-budget figures stand out, select the variance cells and use Home > Conditional Formatting > Highlight Cells Rules > Greater Than, then enter 0. Menu availability and appearance can differ in Excel for the web and on Mac. These are optional readability features; the formulas and clear data entry matter more than decoration.

Give the workbook a descriptive file name and save it somewhere you can find it. If sharing with another person, agree who edits the figures and how you will handle changes. A shared online workbook can help avoid circulating several conflicting copies, but check sharing permissions before adding supplier contact details or private notes.

Common mistakes to avoid

  • Mixing deposits with total prices. Record the full agreed cost separately from the amount already paid.
  • Counting a quote as a final commitment. Mark estimates clearly and update them when the supplier confirms the terms.
  • Forgetting less visible extras. Check quotes for delivery, setup, travel, staffing, overtime and add-ons where relevant.
  • Double-counting a cost. If a package includes a service, do not also enter that service as a separate planned cost unless it is genuinely additional.
  • Leaving dates vague. Record when a balance is due, not merely that it is due later.
  • Assuming that a free template is accurate for every UK location or wedding type. Verify local and supplier-specific information yourself.

Frequently Asked Questions

Where can I get a free UK wedding budget spreadsheet?
You can build one in Excel for the web or Google Sheets without buying a template. Template libraries may also have free files, but check the price, compatibility, currency and categories before relying on one. The layout and formulas above are enough to create a basic working version.

Can I use Excel for free to plan a wedding?
Excel for the web is available through a browser with a Microsoft account. It is different from the paid or licensed Excel desktop app, and particular features can vary. For a basic budget using headings, currency formatting and SUM formulas, a browser spreadsheet is generally sufficient.

Should my wedding budget include money already paid?
Yes, but show it separately from the full supplier cost. The agreed cost tells you the commitment; the paid column records what has already left your account; the remaining balance shows what is still due. This prevents a deposit from making a large supplier bill look smaller than it is.

How much contingency should I put in the spreadsheet?
There is no universally suitable amount. It depends on how complete your quotes are, how much flexibility you have and what you can afford to reserve. Add a visible contingency line, choose an amount that fits your circumstances and avoid treating it as money already available for optional upgrades.

Can I share the wedding budget with family or suppliers?
You can share an online workbook or send a copy, but consider what information it contains. Family members involved in planning may need access to the budget; suppliers usually need only the details relevant to their own booking. Restrict access and avoid storing bank credentials or full payment-card details in the file.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.