Free Staffing Plan Template, Example and Matrix
Six free staffing plan templates: a simple version, an annual plan and budget, a staffing matrix, a worked example, and two written plans. Excel and Word.
Staffing Plan Templates
Six staffing plan templates: a simple two-tab version, a full annual plan with gap analysis and budget, a staffing and skills matrix, a filled-in worked example, a written annual plan, and a build-from-zero plan for a new business. Editable Excel and Word files, no email form in the way.
Most staffing plan templates are a spreadsheet with Role, Department, and Start Date across the top. That part is easy. The hard part is the arithmetic underneath it: how many people you actually have when five of them are part-time, what a hire genuinely costs in its first full year rather than the months left in this one, and which of the roles on your list you can defend when the money is tight.
So there are six templates here. Four are Excel workbooks because the core of a staffing plan is arithmetic, and two are Word documents for the version you hand to a partner or a lender. One of the six is filled in completely for a fourteen-person business, with a second tab showing every calculation with the formula and a worked number. All free, no email form.
What a Staffing Plan Is
A staffing plan sets out how many people the business needs over a defined period, in which roles, by when, and at what cost. For most employers that period is the next twelve months, and the document is a spreadsheet rather than a strategy deck.
Its real job is to force two things into the open. The first is what is currently not getting done and who is absorbing it, which is usually the owner. The second is what each hire costs in a full year, as opposed to the months remaining in the current one. Plans that skip either become lists of roles nobody can defend in a tight quarter.
What Every Staffing Plan Includes
Nine elements, sorting into four groups. The first three are what most templates cover. The fourth is where plans either hold up or fall apart.
Two things get skipped almost universally. The what happens if we do not hire line is what turns a wish list into a plan, and it is the sentence you will want in front of you in a tight quarter. And the assumptions tab is what makes next year's plan possible, because without it you cannot tell whether the plan was wrong or the world was.
Which Template Should You Use?
Pick by how much planning you are actually doing. Three or four hires needs the simple version. A full year with a budget conversation attached needs the annual one.
6 Free Staffing Plan Templates
Download all six together as a zip file, or copy an individual template. Four are Excel workbooks and two are editable Word documents. Every number in them is illustrative and meant to be replaced, including the 25 percent placeholder used for payroll taxes and benefits.
Template 1: Simple Staffing Plan
Two tabs. The roles you need with a priority, a reason, a target start date and an owner, plus a budget tab that turns hours into FTE and pay into first-year cost. For a business planning three or four hires.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Priority | Role | Why now | New or backfill | Type | Hours per week | Target start | Pay range | Who owns the hire | Status |
| 2 | 1 | Office Manager | Owner is spending 12 hours a week on admin | New | Full-time | 40 | 2026-10-01 | $50,000 to $58,000 | Owner | Job description written |
| 3 | 2 | Delivery Driver | Replacing A. Rivera, leaving in September | Backfill | Full-time | 40 | 2026-09-15 | $21 to $24 per hour | Ops lead | Posting live |
| 4 | 3 | Weekend Counter Staff | Saturdays understaffed since May | New | Part-time | 16 | 2026-09-01 | $17 to $19 per hour | Store manager | Not started |
| 5 | 4 | Bookkeeper | Month-end close slipping past the 10th | New | Contract | 8 | 2027-01-05 | $45 per hour | Owner | On hold until Q1 |
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 |
Template 2: Annual Staffing Plan and Budget
Four tabs: current team with FTE and flight risk, gap analysis by department, a quarterly hiring plan that separates cost-this-year from full-year run rate, and an assumptions tab recording what you guessed.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Name or seat | Role | Department | Type | Hours per week | FTE | Started | Annual base | Flight risk | Notes |
| 2 | D. Okafor | Operations Lead | Operations | Full-time | 40 | 1 | 2021-03-01 | 68000 | Low | Five-year anniversary in March |
| 3 | M. Chen | Scheduler | Operations | Full-time | 40 | 1 | 2024-06-10 | 52000 | Low | |
| 4 | A. Rivera | Delivery Driver | Operations | Full-time | 40 | 1 | 2022-08-15 | 46800 | Leaving | Notice given, last day September |
| 5 | J. Park | Counter Staff | Retail | Part-time | 24 | 0.6 | 2025-02-03 | 24960 | Medium | Asked about full-time hours |
| 6 | Seat: Counter | Counter Staff | Retail | Part-time | 16 | 0.4 | 16640 | Open since May | ||
| 7 | Owner | Owner | Admin | Full-time | 40 | 1 | 2019-01-01 | 0 | Doing admin that should be delegated | |
| 8 | ||||||||||
| 9 |
Template 3: Staffing Matrix
A skills grid showing who can do what, with a count column flagging any task only one person can perform, and a shift coverage grid showing which day repeatedly comes up short.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Skill or task | D. Okafor | M. Chen | A. Rivera | J. Park | Owner | People who can do it | Risk |
| 2 | Open and close the shop | Yes | Yes | No | Yes | Yes | 4 | Low |
| 3 | Build the weekly schedule | Yes | Yes | No | No | Yes | 3 | Low |
| 4 | Run the delivery route | No | No | Yes | No | Yes | 2 | Medium |
| 5 | Month-end close | No | No | No | No | Yes | 1 | HIGH |
| 6 | Supplier ordering and returns | Yes | No | No | No | Yes | 2 | Medium |
| 7 | Handle an escalated customer | Yes | No | No | No | Yes | 2 | Medium |
| 8 | Payroll submission | No | No | No | No | Yes | 1 | HIGH |
| 9 | Train a new hire on the counter | Yes | Yes | No | Yes | Yes | 4 | Low |
| 10 | ||||||||
| 11 | Anything with only one Yes is a single point of failure. Cross-train it or write it down |
Template 4: Worked Example
A filled-in plan for a fourteen-person business: headcount against FTE, payroll and hiring cost, people cost as a share of revenue, plus a tab showing every calculation with its formula and a worked number.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Line | Today | End of next year | Change | Note |
| 2 | Full-time employees | 9 | 11 | 2 | Office manager and a driver backfill |
| 3 | Part-time employees | 5 | 6 | 1 | One weekend counter role added |
| 4 | Headcount total | 14 | 17 | 3 | The number people quote, and the least useful one |
| 5 | FTE total | 11.4 | 13.8 | 2.4 | Hours divided by 40, the number to budget from |
| 6 | |||||
| 7 | Base payroll | 612000 | 746496 | 134496 | |
| 8 | Payroll taxes and benefits at 25 percent | 153000 | 186624 | 33624 | Replace 25 percent with your real rate |
| 9 | One-off hiring costs | 0 | 4100 | 4100 | Job boards, background checks, equipment |
| 10 | Total people cost | 765000 | 937220 | 172220 | |
| 11 | |||||
| 12 | Revenue | 2400000 | 2640000 | 240000 | 10 percent growth assumed |
| 13 | People cost as percent of revenue | 31.9% | 35.5% | 3.6 pts | Rising. Either growth beats plan or a hire waits |
Template 5: Annual Staffing Plan (Written)
The Word version for a partner, a board, or a lender. Holds what the spreadsheet cannot: the goals, the honest paragraph about what is not getting done, what happens if you do not hire, and what would change the plan.
Template 6: New Business or New Department Plan
For building from zero, where gap analysis fails because everything is a gap. Works backwards from the first normal day of operating, sequences roles by who trains whom, and counts payroll paid before any revenue.
How to Build One in an Afternoon
A staffing plan for a business of this size is an afternoon of work, not a project. The order matters more than the effort, because each step makes the next one shorter.
The step people skip is the third one, and skipping it costs money in a specific way. If you plan in headcount you see a gap and hire a full-time person. If you plan in FTE you see a gap of 0.6 and hire part-time, or extend hours for someone already on the team who has been asking. At fourteen people that difference is tens of thousands of dollars a year.
The other habit worth building is timing from evidence rather than optimism. Look at your last three hires, count the weeks between posting and a productive start, and use that number. Almost everyone plans with a shorter one, which is why the plan starts slipping in the first quarter.
FTE vs Headcount, and the 50 Trap
Headcount is people. FTE is capacity. One person on sixteen hours a week is one headcount and 0.4 FTE, and budgeting from the first number will overstate what your team costs and understate what it can do. Then there is a third number that trips up growing businesses, because a federal threshold uses definitions of its own.
| Number | How it is calculated | Use it for | Watch out for |
|---|---|---|---|
| Headcount | Count the people | Desks, equipment, licences, who is in the room | It says nothing about capacity or cost |
| Budget FTE | Hours per week divided by 40; 2,080 hours a year | Payroll budgeting, gap analysis, cost per department | A 30-hour employee is 0.75 FTE, not 1 |
| ACA full-time and equivalents | Full-time means 30 hours a week or 130 a month; other hours capped at 120 each, divided by 120 | Working out whether the 50-employee coverage rules apply to you | It is a different formula from budget FTE, so the two rarely match |
This matters more than it sounds for a growing business, because the threshold arrives quietly. A plan that adds three part-time weekend staff barely moves budget FTE but can move the other number, and the obligations attached to crossing it are not the kind you want to discover late.
Staffing Plan vs Workforce Plan vs Schedule
Four documents get called by each other's names, and the confusion produces meetings where two people are answering different questions.
| Document | Answers | Horizon | Lives in |
|---|---|---|---|
| Staffing plan | How many people, in which roles, by when, at what cost | Next 12 months | A spreadsheet, reviewed quarterly |
| Workforce plan | What capabilities the business will need and how the team changes shape | Three to five years | A written document, revisited annually |
| Staffing matrix | Who can do what, and where coverage is thin | Current state | A grid, updated when people or skills change |
| Staffing schedule | Which named person works which shift | This week or next | A rota or scheduling tool |
On a smaller team the first two collapse into one document, and that is fine: a twelve-month plan with a paragraph about where the business is heading does the job of both. The matrix is worth keeping separate because it answers a different question, and the difference between a workforce plan and a weekly schedule is the one worth insisting on, since a repeated gap in the schedule is usually a hiring problem wearing a scheduling costume.
Why Staffing Plans Drift
Most staffing plan templates assume a finance partner, a recruiter, and a formal planning cycle. Plenty of plans get written without any of those, by one person with a spreadsheet. Three things go wrong, and they are the same three whether the plan covers four hires or forty.
The practical answer is smaller than it looks. Four columns, an honest paragraph, one number per hire that is the full-year run rate, and a date in the calendar for the quarterly review.
Approve, Track, and Revisit
The templates work on their own, filled in and saved. What tends not to work is what happens next: the plan is approved in January, three hires happen in a different order for reasons nobody wrote down, and by autumn the file no longer describes anything.
Two habits fix most of it. Put an owner and a status against every role, so the plan stays a live document rather than a snapshot. And review quarterly with three questions: did the planned hires happen, do the reasons still hold, and has anything moved. That review is fifteen minutes and it is the difference between a plan and a document.
That is where FirstHR picks up: once a role is approved, the job description, offer, and new hire paperwork run as a workflow with owners and dates rather than reminders in someone's head, and the employee record shows what you actually have rather than what the spreadsheet said in January. FirstHR is an onboarding and HR platform, not a payroll provider, a job board, or an accountant, so it does not run payroll, post your openings, or model your budget. Applicant tracking is coming soon to FirstHR.
Frequently Asked Questions
What is a staffing plan template?
A staffing plan template is a reusable structure for working out how many people your business needs over a defined period, in which roles, by when, and at what cost. It usually runs as a spreadsheet, because the core of it is arithmetic: current team converted to full-time equivalents, needed capacity per department, the gap between them, and the budget that gap implies. A complete template covers four things: why you are hiring, tied to business goals rather than a feeling that people are busy; the team you have today with hours and FTE; the gap per department with a priority and a target date; and the money, split between what falls in the current year and the full-year run rate once everyone has started.
What should a staffing plan include?
Nine things. Business goals and what each one requires from staffing. A current team snapshot with hours, FTE, and expected departures. A forecast of what you will need, driven by growth, seasonality, and turnover. A gap analysis per department, stated in FTE rather than headcount. A role breakdown covering title, type, hours, skills, and target start date. A budget covering base pay, payroll taxes and benefits, and one-off hiring costs. A recruitment timeline sequenced by quarter with an owner per hire. A risk section naming the hardest roles to fill and what happens if a key person leaves. And an assumptions list, which is the one almost everybody skips and the one that makes next year's plan possible.
How do you create a staffing plan without an HR team?
Start by counting what you have in full-time equivalents rather than headcount, since three part-timers at sixteen hours are not three people of capacity. Then work out the gap per department: FTE needed minus FTE you have. For each gap, write down what happens if you do not fill it, because that sentence is what separates a plan from a wish list. Sequence the hires backwards from the date you need someone productive, subtracting your actual time from posting to start rather than an optimistic guess. Add the money, tracking both what falls in this year and the full-year run rate. Finally, write down your assumptions, particularly your tax and benefit rate, expected turnover, and time-to-hire, so that next year you can see what you guessed wrong. An afternoon is usually enough.
What is the difference between FTE and headcount?
Headcount is the number of people; FTE is the amount of capacity. One person working sixteen hours a week is one headcount but 0.4 FTE if your full-time week is forty hours. The formula is hours worked divided by standard full-time hours, and the common annual baseline is 2,080 hours, which is forty hours a week times fifty-two weeks. Budget from FTE, because payroll follows hours rather than people, and a team of fourteen that includes five part-timers costs nothing like fourteen full-time salaries. Headcount is still worth tracking, since it is what determines desk space, equipment, and how many people are in the room. One important warning: some legal thresholds count employees using their own definitions rather than your budgeting FTE, so never assume one number answers both questions.
How does the 50-employee threshold work for health coverage?
Under the federal employer shared responsibility rules, an employer is an applicable large employer for a calendar year if it averaged at least 50 full-time employees, including full-time equivalent employees, during the preceding calendar year. Two details catch employers out. First, full-time under these rules means an average of at least 30 hours of service per week, or 130 hours of service in a calendar month, which is not the same as whatever your handbook calls full-time. Second, the full-time equivalent calculation for this purpose combines the hours of your non-full-time employees for a month, capped at 120 hours per employee, and divides by 120, which is a different formula from the 2,080-hour figure used for budgeting. If your plan takes you anywhere near 50, run that calculation properly. This is general information, not legal or tax advice.
What is the difference between a staffing plan and a workforce plan?
A staffing plan is operational and usually covers the next twelve months: these roles, by these dates, at this cost. A workforce plan is strategic and usually covers three to five years: what capabilities the business will need, how the shape of the team changes, and what that implies for building versus buying skills. On a smaller team the distinction is mostly academic, because the person writing one is writing the other, and a twelve-month plan with a paragraph about where the business is heading covers both adequately. The distinction matters more once you have enough people that the two horizons genuinely diverge. Both are different again from a staffing schedule, which allocates named people to specific shifts and answers a weekly question rather than an annual one.
Are these staffing plan templates free to download?
Yes. All six download free with no email form and no account: four as Excel workbooks and two as editable Word documents. Downloading all six at once gives you a single zip file with each of them separately. That is worth checking elsewhere, because several of the most visible staffing plan templates require you to create an account to use the template inside the vendor's own product, and template libraries commonly place the more complete versions behind an upgrade. Free also does not mean finished: the numbers in the worked example are illustrative, the 25 percent used for payroll taxes and benefits is a placeholder rather than a rate you should adopt, and every assumption in these files is there to be replaced with your own.
How often should a staffing plan be updated?
Write it annually and review it quarterly, and revisit it immediately whenever something material changes. The quarterly review is short: did the hires we planned actually happen, did the reasons still hold, and has anything moved. The triggers that should override the calendar are a resignation, a customer or contract won or lost that changes volume, revenue landing meaningfully above or below plan, and approaching an employee count that changes your obligations. The most useful discipline is writing down what would change the plan while you are still writing it: name a specific number, such as first-quarter revenue below a stated figure, rather than a feeling, because in the moment the feeling always arrives later than the number does.