Review the event and open the source sheet behind any number that needs attention.
Suggested for your taskFor a family celebration, dinner or gathering
Event Organizer Kit
Plan the guests, the tables and every payment before the day.
Keep estimates and commitments separate, log supplier payments by cost item and review what is due over the next eight weeks. Record guest groups, adults, children and dietary requirements; assign them to tables and check confirmed seats against capacity. A dated checklist tracks the preparation still to do.
- Format
- Excel · .xlsx
- Inside
- 12 worksheets
- Included
- Clean file + example + guide
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
What is still unpaid, unconfirmed or left to prepare?
The venue has a deposit, the caterer needs a final headcount and one family's reply changes the table plan. These are different questions, so they need different records. This kit connects the budget, payment ledger, guest groups, seating and checklist without treating a deposit as the full bill or a guest group as one person.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Open this before entering your event details.
Suggested for your taskSet up the event and update the date before reviewing payments or overdue preparation.
Suggested for your taskGet a quote, agree a supplier commitment or review the remaining balance.
Suggested for your taskRecord a deposit or a later payment without overwriting the earlier payment.
Suggested for your taskRecord a reply or update who is coming and what the host needs to know.
Suggested for your taskReview table assignments before agreeing the layout.
Suggested for your taskReview upcoming supplier balances and plan when to pay them outside the workbook.
Suggested for your taskKeep track of practical jobs such as collecting equipment or confirming the final headcount.
Suggested for your taskGive each event-day activity an owner, start and end time, location and fallback.
Suggested for your taskKeep supplier confirmations, due dates and follow-up separate from payments.
Suggested for your taskReview the added run-of-show and supplier input warnings before the event.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 12 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 12 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Follow a deposit through the event budget.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Review the event and open the source sheet behind any number that needs attention.
- Start: Open this before entering your event details.
- Settings: Set up the event and update the date before reviewing payments or overdue preparation.
- Budget: Get a quote, agree a supplier commitment or review the remaining balance.
- Payments: Record a deposit or a later payment without overwriting the earlier payment.
- Guests: Record a reply or update who is coming and what the host needs to know.
- Seating: Review table assignments before agreeing the layout.
- Payment calendar: Review upcoming supplier balances and plan when to pay them outside the workbook.
- Checklist: Keep track of practical jobs such as collecting equipment or confirming the final headcount.
- Run of Show: Give each event-day activity an owner, start and end time, location and fallback.
- Supplier Checks: Keep supplier confirmations, due dates and follow-up separate from payments.
- Studio 5 Review: Review the added run-of-show and supplier input warnings before the event.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. event-organizer-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. event-organizer-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Follow a deposit through the event budget.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Find the supplier cost
Open Budget in the fictional example. Read the full commitment, not just the deposit.
Trace the actual payment
Find the cost ID in Payments, then inspect the unpaid balance and Payment calendar.
Review what is still owed
Compare the commitment, actual net payments and reserve before making a payment outside the file.
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 12 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Dashboard
The budget, confirmed headcount and preparation summary come from separate working records.
- You enter
- No routine entries; data comes from the working sheets
- Calculated or supplied reference
- Budget, commitments and payment summary; Confirmed guest totals; Preparation and seating attention
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Start
Open this before entering your event details.
- You enter
- No routine data entry; this is the instruction sheet
- Calculated or supplied reference
- No calculations; instructions for the event-planning workflow
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Settings
Set up the event and update the date before reviewing payments or overdue preparation.
- You enter
- Review date, event details, total budget, contingency and currency
- Calculated or supplied reference
- The date and budget assumptions used in the calculated views
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Budget
Get a quote, agree a supplier commitment or review the remaining balance.
- You enter
- Up to 80 cost lines with Cost IDs, suppliers, planned and committed amounts, and due dates
- Calculated or supplied reference
- Payments linked from the ledger; Unpaid balance and cost variance; Overpayment and input checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Payments
Separate ledger rows preserve the date, amount and reference of each supplier payment.
- You enter
- Up to 300 dated payment entries linked to Cost IDs
- Calculated or supplied reference
- Checks for missing or unknown Cost IDs and invalid payment amounts
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Guests
A guest row represents a group, with adults, children, declared dietary requirements and a table.
- You enter
- Up to 200 guest groups with RSVP, adults, children, dietary details and table assignment
- Calculated or supplied reference
- Group headcounts and input checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Seating
Confirmed guest groups are counted against the capacity of their assigned table.
- You enter
- Up to 40 tables with their capacities
- Calculated or supplied reference
- Confirmed seats assigned to each table; Capacity checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Payment calendar
Outstanding supplier amounts are grouped by due date for the next eight weeks.
- You enter
- Due dates and payments are maintained in their source sheets
- Calculated or supplied reference
- An eight-week view of outstanding commitments by due date
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Checklist
Keep track of practical jobs such as collecting equipment or confirming the final headcount.
- You enter
- Up to 100 preparation tasks with owners, due dates and statuses
- Calculated or supplied reference
- Overdue flags and input checks
Actual example worksheet · Preview range A1:K14. Image only; entries are made in your downloaded workbook.
Run of Show
Give each event-day activity an owner, start and end time, location and fallback.
- You enter
- 120 records in blue cells
- Calculated or supplied reference
- Linked input checks and explicitly labelled review values
Actual example worksheet · Preview range A1:J14. Image only; entries are made in your downloaded workbook.
Supplier Checks
Keep supplier confirmations, due dates and follow-up separate from payments.
- You enter
- 120 records in blue cells
- Calculated or supplied reference
- Linked input checks and explicitly labelled review values
Actual example worksheet · Preview range A1:E31. Image only; entries are made in your downloaded workbook.
Studio 5 Review
Review the added run-of-show and supplier input warnings before the event.
- You enter
- Review only
- Calculated or supplied reference
- Linked input checks and explicitly labelled review values
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
Fictional example: the buffet balance and a table of seven
The two payment rows add to USD 500.00, so the USD 1,500.00 buffet commitment still has USD 1,000.00 unpaid. Keeping those entries in a ledger preserves each payment rather than replacing one total. The Morgan family contributes four confirmed people and the Patel family contributes three: seven seats at a table with capacity eight. Changing a payment, reply or table capacity updates the corresponding view. These are recalculated values from the included fictional family-celebration example.
- Review date
- 06 Oct 2026
- Family buffet commitment — E02
- USD 1,500.00
- Two ledger payments
- USD 400.00 + USD 100.00
- Morgan family — confirmed
- 2 adults + 2 children
- Patel family — confirmed
- 2 adults + 1 child
- Window table — TABLE-A
- 8 places
- Buffet paid to date
- USD 500.00
- Buffet still unpaid
- USD 1,000.00
- Confirmed seats at TABLE-A
- 7 people
- TABLE-A capacity
- 8 places
Try the calculation
See why a deposit is not the full bill.
Change the fictional inputs below and compare the result. Nothing is submitted or saved.
Choose Calculate example to see the result.
A small browser demonstration of selected calculation rules. It does not open or edit the downloadable workbook. The kit contains the full records and planning views.
From setup to a regular review
How you use it.
Open the 5-step setup and review routineInputs, calculations and the decision each step supports
- 01
Separate the estimate from the commitment
You enterSet a total budget and contingency. Add a Cost ID, supplier, planned amount, committed amount and due date to each budget line.
CalculatedThe workbook compares planned and committed costs and reserves your chosen contingency.
Your next stepKnow how much of the budget is already spoken for before paying anything.
- 02
Record deposits and later payments separately
You enterLog each payment with its date, Cost ID, amount and reference in Payments.
CalculatedPayments dated on or before the review date are added to the matching budget line. Future payments remain planned. Unpaid and overpaid amounts are checked, and the payment calendar reviews outstanding due amounts across eight weeks.
Your next stepSee the remaining supplier balance after a deposit and the bills to review next.
- 03
Count people and review the seating
You enterAdd guest groups with RSVP status, adults, children, a declared dietary count and notes, and one table assignment for the whole group. Enter each table's capacity.
CalculatedThe workbook counts confirmed people and compares confirmed seating with the capacity of each table.
Your next stepCheck the headcount and table space from the same guest records.
- 04
Finish the preparation in a dated checklist
You enterAssign preparation tasks, deadlines and statuses. Set the review date before checking the dashboard.
CalculatedThe checklist marks overdue work; the dashboard brings guest, budget, payment and preparation summaries together.
Your next stepUse the review to contact the right person and make the remaining decisions yourself.
- 05
Give the day an owner, a time and a confirmed handover.
You enterAdd a run of show with same-owner overlap checks and practical supplier confirmations. A deposit never confirms a task or changes guest replies.
CalculatedNew views include inherited and new input warnings before showing dependent totals.
Your next stepKeep planned choices separate from actual records.
12 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
StartOpen sheet details
Editable inputs
- No routine data entry; this is the instruction sheet
Calculated or reference
- No calculations; instructions for the event-planning workflow
Open this before entering your event details.
Inspect the actual Start sheetSettingsOpen sheet details
Editable inputs
- Review date, event details, total budget, contingency and currency
Calculated or reference
- The date and budget assumptions used in the calculated views
Set up the event and update the date before reviewing payments or overdue preparation.
Inspect the actual Settings sheetBudgetOpen sheet details
Editable inputs
- Up to 80 cost lines with Cost IDs, suppliers, planned and committed amounts, and due dates
Calculated or reference
- Payments linked from the ledger
- Unpaid balance and cost variance
- Overpayment and input checks
Get a quote, agree a supplier commitment or review the remaining balance.
Inspect the actual Budget sheetPaymentsOpen sheet details
Editable inputs
- Up to 300 dated payment entries linked to Cost IDs
Calculated or reference
- Checks for missing or unknown Cost IDs and invalid payment amounts
Record a deposit or a later payment without overwriting the earlier payment.
Inspect the actual Payments sheetGuestsOpen sheet details
Editable inputs
- Up to 200 guest groups with RSVP, adults, children, dietary details and table assignment
Calculated or reference
- Group headcounts and input checks
Record a reply or update who is coming and what the host needs to know.
Inspect the actual Guests sheetSeatingOpen sheet details
Editable inputs
- Up to 40 tables with their capacities
Calculated or reference
- Confirmed seats assigned to each table
- Capacity checks
Review table assignments before agreeing the layout.
Inspect the actual Seating sheetPayment calendarOpen sheet details
Editable inputs
- Due dates and payments are maintained in their source sheets
Calculated or reference
- An eight-week view of outstanding commitments by due date
Review upcoming supplier balances and plan when to pay them outside the workbook.
Inspect the actual Payment calendar sheetChecklistOpen sheet details
Editable inputs
- Up to 100 preparation tasks with owners, due dates and statuses
Calculated or reference
- Overdue flags and input checks
Keep track of practical jobs such as collecting equipment or confirming the final headcount.
Inspect the actual Checklist sheetDashboardOpen sheet details
Editable inputs
- No routine entries; data comes from the working sheets
Calculated or reference
- Budget, commitments and payment summary
- Confirmed guest totals
- Preparation and seating attention
Review the event and open the source sheet behind any number that needs attention.
Inspect the actual Dashboard sheetRun of ShowOpen sheet details
Editable inputs
- 120 records in blue cells
Calculated or reference
- Linked input checks and explicitly labelled review values
Give each event-day activity an owner, start and end time, location and fallback.
Inspect the actual Run of Show sheetSupplier ChecksOpen sheet details
Editable inputs
- 120 records in blue cells
Calculated or reference
- Linked input checks and explicitly labelled review values
Keep supplier confirmations, due dates and follow-up separate from payments.
Inspect the actual Supplier Checks sheetStudio 5 ReviewOpen sheet details
Editable inputs
- Review only
Calculated or reference
- Linked input checks and explicitly labelled review values
Review the added run-of-show and supplier input warnings before the event.
Inspect the actual Studio 5 Review sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | Weekly Task Planner — free | Event Organizer Kit 2.3 |
|---|---|---|
| Purpose | A manual list of 20 tasks | A budget, payment and guest-planning workbook |
| Working records | Tasks with owner, date, priority, status and notes | 80 costs, 300 payments, 200 guest groups, 40 tables and 100 tasks |
| Calculated views | No budget, payment or guest calculations | Unpaid balances, an eight-week payment calendar, confirmed headcounts and seating checks |
| Files | One .xlsx with Read Me sheet | Clean workbook, worked example and one START_HERE.pdf guide with practical limits and license |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
event-organizer-clean.xlsx
Your blank working file. Keep this original and save a separate copy for your own records.
event-organizer-example.xlsx
Fictional worked records. Make a disposable copy before trying the first task.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
Workbook labels, examples and guides are in English. Dates are displayed with month names, such as 06 Oct 2026. Enter all costs in one currency and use one consistent tax convention.
Before you choose
Fit and practical limits.
- A family organising an anniversary, birthday or other seated celebration.
- A host planning a dinner with guest groups, table capacity and dietary requirements.
- A small community gathering with supplier commitments and a manually managed guest list.
Understand the boundaries.
- No ticketing, invitations, RSVP collection, payment collection or bank connection.
- One event and one currency per workbook. Amounts and payments are entered manually.
- The payment calendar reviews eight weeks; it does not pay bills or send reminders.
- Table assignments are manual. Capacity checks do not design a floor plan or arrange individual seats.
- Dietary information is a declared planning record, not an assurance that a menu is safe or suitable.
- Resolve every input warning before relying on calculated views.
Editable .xlsx files for a desktop spreadsheet application; the software is not included. Native Microsoft Excel verification is still pending in this private preview. Google Sheets and Apple Numbers compatibility have not been confirmed.
Event Organizer Kit / Version 2.3
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$7.40USD · One-time purchaseTaxes included where applicable.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Digital download. Review availability and the final total in your cart.
Questions about this workbook
The details that affect your choice.
Can I record several payments against one supplier cost?
Yes. Log each payment as a separate row in Payments and use the same Cost ID. The budget line adds payments dated on or before the review date and calculates the remaining balance. A later-dated payment stays planned until that date. The ledger records your entries; it does not take money or connect to a bank.
Does the available budget subtract payments or commitments?
Commitments. Paying a deposit does not make the remaining bill disappear. The available amount reserves your contingency and subtracts the committed costs, while the unpaid view shows what is still to be paid.
Do guest counts include children?
Guest records distinguish adults and children. Confirmed headcounts use the people in confirmed groups rather than the number of guest rows. You also enter the number of people with a dietary requirement; that count cannot exceed the group size. Confirmed dietary totals use confirmed groups only. Keep the actual requirements in the notes and review them with your caterer.
Will it choose who sits next to whom?
No. You assign a whole guest group to one Table ID; the workbook checks the confirmed adults and children against that table's capacity. It does not split a group between tables, allocate individual seats or create a floor plan.
Can it send invitations or chase RSVPs?
No. RSVP entries are updated manually. The kit does not send email, collect registrations, sell tickets or contact guests.
Is dietary information a catering plan?
No. It is a record to help the host review the requirements guests have declared. Confirm ingredients, allergies, serving arrangements and suitability directly with the people responsible for the food.