Event cost spreadsheet: which columns to include and how to use it
An event cost spreadsheet needs few columns, but well chosen: what each expense is, whether it’s fixed or depends on the number of guests, how much you estimated, how much you actually paid and the difference. On top of that go contingency, margin and the final price. If you build it once and use it for every event, it stops being a piece of paper for the quote and becomes the tool that tells you what to quote better next time.
One sheet per event, not one calculation at the end of the month
To know whether the business makes money you have to look at the month, and that’s explained in how to know whether your event business makes money. But the month is made of events, and each event has its own math. If you mix everything into one sheet, you won’t see which party made you money and which one ate your margin.
The rule is simple: one sheet (or one tab) per event, always with the same columns. That way, after ten events, you can compare them with each other.
The columns it needs
One row per expense, with these columns:
- Item. What it is: catering, sound, servers, freight, decor.
- Category. The group it belongs to (see below). Useful for adding up by block.
- Type. Fixed or variable. Fixed is what you pay the same with 80 or 120 guests, like sound. Variable is what changes with headcount, like food.
- Quantity. People, hours, trips or units.
- Unit price. What the vendor charges you for each one.
- Budgeted. Quantity times unit price, what you calculated when quoting.
- Actual. What you ended up paying. Filled in after the event.
- Difference. Actual minus budgeted. If it’s positive, you spent more than planned.
- Vendor. Who you hired it from.
- Paid. Deposit, balance or pending. It organizes your payments in the week of the event.
That’s enough. If you add twenty more columns, by the third event you’ll stop filling it in.
The cost blocks
Group the rows into blocks so nothing gets lost:
- Per-guest variables. Food, drinks, rented tableware, favors. Everything that multiplies by headcount.
- Event fixed costs. Sound, lighting, decor, venue rental if it isn’t yours. What you pay the same even if guests don’t show.
- Staff. Servers, bar, security, coordination, setup and teardown. With real hours, including those before and after the party.
- Freight and transport. Equipment there and back, staff taxis in the early hours, travel expenses if the event is far. It’s the block people forget most.
- Share of monthly costs. Phone, tools, advertising, accountant. Spread the month’s total across the events you do and add that share to each one.
- Your work. Hours of meetings, visits and coordination. If you don’t count them as a cost, you’re giving them away.
Contingency, margin and final price
Below the blocks go three lines:
- Cost subtotal. The sum of everything above.
- Contingency. A percentage of the subtotal for what always comes up: a vendor who drops out, an extra hour, five guests who weren’t on the list. Choose the percentage based on your experience and adjust it with what the spreadsheet shows you.
- Final price. This is where the most common mistake happens.
If you want to keep 30% of what you charge, adding 30% to the cost isn’t enough. If the cost is 100 and you add 30, you charge 130 and keep 30, which is 23% of the price, not 30%. The correct math is to divide the cost by what’s left after subtracting the margin: cost divided by 0.70. With a cost of 100, the price is 143 and you keep 43, which really is 30% of 143.
Taxes are separate, depending on your situation: ask your accountant how much of what you bill goes to taxes and add it afterwards. The step by step for getting to the number is in how to price your event services.
An example with round numbers
This is an illustrative example, with made-up round numbers to show the logic. They aren’t market prices: your numbers will be different.
A party for 100 guests, budgeted:
- Catering: 100 × 100 = 10,000
- Drinks: 100 × 30 = 3,000
- Sound and lighting: 4,000
- Decor: 2,000
- Staff: 6 people × 500 = 3,000
- Freight: 1,000
- Share of monthly costs: 1,000
- Subtotal: 24,000
- Contingency (5%): 1,200
- Total cost: 25,200
- Final price with a 30% margin: 25,200 divided by 0.70 = 36,000
- Kept: 10,800
After the event you fill in the actual column:
- Catering: 105 people came, 10,500 (difference +500)
- Staff: one extra hour for the whole team, 3,600 (difference +600)
- Freight: one more trip to fetch equipment, 1,500 (difference +500)
- Everything else, as budgeted.
Actual cost: 25,600. You charged 36,000, so you kept 10,400. The differences added up to 1,600 and contingency was 1,200: the missing 400 came out of your margin.
Comparing budgeted against actual
That example shows what the spreadsheet is for. The differences aren’t bad luck: they’re information.
- Five extra guests tell you that you need a price per additional guest in the quote, and a deadline for closing the list.
- The extra hour tells you that you need to charge for it, written into your terms, instead of absorbing it.
- The extra freight tells you that you’re quoting it short, or that loading needs better planning.
Two rules to make it work: close the spreadsheet in the week of the event, while you still remember every taxi, and look at the difference column every three or four events. If a category always runs over, the problem is in how you quote it.
When the spreadsheet isn’t enough anymore
The spreadsheet works very well while you use it alone and do few events a month. It stops being enough when several people touch it and overwrite each other, when the same data gets entered in three places (quote, spreadsheet, messages with vendors) or when you spend time copying numbers instead of selling.
At that point it makes sense to move to a custom system: users with permissions, a database instead of loose spreadsheets, and reports that build themselves. It starts from USD 2,500 and takes 4 to 6 weeks, with a written quote before starting. You don’t need it to begin: spreadsheet first.
Frequently asked questions
Should I use Excel or Google Sheets?
Whichever you already know how to use. Google Sheets has the advantage that you can open it from your phone on the event day and share it with whoever is helping you.
What contingency percentage should I use?
There’s no number that works for everyone. Start small and watch the difference column: if you go over at every event, raise it; if you never use it, you may be overcharging.
Do I show the spreadsheet to the client?
No. You send the client a clear price with what’s included and what isn’t. The spreadsheet is yours: it has your costs and your margin.
Building it with someone next to you
If you do events every month and have never compared budgeted against actual, that’s where the money slips away. We can build prices with a real margin together, and the cost and price spreadsheet can be delivered finished and ready to use. Message me on WhatsApp and we’ll look at it.
