Standard Operating Procedure: Sales Pipeline Tracking

This Standard Operating Procedure (SOP) outlines the mandatory protocols for maintaining the Sales Pipeline Tracking Spreadsheet. An accurate, real-time pipeline is the operational backbone of our revenue organization; it ensures precise forecasting, identifies bottlenecks in the sales process, and allows management to allocate resources effectively. Adherence to this procedure is required for all sales representatives and account executives to maintain data integrity and organizational visibility.

Phase 1: Data Entry and Lead Qualification

• Initial Entry: All new opportunities must be logged within 24 business hours of discovery or inbound inquiry.
• Standardized Fields: Ensure all columns (Client Name, Contact Information, Lead Source, Estimated Deal Value, and Close Date) are populated correctly using the predefined dropdown menus.
• Qualification Status: Assign a qualification stage (e.g., Prospecting, Discovery, Proposal, Negotiation, Closed Won/Lost) based strictly on our current definitions of "Exit Criteria" for each stage.
• Next Steps: Every entry must include a concrete "Next Action" and a "Due Date" in the corresponding columns.

Phase 2: Ongoing Maintenance and Hygiene

• Weekly Audit: Every Friday by 4:00 PM, all users must review their active opportunities to ensure status, deal size, and close dates are current.
• Stage Advancement: Never move a deal to the next stage unless the corresponding documentation (e.g., sent proposal, completed contract) has been uploaded to the CRM or shared folder.
• Lost Deal Analysis: If a deal is marked "Closed-Lost," you must select a "Loss Reason" from the dropdown (e.g., Price, Competitor, Budget, Timing) to assist in future strategy.
• Pipeline Cleansing: Stagnant deals (no contact in 30+ days) must be moved to "Nurture" or "Closed-Lost" to ensure the active pipeline reflects realistic revenue.

Phase 3: Reporting and Forecasting

• Weighted Value Calculation: Ensure the "Weighted Revenue" column is functioning correctly, as this is the primary metric for monthly and quarterly forecasting.
• Risk Flagging: If an opportunity is at risk of slipping, use the "Risk Level" column (High, Medium, Low) and add a brief comment explaining the blocker in the "Notes" section.
• Manager Review: Updates must be finalized prior to the Monday morning Sales Meeting to ensure the dashboard accurately reflects the current status of the team.

Pro Tips & Pitfalls

• Pro Tip (Data Integrity): Use "Data Validation" in Excel/Google Sheets to restrict cells to dropdown lists. This prevents manual entry errors and makes filtering data much easier.
• Pro Tip (Visibility): Set up conditional formatting to turn cells red if a "Next Action" date has passed. This acts as a visual prompt to ensure no leads are neglected.
• Pitfall (Optimism Bias): Avoid the tendency to inflate deal sizes or keep "dead" deals in the pipeline to make figures look better. An inflated pipeline leads to poor business decisions and missed targets.
• Pitfall (The "Silo" Trap): Failing to share updates with the marketing or customer success teams via the notes field creates disconnects. Keep the sheet transparent for all relevant stakeholders.

Frequently Asked Questions (FAQ)

Q: What do I do if I’m not sure which stage a prospect belongs in? A: Refer to the "Sales Playbook" document linked in the spreadsheet header. If the scenario is not covered, consult your direct manager before updating the stage.

Q: Should I delete rows for deals that have been lost for more than a year? A: Do not delete historical data. Instead, move completed/lost deals to an "Archive" tab within the workbook to keep the active pipeline clean while maintaining access to historical records.

Q: How often should I update the estimated value of a deal? A: You should update the value as soon as you have more accurate information from the client. Never wait until the end of the month to correct a deal size that has changed significantly.