Wedding Budget Spreadsheet Template for Excel and Google Sheets

Start by working out what you can actually afford. Sit down with your partner and any family who are contributing. Be honest about savings, monthly income, and what you are willing to borrow. A realistic budget is one you can pay off without debt hanging over your first year of marriage.

Think about your priorities. Do you care most about the food, the music, or the photographs? Put your money where your joy is. If you both love dancing, spend more on the band and less on flowers. If you want a long guest list, choose a simpler menu. There is no right or wrong split, only what feels right for you.

Remember that the total cost is not just the venue and catering. You will also need to cover legal fees for giving notice, registrar fees, marriage certificates, rings, outfits, hair and make-up, transport, stationery, and small extras like thank-you cards. Add a contingency fund of about five to ten percent of your total budget for forgotten items or price rises. This is a buffer, not a target.

Your spreadsheet should have one row for every item you plan to buy or book. Common categories include venue, catering, drinks, cake, photographer, videographer, music, flowers, decorations, outfits, rings, hair and make-up, transport, stationery, gifts, favours, legal fees, and insurance.

Create columns for the item name, category, estimated cost, actual cost, deposit paid, balance due, due date, supplier, and notes. A notes column is useful for recording contact details, payment reference numbers, and any special requests.

Add a section for income. List who is contributing and how much, including your own savings. This helps you see at a glance whether your total estimated costs match your total available money. If they do not, adjust your estimates before you book anything.

Open a new workbook and create two sheets. Name the first one "Budget" and the second one "Income". On the Budget sheet, set up your column headers in row one: Item, Category, Estimated Cost, Actual Cost, Deposit Paid, Balance Due, Due Date, Supplier, Notes.

In the Category column, use a consistent list of categories, such as Venue, Catering, Photography, Music, Attire, Beauty, Transport, Stationery, Legal, and Other. You can type these yourself or use data validation to create a dropdown list. In Google Sheets, select the category cells, click Data, then Data validation, and add your list. In Excel, use Data, then Data Validation, and choose List.

For the formulas, you want a total row at the bottom. In the Estimated Cost column, use =SUM(D2:D100) if that is where your estimates sit. Adjust the range to match your rows. Do the same for Actual Cost, Deposit Paid, and Balance Due. Add a formula for the remaining balance: =SUM(Estimated Cost range) - SUM(Actual Cost range). This shows you what is still to pay.

On the Income sheet, list each contributor and amount. Total the income with =SUM(B2:B20). Then on the Budget sheet, add a cell that references the total income, for example =Income!B21. Compare this with your total estimated cost. If the estimated cost is higher, you know to trim somewhere.

Update the spreadsheet the moment you pay anything. Do not wait until the end of the month. Enter the deposit when you book a supplier, then enter the balance when you pay it. This keeps your Actual Cost column accurate.

Use the Due Date column to plan your cash flow. Sort the sheet by due date every few weeks. This tells you which payments are coming up and whether you have enough in your bank account. You can also set reminders in your phone for each due date.

Keep a separate column for "Paid?" with a simple yes or no. You can also use conditional formatting to highlight overdue payments. In Google Sheets, select the Due Date column, click Format, then Conditional formatting, and set a rule for dates before today. In Excel, use Home, then Conditional Formatting, and choose Highlight Cell Rules.

Review your spreadsheet every two weeks. Compare estimated costs with actual costs for items you have booked. If you spent more on the photographer than planned, decide where to save. You might choose a cheaper cake, or skip the printed order of service booklets.

Be realistic about what things cost in the UK. Venue and catering usually take the largest share, but there is no fixed percentage that works for everyone. The key is to agree on your own priorities and stick to them. If you are unsure about a typical breakdown, ask suppliers for quotes and compare them side by side in your spreadsheet.

Remember that legal fees and registrar costs are fixed and non-negotiable. Check the current fees on GOV.UK or at your local register office. These can change, so always confirm before you finalise your budget.

Share the spreadsheet with your partner so you both see the same numbers. In Google Sheets, click Share and add their email. In Excel, save it to a shared drive or use the co-authoring feature. Decide who is responsible for updating which categories, so nothing is missed.

If family members are contributing, you can share a read-only version with them. This helps them see how their gift is being used without giving them editing access. You can also use the notes column to record any conditions attached to a contribution, such as "for the bar only".

Use the spreadsheet as a planning tool, not a source of stress. If a category goes over, adjust another. The goal is to have a clear picture of your spending, not to create a perfect plan that never changes.

Set aside a small emergency fund in your spreadsheet, separate from the contingency. This is for last-minute items like extra drinks or a taxi. Do not dip into it unless you really need to.

When you are close to the wedding, stop adding new items. If you have not booked it by the month before, it is probably not essential. Stick to your original plan and your original estimates.

After the wedding, close the spreadsheet. Add any final costs, then total everything. This gives you a clear record of what you spent. Keep the file as a reference for your own future advice to friends, and as proof of payment if you need it for insurance or disputes.