Pipeline Recovery Group · Structural Analysis · Revenue Risk Framework™ v1.3 · Last Updated: March 2026
What a CRM Audit Checklist Does
A CRM audit checklist evaluates the structural reliability of pipeline data across five domains: data completeness, temporal consistency, pipeline structure, contact-deal alignment, and activity patterns. Unlike a data cleaning exercise, a structural audit measures whether the CRM reflects commercial reality — not just whether fields are populated.
Before You Start
What you need:
- A deals CSV export from your CRM — deals table with amount, owner, close date, stage, and activity timestamp columns
- Optionally, a contacts CSV export to evaluate contact-deal associations
What you don't need:
- CRM login or administrative access — CSV export is sufficient
- API credentials or integrations
- Database access or specialized technical tools
The CSV-only approach is a feature: you audit the same data your reports are built from, using the same export format you use for analysis. No proprietary integrations, no sync delays, no data transformation overhead.
The Checklist
Data Completeness
Are monetary values populated on open deals?
Deal amounts are the foundation of revenue forecasting. Missing or zero amounts inflate deal count while deflating revenue visibility, and prevent sizing-based analysis like concentration risk assessment.
Failure looks like: 15%+ of open pipeline by count with zero or missing amount fields; round-number placeholder amounts ($50K, $100K) on a material proportion of deals.
Do deals have assigned owners?
Owner assignment is the link between records and commercial responsibility. Unassigned or orphaned deals cannot be attributed to a specific person or team, which breaks accountability structures and territory analysis.
Failure looks like: 10%+ of open pipeline assigned to a default/team account rather than a named rep; unassigned deals in active pipeline stages.
Are close dates present on deals in active stages?
Close dates anchor pipeline timing and enable forecast calculations. Deals in late-stage positions without close dates indicate either incomplete data entry or deals advancing without a defined closure target.
Failure looks like: Proposal-stage or later deals with missing close dates; >5% of open pipeline lacking close dates across all stages.
Do contacts have associated company or account records?
Contact-to-company association enables organization-level analysis, prevents duplicate work, and improves handoff clarity across the team. Orphan contacts without company relationships fragment account coverage and create hidden duplication.
Failure looks like: 20%+ of contacts in the export without a company_id or account_name field; multiple contacts from the same company listed independently without association.
Temporal Integrity
Are close dates in the future for deals marked as open?
Open deals carrying past close dates create forecast distortion by appearing in near-term revenue windows while being, structurally, stalled or unresolved. This is a primary source of forecast volatility.
Failure looks like: >15% of open pipeline with close dates in the past; large deal values with close dates passed 30+ days ago.
Have close dates been updated in the last 90 days?
Close dates that remain static for extended periods (beyond normal deal velocity) indicate stalled commercial relationships. When close dates stop moving but deals remain open, the data is no longer reflecting active engagement.
Failure looks like: High-value deals with close date last-update timestamps older than 90 days; stage assignments and close dates moving in opposite directions (stage progressed but close date unchanged).
Is there evidence of close date drift (repeated date pushes)?
Close date drift — where the same deal has multiple historical close dates, each pushed forward at some point — indicates deals advancing through the pipeline without corresponding commercial signal changes. It surfaces deals that are perpetually "about to close."
Failure looks like: Deals with close date history showing 3+ revisions over a 6-month period, all pushed forward; patterns of close date resets at period-end.
Pipeline Structure
Do deals progress through stages in a logical sequence?
Pipeline stages define expected deal progression. Deals that appear in the export in a non-sequential order, or that have backwards transitions without corresponding stage names, indicate either data entry errors or stage definitions that have drifted from their original meaning.
Failure looks like: Deals in "Closed Won" stage with stage transition history showing backwards moves; stage names that are ambiguous or not in a standard sales sequence (e.g., "Qualified" before "Initial Contact").
Are deals distributed across stages (not clustered at entry/exit)?
Healthy pipelines show reasonable distribution across stages. Heavy clustering at entry (Prospecting) or exit (Proposal/Negotiation) suggests either filtering, reporting scope issues, or deals that are not moving through the pipeline as expected.
Failure looks like: >50% of open deals in a single stage; early-stage deals representing <10% of pipeline count; no deals in middle stages.
Do stage positions correlate with deal age?
Pipeline velocity expectations assume that later-stage deals are newer or moving faster than early-stage deals. Deals in early stages that are 6+ months old suggest stalled prospecting. Deals in late stages created 1+ months ago suggest delays in the sales cycle.
Failure looks like: Large deals in Prospecting stage created 120+ days ago with no stage movement; recently created deals in late stages without corresponding close date proximity.
Contact-Deal Alignment
Do deals have associated contacts?
Contact associations anchor deals to specific relationships and decision-makers. Deals without contact associations suggest records that are incomplete or entered prematurely. Accounts can have multiple deals across multiple contacts; each deal should have at least one associated contact.
Failure looks like: 25%+ of open deals with no associated contact record; entire accounts with multiple deals but no linked contacts across any of them.
Is there meaningful overlap between contact and deal ownership?
When a deal is assigned to one rep and all associated contacts to a different rep, it creates handoff ambiguity and ownership disputes. Contact ownership should align with deal ownership or be intentionally transferred.
Failure looks like: Deals with a primary owner whose name appears on fewer than 30% of associated contact records; systematic cross-ownership patterns suggesting teams are not aligned on account structure.
Activity & Engagement
Do open deals show activity within the last 30 days?
Open deals without recent activity are stalled relationships. The 30-day threshold assumes that active commercial conversations would produce at least one logged interaction (call, email, meeting, activity note) per month. Deals beyond this window are either genuinely stalled or not being tracked in the CRM.
Failure looks like: >30% of open pipeline with no logged activity in 30+ days; large-value deals in late stages (Proposal+) with no activity in 60+ days.
Is there evidence of recent engagement on high-value opportunities?
High-value deals carry forecast weight disproportionate to their volume. These deals should show consistent engagement. Deals above a materiality threshold (e.g., >$100K) without activity in 30+ days indicate either lost focus or data entry gaps at the point of highest forecast impact.
Failure looks like: Deals valued above your typical annual per-rep quota with no logged activity in 60+ days; high-value deals in Proposal/Negotiation stages with activity timestamps more recent than their last stage change (suggesting activity not tied to stage progression).
What the Checklist Tells You
If 3 or more items fail across multiple domains, structural exposure is likely present in your pipeline. A single failure in one domain can be data-entry noise or an isolated condition. Multiple failures across domains indicate systematic structural degradation — the gap between what the CRM reports and what commercial activity is actually occurring is meaningful.
This checklist identifies observable symptoms; a formal diagnostic quantifies the financial impact. The checklist is qualitative — yes/no observations. A structural CRM audit is quantitative — it assigns exposure scores, identifies which percentage of pipeline is affected, and models the dollar impact of each structural condition.
The Automated Alternative
Running through this checklist manually takes 45–90 minutes per CRM export and requires someone with access to both the raw data and the CRM system. A structural assessment that evaluates all five domains automatically takes 2 minutes.
PRG's free Revenue Risk Score applies this same checklist framework across all five structural domains automatically — upload a standard CRM export (deals + optionally contacts), receive a structural classification, and see the specific findings in your pipeline within seconds. No login, no integration, no analysis labor.
Use this checklist manually as a preliminary assessment, or run the automated version to get a complete structural evaluation with quantified findings and financial impact estimates.
Next Steps
If your checklist reveals multiple failures: A formal diagnostic applies quantitative analysis to these same observations, producing a report with financial estimates, control recommendations, and prioritized recovery steps. The diagnostic is delivered in 48–72 hours and includes a 90-day implementation architecture if you order the complete package.
If your checklist is clean but you want confidence: Run an automated structural assessment to verify the findings and get versioned documentation you can present to leadership or use as a baseline for comparison audits later.
The structural conditions evaluated in this checklist affect how reliably your pipeline can be used for forecasting and planning. A checklist pass means your CRM is structurally sound. A checklist fail means the gap between reported pipeline and commercial reality is wide enough to affect decision quality.
Run a free structural assessment →
What is a CRM Audit? →