Plenty of effort goes into an event budget beforehand. Far fewer people compare it with what was actually spent once the event is over. That comparison makes the final report easy and gives the next organizer a realistic starting point. If receipts were photographed during the event, it takes surprisingly little time.
1. Budget by line item
A single figure like "1,500 total" can't tell you what went over. Break the budget into lines you can match to receipts.
| Line | Budget | Basis |
|---|---|---|
| Venue | 400.00 | 4 hours × 100 |
| Food | 600.00 | 30 people × 20 |
| Snacks and drinks | 150.00 | 30 people × 5 |
| Supplies and printing | 200.00 | Banner, name badges |
| Transport | 100.00 | Taxis for equipment |
| Contingency | 50.00 |
The Basis column matters most. When a line goes over, you'll immediately see whether it was more people or higher prices.
2. Collect event receipts into a table
Have organizers photograph receipts as they go, then add them all to the receipt tool after the event. Next to the Date, Store and Total columns in the downloaded file, add a Line column and use exactly the same names as the budget. Even a small spelling difference creates a separate total, so a Data Validation list based on the budget lines is worth setting up.
Use "Add row" for anything paid without a receipt.
3. Comparison formulas
Say the Budget sheet has line names in column A and budget amounts in column B, and the Spending sheet has amounts in column D and lines in column E. Add columns to the Budget sheet:
- Actual (C2):
=SUMIF(Spending!E:E, A2, Spending!D:D) - Variance (D2):
=C2-B2(positive means over budget) - % used (E2):
=IF(B2=0, "", C2/B2)with a percentage format
| Line | Budget | Actual | Variance | % used |
|---|---|---|---|---|
| Venue | 400.00 | 400.00 | 0.00 | 100% |
| Food | 600.00 | 684.00 | 84.00 | 114% |
| Snacks and drinks | 150.00 | 96.50 | −53.50 | 64% |
| Supplies and printing | 200.00 | 187.00 | −13.00 | 94% |
Add a total row and check that the Actual total equals the total of the Spending sheet. If it doesn't, some row has a mistyped line name.
4. Make overspending stand out
Select the % used column and choose Conditional Formatting > Highlight Cells Rules > Greater Than, entering 1 (100%). Overspent lines are colored instantly. A second color for 90% to 100% shows lines that are nearly used up while the event is still being planned.
5. Add income and cost per attendee
If attendees pay a fee, keep an Income sheet and add a few lines to the summary:
- Total fees collected
- Total actual spending
- Difference (money left over, or topped up from group funds)
- Actual cost per attendee:
=total actual spending / attendees
Cost per attendee is the best basis for setting next time's fee.
6. Leave notes for next time
Add a Change next time column and write one line per budget line, such as "Food: 34 actually came, budget for more" or "Snacks: half left over, cut back". The next organizer can open this file and budget far more accurately.
Summary
An event wrap-up needs just a line-item budget, receipts tagged with the same line names, and a SUMIF comparison. Let the tool turn receipt photos into rows, and spend the time you save on why lines went over and what to change next time.