You do not need expensive software to manage event finances effectively. A well-structured spreadsheet can handle everything from initial budgeting to post-event reconciliation. Google Sheets or Microsoft Excel will do the job perfectly well, and they are tools most people already have access to. Here is how to set them up properly for event finance management.
The master event budget spreadsheet
Your main spreadsheet should have four tabs: Budget, Actual Expenses, Revenue Tracker, and Cash Flow. Each serves a distinct purpose and together they give you a complete picture of your event finances.
Tab 1: Budget
This is your plan. Set it up with these columns:
- Category (venue, production, talent, staffing, marketing, insurance, miscellaneous)
- Line item (specific cost within each category)
- Estimated cost (your best guess before quotes)
- Quoted cost (the actual quote received)
- Committed cost (what you have agreed to pay)
- Notes (supplier name, payment terms, VAT status)
Use a SUM formula at the bottom of each category to give subtotals, and a grand total at the very bottom. Add a row for your contingency (10 to 15 percent of the total). Your total budget including contingency should not exceed your conservative revenue estimate.
Tab 2: Actual expenses
Once you start spending money, record every transaction here:
- Date
- Supplier/payee
- Category (matching the categories in your budget tab)
- Description
- Amount (ex-VAT)
- VAT amount
- Total paid
- Payment method (bank transfer, card, cash)
- Invoice/receipt reference
Use a SUMIF formula to total expenses by category, then compare these to your budget tab. A simple formula like =SUMIF(C:C,"venue",G:G) will sum all expenses in the "venue" category. Add a variance column that shows the difference between budgeted and actual spend for each category.
Tab 3: Revenue tracker
Track all incoming money here:
- Date
- Source (ticket sales, sponsorship, vendor fees, bar revenue, etc.)
- Amount
- Status (received, invoiced, pending)
- Notes
For ticket sales, you can either enter a daily total from your ticketing platform or update weekly. If you are using a platform like Tickts that pays directly to your Stripe account, you can reconcile against your Stripe dashboard regularly to make sure everything matches up.
Tab 4: Cash flow
This is the tab most organisers skip, but it is arguably the most important. Set up a weekly timeline:
- Week (Week 1, Week 2, etc., from planning start to two weeks post-event)
- Money in (expected revenue for that week)
- Money out (payments due that week)
- Net cash flow (money in minus money out)
- Running balance (previous balance plus net cash flow)
The running balance column is key. If it goes negative at any point, you have a cash flow gap you need to plan for. See our guide on cash flow management for strategies to address this.
Useful formulas for event finance
Here are specific formulas that make event finance spreadsheets more useful:
Break-even calculator
In a separate area of your budget tab, calculate your break-even point: total fixed costs divided by ticket price minus variable cost per attendee. If your fixed costs are £5,000 and your ticket price is £20 with £2 variable cost per person, your break-even is £5,000 / (£20 - £2) = 278 tickets. Knowing this number is essential for deciding whether an event is financially viable.
Budget versus actual variance
For each category, calculate: (Actual - Budget) / Budget * 100 to get a percentage variance. Use conditional formatting to highlight anything more than 10 percent over budget in red. This gives you a visual early warning system.
Revenue forecast tracker
Plot your actual cumulative ticket sales against your forecast. Create three forecast lines (conservative, expected, optimistic) and update your actual sales line daily or weekly. A simple line chart from this data shows you instantly whether you are on track.
Tips for keeping your spreadsheet useful
- Update it regularly -- A spreadsheet that is two weeks out of date is worse than useless because it gives you false confidence. Set a reminder to update at least weekly.
- Keep receipts linked -- If using Google Sheets, add links to photos of receipts stored in Google Drive. If using Excel, reference the receipt number and keep a folder of scanned receipts that matches.
- Lock completed cells -- Once a budget item is confirmed and paid, protect those cells so you do not accidentally overwrite them.
- Use data validation -- Set up dropdown lists for categories and payment methods so entries are consistent. Inconsistent category names will break your SUMIF formulas.
- Share with your team -- If you have a co-organiser or treasurer, share the spreadsheet so everyone is working from the same numbers. Google Sheets makes real-time collaboration easy.
When to move beyond spreadsheets
Spreadsheets work well for individual events and small event businesses. However, if you find yourself running more than ten events per year, employing staff, or managing six-figure budgets, it may be time to consider proper accounting software. Tools like Xero or QuickBooks integrate with your bank account, automate much of the data entry, and generate reports that your accountant can work with directly.
Even then, many organisers keep a per-event spreadsheet alongside their accounting software. The accounting software handles the legal and tax side, while the spreadsheet gives you the event-specific detail you need for planning and decision-making.
The most important thing is not which tool you use, but that you use it consistently. An imperfect system that you update regularly is infinitely better than a perfect system you abandon after the first week. Start simple, build the habit, and refine your approach as you learn what information you actually need.
For more on the financial foundations of event organising, see our guides on creating an event budget and accounting basics for event businesses.
