Build a Simple Capacity Tracker So You Always Know Who's Free

Someone walks in with a project. You want to say yes. But you have no idea whether your team has room for it without calling three people, checking two spreadsheets, and making an educated guess. That's not a people problem. It's a visibility problem.

Why Most Small Businesses Don't Know Their Capacity

Capacity tracking sounds like something large companies do with complex project management software. For a team of five to fifteen people, it feels like overkill. The result is that most small professional services businesses operate on gut feel: the owner has a rough sense of who's busy, no one has a precise view of available hours, and project commitments happen on optimism rather than data.

This creates two recurring problems. The first is overcommitment: you say yes to work your team can't actually absorb, someone works nights and weekends, and quality or morale suffers. The second is under-utilization: someone is actually available but no one knows it, so the opportunity to take on more work gets missed.

What Owners Get Wrong

The most common mistake is confusing activity with capacity. A team member who always seems busy may be running at 60 percent billable and spending the rest on admin and internal meetings. A team member who seems available might actually have a project deadline hitting in two weeks. Without a structured view, your read on capacity comes from hallway impressions, not data.

The second mistake is building something too complicated. A capacity tracker does not need to be a sophisticated resource management system. A shared spreadsheet updated weekly is better than a complex tool that no one maintains. The goal is a single view that shows committed hours and available hours per person for the next four to eight weeks. That's it.

The CFO Perspective

A consulting firm with nine staff was making resourcing decisions in weekly meetings that ran 90 minutes and still produced uncertain outcomes. The owner would ask "who has room for this?" and get shrugs and rough estimates. We built a single shared spreadsheet with team members across the top, weeks down the side, and committed project hours filled in as projects were confirmed. Available hours were calculated automatically as total weekly capacity minus committed hours.

The weekly resourcing meeting dropped to 20 minutes. New project decisions could be made in the meeting by looking at one screen instead of polling the room. The first time they used it to say no to a project that would have overloaded a key staff member, the owner said it paid for itself. It had taken about three hours to build.

Building a Simple Capacity Tracker

Define capacity per person

Start by setting the baseline. For each team member, define their total available hours per week after accounting for any part-time arrangements or set non-billable commitments. This is not their target billable hours. It's the total time they have available for project work before you add any specific commitments.

Create a four to eight week rolling view

Build columns for each of the next four to eight weeks. Most scheduling decisions are made in this window. Looking further out is useful for planning but the near-term view is what you use for day-to-day allocation.

Enter committed hours by project

For each active or confirmed project, add the hours committed for each team member per week. If a team member is committed to a project for 12 hours in a given week, that goes in their column for that week. You don't need to be precise to the hour. Blocks of two to four hours are granular enough for most small teams.

Calculate available hours automatically

Add a row that subtracts committed hours from total capacity for each person each week. Color it: green for comfortably available, yellow for near capacity, red for over-committed. This is the view you use when a new project request comes in.

Update it weekly

A capacity tracker is only useful if it reflects current reality. Build a 15-minute weekly update into your team meeting. Whoever manages resourcing updates committed hours based on project progress and new commitments. It takes less time than the resourcing confusion it replaces.

What to Do About It

1. List your team and their weekly available hours. Start with total hours per person per week, not billable targets. Adjust for any fixed non-billable commitments like management responsibilities.
2. Map your active projects to team members and estimate weekly hours. You don't need perfect numbers. Rough estimates are better than nothing. Refine them over the first month.
3. Build the grid. Team members across the top, weeks down the side, committed hours in cells, available hours calculated at the bottom. One sheet, no macros, color-coded available row.
4. Use it for the next new project request. Before you commit, check the grid. This single step is the payoff: making resource decisions based on data instead of gut feel.
5. Review and update weekly. Make someone responsible for keeping it current. If it falls out of date, it stops being useful. 15 minutes per week is the maintenance cost.
6. Add a utilization summary tab over time. Once you've run the tracker for a quarter, you'll have data on actual versus committed hours per person. Use that to refine your capacity assumptions and your pricing.

Know Who's Free Before You Need To

A capacity tracker is not about control. It's about making better decisions faster. When you can see available hours in real time, you say yes more confidently to the right work and no more clearly to work that would break your team. That visibility is worth a few hours to build and 15 minutes a week to maintain.

If your resourcing decisions feel more like guessing than planning, book a free call at peterxiacpa.com/book.

Next step: run your numbers through the free CFO scorecard.