Bring monthly recruiting activity into one structured Excel view so you can follow hiring volume, funnel movement, placement results, hiring speed, and recruiting-channel signals without rebuilding charts for each review.
The workbook is designed around a simple workflow: define general settings, enter monthly recruiting KPI data, and review the selected month on the dashboard. It is suited to HR and recruiting teams that want a consistent way to organize measures such as open positions, active candidates, interview stages, offers, placements, commissions, days to hire, placement rate, decline reasons, and application sources.
Track recruiting throughput
Follow open positions, new roles, active candidates, interviews, offers, and candidates placed to see how work moves through the hiring process.
Review hiring speed and placement
Use days to hire and placement-rate views alongside monthly activity to spot changes in recruiting efficiency over time.
Compare recruiting signals
Review application sources, candidate and client decline reasons, and the recruitment funnel to identify where closer investigation may be useful.
What this template helps you analyze
The dashboard brings operational recruiting measures together so managers can review activity and outcomes in the same monthly context. Rather than treating one KPI in isolation, the workbook makes it easier to compare workload, funnel progression, speed, placement results, and source information before deciding where to focus recruiting attention.
Hiring demand and workload: review open positions, new roles, total roles, and active candidates for the selected reporting month.
Time to hire: monitor the days-to-hire measure alongside other monthly recruiting KPIs.
Placement and commission measures: view candidates placed, placement rate, total commission, and average commission amount.
Source and decline patterns: review application-source counts plus candidate and client decline reasons to see where outcomes differ.
What is inside the workbook?
The workbook separates general setup, monthly KPI entry, and visual review. The visible instructions identify colored cells for values and separate calculation cells that are not intended for routine editing. The dashboard can then be changed by month so the same KPI framework supports repeated reporting across the year.
General settings
Set the year start month, reporting year, and company name before entering operating data.
Monthly KPI inputs
Enter recruiting measures by month across the year, with totals or summary values shown in the KPI data table.
Dashboard outputs
Review KPI cards, trend lines, funnel stages, decline-reason charts, replacement rate, and application-source visuals for the selected month.
The KPI Data worksheet organizes recruiting measures by month, including roles, candidate activity, interview stages, offers, placements, commission metrics, days to hire, and placement rate.
Enter the recruiting data that drives the view
The input table provides a consistent monthly structure from January through December. This is where the team records the operating measures that feed reporting, making it easier to keep the same definitions and review format from one month to the next.
The dashboard combines monthly KPI cards with recruiting-funnel stages, decline reasons, replacement rate, declined applications, and application-source counts.
Review the selected month in one dashboard
The dashboard places high-level recruiting counts next to diagnostic views. Managers can compare open positions, active candidates, placements, days to hire, and commission figures while also seeing where candidates sit in the funnel and which sources or decline categories are appearing.
The Settings worksheet contains the year start month, reporting year, and company name fields used to establish the workbook context.
Set the reporting context first
The Settings view keeps basic workbook parameters separate from recurring KPI entry. Establishing the reporting year and start month first helps keep the monthly dashboard aligned to the period the team intends to review.
How do you use the template?
Complete the settings
Enter the year start month and year, and add the company name if you want it displayed in the workbook.
Enter monthly KPI values
Use the designated input cells to record recruiting activity, funnel stages, placements, commissions, hiring speed, and placement rate.
Open the dashboard
Select the month you want to review and read the KPI cards and charts together rather than relying on a single measure.
Investigate changes
Use funnel stages, application sources, decline reasons, and monthly KPI movement to identify where the recruiting process deserves a closer operational review.
Who is this template for?
This workbook is appropriate for HR leaders, recruiters, talent-acquisition teams, people managers, staffing or placement teams, and business owners who already collect recurring recruiting data and want a structured Excel dashboard for monthly review. It is especially useful when the team needs to discuss candidate flow, open roles, hiring speed, placements, recruiting sources, and decline reasons in a common reporting format.
For a broader people-measurement view, the HR Metrics Dashboard is a relevant companion. Teams working more directly with payroll administration may also use the Excel Payroll Calculator, while the Payroll Time Calculator can support time-based payroll calculations alongside recruiting reporting.
Choosing a selection results in a full page refresh.
