HiddenA wedding is a project with a hard deadline, a fixed budget and dozens of people who each need a different piece of information. The details are what take the time: who has replied, who eats what, what is paid and what is still due. A spreadsheet is a good place to keep them, because every number is visible and the sums are done for you. This guide shows how to set up the main parts, with the arithmetic.
Start with three numbers
Before any booking, fix three numbers: the date (or a range of possible dates), the total budget, and a guest count you can live with. Each affects the others. The date decides which venues and vendors are free, the budget decides what you can ask for, and the guest count decides the cost of food, drink and space. Write them at the top of the plan, and revisit them when something changes.
The budget
List every cost on its own line, grouped by category, with three columns of money: the estimate, what you have paid (deposits) and the balance due. Add the date by which each balance must be paid.
Here is a worked example with made-up numbers. The total budget is EUR 12,000, and the guest list is 80.
| Item | Estimate | Deposit paid | Balance due |
|---|---|---|---|
| Venue | EUR 3,500 | EUR 1,000 | EUR 2,500 |
| Catering, 80 guests at EUR 70 | EUR 5,600 | EUR 800 | EUR 4,800 |
| Photographer | EUR 1,800 | EUR 500 | EUR 1,300 |
| Music | EUR 900 | none | EUR 900 |
| Attire | EUR 1,200 | none | EUR 1,200 |
| Flowers | EUR 600 | none | EUR 600 |
| Other | EUR 400 | none | EUR 400 |
| Total | EUR 14,000 | EUR 2,300 | EUR 11,700 |
The estimates add up to EUR 14,000, which is EUR 2,000 over the EUR 12,000 budget. It is much better to see that now than after the deposits. Some levers: catering costs EUR 70 per guest, so 10 fewer guests cut EUR 700 from that line, while the venue and photographer costs do not change. A cheaper date or a smaller venue may save more. A budget sheet should highlight lines over budget and show the projected total, and it should stay up to date as the real prices come in.
Buehler, Griffin and Ross (1994) found that people tend to underestimate the time their own tasks will take. Their paper is about time, not money, but cost estimates for a first-time project often fail in the same way. Add a contingency line, and check your estimates against real quotes as soon as you get them.
The guest list
A guest list is a table with one row per guest: name, side (for example, whose family or friends), group, RSVP status, meal choice, dietary notes and gifts received. Send invitations with a reply-by date, and record each answer as it comes.
Two counts matter. The first is the headcount: say you invited 100, 60 said yes, 12 said no and 28 have not answered. Those 28 need a phone call, and until you know, you cannot give the caterer a final number. The second is the meal count: of the 60, perhaps 30 chose chicken, 20 vegetarian and 10 fish, and a few have allergies. Caterers usually want these figures by a date, so write it in.
A spreadsheet can count them for you with formulas that tally the statuses and the meal choices, so you do not recount the list by hand every time someone replies.
The seating plan
Seating is a puzzle with constraints: each table has a capacity, and some guests need to be together or apart. Work it out in this order.
- Count the tables. Divide the confirmed guests by the seats per table, and round up. For 84 guests at tables of 8, that is 10.5, so 11 tables. Or ten tables of 8 and one smaller table of 4, if the room allows.
- Check capacity. A plan that puts nine people at a table of eight should show a warning at once.
- Place anchors first. Seat the couple, the families and the guests with fixed needs (a wheelchair user, someone who must be near the door).
- Fill in the rest by groups, and leave a seat or two free for last-minute changes.
A sheet that lists the guests at each table automatically spares you from copying names between lists, and the table list can go to the venue.
The checklist
A wedding has dozens of tasks, from booking the venue to confirming the final numbers. The useful way to date them is relative to the wedding. A task that must be done six months before the wedding is due on a date you can calculate. For a wedding on 12 June 2027, a task due six months ahead falls on 12 December 2026. If the wedding date moves, every date moves with it, and you do not edit dozens of cells by hand.
Group tasks by time: a year or more before, six to nine months, three to six months, the last month, the last week and the day itself. Put the day-of timeline on one page for the people who help: when the hair and make-up start, when the car comes, when the music begins, and who has the rings.
Vendors and payments
Keep one list of vendors with contact name, phone, email, what was agreed and the contract date. Next to it, a payment schedule lists each payment with its due date, amount and whether it is paid. Overdue payments should stand out, because a missed payment can cost a booking. Check each contract for cancellation and refund terms, which differ by vendor and country, and keep a copy.
Keeping the sheet reliable
A wedding workbook is a spreadsheet, and spreadsheets have errors. Powell, Baker and Lawson (2008) reviewed research on spreadsheet errors and found that errors are common in spreadsheets generally. Check the budget total by hand against your quotes once, and check that the guest count in the plan equals the count in your list. When a total looks too good, look for a missing line.
Printing and sharing
Some people like paper for the day itself: a checklist on the table and a seating chart on an easel. Print them in your paper size. For sharing with a planner or family, send a PDF, not the working file, so that no one changes a formula by accident.
Tool that fits
The Wedding Planner Spreadsheet (Excel, EUR 17, paid once) has 10 sheets. A dashboard shows days to go, projected spend, RSVPs, meal counts, next tasks and three charts. The budget works by line item and category with deposits, balance due and over-budget highlighting. The guest list holds up to 400 guests with side, group, RSVP, meal choice, dietary notes and gifts. The seating plan checks table capacity and lists the guests at each table automatically. A 93-task checklist recalculates its due dates when you change the wedding date. There are vendor contacts, a payment schedule with overdue warnings and a day-of timeline, plus a printable checklist and a round-table seating chart as PDFs in A4 and US Letter. It works in Excel 2016 and later, Google Sheets and LibreOffice, but Apple Numbers is not supported. Budget figures are your own estimates for planning. It is not financial advice.
What to do next
The Wedding Planner workbook has a budget with deposits, a guest list for up to 400 guests, a seating plan that checks table capacity, a 93-task checklist, vendor payments and a day-of timeline, plus printable checklist and seating PDFs. €17 once.
Questions people ask
How do I keep a wedding budget under control?
Set the total first, list every cost with an estimate, and record deposits and balances as you pay. Compare the estimates with your total early, because the biggest items, usually the venue and catering, are decided first. Catering often scales with the guest count, so the guest list is part of the budget.
How many tables do I need for my guests?
Divide the number of guests by the seats per table and round up. For 84 guests and tables of 8, that is 10.5, so you need 11 tables, or you could use some larger tables. Check the capacity of the room and of each table before you assign seats.
Should I plan a wedding in a spreadsheet or an app?
A spreadsheet suits a couple who want to see everything and keep control of the numbers, and it works offline. An app or a planner may suit you better if you need shared real-time editing, guest-facing websites or vendor marketplaces. Many couples use both.
Sources
- Buehler, Griffin and Ross (1994), Exploring the planning fallacy: why people underestimate their task completion times, Journal of Personality and Social Psychology 67(3), 366-381
- Powell, Baker and Lawson (2008), A critical review of the literature on spreadsheet errors, Decision Support Systems 46(1), 128-138
- HiddenWay worked example: our own arithmetic, assumptions listed in the text
We checked each source on 17 October 2026. If a fact here is out of date, tell us at hello@hiddenway.info.