Event Planning - Sales Tracker - Summary View

Download and customize a free Event Planning Sales Tracker Summary View Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.

Event Name	Date	Location	Sales Target ($)	Actual Sales ($)	Target Achievement (%)	Status
Annual Conference 2024	2024-05-15	Grand Ballroom, City Center	150,000	145,875	97.2%	In Progress
Spring Networking Gala	2024-06-10	Luxury Pavilion, Downtown	85,000	92,345	108.6%	Completed
Fall Product Launch	2024-09-22	Innovation Hub, Tech Park	120,000	118,567	98.8%	Scheduled
Total (All Events)	-	-	355,000	356,787	100.5%	Overall: On Track

Note: This is a summary view of sales performance for upcoming and past events. Data updated as of 2024-04-15.

Event Planning Sales Tracker – Summary View Excel Template

This comprehensive Excel template is specifically designed for professionals in the event planning industry who need to monitor and manage sales performance across multiple events. By combining the strategic goals of Event Planning, with the analytical power of a Sales Tracker, this template delivers a centralized, real-time summary view that enables decision-makers to track revenue, evaluate campaign effectiveness, forecast future bookings, and optimize resource allocation.

Sheet Names & Structure Overview

The template consists of three core worksheets:

Summary Dashboard: The central hub providing an at-a-glance overview of all event sales performance across key KPIs.
Sales Activity Log: A detailed transactional table recording every booking, contract, and payment related to events.
Event Details: A master reference list containing information about each planned event (e.g., venue, date, client name).

Sales Activity Log – Table Structure & Columns

The Sales Activity Log serves as the backbone of the tracker. It contains structured data to ensure accurate reporting and analysis.

Column Name	Data Type	Description & Usage Example
Event ID	Text/Number (Auto-incremented)	A unique identifier (e.g., EVT-2024-015) for each event. Used to link entries across sheets.
Event Name	Text	Name of the planned event (e.g., "Corporate Annual Gala 2024").
Date Held/Planned	Date (DD/MM/YYYY)	Actual or projected date for the event. Critical for timeline tracking.
Client Name	Text	Name of the organization or individual booking the event.
Event Type	List (Dropdown: Wedding, Corporate, Birthday, Conference, Charity)	Categorizes events for segmentation and reporting purposes.
Sales Representative	List (Dropdown: John Doe, Sarah Smith, etc.)	Tracks performance by individual sales staff.
Contract Value (£)	Currency (£)	Total agreed value of the event contract (including services and packages).
Advance Payment Received (£)	Currency (£)	Amount paid upfront by the client.
Balance Due (£)	Currency (£) – Formula-based	`=Contract Value - Advance Payment Received`
Status	List (Dropdown: Proposed, Confirmed, In Progress, Completed, Cancelled)	Tracks the lifecycle stage of each event booking.
Source Channel	List (Dropdown: Referral, Website Form, Email Campaign, Social Media)	Measures marketing effectiveness by source.

Summary Dashboard – Key Features & Formulas

This sheet presents a high-level summary view of sales performance. It dynamically pulls data from the Sales Activity Log using advanced formulas and conditional formatting.

Total Contract Value (All Events): =SUM(SalesActivityLog!E:E)
Total Revenue Collected: =SUM(SalesActivityLog!F:F)
Outstanding Balances: =SUM(SalesActivityLog!G:G)
Number of Events by Status: Use COUNTIF(SalesActivityLog!H:H, "Confirmed"), etc.
Top Performing Sales Reps (Last 3 Months): Use a combination of SUMIFS and sorting with dynamic ranking.
Average Event Value by Type: =AVERAGEIF(SalesActivityLog!D:D, "Corporate", SalesActivityLog!E:E)

Conditional Formatting Rules

To enhance visual clarity and immediate insight, the following conditional formatting rules are applied:

Outstanding Balance > £500: Highlighted in red font with light orange background.
Status = Cancelled: Text appears in gray with a strikethrough effect.
Balance Due = 0: Cell background turns green to indicate full payment.
Contract Value > Average: Yellow fill for events above the average contract size (calculated dynamically).
Sales Rep Performance Bar Chart (Conditional Color Scale): Visual trend indicators based on individual sales volume.

Instructions for the User

Begin by populating the Event Details sheet with all upcoming events, including ID, name, date, and client info.
In the Sales Activity Log, enter new bookings using consistent formatting. Use dropdowns to ensure data integrity.
Update payment details as they are received—this keeps the balance due column accurate.
Change status fields as events progress through their lifecycle (e.g., from "Proposed" to "Confirmed").
The Summary Dashboard updates automatically. Review KPIs weekly for performance tracking.
To analyze trends, filter by date range or sales rep using the built-in filters.
Export data to PDF monthly for stakeholder reporting sessions.

Example Rows (Sales Activity Log)

Event ID	Event Name	Date Held/Planned	Client Name	Event Type	Sales Representative	Contract Value (£)	Advance Payment Received (£)	Balance Due (£)	Status
EVT-2024-015	Spring Networking Conference 2024	15/03/2024	InnovateX Ltd.	Conference	Sarah Smith	18,500.00	9,250.00	9,250.00	In Progress
EVT-2024-187	Laura & Mark’s Wedding Gala	18/11/2024	Smith Family Trust	Wedding	John Doe	35,000.00	17,500.00	17,500.00	Confirmed
EVT-2124-329	Annual Charity Ball 2024	08/12/2024	FundForGood Foundation	Charity	Jane Lee	15,750.00	15,750.00	Completed

Recommended Charts & Dashboards (Summary View)

The Summary Dashboard includes the following visual elements:

Bar Chart: Monthly Event Revenue Trend (Last 12 Months): Shows monthly contract value trends.
Pie Chart: Revenue Distribution by Event Type: Visualizes which event types contribute most to sales.
Stacked Column: Sales Rep Performance vs. Target: Compares each rep’s actual vs. forecasted revenue.
Gantt-style Timeline (Optional): Displays upcoming events with planned dates and statuses for scheduling coordination.

This template merges the precision of sales tracking with the strategic vision required in event planning, making it an indispensable tool for modern event agencies aiming to scale efficiently while maintaining financial control and client satisfaction.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT