Simple Operations Dashboard – Sales Tracker Excel Template

This Simple Operations Dashboard – Sales Tracker Excel template is designed for small to mid-sized businesses seeking an efficient, user-friendly tool to monitor daily sales performance and operational metrics. Built with clarity and ease of use in mind, this template serves as a streamlined yet powerful resource for sales teams, operations managers, and business owners who need real-time visibility into their sales pipeline without overwhelming complexity.

Template Overview

As a Sales Tracker, the primary purpose of this Excel file is to log, analyze, and visualize key sales data across time periods. However, it doubles as an Operations Dashboard, enabling managers to track not just revenue but also team performance, conversion rates, and other critical operational KPIs. The entire design follows a Simple style—clean layout with minimal distractions, intuitive navigation, and no unnecessary complexity. It’s perfect for users who prefer quick data entry and instant insights without needing advanced Excel skills.

SHEET NAMES

The template contains three core sheets:

1. 1. Sales Log
2. 2. Summary Dashboard
3. 3. Instructions & Tips

SHEET 1: SALES LOG – Table Structure and Data Entry

This sheet is the data input hub, where users enter daily or weekly sales records.

Table Structure:

• Start at Row 1: Header row with column labels.
• Data starts at Row 2, expanding downward as new entries are added.
• Uses Excel Table formatting (Ctrl+T) for automatic expansion and formula referencing.

Columns and Data Types:

• Date (Column A): Date – Format as "DD/MM/YYYY". Auto-populates using a date picker.
• Salesperson (Column B): Text – Enter name or ID of the sales representative.
• Customer Name (Column C): Text – Full name or company name of client.
• Sale Type (Column D): List/Text – Dropdown options: "New", "Renewal", "Upsell", "Referral".
• Product/Service (Column E): Text – Name of product or service sold.
• Sale Amount (£) (Column F): Numeric (Currency) – Enter amount in pounds. Uses format: £#,##0.00.
• Status (Column G): Text – Dropdown with options: "Confirmed", "Pending", "Cancelled".
• Payment Method (Column H): List/Text – Options: "Cash", "Card", "Bank Transfer", "Online Payment".
• Notes (Column I): Text – Optional field for comments or follow-up details.

Formulas in Sales Log:

• =IF(G2="Confirmed", F2, 0): In a hidden "Revenue" column (if needed), this captures only confirmed sales.
• =TEXT(A2, "MMM YYYY"): Used to extract month/year for grouping in the dashboard.

Conditional Formatting:

• Status Column (G):
  • Green background and checkmark icon for "Confirmed".
  • Yellow background for "Pending".
  • Red background with X icon for "Cancelled".
• Sale Amount (F):
  • High values (> £5,000) highlighted in blue text.
  • Low values (< £100) shown in grey text.

SHEET 2: SUMMARY DASHBOARD – KPIs and Visualizations

This is the central Operations Dashboard, offering a visual snapshot of key metrics based on data from the Sales Log.

Key Metrics Displayed:

• Total Revenue (Last 7 Days)
• Total Confirmed Sales
• Average Deal Size
• Sales by Salesperson (Top 5)
• Monthly Revenue Trend

Recommended Charts:

• Column Chart: Monthly revenue trend (using data from the "Month/Year" column).
• Pie Chart: Sales by product/service distribution.
• Bar Chart (Horizontal): Top-performing salespeople by total confirmed sales.

Formulas in Dashboard:

• =SUMIFS(SalesLog[Revenue], SalesLog[Date], ">= "&TODAY()-7, SalesLog[Status], "Confirmed") – 7-day revenue.
• =COUNTIFS(SalesLog[Status], "Confirmed") – Total confirmed sales.
• =AVERAGEIF(SalesLog[Status], "Confirmed", SalesLog[Sale Amount]) – Average deal size.
• =SUMIFS(SalesLog[Sale Amount], SalesLog[Salesperson], "John Smith", SalesLog[Status], "Confirmed") – Individual performance (dynamic with cell references).

SHEET 3: INSTRUCTIONS & TIPS – User Guidance

This sheet provides onboarding and best practices for using the Simple Operations Dashboard – Sales Tracker:

• Always enter data in the "Sales Log" starting from Row 2.
• Use dropdowns in D, G, and H to maintain data consistency.
• Do not delete or rename columns—this breaks formulas.
• To update charts: Right-click chart → "Select Data" → Adjust range if needed.
• Monthly summaries are automatically calculated; no manual input required.

EXAMPLE ROWS IN SALES LOG

CLOSING NOTES ON SIMPLICITY AND PURPOSE

This template embodies a truly Simple design philosophy—no complex macros, no hidden scripts. Every element is purpose-built for the dual role of an Operations Dashboard and a practical Sales Tracker. It's ideal for startups, freelancers, or small teams that need to track sales performance efficiently while maintaining operational transparency. Its modular design ensures scalability: as your business grows, you can expand the dashboard with additional KPIs without losing simplicity.

Download this template today and start tracking your sales success with clarity, confidence, and zero clutter.