How to make a wedding budget spreadsheet

Seven steps, about twenty minutes, and a budget that counts itself.

Updated 18 October 2026 · You & Evermore

Prefer a spreadsheet? Our Wedding Budget Spreadsheet works in Google Sheets and Excel (on Etsy).

Rather not build it? Get our free UK budget spreadsheet.

  1. Agree the total first. Type it in one cell at the top and name it Budget. Every formula can then point to it.
  2. Add your categories. Venue, food and drink, ceremony, suppliers, outfits and rings, stationery and extras, insurance, buffer. A drop-down (Data > Data validation) keeps them consistent.
  3. One row per cost. Keep a row for each thing you will pay for, not each supplier. The venue might have hire, food and drinks on separate rows.
  4. Three money columns. Planned, Quoted, Paid. Never overwrite the plan with the quote; the gap tells you where you overspent.
  5. Work out what is left. Cost is the quote if there is one, otherwise the plan. Left to pay is cost minus paid.
  6. Add due dates. Add a column for the next payment's date. A rule turns it red when the date has passed and the line is unpaid.
  7. Share it. In Google Sheets: Share, add your partner as an editor. In Excel: save to OneDrive, then Share.

Useful extras

Protect the big payments

Pay at least part of any large deposit directly on a credit card where you can. Under Section 75 of the Consumer Credit Act, the card company can be jointly liable. It applies if a supplier fails. The single item or service must cost over £100 and up to £30,000. See our Section 75 guide.

Or skip the build: our UK Wedding Planner Spreadsheet has all of this. It links to guests, seating and a dated checklist.

The formulas, written out

Say Planned is column E, Quoted column F, Paid column G and Due date column J. Start on row 2. Then:

Copy each formula down the column and it adjusts for every row.

Making overdue payments stand out

Select the Due date column and add a conditional formatting rule. In Sheets it is Format > Conditional formatting; in Excel, Home > Conditional Formatting. Use a custom formula like =AND(J2<TODAY(),I2>0). A date in the past with money still owed then turns red. A second amber rule for dates in the next 30 days gives you a month's warning.

Mistakes worth avoiding

When to stop building

A wedding budget does not need macros or pivot tables. It needs the total, what is paid, what is left and what is due next. Then it is finished.

Sources

Rules change; always confirm with your card provider.

Questions

What formula works out what is left to pay?

Cost minus paid, where cost is the quote if you have one, otherwise the planned figure.

How many categories should a wedding budget have?

Six to eight is plenty. Venue, food and drink, ceremony and suppliers. Outfits and rings, stationery and extras, insurance and a buffer.

How do I flag overdue wedding payments?

Add a conditional formatting rule to the due date. It turns red when the date is before today and money is still owed.

The whole wedding in one spreadsheet

Our UK Wedding Planner Spreadsheet has the budget, payments, guests, seating and 39 dated tasks. It works in Google Sheets and Excel. Launch sale: 35% off until 1 December.

UK Wedding Planner Spreadsheet, £12.31 on EtsyPrefer Notion? Budget Planner, £7.02 on Etsy

Related guides

Free UK wedding budget spreadsheetDeposits and balancesA wedding planning spreadsheet, filled in