A free event budget template that does the maths
This event budget template works like a spreadsheet that already knows how events are priced. Choose a birthday party, a corporate event or conference, a festival or community event, or a blank template; each starts with the cost lines those events usually need. Mark every line as a fixed cost or a per-guest cost, and the planner multiplies per-guest lines by your headcount, adds a contingency and shows the total and the cost per guest.
As quotes and bills come in, type them in the Actual column to see where you are over or under. Ticket sales, sponsors and stall fees go in the optional income table, which gives you the net result. Export to Excel (with live formulas), CSV or a printable PDF — nothing is uploaded, and the budget is kept in your browser between visits.
How to use the Event Budget Planner
- Pick the event type, give it a name and date, and choose your currency.
- Enter the number of guests or attendees and a contingency (10% is common; festivals often use 15%).
- Go down the Costs table: rename lines, set each to Fixed or Per guest, and type your estimates. Add or remove lines as needed.
- Add any income — ticket price per attendee, sponsorship, stall fees — to see the surplus or shortfall.
- Fill in Actual amounts as you pay; red figures show lines that went over.
- Download Excel, CSV or the PDF, or copy a summary for your team.
Event Budget Planner features
Fixed vs per-guest costs
Venue, stage or DJ are fixed; food, drinks, favours and badges scale with the headcount automatically.
Three ready templates
Birthday party, corporate event and festival line items, plus a blank sheet.
Plan vs actual
Difference per line and overall, highlighted when you overspend.
Income and net result
Tickets per attendee, sponsors and stall fees against total costs.
Excel with formulas
The .xlsx keeps formulas for per-guest lines, the subtotal, contingency and totals, so you can keep working in Excel or Google Sheets.
Printable PDF
A clean A4 or Letter budget sheet to share with a client, committee or family.
How the event budget is calculated
Planned cost of a line = the estimate for fixed lines, or estimate × guests for per-guest lines. Subtotal = the sum of all lines; contingency = subtotal × contingency %; total = subtotal + contingency; cost per guest = total ÷ guests.
Worked example with the birthday template in rupees: fixed lines (venue ₹8,000, cake ₹2,500, decorations ₹3,500, entertainment ₹5,000, invitations ₹500, photography ₹4,000) add to ₹23,500. Per-guest lines (food ₹450, drinks ₹80, return gifts ₹150) cost ₹680 a head, ₹20,400 for 30 guests. The subtotal is ₹43,900; with 10% contingency the total is ₹48,290, or ₹1,610 per guest. The example amounts are placeholders to show the method — replace them with real quotes for your city.
Typical line items by event type
| Event | Usually fixed | Usually per guest | Income |
|---|---|---|---|
| Birthday party | Venue, cake, decorations, entertainment, photos | Food, drinks, return gifts | — |
| Corporate event | Venue hire, AV, speakers, travel, marketing, staff, insurance | Catering, badges and printing, giveaways | Tickets, sponsorship |
| Festival / community | Ground and permits, stage and sound, security, toilets, performers | Refreshments | Entry tickets, stall fees, sponsors, donations |
Tips for an accurate event budget
- Get the headcount right first. Every per-guest line moves with it; for parties expect some no-shows, for free community events plan for more people than registered.
- Compare quotes with tax. Ask whether prices include GST, VAT or sales tax and service charges.
- Keep a contingency. Last-minute extras — more chairs, overtime, weather cover — are normal at events.
- Use the specialist tools for the big lines: the drink calculator for the bar, the cake serving calculator for the cake and the split bill calculator if friends share the cost. Weddings have their own wedding budget calculator.
Event Budget Planner FAQ
Is this event budget template free?
Yes — no sign-up, no watermark. The Excel, CSV and PDF files are generated in your browser.
Can I get the event budget template in Excel or PDF?
Yes. “Download Excel” makes an .xlsx with formulas, “Download CSV” a plain file for any spreadsheet, and the printable section makes an A4 or Letter PDF. For Word, paste the copied summary or insert the PDF.
What should an event budget include?
Venue, food and drink, decor, entertainment or speakers, AV, marketing, staff, insurance and a contingency — plus income such as tickets or sponsorship if you have any.
How much contingency should I add?
Ten per cent of costs is a common rule; outdoor events and festivals often keep 15% or more.
Is my budget saved?
It is stored in this browser’s local storage as you type and comes back when you reopen the page on the same device. Download a copy to keep it safe or share it.
Are the example amounts real prices?
No. They are round placeholders to show how the template works; prices vary widely by city and supplier. This planner is a calculation aid, not financial advice.