Most studios and agencies staff projects from a bench they can’t actually see. The knowledge of who’s good at what, who’s free, and what they charge lives in one person’s head, a scatter of DMs, and a rate you half-remember. It works — right up until that person is on leave when a project lands, or you realize the one contractor who can do a thing is booked for a month. The Contractor & Freelancer Bench & Capability Tracker turns that mental rolodex into a searchable bench you own.
It’s built for the agency or studio owner running a roster of freelancers and 1099 contractors — and for the producer or resource manager who needs to know, fast, who’s free and qualified for the next brief. It’s a manager-facing resourcing tool, not a job-seeker’s profile.
New to keeping a bench this way? Try the free single-skill bench list — a one-discipline roster of names, rates, and who’s available, then upgrade here for the full capability matrix, utilization board, and Staffing Finder.
What does the Bench & Capability Tracker do?
It runs your bench from one connected workbook, across six tabs:
- Bench Roster — everyone you can call on: discipline, day rate, days a week available, when they’re next free, and how to reach them. The name here is the key every other tab reads from.
- Capability Matrix — who can do what. Set each contractor’s level per skill from a dropdown — Can lead, Can do, Learning, or a dash — colored so the whole bench’s coverage reads at a glance, with a coverage count per skill so a thin spot is obvious.
- Assignments — every current commitment of a contractor’s time: project, client, days a week, and a status. Only the Active rows count toward utilization.
- Bench & Utilization — the staffing board. Each contractor’s booked, free, and utilization with an availability flag — plus a Staffing Finder: pick a skill and the board shows, for every contractor, whether they’re qualified and free, flagging the ones you can Staff now.
- Dashboard — bench health: free now, over-allocated, average utilization, coverage by skill, and your day-rate range, all pulled live.
Plus three plain-English PDF guides — a Start Here guide, a capability and staffing guide, and printable bench sheets.
The Staffing Finder: two questions, one answer
When a brief lands, “who can I staff this with?” has two parts — who’s qualified and who’s free — and the wrong answer to either is useless. The Staffing Finder combines them: pick a skill, and for every contractor the board reads their level from the capability matrix and their availability from the utilization board, then flags the ones who are both Staff now. A qualified-but-booked contractor shows as Qualified · busy, so you know who to chase if the timing can flex. It turns a memory test into a filter.
Why an owned bench, not resourcing software?
Per-seat resource-management platforms are built for a large agency, cost a monthly fee for every seat, and hold your bench and your contractors’ rates on their servers. A blank spreadsheet is free, but you build every formula, matrix, and utilization view from scratch. This is the owned middle ground: a connected system that maps capability and finds who’s free and qualified for you — structure you keep, adapt, and search on your own terms. Buy once; no seats, no subscription.
Who is it for?
- Agency and studio owners who staff client projects from a roster of freelancers and 1099 contractors.
- Producers and resource managers who need to know, fast, who’s free and qualified for the next brief.
- Small consultancies that pull in specialists and want the bench in one owned place.
- Anyone who staffs work from a network and is tired of tracking it in DMs and memory.
Works in Excel, Google Sheets, and LibreOffice
It’s a workbook, not “Excel only.” Open the .xlsx in Excel or LibreOffice Calc, or click the included link and choose Make a copy for a native Google Sheet — every dropdown, color, and live formula already set up, nothing to import.
A planning tool — not HR, legal, tax, or classification advice
This plans and tracks your bench. It does not classify anyone: whether a worker is an independent contractor or an employee — and the tax, legal, and insurance obligations that follow — is defined by the law where you are and your own advisors, not by this file. The example agency, contractors, and rates are fictional and illustrative. Keep contractor data the way your own privacy policy requires.
