Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Event | Emma and Daniel's wedding | Event date | 46550 | ||
|---|---|---|---|---|---|
| Days to go | 208 | As of | 46342 | ||
| Total budget | 38,000.00 | Items not yet booked | 6 | ||
| Estimated total | 35,650.00 | Payments overdue | 2 | ||
| Projected cost | 37,045.00 | Payments due soon | 2 | ||
| Paid so far | 14,025.00 | Tasks done | 8 | ||
| Balance still to pay | 23,020.00 | Tasks overdue | 2 | ||
| Budget remaining | 955.00 | Confirmed guests | 29 | ||
| Budget used | 97.5% | Cost per confirmed guest | 1,277.41 | ||
| Budget status | Near the limit | Lines without a valid category | 0 | ||
| Category | Estimated | Projected | Paid | Balance | % of budget |
| Venue | 8,900.00 | 9,400.00 | 4,250.00 | 5,150.00 | 24.7% |
| Catering | 9,600.00 | 10,240.00 | 2,640.00 | 7,600.00 | 27.0% |
| Photo and video | 4,300.00 | 4,300.00 | 1,400.00 | 2,900.00 | 11.3% |
| Music | 1,900.00 | 1,950.00 | 1,050.00 | 900.00 | 5.1% |
| Flowers and decor | 2,900.00 | 3,050.00 | 250.00 | 2,800.00 | 8.0% |
| Attire and beauty | 2,600.00 | 2,720.00 | 2,050.00 | 670.00 | 7.2% |
| Stationery | 500.00 | 465.00 | 465.00 | 0.00 | 1.2% |
| Transport | 400.00 | 450.00 | 150.00 | 300.00 | 1.2% |
| Rings and gifts | 1,600.00 | 1,520.00 | 1,520.00 | 0.00 | 4.0% |
| Licence and fees | 250.00 | 250.00 | 250.00 | 0.00 | 0.7% |
| Accommodation | 1,200.00 | 1,200.00 | 0.00 | 1,200.00 | 3.2% |
| Contingency | 1,500.00 | 1,500.00 | 0.00 | 1,500.00 | 4.0% |
Example from the “Summary” tab, with the numbers and formulas that are in the file.
What is inside
- Summary: Total budget, estimated and projected cost, paid so far, balance still to pay and the budget remaining, with a status (within budget, near the limit, over budget). It also shows overdue and due-soon payments, tasks done and overdue, confirmed guests, the cost per confirmed guest, a table by category and three charts.
- Budget: One row per cost: category, item, vendor, estimated cost, actual cost, amount paid and the next payment due date. It works out the projected cost, the balance, the difference from the estimate and a status: Not booked, Booked, Due soon, Overdue or Paid. Room for 300 lines.
- Tasks: Your checklist: task, owner, due date and whether it is done. The status turns Overdue or Due soon on its own. Room for 200 tasks.
- Guests: One row per invitation with party size, group, RSVP (Yes, No, Pending), meal and table. Counts the people who have confirmed. Room for 500 invitations.
- Lists: Your budget categories, guest groups and meal choices. They feed the dropdowns and the Summary.
- Settings: Event name and date, total budget, currency symbol, today's date and the alert window in days.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most event budget templates give you a list of categories with an estimated and an actual column. This one also follows the money after the quote: what you have paid, what is still owed, and which payment dates are close or missed. The checklist and the guest list sit in the same file, so the headcount, the meal counts and the cost per guest come from the same place. The sample is a wedding with dates in October 2026 to June 2027, so you can see every sheet working before you replace it with your own event.
How do I make an event budget in Excel?
Start with the total you can spend and type it on Settings. Then add one row on the Budget sheet for each cost you expect, with a category and an estimate. Estimates are guesses: price a few vendors, or use a rough share of the total for each category.
As quotes arrive, type the real figure under Actual. The sheet then uses the actual cost instead of the estimate in every total, so the projected cost always shows your best current number. In the sample the estimates add up to 35,650.00 and the projected cost is 37,045.00 against a budget of 38,000.00, which leaves 955.00 and is shown as near the limit.
How do I track deposits and payments to vendors?
Type what you have paid so far under Paid, and the date the next payment is due. The Balance column is the projected cost minus what you have paid, and the Status column tells you whether the line is not booked yet, booked, due soon, overdue or fully paid.
In the sample the amount paid so far is 14,025.00 and 23,020.00 is still to pay. Two payments are overdue (the photographer and the car hire) and two are due within the alert window. Keep your contracts: the sheet records what you tell it, and the vendor's terms are the ones that count.
How do I build a wedding planning checklist and guest list?
List each task with an owner and a date on the Tasks sheet and type Yes when it is done. In the sample, 8 of 16 tasks are done and 2 are overdue. Put the hard deadlines first: the venue, the caterer, the invitations and the final headcount for the caterer.
On the Guests sheet enter each invitation once with its party size. The sample has 44 people invited, 29 confirmed, 6 declined and 9 still to reply. The Summary also counts confirmed guests by meal, so you can give the caterer the numbers, and divides the projected cost by the confirmed guests to give a cost per head. For a venue-based event, see the event hall bookings template; for a wider spending plan, the business expenses budget.
How to use it
- On the Settings sheet type the event name and date, your total budget, the currency symbol, and today's date (the As of date) so the sheet can tell what is overdue.
- On the Lists sheet edit the budget categories, guest groups and meal choices to suit your event.
- On the Budget sheet add one row per cost: category, item, vendor and your Estimated cost. When you get a quote or sign a contract, type it under Actual. Type every deposit and payment total under Paid, and the date the next payment is due.
- Read the Status column: Not booked (only an estimate so far), Booked, Due soon, Overdue or Paid. The Projected column uses the Actual cost when you have one and the Estimate when you do not.
- On the Tasks sheet list what has to happen, who owns it and by when. Type Yes under Done when it is finished.
- On the Guests sheet add each invitation with the party size, the RSVP (Yes, No or Pending), the meal and the table. Open Summary for the budget by category, the guest and meal counts and the charts.
Before you start:
- Capacity: 300 budget lines, 200 tasks, 500 guest invitations, 20 budget categories, 6 meal choices.
- Projected cost = Actual if you have typed one, otherwise Estimated. Balance = Projected - Paid. A negative balance means you have paid more than the cost.
- Status: Not booked (no Actual yet), Paid (nothing left to pay), Overdue (due date before the As of date), Due soon (due within the alert window on Settings), otherwise Booked.
- Type today's date on Settings by hand, or enter =TODAY() there to let it update itself.
- Cost per confirmed guest = projected cost / guests who replied Yes (counted by party size).
- The Summary charts show the first 12 budget categories on your Lists sheet. Use one currency in one workbook; the symbol on Settings is only a label.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is this event planning template really free?
Yes. Download it, use it for your event and change anything you like. There is nothing to sign up for to open the file.
Does it work for events other than weddings?
Yes. Rename the categories on the Lists sheet, for example to venue, speakers, marketing and catering for a conference or a fundraiser, and use the guest list for attendees.
Does it work in Google Sheets and LibreOffice?
Yes. It uses only ordinary formulas such as SUMIFS, COUNTIFS, INDEX and IF, so it works in Excel 2016 and later, LibreOffice and Google Sheets.
How many budget lines, tasks and guests can it hold?
300 budget lines, 200 tasks, 500 guest invitations and 20 budget categories. The Summary charts show the first 12 categories.
Why does a line say Not booked?
It has an estimate but no Actual cost yet. Type the quote or contract amount under Actual and the status changes to Booked, or to Paid once nothing is left to pay.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Events and weddings
More free templates
- Fleet Fuel and Maintenance Log Template for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Ecommerce Profit Margin Calculator for Excel
- Installment Payment Tracker for Excel
- Social Media Content Calendar Template for Excel
- Class Schedule Maker for Excel
- GPA Calculator for Excel (Weighted and Unweighted, by Term)