Onboarding Admin Time Per Hire
HR admin time per new hire dropped from 4 hours to 1.5 hours - most of which is now reviewing automated status rather than chasing task owners manually.
Case study
Zero Missed IT Setups: HR Onboarding Tracker That Cut New-Hire Admin by 60%
A fast-growing services firm was onboarding 4-8 new hires per month via email chains and printed checklists. IT setups were missed, access provisioning was delayed, and new hires arrived on Day 1 to find their laptop not ready. An Excel onboarding tracker with automated task reminders changed the outcome.
Missed IT Setups Since Deployment
Zero. Automated daily reminders to IT flag every setup task due within 48 hours - ending the recurring problem of new hires arriving to unprovisioned equipment.
New Hires Tracked Simultaneously
Dashboard tracks up to 20 concurrent onboarding journeys across all departments - HR sees every active new hire's progress and risk status at a glance.
Task Owner Accountability
Every task has an assigned owner and a due date. Automated reminders fire to the specific owner - not a general HR inbox. IT, managers, and department heads are all in the loop.
Day 1 Readiness Rate
Fully provisioned on Day 1 increased from 68% to 97% - tracked over the 6 months post-deployment across 38 new hires.
Time to Create a New Hire Record
3 minutes. HR enters name, role, start date, and line manager. Task list generated from role template, due dates calculated, task owner emails dispatched automatically.
The Problem: Onboarding by Email Chain
This professional services firm was hiring 4-8 new staff per month across client-facing, technical, and support roles. HR managed each onboarding journey through a combination of email threads, printed checklists, and personal follow-ups.
There was no central visibility of where each new hire was in the process. If IT had not provisioned a laptop, HR found out when the new hire arrived. If a manager had not arranged building access, HR found out when the new hire was locked out. The information that would have prevented these problems - task status by owner - did not exist in a form anyone could see without emailing around.
The HR coordinator spent approximately 4 hours per new hire on onboarding administration - chasing IT, chasing the line manager, following up on documents, and updating the printed checklist after each call. As hiring volume increased, this was clearly unsustainable.
Three Failure Patterns That Repeated
IT Setups Missed Because Nobody Chased on Time
IT provisioning requires a lead time of 5 working days. If the request was not submitted by HR by day -5, the laptop was not ready on Day 1. HR was often submitting on day -3. The IT team had no visibility of upcoming starts without being told directly - they relied entirely on HR's email prompt.
Documents Not Collected Before Start Date
Right-to-work checks, signed contracts, and bank details had to be received before the new hire started. Without a tracked deadline, HR was often chasing these on the morning of Day 1 - creating compliance risk and a poor first impression for the new hire.
No Status View for the HR Manager
The HR manager had no way to see which new hires were on track and which were at risk without emailing the coordinator for an update. Decisions about when to escalate a late setup could not be made from data.
What We Built
We designed an Excel onboarding tracker with three components: a new hire intake form, a role-based task template library, and an automated reminder engine.
When HR creates a new hire record - name, role, start date, department, line manager - the tracker generates the task list from the matching role template. Each role has a defined set of onboarding tasks with category labels (IT Setup, HR Documents, Equipment, System Access, Training), assigned owner roles, and lead-time rules that calculate due dates backward from the start date.
The HR manager dashboard shows all active onboarding journeys with completion percentage, overdue task count, and a Day 1 readiness indicator - green when all Day 1 critical tasks are complete, amber when one or more is at risk, red when one or more is overdue.
A VBA routine runs each weekday morning via Windows Task Scheduler. It identifies tasks due today or overdue, looks up the task owner's email address from the owner register, and sends a targeted Outlook email - naming the specific new hire, the task, and the original due date. Task owners are accountable to their own inbox, not to a general HR chase.
Tracker Capabilities
Role-Based Task Templates
Different task sets for different roles - technical staff, client-facing roles, and support functions each have tailored onboarding checklists. New role templates added in minutes.
Automatic Due Date Calculation
Task due dates calculated from start date minus lead time rules. IT provisioning request flagged 7 working days before start - not after it's too late.
HR Manager Progress Dashboard
All active new hires visible with completion percentage, overdue count, and Day 1 readiness status. At-risk onboarding journeys visible before they become Day 1 problems.
Automated Daily Reminder Emails
VBA engine sends targeted reminders to task owners for overdue and due-today tasks. IT, managers, and HR each receive only their relevant tasks - not a general reminder.
Document Collection Tracker
Right-to-work, signed contract, bank details, and DBS checks tracked separately with compliance deadline flags. Outstanding documents escalated automatically on the day before start date.
Offboarding Checklist (Included)
Mirror offboarding module for resignations and terminations. Same reminder engine monitors access revocations, asset returns, and final payroll items.
After Go-Live: What Changed
In the six months after deployment, 38 new hires were onboarded through the tracker. Day 1 full provisioning rate was 97% - up from 68% in the comparable period before. The two misses in that period were caused by late start date changes communicated to HR after tasks had already been triggered, not by task tracking failures.
HR admin time per hire dropped from 4 hours to 1.5 hours. Most of the remaining time is the initial record creation (3 minutes) and a daily review of the dashboard to check for escalations. Manual chasing calls to IT and line managers effectively stopped - automated reminders handle the follow-up.
The HR manager now sees a real-time view of the onboarding pipeline without asking the coordinator for status. At-risk journeys are identifiable a week in advance - early enough to escalate and resolve before they affect Day 1 experience.
“We used to have new hires show up and discover their laptop wasn't ready or their access hadn't been set up. It was embarrassing. Now I can see every open task across all our new starters at a glance, and IT get a reminder automatically when they need to act. We haven't had a Day 1 setup failure since we deployed this.
Tech Stack
Excel VBA - onboarding record creation, task list generation, dashboard rebuild, and reminder engine
Role template library - structured task sets per role type with configurable lead-time rules and owner assignments
Outlook object model integration - targeted daily reminder emails to task-specific owners
Windows Task Scheduler - daily morning trigger for automated reminder dispatch without manual intervention
Offboarding module - mirrored checklist engine for employee exits including access revocation and asset return tracking
Frequently Asked Questions
How does the Excel onboarding tracker send reminder emails automatically?
A VBA routine runs each morning via Windows Task Scheduler. It checks the task due dates in the onboarding tracker for every active new hire, identifies overdue and due-today tasks, and sends a targeted Outlook email to the task owner - IT for setup tasks, HR for document collection, the line manager for equipment and access requests. The email names the specific new hire, the overdue task, and the due date. No manual review needed - owners are chased automatically.
Can the same tracker be used for offboarding?
Yes - the toolkit includes a separate offboarding checklist template that mirrors the onboarding structure. When a resignation or termination is processed, HR creates an offboarding record linked to the employee profile. The same reminder engine monitors offboarding task deadlines - IT asset return, system access revocation, final payroll items, and knowledge transfer sessions. This client reduced missed access revocations from a recurring audit finding to zero.
What does the HR dashboard show?
The dashboard shows every active onboardee with an overall completion percentage, a breakdown of tasks by category (IT setup, HR documents, equipment, system access, training), tasks overdue, tasks due this week, and an estimated Day 1 readiness score. The HR manager uses this to identify at-risk onboarding journeys - new hires where IT setup is lagging and likely to affect Day 1 productivity - rather than discovering the problem when the new hire arrives.
How long does it take to create a new hire onboarding record?
About 3 minutes. HR enters the new hire's name, role, start date, department, and line manager. The system generates the task list from the role template - different roles have different task sets; a software engineer needs different access provisioning than a field sales rep. Task due dates are calculated automatically based on the start date and lead time rules. The task owners receive their assignments by email within minutes of the record being created.
Next step
Want similar results in your operations?
Book an Automation Opportunity Assessment. We map workflows and scope a practical build plan.
- No Onsite Visit Required
- No Technical Specification Required
- Assessment Before Commitment
- Clear Scope Before Work Begins
Questions before you book? Speak with our team at +1 385 386 3860
