Event Planning - Sales Tracker - Weekly

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

Weekly Sales Tracker - Event Planning

Week Ending	Event Name	Client Name	Sales Rep	Initial Quote ($)	Paid Deposit ($)	Total Revenue ($)	Status
2023-10-15	Annual Charity Gala	Greenfield Enterprises	Jane Smith	$45,000	$9,000	$42,500	Confirmed & In Progress
2023-10-15	Spring Product Launch	Innovatech Inc.	Michael Brown	$38,000	$7,600	$36,250	Proposal Sent
2023-10-15	Corporate Retreat 2024	Summit Dynamics	Sarah Johnson	$65,000	$13,000	$62,500	Pending Approval
2023-10-15	Winter Holiday Party	Luxury Living Group	David Lee	$28,500	$5,700	$26,800	On Hold - Client Reviewing
2023-10-15	Startup Pitch Night	TechVenture Labs	Lisa Wang	$18,000	$3,600	$17,250	Confirmed - Final Details Pending
Total Weekly Sales:				$194,500	$39,900	$185,300

Weekly Sales Tracker updated as of October 15, 2023 | Event Planning Department

Weekly Sales Tracker for Event Planning – Excel Template Overview

This comprehensive Excel template is specifically designed for professionals engaged in event planning, aiming to streamline and monitor sales performance on a weekly basis. By integrating the functionality of a Sales Tracker with a recurring weekly reporting cycle, this template enables event coordinators, planners, and sales managers to visualize revenue trends, track client acquisition progress, manage contracts efficiently, and forecast future demand with accuracy.

Each week's data is captured systematically within clearly defined sheets that support both real-time data entry and long-term performance analysis. This dynamic structure makes it ideal for agencies managing multiple events such as corporate conferences, weddings, product launches, or trade shows — all of which rely on consistent sales tracking to ensure financial success.

Sheet Names

Weekly Sales Tracker: The primary data entry sheet where daily and weekly sales are recorded.
Daily Activity Log: A supplementary sheet for logging client meetings, proposals sent, follow-ups, and event milestones.
Sales Dashboard: A visual summary page with charts, KPIs, trends over time, and progress toward weekly targets.
Event Summary Report: A consolidated view of all active events with status indicators and key performance metrics.

Table Structures and Columns

1. Weekly Sales Tracker (Main Sheet)

Column	Data Type	Description
Week Ending Date	Date (DD/MM/YYYY)	The final day of the reporting week (e.g., 30/06/2024).
Event Name	Text (Short)	Name of the event being planned or sold (e.g., "TechFest 2024", "Spring Wedding Gala").
Client Name	Text (Medium)	The name of the individual or organization booking the event.
Sales Rep	Text (Dropdown List)	Assigns ownership to a sales representative from a predefined list of team members.
Sales Stage	Text (Dropdown: Prospect, Proposal Sent, Negotiating, Confirmed, Cancelled)	Tracks the current status of each sale within the sales funnel.
Contract Value (£/USD)	Currency (Format: £#,##0.00)	Total value of the signed agreement or estimated deal size.
Commission Earned (£/USD)	Currency (Auto-calculation: 10% of Contract Value)	Automatically calculated commission based on a standard rate (configurable).
Sale Date	Date	Date when the deal was closed or signed.
Event Date	Date (DD/MM/YYYY)	Planned date of the actual event.
Status	Text (Auto: 'On Track', 'Delayed', 'At Risk')	Dynamically updated based on event date vs. current date and stage.

2. Daily Activity Log

Records daily actions related to sales and event preparation:

Date | Activity Type (Call, Email, Meeting) | Client Name | Summary | Next Action

3. Sales Dashboard

A visually rich summary page that pulls data from the main tracker and displays:

Weekly revenue total (sum of Contract Value)
Conversion rate (Confirmed/Total Opportunities)
Sales by Rep (bar chart)
Trend line for weekly sales over the last 12 weeks

4. Event Summary Report

Lists all events with columns: Event Name, Client, Contract Value, Status (Confirmed/At Risk/Canceled), and Timeline Progress.

Formulas Required

Sales Stage Validation: Use data validation to restrict input to predefined stages.
Commission Calculation: =IF(E2<>"", D2*0.1, "") – calculates 10% commission automatically.
Status Indicator: =IF(AND(E2="Confirmed", F2>TODAY()), "On Track", IF(F2
Weekly Total Revenue: =SUMIFS(D:D, A:A, ">=" & DATE(YEAR(TODAY()), MONTH(TODAY()), 1), A:A, "<=" & EOMONTH(TODAY(),0))
Conversion Rate: =COUNTIF(B:B,"Confirmed") / COUNTA(B:B) — used in dashboard.

Conditional Formatting

Past Due Events: Highlight rows where Event Date is before today and Status ≠ "Completed" with red fill.
Sales Stage Progress: Color-code stages: Green for Confirmed, Yellow for Negotiating, Red for Cancelled.
High Value Deals: Format Contract Value > £5000 in bold and blue text.
Weekly Revenue Trend: Use data bars to show growth across weeks on the dashboard.

User Instructions

Open the template and save it with a unique filename (e.g., "EventSales_Tracker_Q3_2024.xlsx").
Set your weekly cycle by defining the start date in cell A1 (e.g., Monday, 1st July).
Enter new sales data under the 'Weekly Sales Tracker' sheet each day.
Select from dropdown menus for Sales Stage and Rep to maintain consistency.
Update the 'Daily Activity Log' daily to document outreach efforts.
The dashboard will auto-update with new data. Review charts weekly during team meetings.
Use conditional formatting to quickly identify risks or opportunities at a glance.

Example Rows

Week Ending Date: 07/07/2024
Event Name: Summer Music Festival
Client Name: Harmony Events Ltd.
Sales Rep: Jane Doe
Sales Stage: Confirmed
Contract Value (£): £12,500.00
Commission Earned (£): £1,250.00
Sale Date: 31/06/24
Event Date: 28/07/24
Status: On Track Week Ending Date: 14/07/2024
Event Name: Corporate Training Summit
Client Name: NovaTech Inc.
Sales Rep: Mike Smith
Sales Stage: Negotiating
Contract Value (£): £8,900.00
Commission Earned (£): £890.00
Sale Date: 12/07/24
Event Date: 15/12/24
Status: On Track

Recommended Charts and Dashboards

Bar Chart: Weekly Revenue by Sales Representative (on Dashboard).
Trend Line Graph: Monthly Sales Trend over the past 12 months.
Pie Chart: Distribution of sales by event type (e.g., Wedding, Conference, Product Launch).
KPI Cards: Show Weekly Revenue, Total Deals Closed, Conversion Rate as large digital-style indicators.

This Excel template transforms the complex nature of event planning into a structured and actionable weekly sales workflow. It combines the precision of a Sales Tracker with an intuitive weekly format that supports agile decision-making, team accountability, and long-term strategic growth.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT