
Turn a fixed ceiling into category lines, log deposits as they happen and see which line is over before it hurts, with a 120-guest dinner.
A neighbourhood association is hosting a dinner for 120 people and the treasurer has set a hard ceiling of $4,500. The hall wants a deposit this week, the caterer wants a number, and nobody has agreed what the evening is allowed to cost. Event Budget Planner breaks the ceiling into lines first, then tracks every payment against them.
The video below shows the planner from a blank page to a finished budget.
Quotes arrive one at a time and each looks reasonable in isolation. Starting with the ceiling reverses that: you decide the share each category gets and then ask every vendor to fit it. In the planner, enter 4500 in the total budget box, choose an event type from the menu and press Add typical categories. The menu offers Wedding, Birthday, Corporate event, Exhibition or trade show, Fundraiser and Conference.
For a community dinner that raises money, Fundraiser is the closest match. It splits $4,500 as Venue $1,125 (25 percent), Catering $1,350 (30), Entertainment and auction $675 (15), Marketing and printing $450 (10), Decorations $360 (8) and Contingency $540 (12). The lines add up to exactly $4,500, with the last line absorbing any rounding. The page labels these as rule-of-thumb shares, so edit any amount you disagree with. A catering line of $1,350 for 120 guests works out to $11.25 a head, which is the first sanity check: can a caterer in your area do a plated meal at that price?
Below the plan is a form for expenses: a description, a category from the suggestions list and an amount. Add each deposit and invoice when it is paid. The tiles at the top show Planned, Spent so far and what is left to spend, and each category row has a bar plus a red highlight when it goes over.
Follow the dinner through a few weeks. The hall booking is $1,125, which uses the venue line exactly. The caterer asks for a $675 deposit. The balance arrives later as a quote of $12.60 a head, which is $1,512 for 120 people, so the catering line shows $1,512 spent against $1,350 planned, $162 over and 112 percent used. Flyers and tickets cost $230 under Marketing and printing, table runners $90 under Decorations and raffle prizes $300 under Entertainment and auction.
At that point total spent is $3,257, which leaves $1,243 on the tile, so the overall budget looks healthy. The detail tells a different story: catering is over by $162 while Entertainment has $375 unspent, Marketing and printing $220 and Decorations $270. Contingency still holds its $540.
That is the decision the tool prepares you for. The treasurer can cover the $162 from the unspent entertainment line and leave contingency alone, or negotiate the per-head price down. Without per-category bars, the overall remaining figure would hide the overspend until the final invoice.
Say the sound-system hire arrives at $180 under the category Equipment, which has no plan line. Total spent becomes $3,437 and the remaining tile drops to $1,063. The page flags that $180 was spent in a category with no planned amount and offers a button to plan that amount in one click. Doing it keeps the totals honest: the planned total moves to $4,680 only if you add the line, which makes the overrun obvious, while leaving it unplanned keeps the ceiling at $4,500 and shows the money as unbudgeted. Either way, the spend is not hidden.
Category names are matched ignoring capital letters, so typing marketing and printing in lower case still lands on the planned line.
The Excel file has a Budget sheet with Category, Planned, Spent, Remaining and percent used, plus an Expenses sheet with date, description, category, amount and total paid. The budget CSV contains the planned lines only. You can also import a budget CSV and download a blank template for it.
The project lives in your browser tab and is erased when the tab closes, so use Save project (a small file saved to your device) if you want to continue another day. Each download counts as one trial use.
Entering a quote as spent. A quote is not a payment, and recording it early makes the remaining figure look worse than reality. Record money when it leaves the account.
Mixing currencies on one budget. Lines in another currency are left out and flagged, so convert them first with the Currency Converter.
Skipping contingency. Almost every event has one unplanned cost, and it is better to have named a line for it than to find money in the decorations.
Spending against a line that is already full without moving money. Rebalance on purpose and write down why.
The schedule of tasks behind this budget belongs in Event Checklist Planner, the invitations in Invitation Maker and the headcount in Guest List Tracker. If you run several of them together, the guide to planning an event in one shared project shows how they share data, and event tools lists the rest.
Which line of your event budget always goes over first: catering, venue or something you did not plan for? Tell us on the contact page.