Requisition Aging Report – Open Roles by Days Open
Track open roles by days open, aging bucket, and owner so recruiting teams can spot stalled requisitions before they slow hiring. This report template turns raw requisition data into a clear prioritization view.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Technology · Healthcare · Manufacturing · Retail · Professional Services
Overview
The Requisition Aging Report – Open Roles by Days Open template helps recruiting teams see which requisitions have been open the longest, who owns them, and what needs action next. It is designed for weekly or biweekly recruiting operations reviews, leadership updates, and hiring manager check-ins where speed, visibility, and accountability matter.
Use this template when you need a simple, repeatable way to prioritize open roles, identify stalled approvals, and separate truly hard-to-fill jobs from roles that are delayed by process issues. It is especially useful when multiple recruiters, departments, or locations are hiring at once and the team needs one shared view of aging by requisition. The template can also support reporting by role level, employment type, remote ok status, and department so you can compare like with like.
Do not use days open as a standalone performance score. A role may be aged because it is niche, undercompensated, waiting on approval, or paused for business reasons. This report works best when paired with stage, owner, and next action fields so the team can tell the difference between normal cycle time and a real bottleneck. If your process is still changing every week, lock the definitions first before using the report for leadership decisions.
Standards & compliance context
- Keep requisition notes factual and job-related so the report supports EEOC and OFCCP-aligned hiring practices without introducing subjective bias.
- Use the report to document essential functions, role level, and required skill gaps when a requisition is stalled, but do not use it to justify discriminatory screening criteria.
- If the report is used for exempt or non-exempt hiring decisions, make sure the underlying requisition data aligns with FLSA classification and local wage-hour rules.
- For jurisdictions that require pay transparency, include a salary range with min, max, and type so open roles are not tracked without required compensation context.
- If the report feeds hiring manager reviews, keep access limited to authorized users and avoid exposing candidate or employee PII.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
How to use this template
- 1. Export or enter each open requisition with its open date, owner, department, role level, employment type, location, and current stage.
- 2. Calculate days open and assign each role to a consistent aging bucket such as 0-7, 8-14, 15-30, or 30+ days.
- 3. Add a next action field for each requisition so the report shows what should happen before the next review meeting.
- 4. Review the report with recruiting, finance, and hiring managers to confirm which roles are moving, paused, or need escalation.
- 5. Update the report on a fixed cadence and close out filled, canceled, or on-hold requisitions so the aging view stays accurate.
Best practices
- Use one aging definition across all teams so a role opened 21 days ago is treated the same way in every report.
- Sort the report by days open and then by priority so the oldest roles do not hide behind lower-impact requisitions.
- Include the current stage and owner on every row so the report drives action instead of just counting open jobs.
- Separate paused requisitions from active requisitions so business holds do not distort your aging analysis.
- Review aging by role level and employment type because executive, contract, and part-time searches often follow different timelines.
- Flag roles with missing salary range, location, or remote ok status because incomplete requisitions often age for avoidable reasons.
- Use factual notes only, such as waiting on approval or interview feedback, to avoid subjective language that can create bias risk.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What does this requisition aging report template include?
This template is built to show open roles by days open, aging bucket, recruiter or hiring manager owner, department, location, and current stage. It also gives you room for notes, next action, and priority flags so the report is useful for follow-up, not just counting. Use it to identify which requisitions need escalation, refresh, or approval review.
Who should run this report?
Recruiting operations, talent acquisition leadership, or an HR analyst usually owns it because they can interpret both the data and the workflow. Recruiters and hiring managers can also use it as a shared working report if ownership is clear. The key is assigning one person to maintain the cadence and chase updates.
How often should the report be updated?
Weekly is the most common cadence for active hiring teams, with daily updates for high-volume recruiting or urgent hard-to-fill roles. If your process is slower or more centralized, a biweekly review may be enough. The template works best when the update schedule matches how often decisions are actually made.
What counts as an aging role in this template?
Aging is usually measured from requisition open date to today, then grouped into buckets such as 0-7, 8-14, 15-30, and 30+ days. You can adjust the thresholds to match your hiring cycle, but the point is to make delays visible. A role can be old for legitimate reasons, so the report should pair age with stage and owner context.
How does this help with compliance or fair hiring practices?
The report supports process discipline by making it easier to review stalled requisitions, missing approvals, and inconsistent handling across roles. It does not replace EEOC, OFCCP, or internal hiring controls, but it can help surface patterns that deserve review. If you use it for decision-making, keep notes factual and avoid subjective labels that could create bias risk.
What are the most common mistakes when using an aging report?
The biggest mistake is treating days open as the only signal, because some roles naturally take longer due to specialty, location, or compensation constraints. Another common issue is leaving owner fields blank, which makes follow-up impossible. Teams also forget to define aging buckets consistently, which makes trend comparisons unreliable.
Can I customize the report for different departments or job families?
Yes, and you should. Add fields for department, job family, role level, employment type, location, and remote ok so the report reflects how your hiring process actually works. You can also create separate views for exempt and non-exempt roles, or for high-priority business units.
How does this compare with ad hoc spreadsheet tracking?
Ad hoc tracking usually breaks down because each recruiter measures aging differently and no one trusts the numbers. This template gives you a repeatable structure for the same fields every time, which makes it easier to compare roles, spot bottlenecks, and report upward. It also reduces the chance that important stalled requisitions get buried in email or chat.
Can this template connect to ATS or reporting tools?
Yes. It works well as a reporting layer fed by ATS exports, BI dashboards, or a shared spreadsheet that recruiters update after weekly pipeline reviews. If you integrate it with your ATS, keep the template fields aligned to your system so open date, stage, owner, and status stay consistent.
Related templates
Go deeper on the topic
-
Discover proven strategies to motivate retail employees—from recognition and communication to mobile-first training tools that drive engagement and reduce...
-
Healthcare employee engagement ideas to reduce burnout, boost retention, and improve patient outcomes in your health system.
-
10 strategies to reduce burnout among retail associates with smarter scheduling, training, and engagement tools that cut turnover and stress
-
Discover how a mobile-first employee app transforms retail staff training—streamlining onboarding, standardizing SOPs, and reaching every frontline worker.
Ready to use this template?
Get started with MangoApps and use Requisition Aging Report – Open Roles by Days Open with your team — pricing built for small business.
