Employee Onboarding Checklist Template for Excel: Tasks by Phase, Owners, Auto-Calculated Deadlines and Progress
Build an employee onboarding checklist in Excel or Google Sheets for a small business: tasks before day one, on day one, week one and through 30/60/90 days, owners, deadlines calculated from the start date with WORKDAY, overdue flags and percent complete, with a worked example.
An employee onboarding checklist template lists everything that has to happen for a new hire to start well — before day one, on day one, in week one and through the 30-, 60- and 90-day marks — with an owner for each task and a deadline calculated automatically from the start date. A status column and a percent-complete cell show at a glance what is still open. In a small business without an HR team, it prevents the classic misses: a laptop that isn’t ready, an account nobody requested, a form with a legal deadline.
This guide is part of Onboarding & Staff Records. Once the new hire is settled, scheduling and hours live in the employee schedule template and the timesheet template.
Template structure
| Column | Content | Formula |
|---|---|---|
| A – Phase | Before start, Day 1, Week 1, 30 days, 60 days, 90 days | — |
| B – Task | Specific action | — |
| C – Owner | HR, IT, manager, payroll… | — |
| D – Offset | Days from start date (negative = before) | — |
| E – Due date | Calculated | =$B$1+D2 |
| F – Status | Not started, In progress, Done | dropdown |
| G – Flag | Overdue or due soon | =IF(F2="Done","",IF(E2<TODAY(),"OVERDUE",IF(E2-TODAY()<=3,"Due soon",""))) |
B1 holds the start date. When a deadline must land on a business day, replace the formula in E: =WORKDAY($B$1,D2,Holidays!A:A) counts business days, and =WORKDAY($B$1+D2-1,1,Holidays!A:A) moves a calendar-day deadline to the next business day if it falls on a weekend or holiday.
Percent complete: =COUNTIF(F:F,"Done")/COUNTA(B2:B50). Save the sheet as a master, copy it for every hire, and change only B1.
Paperwork with legal deadlines (U.S.)
A few onboarding tasks have deadlines set by law, not by preference. In the United States, the employee completes Section 1 of Form I-9 no later than the first day of work, and the employer completes Section 2 within three business days of that first day; federal law also requires new-hire reporting to the state, generally within 20 days of hire, and many states set shorter deadlines. Tax withholding forms (Form W-4 and any state equivalent) and payroll setup belong in week one. Rules change and vary by state, so confirm current requirements with official sources or your payroll provider; the checklist simply makes sure nothing is forgotten.
Worked example: new hire starting Monday, November 16, 2026
A sales coordinator joining a small company. Status reviewed Friday, November 6:
| Phase | Task | Owner | Due | Status |
|---|---|---|---|---|
| Before start | Send welcome email with first-day details and documents to bring | HR | Fri 11/6 | Done |
| Before start | Order laptop and phone | IT | Mon 11/9 | In progress |
| Before start | Create email, chat and CRM accounts | IT | Wed 11/11 | Not started |
| Before start | Prepare 30-60-90 plan and assign an onboarding buddy | Manager | Fri 11/13 | Not started |
| Day 1 | Form I-9 Section 1 completed by employee | HR | Mon 11/16 | Not started |
| Day 1 | W-4, state withholding form, direct deposit | HR / payroll | Mon 11/16 | Not started |
| Week 1 | Benefits overview and enrollment deadline explained | HR | Wed 11/18 | Not started |
| Week 1 | Form I-9 Section 2 — review documents | HR | Thu 11/19 (3 business days) | Not started |
| Week 1 | New-hire report to the state | Payroll | Fri 12/4 (day 20 is a Sunday; file earlier if your state requires) | Not started |
| 30 days | 30-day check-in | Manager | Wed 12/16 | Not started |
| 60 days | 60-day review against the plan | Manager | Fri 1/15/2027 | Not started |
| 90 days | 90-day review and goals for the next quarter | Manager | Tue 2/16/2027 | Not started |
Progress: 1 of 12 tasks (8%). Day 90 falls on Sunday, February 14, 2027, and Monday the 15th is Washington’s Birthday, so with the holiday list in place WORKDAY moves the review to Tuesday, February 16. Thanksgiving (November 26) sits inside the first two weeks — worth remembering when planning training sessions. With ten days to go, the critical path is equipment and accounts by Wednesday the 11th.
Views for each owner
A PivotTable with Owner in rows and Status in columns shows who has what. In Excel 365, =FILTER(B2:F13,(C2:C13="IT")*(F2:F13<>"Done")) lists IT’s open items — easy to paste into a message.
Good practices
- One master template covering every role, then delete what doesn’t apply.
- Concrete tasks: “Create CRM user with sales permissions” rather than “give access”.
- A buddy assigned before day one, and a lunch on the calendar.
- Ask for feedback at 30 days and improve the master template.
- Keep sensitive data out: Social Security numbers, I-9 documents and bank details belong in secure HR and payroll systems, not in a shared checklist.
- Lock formulas using how to protect formulas in Excel.
FAQ
Can it handle offboarding?
Yes — put the last day in B1 and list tasks such as recovering equipment, revoking access, final paycheck and exit interview, with negative and positive offsets.
How do I run several new hires at once?
Add a “Person” column, combine all rows in one table and filter by person or owner.
Does it work in Google Sheets?
Yes. WORKDAY, COUNTIF, FILTER and dropdowns all work the same.
Next step: list the tasks from your last hire with owners and offsets, save it as the master, and for the next hire change only the start date.