CRM hygiene checklist for SaaS sales teams
A working checklist for keeping your pipeline data clean, accurate, and useful for forecasting and commission calculations.
Bad CRM data is one of the most expensive invisible costs in a SaaS revenue team. Stale deals inflate pipeline, missing fields break automation, and inaccurate close dates distort forecasts. Commission calculations are only as accurate as the deal data they pull from. This checklist covers the hygiene practices that make a CRM genuinely useful rather than a graveyard of historical activity.
Deal stage hygiene
- Every deal has a clearly defined next step and a next-step date
- No deal has been in the same stage for more than 30 days without a stage update or note
- Close dates are updated when the expected close changes — not left on the original estimate
- Deal stage definitions are documented and agreed by the team (not interpreted individually)
- Deals that have gone dark are moved to a separate nurture stage rather than left in an active pipeline stage
Required field completeness
CRM hygiene reviews consistently find that the same fields are missing across deals. For SaaS teams, the most commonly absent fields are:
| Field | Why it matters |
|---|---|
| ARR / ACV | Required for commission calculations and pipeline weighting |
| Close date | Required for period-accurate forecasting |
| Decision maker contact | Required for deal attribution and renewal tracking |
| Competitor | Required for win/loss analysis |
| Deal source / lead source | Required for marketing attribution |
Pipeline accuracy checks
- The sum of weighted pipeline in the current quarter aligns with the forecast model
- Deals are not counted in multiple periods simultaneously (e.g. expected to close this quarter but the close date is next quarter)
- Lost deals are marked as closed-lost with a reason — not deleted or left in pipeline
- Duplicate contacts and companies are merged monthly
- Multi-product deals are split correctly if commission rates differ by product
Commission-specific hygiene
If your commission calculations pull directly from CRM data (or via CSV export), specific hygiene practices matter more than general cleanliness:
- 1ARR values are final at close — any post-close adjustments are logged as amendments, not edits to the original deal
- 2Rep assignment is correct on every deal — split deals have attribution percentages recorded
- 3Deal type is accurate (new business vs. expansion vs. renewal) if commission rates differ
- 4Refunded or churned deals within the clawback window are flagged with a specific field or tag
- 5Multi-year deals have annual values recorded separately from total contract value
Watch out
Retroactive ARR edits are the most common cause of commission disputes. Establish a clear policy: once a deal closes, the ARR is locked unless an amendment process is followed with documentation.
Review cadence
CRM hygiene is a recurring process, not a one-time cleanup. Effective teams build reviews into their operating rhythm:
| Cadence | Review type |
|---|---|
| Weekly (deal review) | Next steps, stage accuracy, close date updates |
| Monthly | Required field completeness, deal deduplication |
| Quarterly | Full pipeline audit, lost-deal reason analysis, rep attribution review |
Tip
The best CRM hygiene programs make the reps responsible for their own data quality, with the manager's deal review serving as the accountability mechanism — not a RevOps team chasing fields after the fact.
Still calculating commissions in spreadsheets?
Join the waitlist for early access to the Toolsmith Commission Tracker plus free tools.