
Colorado FAMLI Headcount Reporting: The Annual Task Your Payroll Provider Can’t Do for You
One missed HR task could cost a four-person business more than $700 in a year.




By Allisha McCartney22 Oct 202610 min read

How many people left your business last year, and why? How long did it take to fill your last opening? What did that hire really cost once you add the job ads to the hours you spent interviewing? Most owners have a feeling about these answers. HR metrics turn that feeling into a number you can check, and HR analytics is the habit of looking at those numbers regularly and asking what they say about your business.
You don't need an HR department, special software or a data team to start. A spreadsheet, a short list of measures and the habit of updating them once a month will take a small business a long way. This post covers the core HR KPIs for a small team, how to calculate them, what goes in a monthly HR report and when a dashboard is worth setting up.
In a small business, people problems tend to show up as a feeling first. The schedule feels tight, a manager seems stretched thin, or the same role keeps coming open. By the time the feeling is strong enough to act on, the problem has often been around for months. A few numbers, tracked the same way every month, show you the pattern earlier and tell you whether the change you made worked.
Here's an example from my own work. I worked with a client who was experiencing high turnover, especially within the first week or two of employment. I worked with them to refine their hiring and interview processes, implement a better on-the-job training program and create a full 90-day onboarding program, and it led to better retention long term and lower turnover in the first few weeks.
If you only looked at one yearly turnover figure, you'd know turnover was high without knowing where. When departures cluster in the first few weeks, hiring, training and onboarding are the first places to look, and you can only see that if you track when people leave as well as how many leave.
Before you build anything, pick measures you'll act on. A metric nobody looks at is HR for HR's sake, and it costs you time every month without telling you anything you'll use.
For most small businesses, a short list is enough. Getting the definitions right is more important than the list, because a turnover rate is only useful when you count it the same way every month, so write them down once at the top of your tracking sheet.
Headcount is the number of people on your payroll, counted at the same point each month. Decide who counts and stick to it. The U.S. Bureau of Labor Statistics (BLS), which runs the national Job Openings and Labor Turnover Survey, counts these people as employed: full-time and part-time employees, permanent, short-term and seasonal employees, salaried and hourly workers, and employees on paid vacation or other paid leave. It leaves out employees of temporary help agencies, employee leasing companies, outside contractors and consultants. Its definitions are written for a national survey, but they're a sensible starting point for your own rule.
Track headcount by team or location as well as in total, and keep full-time and part-time numbers apart if you have both.
Turnover tells you how many people left compared with how many you employ. BLS computes its separations rate by dividing the number of separations by employment and multiplying that quotient by 100. For your business, that's the number of people who left this month, divided by your headcount, times 100. For a yearly figure, add up the year's departures, divide them by your average headcount across the year and express the result as a percentage.
Split turnover by type as well. The BLS survey sorts separations into quits, meaning employees who left voluntarily, layoffs and discharges, meaning involuntary separations initiated by the employer, including firings for cause, and other separations, such as retirements, transfers to other locations, deaths and separations due to employee disability. A rising number of quits and a rising number of terminations point to different problems, and one combined turnover figure mixes them together.
Early turnover is the share of new hires who leave within a set window after they start. Pick one window, such as the first three months, and use it every time. It's the clearest number for showing whether your hiring and onboarding are working. When it's high, look first at how you hire, train and welcome people. In my Hiring & Onboarding work, I help with the hiring process and a first 90 days that keeps people.
Time to hire is the number of days from the day a role opens to the day your chosen candidate accepts the offer. You can start counting when the job ad goes live or when a manager asks for the role, as long as you use the same starting point every time. Track it role by role, because a front-line opening and a manager role often move at very different speeds.
Cost per hire is what you spent on hiring in a period, divided by the number of people you hired in that period. Include the outside costs, such as job board ads, recruiting help, assessments and background checks. If you can estimate it, add the time you and your managers spent screening and interviewing. Decide up front whether you're counting that time.
When cost per hire and early turnover are both high, you're paying to fill the same seat twice. When the problem is getting qualified applicants at all, pay may be part of it. For one client that was struggling to get qualified applicants, I completed a wage analysis and found their pay wasn't competitive for the market. I helped them create competitive pay ranges for all of their positions and a clear annual review process, and it led to easier hiring and better retention.
Turnover tells you about the people who left. Retention and engagement tell you about the people who stayed, and they're harder to fit into one number. A simple retention measure is the share of the people on your payroll at the start of the year who are still with you at the end of it.
For the reasons behind the numbers, talk to people. I offer stay interviews, and I don't use eNPS. In my engagement work, I focus less on perks and more on the everyday things. Engagement surveys help as well, and how often to run one depends on the business and the industry: no more than once a year, with pulse checks, and sometimes only every other year or every few years. Keeping good people is part of my Employee Relations & Engagement work, alongside help with the hard people moments.
For a small business, HR analytics means taking the records you already keep and asking them a few questions on a regular schedule. You'll also hear the bigger version called workforce analytics, and at any size you start the same way, by deciding what you want to know and then finding the records that answer it.
Most of what you need already exists in your payroll system, your job ads and your calendar. Most of the effort goes into pulling it into one place, and a tracking sheet with one row per team member does most of it. Useful columns include:
From that sheet, you can count headcount, hires, departures, early leavers and time to hire in a few minutes each month.
Keep two cautions in mind. Small numbers move a lot. In a team of a dozen people, one departure swings your turnover rate, so look at the trend over several months and at the people behind the numbers before you react. HR data is also personal, so keep the sheet to the people who need it.
Not everything worth measuring is a number. When I look at whether a training worked, it depends on the training. For training on giving effective feedback and regular communication, I'd look at things the owner now notices, any impact on team member performance, examples of what the manager is now doing, and feedback from team members or team member surveys before and after.
How long to keep the records behind your metrics is its own question. My HR & Payroll Record Retention Toolkit lists general requirements for federal and state law, then my recommendation depending on the type of record.
A monthly HR report doesn't need to be long. One page that you can read in a few minutes is more useful than a long report nobody opens. For a small business, it can cover:
That last line matters most. Numbers without a "so what" turn into a report that gets filed and forgotten, which is the spreadsheet version of a policy that sits in a folder and never gets used.
Once a quarter, read the last three months together. Once a year, work out your annual turnover rate and early turnover, compare them with the year before, and check whether your hiring plans still match where the business is going. Share team-level numbers with each manager, and keep individual reasons for leaving to the people who need them.
A spreadsheet report works for a long time. A dashboard starts to make sense when updating the report by hand takes longer than reading it, when your data sits in several systems that don't talk to each other, or when several managers each need their own view. Growth usually tips it over, as you add locations, managers and hiring.
When I set up a dashboard for a client, I usually build a spreadsheet, or use Power BI if it's needed, and I walk the client through what the numbers mean.
If you're weighing an HR system (an HRIS) partly for its reporting, start with what you need the system to do before you sit through vendor demos. That's where I start when I help a client choose one, and I also look at their headcount, budget, payroll setup and existing tools.
Planning is the other reason to keep your numbers in one place. When I've helped a client plan their next hires, I helped them map out what their future structure should look like, including the triggers for when the next move would need to be made and what they needed to monitor and track to know when to start planning for the next role. That kind of planning, for headcount, pay and structure before growth forces it, is part of my Workforce Strategy work.
If you'd like support with HR reporting, analytics setup or a dashboard for your business, that's part of my HR Operations Support.
HR metrics are the measures themselves, such as headcount, turnover rate or time to hire. HR analytics is what you do with them, such as comparing them over time, splitting them by team, type or reason, and using what you find to make a decision. A small business can do both in one spreadsheet.
For a month, divide the number of people who left by your headcount and multiply by 100, the same way BLS computes its separations rate. For a year, add up the year's departures, divide them by your average headcount for the year and express the result as a percentage. Count quits, terminations and other departures separately as well as together, so you can see what's behind the total.
Start with headcount, turnover split by type, early turnover among new hires and time to hire. Add cost per hire once you're hiring regularly, and engagement measures once the basics are routine. A few measures you update every month are worth more than a long list you abandon after the second report.
No. A spreadsheet with one row per team member covers the core HR KPIs for a small team. Software starts to earn its keep when updating by hand takes longer than reading the report, or when your data is spread across systems that don't connect.
Monthly for the basics, quarterly for trends and yearly for annual turnover and planning. In a small team, the monthly numbers jump around, so look at the whole quarter before you change anything big because of one month.
Subscribe to my newsletter
Join my email list to hear when I release new HR resources for small businesses, plus Colorado HR updates.
Thanks, you're on my list.

One missed HR task could cost a four-person business more than $700 in a year.
Read more
Colorado's pay transparency law applies from your first team member in the state. It sets what goes in a job posting, which promotions need a notice and how equal pay works.
Read more
What fractional HR means, how it works week to week for a small business, what it covers and what it does not, how it differs from a PEO, and the signs you are ready.
Read moreHR Fit Check
Tell me a little about your team and I'll point you to the service that fits your business and the way of working together that suits you.
Take the Fit CheckTake the Fit Check