Event Planning - Shopping List

Freelancer Event Planning Shopping List Excel Template

Purpose: This Excel template is specifically designed for freelance event planners who need a streamlined, customizable shopping list system to manage purchases efficiently across multiple events. Whether you're organizing corporate conferences, weddings, or social gatherings as a solo freelancer or small business owner, this template provides the tools necessary to track inventory needs, control budgets, and ensure nothing gets overlooked.

Template Type: Shopping List – This is not a general event planner; it's focused exclusively on tracking purchases required for events. The system allows freelancers to add new items dynamically, mark them as purchased or pending, and automatically calculate total costs based on quantity and unit price.

Style/Version: Freelancer – Designed with the independent professional in mind, this template features a clean, modern interface that balances functionality with visual clarity. It supports multiple event entries simultaneously, includes budget tracking for each project, and provides quick-reference summaries—ideal for freelancers juggling several clients at once.

Sheet Names

• 1. Shopping List (Main): The primary workspace where all items are listed, categorized, and tracked.
• 2. Budget Tracker: A summary sheet showing estimated vs. actual spending per event.
• 3. Event Overview: A dashboard-style summary of upcoming events with purchase status indicators and deadlines.
• 4. Categories & Suppliers: Reference sheet for setting up standard categories (e.g., Catering, Decorations) and supplier contacts.

Table Structures and Columns

The main Shopping List sheet contains a structured table with the following columns:

Formulas Required

• Total Cost ($): =IF(Quantity > 0, Quantity * Unit_Price, 0)
• Auto-generated Event ID: =CONCAT("EVT-", YEAR(TODAY()), "-", TEXT(COUNTA(A:A)+1,"000"))
• Date Purchased (auto-fill): =IF(Purchased?="✓", TODAY(), "")
• Count of Unpurchased Items per Event: =COUNTIFS(Event_Name_Column, "Wedding 2024", Purchased?, "FALSE")
• Total Budget Spend per Event (in Budget Tracker): =SUMIF(Shopping_List!Event_Name_Column, [Event Name], Shopping_List!Total_Cost_Column)

Conditional Formatting

• Overdue Purchases: Highlight rows in red if "Date Purchased" is blank and the event date (in Event Overview) has passed.
• Pending Items: Yellow highlight for items where "Purchased?" is unchecked and the item cost exceeds $50.
• Category Breakdown: Color-coded background by category (e.g., red for Food, blue for Decorations) to enable visual scanning.
• Budget Threshold: If total spend per event exceeds 90% of the budget, highlight row in orange.

Instructions for the User (Freelancer)

1. Open the template and save it as a new file with your name or client project.
2. In "Categories & Suppliers", add any custom categories or suppliers you use regularly.
3. Create a new row for each item needed for an event. Use the dropdowns to maintain consistency.
4. Enter quantity and unit price; total cost is automatically calculated.
5. Check the "Purchased?" box when an item has been bought. The date will auto-fill.
6. Review the "Budget Tracker" sheet weekly to monitor spending against estimates.
7. Use the "Event Overview" dashboard to track deadlines and purchase statuses at a glance.

Example Rows

Recommended Charts and Dashboards (in "Event Overview" Sheet)

• Pie Chart: Show percentage of total spending by category per event.
• Bar Chart: Compare actual vs. estimated budgets across multiple events.
• Gantt-style Timeline: Visualize purchase deadlines against the event date with color-coded status (Pending, In Progress, Complete).
• KPI Dashboard: Display total events managed this month, average cost per event, and number of items purchased.

This Excel template empowers freelance event planners to stay organized, professional, and client-ready with minimal effort. Its integration of automation, conditional logic, and visual feedback makes it an essential tool for freelancers aiming to scale their services efficiently.