How to build a wedding budget spreadsheet that actually works

Planning a wedding budget is rarely the most romantic part of getting engaged. It is a conversation about money, priorities, and compromise. But getting it right from the start is the single most effective thing you can do to ensure the planning process is enjoyable rather than stressful. A well-constructed spreadsheet is not just a list of numbers. It is a financial road map for one of the most significant events of your life.

The aim is not to restrict you, but to give you control. A clear budget allows you to spend money confidently on the things that matter most to you, whether that is exceptional food, a specific photographer, or a live band that will keep everyone dancing until midnight. This guide will show you how to create a budget spreadsheet that is practical, detailed, and genuinely useful from your first booking to your final payment.

First, A Reality Check on UK Wedding Costs

Before you open a blank spreadsheet, it is important to understand the current financial landscape of UK weddings. The average cost is now approaching £30,000, a figure that can seem daunting. This is not about suppliers adding a "wedding tax". It is a reflection of the cost of skilled labour, high-quality ingredients, insurance, and the simple fact that a wedding is a large, logistically complex event that requires a huge team of professionals.

Costs also vary dramatically by location. A marquee wedding on private land in rural Northumberland will have a completely different cost structure to an all-inclusive package at a hotel like Heckfield Place in Hampshire. A London wedding, with its higher venue and supplier fees, will almost always command a premium. Understanding these regional differences and the basic costs of key suppliers is the first step toward building a realistic budget that aligns with your expectations.

The Big Three: Venue, Food, and Drink

For almost every wedding, three categories will consume the largest portion of your budget: the venue, the catering, and the drinks. Expect these to account for at least 50% of your total spend. Getting a clear picture of these costs early on is essential, as they will dictate how much you have left for everything else. For example, a dry-hire barn venue in the Cotswolds might cost £10,000 for a weekend rental in 2026. This gives you a blank canvas, but you are responsible for everything else.

Catering for 100 guests is a significant expense. A realistic per-head cost for canapés, a three-course meal, and evening food is between £110 and £150. For 100 guests, that is an immediate £11,000 to £15,000. Add a drinks package or a bar tab, which could easily be another £5,000. Suddenly, you have allocated £26,000 before even considering a photographer, flowers, or entertainment. These are the foundational numbers your entire budget will be built upon.

Building Your Spreadsheet: A Step-by-Step Guide

Your spreadsheet will become the central source of truth for your wedding finances. It will track your spending, manage your payment deadlines, and help you make informed decisions. Google Sheets is an excellent choice as it allows you and your partner to collaborate in real-time.

1. Create Your Columns. A functional spreadsheet needs more than just a list of items and costs. Start with these columns: Category (e.g., Photography), Item (e.g., 10 hours coverage), Estimated Cost, Quote 1, Quote 2, Actual Cost, Deposit Paid, Balance Due, Due Date, Paid (Y/N), and Notes. This structure provides a complete overview of each expense.

1. List Every Possible Expense. Brainstorm every single thing you might need to pay for. Go beyond the obvious. Include the marriage notice fee (currently £35 per person in England and Wales), postage for invitations, supplier meals on the day, thank you gifts, and any potential corkage fees, which can be £20 or more per bottle at some venues.

1. Research and Get Quotes. Begin filling in the 'Estimated Cost' column based on initial research. Then, contact suppliers for actual quotes. Aim for two to three quotes for major expenses like catering and photography. A good London-based photographer in 2026 will likely cost between £3,000 and £5,000. A florist providing bouquets, buttonholes, and table arrangements for 10 tables might quote around £3,500.

1. Allocate Your Total Budget. Enter your total wedding budget at the top of the sheet. As you populate the 'Estimated Cost' column, a simple SUM formula will show you a running total. This is often the moment of truth, where you see if your initial estimates align with your total budget. Be prepared to adjust.

1. Track Every Payment. As soon as you book a supplier and pay a deposit, update the 'Actual Cost', 'Deposit Paid', and 'Balance Due' columns. Record the payment date in the 'Notes' column. This transforms your spreadsheet from a planning document into a live accounting tool, preventing missed payments and financial confusion.

