A pipeline aging report shows how long opportunities remain in a stage and which buyer decision is holding them there. It helps a small sales team distinguish active evaluation from a deal that survives only in the forecast.
Download the editable CSV worksheet. Open it in your spreadsheet application, keep the instructions, and complete the blank entry, owner, due date, and evidence columns. This is a blank planning tool; the example below is illustrative.
When to use this worksheet
Use it with the manager who owns this workflow and one person who performs the work. Bring a recent completed case and a recent exception. Compare the worksheet with those records before adopting it as a team standard. If an existing system already stores these details, use its fields rather than maintaining two competing records.
Template fields and completion checklist
| Field | What to record |
|---|---|
| Opportunity | Use a stable identifier and account name. |
| Stage entry date | Preserve the date when stage evidence was first met. |
| Days in stage | Calculate from the entry date using one reporting convention. |
| Buyer next step | Name the buyer action needed to progress. |
| Seller commitment | Record the owner and dated follow-up. |
| Disposition | Advance, hold with reason, nurture, or close with reason. |
How to put the process into practice
Group opportunities by stage and deal type. A complex implementation and a repeat purchase should not share one arbitrary aging threshold.
Review older opportunities against documented buyer evidence. Ask what changed since the last review and who owns the next decision.
Remove unsupported close dates and record an honest disposition. Use the history to revise qualification and stage definitions.
Worked example
Illustrative example: a proposal has been open for 45 days. The seller reports enthusiasm, but the buyer has not confirmed a budget owner or review date. The manager moves it out of the near-term forecast and schedules a qualification conversation. Age triggers investigation; it does not automatically prove the deal is lost.
Common mistake to avoid
Resetting stage dates to make a report look healthier hides the bottleneck. Preserve meaningful history and record why an opportunity re-entered a stage.
What to measure after implementation
Track stage duration, repeated close-date slips, and conversion by opportunity cohort. Review closed losses as well as wins to avoid a biased cycle-time estimate.
Review the first completed worksheet
Before expanding this process, have the responsible manager check one completed record against the original evidence. Confirm that another team member can understand the next action without asking the author to explain it. Record any missing information as a revision to the worksheet. Choose a review date based on how often the workflow runs; a weekly process gives feedback sooner than a quarterly one.
Related templates and implementation support
- Sales to Operations Handoff Checklist for Service Firms
- CRM Data Cleanup Checklist Before Sales Automation
- Lead Response Time SLA Template for Small Sales Teams
- Browse all business templates and checklists
Elixir Consulting Group helps owner-led businesses install practical systems. Explore sales systems consulting or book a consult to discuss the workflow your team needs to improve.
