← Back to blog

How to plan your event business year in one spreadsheet

Planning the year of an event business means putting four things in a single spreadsheet: when your events happen, when they get sold, when you rest and when you change your prices. Almost nobody does it. Most people live the year backwards: they find out peak season is coming when it’s already on top of them, and discover the slow month is slow when there’s nothing left to do about it.

I suggest building it once, in an afternoon, and reviewing it every month.

The spreadsheet: twelve rows and six columns

You don’t need any system. A spreadsheet with one row per month and these columns is enough:

  • Month.
  • Which events happen. The ones you do that month: weddings, birthdays, year-end parties, company events, graduations, whatever your field is.
  • What I sell. This is the column almost everyone forgets. What you do in a month isn’t the same as what you need to be selling that month.
  • What I expect to bill. An estimate, taken from what you billed in that same month last year.
  • Price. Whether the usual price list applies that month, a new list or a surcharge for a peak date.
  • Rest and internal tasks. Vacation, maintenance, new photos, sorting out the numbers.

Fill in what already happened first. If you have last year’s events written down, copy them month by month. If you don’t, pull them from your phone calendar, your chats with clients or your invoices. That real picture is worth more than any imagined plan.

Mark your seasons, not the industry’s

Every event business has its own year. A kids’ party venue, a wedding caterer and a corporate event company have peaks in different months. That’s why copying someone else’s calendar doesn’t work.

With the events column filled in, color each month with one of three colors:

  • Peak: months when you lack capacity and turn work down.
  • Normal: months when you work at a steady pace.
  • Slow: months with plenty of free dates.

If you want to go deeper on the busy end, I’ve written about how to get through peak season without burning out. What matters here is seeing both ends together on one sheet, because what you do in one shapes how the other goes.

Peak dates come first

Within each season there are specific dates that sell themselves: Saturdays in wedding months, the weeks of company year-end parties, long holiday weekends if you work with tourism, the end of the school year if you do graduations. Write them down by name in the spreadsheet.

Those dates are your scarcest resource. They can only be sold once. Two simple rules:

  1. Don’t give them away with discounts. A peak date sold at a discount is money left on the table.
  2. Decide in advance what type of event you want on each one. If a peak Saturday gets taken by a small event because it came first, then the big one arrives and you have no room.

When to sell each type of event

Each type of event is decided with a different lead time. A wedding usually books much further ahead than a birthday, and a company year-end party gets decided in a short window before the year ends. I won’t give you exact months, because they change with your field, your city and your client: take them from your own data.

How: for each event last year, write down the date the client first contacted you and the date of the event. The difference is your real lead time. With that you fill in the What I sell column: if your weddings for a given month were booked several months earlier, in those earlier months you need to be showing weddings, replying fast and doing site visits.

That gap explains many slow months: they aren’t slow because there are no events, but because nobody sold in time the events that should have landed there.

When to raise prices

Raising prices in the middle of a negotiation is awkward. Raising them on a date you’d already marked in the spreadsheet is part of the business. Some ideas for choosing the moment:

  • Before the selling window for your peak season opens. If peak events are sold well ahead, the new price has to be ready before inquiries come in, not after you’ve done the site visits.
  • At the turn of the year. It’s when clients expect prices to be updated.
  • When your costs change. If your suppliers raise their prices, review your list that same month.

And always honor what you’ve already quoted: if you sent a price with a validity date, that price holds until that date.

When to rest

Rest goes in the spreadsheet too, with a date. If you don’t write it down, the first client who asks for exactly that weekend will eat it.

Choose your rest by looking at the colors: the best moment is usually after peak season and before selling for the next one begins. Block it in your calendar as if it were a confirmed event. Tell your team and your suppliers well ahead.

In slow months, also mark the internal tasks that always get pushed back: taking new photos of your events, updating your Google Business profile, sorting your client list, reviewing the year’s numbers.

Review it once a month

The spreadsheet is useless if you build it in January and never open it again. Once a month, half an hour:

  • Write down what you actually billed next to what you expected.
  • Look at what you need to be selling now for the coming months.
  • Confirm that the rest dates and price-change dates still stand.

With a full year of data, by the second year the spreadsheet is no longer an estimate: it’s your business on one sheet.

If you want to do it with someone next to you

Building this calendar is part of what I do with event business owners: in the first month we get the full picture of the business and a 90-day plan, and then we go out to sell on that base. If you don’t know where to start, message me on WhatsApp and we’ll look at where your business stands today.

Frequently asked questions

What do I do if I have no data from last year?

Start anyway. Fill in the spreadsheet with what you remember and mark the estimates in a different color. From this month on, log every inquiry with its date and every booked event. In a year you’ll have your own numbers.

Spreadsheet or system?

Spreadsheet. If you use it every month and it becomes too small, only then does it make sense to think about a system.

Should I lower prices in the slow season?

Not necessarily. Before lowering your price, try selling a different type of event or a smaller format for those months. Lowering a price is easy; raising it again isn’t.

Message me on WhatsApp