AI is good at the structure of event paperwork and poor at the numbers. Give a chat assistant your brief (guest count, venue, format, fixed times) and it will draft every budget line and a timed run sheet in minutes. Then enter real supplier quotes in a spreadsheet where formulas do the maths, and ask the AI to stress-test the timings.
What follows is a budget layout that separates guesses from quotes, a run-sheet format suppliers can follow on a phone, four prompts to copy, and a checking routine. One caveat first: an assistant doesn't know what your caterer charges or how long your AV crew needs to rig, so any figure it volunteers is a placeholder until a supplier confirms it.
What AI gets right on budgets and run sheets, and where it guesses
The value is completeness and speed of layout. Ask for a budget for a 150-guest awards dinner and a decent assistant will remember the lines planners forget under pressure: crew meals, cloakroom staff, security, generator fuel, lectern hire, printed table plans, overtime if the curfew slips, card-payment fees on the final invoice. Ask for a run sheet and it will lay out arrivals, service, speeches and load-out in a consistent format in under a minute.
The weaknesses are just as predictable:
- Prices. It produces plausible figures from general web text. They are not your market, your suppliers or this year.
- Arithmetic inside the chat. Language models predict text. Long columns of sums and percentage uplifts can come out wrong while looking tidy, so totals belong in spreadsheet formulas. There's more on the reason in why AI is bad at maths.
- Physical timings. Load-in through a single goods lift, the walk from a ceremony lawn to a marquee, a band's line check: the assistant can only guess unless you give it the numbers.
- Venue rules. Curfews, noise limits, access windows and preferred-supplier lists live in the venue contract, not in the model.
So the working method is simple. AI drafts the shape, you supply the facts, formulas do the sums, and AI checks the result for gaps.
Stage 1: turn the brief into a budget skeleton (about 15 minutes)
Start with the brief in writing, even if it's rough notes from a call. The more constraints you include, the fewer invented lines you'll delete later. This prompt works in ChatGPT, Claude or Gemini:
You are helping an event planner build a budget skeleton.
Event: [type, e.g. client appreciation evening]
Date and hours: [date, start, finish, venue curfew]
Guests: [number], including [speakers, VIPs, children, dietary notes]
Venue: [type], and what the venue includes: [tables, chairs, AV, staff]
Client budget: [total or range], and whether it includes our fee
Must-haves: [list] Not needed: [list]
Produce a budget table with these columns:
Category | Line item | Unit | Quantity | What drives the cost
Group lines under: Venue, Food and drink, Staffing, Production and AV,
Decor and print, Entertainment, Logistics, Contingency, Planner fee.
Do NOT enter any prices.
Where a line depends on a decision the client hasn't made,
write DECISION NEEDED in the last column.
Finish with a list of lines people often forget for this event type.An illustrative slice of what comes back for a client appreciation evening where the brief said "Not needed: live music":
Category Line item Unit Qty What drives the cost
Staffing Cloakroom attendant hours 2x5 Guest count, weather
Staffing Crew meals meals 14 Supplier headcount
Entertainment DJ and sound system event 1 DECISION NEEDED
Logistics Marquee heating days 1 Outdoor space, season
Contingency Contingency % total 1 Venue familiarity
Often forgotten: crew meals, card-payment fees, printed table plan,
overtime if the curfew slips, lectern hireTwo lines to delete and one to thank it for. The DJ contradicts the brief (it read "live music" narrowly and added recorded music instead, so ask the client rather than keeping or cutting it silently). The marquee heating is a stock line from outdoor events; this one is indoors. Crew meals, though, is exactly the line planners forget, and 14 meals for suppliers on a five-hour event is a real cost. Delete the misfits, keep the reminders, and the skeleton is ready for the sheet.
Telling it not to enter prices is deliberate. A skeleton with blanks invites you to fill them from quotes; a skeleton with made-up figures invites you to leave them there.
Stage 2: move it into a spreadsheet where formulas do the maths
Paste the table into Excel or Google Sheets and add the columns that make a budget trustworthy. This is the layout I'd use:
| Column | What goes in it | Why it matters |
|---|---|---|
| Supplier | Named supplier or TBC | Shows at a glance which lines are still open |
| Quote reference | Quote number and date | Finds the source in seconds when the client queries a line |
| Unit cost | From the quote, never from the chat | The only place a price is typed |
| Quantity | Guests, hours, items | Drives the formula |
| Cost | Unit cost multiplied by quantity | Always a formula, never typed |
| Status | Estimate, Quoted, Contracted or Paid | Separates guesses from commitments |
| Client price | Cost plus margin, or cost if you charge a flat fee | Keeps your markup visible to you and hidden from the client version |
| Deposit due and balance due | Dates | Feeds your payment reminders |
If you're on Microsoft 365 with Copilot, or Google Workspace with Gemini, the assistant inside the sheet can write the formulas: ask it to add a Cost column that multiplies Unit cost by Quantity and a total row that sums Cost by Category. Click into one result afterwards to confirm the formula points at the right columns.
The same assistants can read a supplier's quote PDF into rows, and this is where a quick sum pays for itself. Say an AV quote's price table lists a PA, two microphones and uplighting for a total of $2,100, and the extracted rows add up to exactly that. Page two, in smaller type, adds a technician at $95 an hour for six hours and a 10% charge for delivery and collection. The real figure is $2,100 plus $570 plus $210, or $2,880, and an extraction that stopped at the price table would have left $780 out of the budget. After every extraction, compare the total on your sheet with the final total printed on the quote, and ask the assistant "List every charge on this quote outside the main price table" as a second pass. What Copilot in Excel can and can't do and Gemini in Google Sheets cover the details for each.
Two rules keep the budget honest. Hold a contingency line (I'd keep 5-10% of the supplier total, more for outdoor events or a venue you haven't worked before) and don't spend it on upgrades. And add a per-head figure under the total, because clients compare per-head costs between events even when they don't say so.
Worked example: a letting agency's 20th-anniversary evening
These figures are illustrative. Say a letting agency asks a planner for a drinks-and-canapés evening for 110 landlords and staff, 18:30 to 22:30, with a budget of $18,000 including the planner's fee. The Stage 1 skeleton had 34 lines. The planner deleted five that didn't apply and added two the model missed: a second bar point, because the venue has two rooms, and a photographer. Once quotes arrived, the category totals looked like this:
| Category | Status | Cost |
|---|---|---|
| Venue hire, exclusive use for 5 hours | Contracted | $3,200 |
| Food and drink (canapés and drinks package, 110 at $63 a head) | Quoted | $6,930 |
| Extra bar staff and cloakroom | Quoted | $840 |
| Production and AV (PA, two microphones, uplighting) | Quoted | $1,650 |
| Decor, flowers and print | Estimate | $1,100 |
| Photographer, 4 hours | Quoted | $900 |
| Contingency, 7% of the lines above | Held | $1,023 |
| Planner fee | Contracted | $2,400 |
| Total | $18,043 ($164 a head) |
The sheet shows immediately that decor is the only line without a quote and that the total is $43 over. That's a conversation about decor, not about the whole budget. On the version the client sees, the estimate is labelled rather than hidden: "Decor, flowers and print: $1,100 (estimate from our last two evenings of this size; florist's quote due 14 March)". When the quote arrives at $1,240, the client reads a line moving as flagged, not a planner who got it wrong. When the planner asked the assistant for three ways to save $300 without guests noticing, it suggested moving the entrance flowers to the bars after arrivals, replacing printed menus with one welcome board, and using the venue's own uplighting. She checked the last idea with the venue before offering it, because the model had no way of knowing whether the venue owned any.
Stage 3: build the run sheet backwards from the fixed times
Most run sheets go wrong because they're written forwards from the start time, and every delay pushes everything after it. Write them backwards from the anchors that can't move: venue access, doors, the food service windows the caterer has committed to, speeches, curfew and the load-out deadline. Give the assistant those anchors plus your confirmed supplier timings, and make it fill the gaps.
Build a run sheet for the event below. Use 5-minute steps before
doors and during speeches, 15-minute steps elsewhere.
Fixed anchors (do not move these):
- Venue access from [time]; load-out complete by [time]
- Doors [time]; food service [times]; speeches [time]
- Music off / curfew [time]
Supplier timings I have confirmed:
- [Supplier]: arrives [time], needs [minutes] to set up, needs [power/access]
- ...
Columns: Time | Duration | What happens | Where | Owner | Cue | Notes
Rules:
- Leave at least 10 minutes of buffer before each anchor.
- Flag any point where one person owns two things at once, or a
supplier needs access before the venue opens.
- Do not invent supplier times. If one is missing, write MISSING.The Cue column is what makes a run sheet usable on the night. "19:40 speeches" is a hope; "Cue: third canapé round cleared and the MD has a drink" tells the AV engineer and the host when to actually start.
For a one-day conference the same method needs one more idea: a column per room. Say 200 delegates move between a main hall and three breakout rooms. Ask the assistant for the anchors (registration, keynote, lunch, close) and one column each for the hall and rooms A, B and C, so a glance down the sheet shows what every space is doing at 11:15. Then give it the changeover time you've actually walked. Two hundred people leaving one hall through one corridor rarely manage it in the five minutes a draft tends to allow; ten to fifteen is more realistic, and the difference comes out of the coffee break, which delegates notice.
Here's a slice of what that produced for the anniversary evening, after the planner's edits:
| Time | What happens | Where | Owner | Cue |
|---|---|---|---|---|
| 16:30 | AV load-in via rear door; PA and uplighting rig | Main room | AV lead | Venue manager opens rear door |
| 17:45 | Line check, both microphones | Main room | AV lead | Rig complete |
| 18:00 | Bars set, glassware checked | Both bars | Bar manager | Stock delivered and chilled |
| 18:15 | Ten-minute team briefing | Foyer | Planner | All suppliers on site |
| 18:30 | Doors and welcome drink | Foyer | Front of house | Planner's go |
| 19:40 | Speeches, 15 minutes | Main room | Planner and MD | Third canapé round cleared |
| 22:30 | Music off, bars close | Both rooms | Venue manager | Curfew |
| 23:15 | Load-out complete | All areas | AV lead and florist | Venue manager signs off |
Stage 4: stress-test the run sheet before anyone sees it
Open a fresh chat, so the assistant isn't defending its own draft, and paste in the finished run sheet with this:
You are a venue operations manager reviewing a run sheet the night
before an event. Be critical. List, with the time of each:
1. Any person or supplier in two places at once
2. Any task with no owner or no cue
3. Any gap under 10 minutes before a fixed anchor
4. Anything needing power, access or parking that isn't mentioned
5. If speeches start 20 minutes late, which later items break?
6. Questions I should ask each supplier before the dayAn illustrative answer to question 1 from the stress test on the anniversary evening: "18:15: the planner runs the team briefing in the foyer, and the late ice delivery is due at the rear door at the same time. Nobody else is named to receive it." A small thing on paper; on the night it's a planner leaving the briefing halfway through, or warm drinks at 18:30. The fix is one change of owner: the bar manager receives the ice, and the briefing keeps its ten minutes.
Question 5 earns its place. Running the late-speeches scenario shows which items have slack and which will collide with the curfew. On the example evening it caught that the photographer's contracted four hours ended at 22:15, while the planner had pencilled the staff group photo in for 22:20.
Stage 5: produce a version for each supplier
Suppliers don't want the full sheet. The caterer needs food, bar and staffing rows; the AV engineer needs rig, cues and speeches; the venue needs access and load-out. Ask the assistant to filter the master: "From this run sheet, produce a one-page version for the AV supplier with only the rows where AV is the owner or appears in the cue, plus my mobile number and the load-out deadline." Regenerate the versions every time the master changes, and put the date in each footer so nobody works from Tuesday's copy on Thursday.
Check what the filter leaves out as carefully as what it keeps. On an illustrative first attempt at the AV version for the anniversary evening, the 18:15 team briefing disappeared, because its owner was the planner and its cue said "all suppliers on site", which the assistant didn't read as including AV. The AV lead didn't come to the briefing and missed the change to the speeches cue. The fix is a line in the filter prompt: "include every row whose owner, cue or notes mention all suppliers, everyone or the whole team". Then scan the one-pager for the briefing, the speeches and load-out before sending it.
Five errors to catch before a client or supplier sees either document
- A price with no quote reference. Sort the budget by Status. Anything marked Estimate needs a source, or a clear label on the client version.
- Totals typed as numbers. Click the total cells. If one shows a number rather than a formula, someone pasted it, and it won't update when a quote changes.
- Per-head prices applied to the wrong count. Catering is often charged on final confirmed numbers with a minimum, and drinks packages may exclude crew. Check each quantity against the terms of its quote.
- Times the assistant invented. Search the run sheet for any supplier time you didn't provide. If you used the MISSING rule, there should be none.
- Figures that drift into prose. Ask the assistant to write the client's cover note and it may restate numbers from memory rather than from the sheet. Check every figure in the note; catching made-up figures in AI-drafted documents covers how to check them.
Time, tools and cost
For a mid-sized event, allow roughly 15 minutes for the budget skeleton, however long suppliers take to quote (AI doesn't speed them up), 30 minutes for the run sheet once timings are confirmed, and 10 minutes for the stress test. Those are my estimates for a planner who already keeps templates, not measured averages, but they compare well with the afternoon a blank spreadsheet usually takes.
You don't need specialist software. Any of these handles the method:
- ChatGPT Plus or Claude Pro, each $20 a month (list price in USD), for drafting and stress-testing.
- Microsoft 365 business plans include Copilot Chat at no extra cost. The paid Microsoft 365 Copilot Business licence ($21 per user a month on annual billing, with an $18 promotional price until 31 December 2026) adds Copilot working across your own files. Check which Excel features your plan shows before paying.
- Google Workspace Business Standard (about $14 per user a month on an annual plan) and above include Gemini in Sheets and Docs.
If you're still choosing tools, the best AI tools for small event planning businesses groups them by task. And once the budget and run sheet exist, the same brief feeds straight into writing the event proposal, so you're not typing the event details a third time.
Signs the budget and run sheet are doing their job
After three or four events, ask three questions. Did any supplier arrive at a time the run sheet didn't show? Did the final invoice land inside your contingency? Did anyone on the night ask "what's next?" instead of reading their own version? If the answer to the last one is yes, the Cue column needs more detail. That fix is yours to make, not the AI's, and it's usually the difference between a run sheet people follow and one they fold into a pocket.
Budgets, run sheets and AI: follow-up questions
Can AI read supplier quote PDFs straight into my budget?
Usually, yes. ChatGPT, Claude and Copilot can read a quote PDF and list its line items, quantities and totals as a table you paste into the sheet. Treat it as data entry you still check: compare the extracted total with the total printed on the quote, and look for service charges, minimum spends and overtime rates that sit in the small print rather than the price table.
Should I show the client the AI-drafted budget?
Not in its first form. The first draft is a skeleton, and clients anchor on the first number they see. Share the budget once every line is marked as quoted or as an estimate from your own past events, and label the estimates clearly so a later change reads as expected movement rather than a broken promise.
Is a spreadsheet or a document better for a run sheet?
Build the master in a spreadsheet, because you can sort by time, filter by owner and spot overlaps. Export supplier versions to PDF or a shared document for people who will read them on a phone on the day. Keep one master and regenerate every version from it, so there is never a second copy drifting out of date.
Further reads
- How to Compare Supplier Quotes Side by Side With AI — Line up caterer and AV quotes on the same basis before they reach the budget.
- A Wedding Planner's AI Workflow From Enquiry to Final Timeline — The same method followed through one wedding, month by month.
- How Caterers Use AI to Quote Events and Plan Menus — See how caterers build the per-head figures you'll be budgeting.
- How to Build a Job Costing Sheet in Excel With AI Help — Set up margin and cost columns properly in Excel.
- How to Use Claude With Excel and Google Sheets Safely — Rules for letting an assistant touch a live client spreadsheet.
- Which Event Planning Tasks Should You Hand to AI First? — Choose which planning job to hand to AI first.
- Can ChatGPT Read PDFs, Spreadsheets and Photos? What Breaks — What ChatGPT reads well in PDFs, spreadsheets and photos, the features that make it misread or skip things, and a five-minute test before you trust a figure.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: Microsoft 365 business and Copilot plan pages, Google Workspace pricing page, OpenAI and Anthropic plan pages (figures checked September 2026).