1. Include a Contingency Fund. No budget is perfect. Unforeseen costs will appear. A dress might need more complex alterations, or you may need to hire heaters for a marquee at the last minute. Allocate 10-15% of your total budget to a contingency fund. For a £40,000 wedding, that is a £4,000 to £6,000 safety net. Do not touch this fund for upgrades; it is for genuine emergencies only.

A Sample Budget for a £35,000 Wedding

To make this more concrete, here is a potential breakdown for a wedding with 90 guests. This is just an example. Your priorities will determine where you choose to spend more or less.

| Category | Item | Estimated Cost | | :--- | :--- | :--- | | Venue | Dry-hire barn, weekend hire (Sussex) | £8,500 | | Catering | Canapés, 3 courses, evening food for 90 | £10,800 | | Drinks | Welcome drinks, wine for dinner, toast | £4,000 | | Photography | 8 hours coverage, one photographer | £2,800 | | Attire | Dress, suit, alterations | £2,500 | | Floristry | Bridal party, ceremony, 9 tables | £2,200 | | Entertainment | Evening DJ, 5 hours | £1,000 | | Cake | 3-tier cake | £600 | | Stationery | Invitations, postage, on-the-day items | £800 | | Contingency | Approx. 5% | £1,800 | | Total | | £35,000 |

This breakdown illustrates how quickly the core costs add up. It also shows that even with a substantial budget, choices must be made. For instance, this budget includes a DJ rather than a more expensive live band, and the contingency is on the lower side.

The Hidden Costs You Must Not Forget

A common reason budgets fail is the collection of small, un-tracked costs that add up over time. Some of the most frequently overlooked expenses are critical to account for in your spreadsheet from day one. Always ask suppliers if their quotes are inclusive of VAT, as the extra 20% can be a nasty surprise on a large invoice.

Supplier expenses are another area to watch. If your photographer is travelling from Manchester to your venue in the Lake District, their quote will likely include mileage and possibly an overnight stay. The same applies to bands and videographers. Wedding insurance is a non-negotiable expense. For a few hundred pounds, it protects you from supplier bankruptcy or other major issues. Finally, remember details like dress alterations, which can cost £300-£700, and on-the-day stationery like menus and place cards, which can add another several hundred pounds to your stationery budget.

FAQ

How much should we set aside for a contingency fund? A minimum of 10% of your total budget is the standard advice. For a £30,000 wedding, this is £3,000. If you are planning a marquee wedding or anything with complex logistics, aiming for 15% is safer. This fund is for unexpected problems, not for upgrading your wine selection.

Who is expected to pay for the wedding? Traditional payment structures, where the bride's family covers the cost, are now very rare. The vast majority of couples pay for their own wedding, often with contributions from both sets of parents. The most important thing is to have an open conversation with your families early on to understand if they wish to contribute, and if so, how much.

Is hiring a wedding planner worth the cost? A full-service wedding planner typically charges 10-15% of your wedding budget. For a £40,000 wedding, this could be a £4,000 to £6,000 fee. In return, you get their expertise, supplier connections, and logistical management. A good planner can often save you money through their network and by preventing costly mistakes, making them a worthwhile investment for time-poor couples or those planning a complex event.

What are the most effective ways to reduce our budget? The fastest way to reduce costs is to reduce your guest list. Each guest adds £100-£150 in food and drink alone. Second, consider an off-season or mid-week wedding date. A venue might offer a 20% discount for a Thursday wedding compared to a Saturday. Finally, look at your 'Big Three'. A venue that lets you supply your own alcohol (even with a corkage fee) can be significantly cheaper than one with a fixed bar package.

Should we use a credit card for wedding payments? Where possible, yes. Paying for any single item over £100 on a credit card gives you protection under Section 75 of the Consumer Credit Act. This means if a supplier goes out of business before your wedding, you can claim the money back from your credit card company. Be sure to pay off the balance in full each month to avoid incurring interest.

---

Once your budget is set, you can find vendors who fit your financial plan by using the search filters on shortlist.wedding to see suppliers within your specific price point.