Skip to content
Opsium
Sign InBook a Demo
Free template · Excel and Google Sheets

Free resource planning template for agencies.

This free resource planning template maps who works on what for the next 12 weeks, then shows what that plan is worth in revenue and margin. We make Opsium, so weigh our advice with that in mind.

By Andrii Chernysh · CEO, Founder

17 min read

On this page1. Feature by feature17 min read
The short answer

Use this free template while one person owns the plan and it still fits in one sheet. When it stops keeping up, move to Opsium, where rates are versioned, approved hours become QuickBooks invoices, and our team imports the sheet for you once you subscribe.

  • Free for Excel and Google Sheets, no macros
  • Opsium: versioned rates and a change-aware planner
  • Opsium from 25 people: $12 per person a month, billed annually
  • Opsium: 30-day free trial, no credit card

Get the free resource planning template

Nine tabs with a sample 10-person team: allocation, time off, utilization, margin forecast and variance. Leave your name and work email and you get it straight away, as an Excel file and as a Google Sheets copy.

Choose Opsium if

  • several people edit the plan
  • capacity, roles and rates change during the year, and past weeks must keep what applied then
  • planned hours must become approved timesheets, invoices and vendor bills
  • cost rates should stay hidden from most of the team
  • keeping the sheet current takes more than an hour a week

Choose a spreadsheet if

  • you have fewer than about 25 people and one person owns the plan
  • rates change about once a year and invoices match the plan most months

Feature by feature.

FeatureOpsiumSpreadsheet template
Price per person per month$12 billed annually, $15 billed monthly, $10 on a 2-year termFree
Seat minimum25 people, because hands-on onboarding by our team is includedNone
Getting started30-day free trial, no credit card; once you subscribe, our team imports your data, sets Opsium up and trains your teamFill in a short form, then open the Excel file or a Google Sheets copy; sample data is already filled in
Weekly allocation by person and projectYesDrag-and-drop timeline planner; placeholders for people you have not hired yet are freeYesHours per person, per project, per week, for 12 weeks
Change-aware timeline plannerYesHours per day, role, seniority and rates change on a date, past or future, and the planner reads what was in effect each dayNoOne row per person; changing someone's weekly hours rewrites every week of the plan
Capacity per personYesWorking hours and billable capacity per person, each change datedYesWeekly hours per person, minus hours off typed in on the Time off tab
UtilizationYesShown per person, day by day, as you plan; a booking that creates overtime is flagged; filters show who is free or has billable time freeYesPer person per week, colored by band, plus a whole-team row
Planning aheadYesTentative projects with a probability; draft and unconfirmed bookings with their own probability; you choose which statuses count toward utilizationYesConfirmed or Tentative projects, with a win probability that weights revenue
Time offYesRequests, approvals by one or several approvers, accrual policies and balances, shown on the plannerPartlyHours off typed in per person per week
People recordsYesDepartment, role, seniority, manager, in-house, partner or contractor, location and your own custom fields, each change datedPartlyName, role, weekly hours and two rates on one row
Projects and clientsYesTime and materials, fixed price or non-billable; project managers, industries and custom fields; clients with payment terms and billing addressPartlyOne row per project: client, status, probability, budget and a billable flag
Logged hoursYesTimer or manual entry; hours sync in from Jira, Tempo and ClockifyPartlyPasted into the Actuals tab by hand
Timesheet approvalsYesApproved by project, person or entry, with hours to invoice and to pay set separatelyNoNone
Versioned ratesYesEvery rate is a dated record, from the organization default down to a project's rate card; past work keeps the rate in effect when it was doneNoOne rate per person; changing it recalculates past weeks
Change historyYesA Change History tab on every person and project: before and after, the date it applies from, and who or which integration made itPartlyFile version history at best; nothing records which rate applied when
Forecast from the planYesReports forecast capacity, booked and probability-weighted hours, plus revenue and cost for projects on a flat rate or a project rate cardPartlyForecast tab prices booked hours at bill rates; time and materials only
ProfitabilityYesProfitability report: cost from tracked hours, revenue from invoices, overheads and net profit; no budget-vs-actual viewNoVariance compares planned and logged hours; no profit from what was logged
InvoicingYesCreated in QuickBooks Online from approved hours at the rates in effect; status and balance sync back; no XeroNoNone; totals are copied into your accounting tool by hand
Vendor billsYesCreated in QuickBooks Online at cost rates from approved hoursNoBuilt by hand from the Actuals tab
Cost rates hidden by roleYesThe server hides rates from anyone without rate permission; permission groups are yours to defineNoAnyone who can open the file sees every rate
Unbilled-work alertsYesFlags a booking at a zero rate and hours logged with no booking behind themNoNothing warns you; a deleted rate quietly prices hours at $0

What the free spreadsheet really costs you.

The template is free, but keeping it current is not. Put in the hours the sheet takes each week and the invoices you build from it, and see what that costs next to Opsium, which pulls hours in and generates the invoices.

30 people
3 hours
10
$50 an hour

At 30 people, Opsium costs $457 a month less than the free sheet once its hours are counted.

Opsium's subscription here is $360 a month, the same as 7.2 hours of spreadsheet work at your hourly cost. On these numbers the sheet takes 16.3 hours.

  • Opsium$360 a month

    Subscription only: hours arrive from Jira, Tempo, Clockify or the timer, and invoices and vendor bills are created in QuickBooks Online

  • Spreadsheet template$817 a month

    Free, plus 16.3 hours a month of upkeep and invoice building, worth $817

  • Subscription
  • Hours spent on the sheet, at your hourly cost

How it works: Opsium's subscription is its annual list price for the people on the plan, with its seat minimum. The sheet's cost is your weekly upkeep times 52 weeks over 12 months, plus each invoice or bill at 20 minutes by hand, times your hourly cost. Opsium syncs hours in and creates invoices and bills from approved hours, so it counts neither.

Opsium list price as of October 14, 2026, billed annually. Hours, counts and hourly cost are your inputs, and the starting values are examples.

How to set up the capacity planning template in six steps.

This resource planning template comes as an Excel file and a Google Sheets copy that goes into your own Drive; the form at the top of this page sends you to both. It has no macros. A sample 10-person studio is already filled in, so you can watch every tab work before you type over it.

  1. On Start here, check the plan start date. It defaults to this week's Monday and moves forward every Monday, so type your plan's start date before you enter any hours.
  2. On Team, add one row per person: name, role, hours per week, cost rate, bill rate and billable target. Use contracted hours, so a four-day week is 32, not 40.
  3. On Projects, add one row per project with its client, status (Confirmed or Tentative), a win probability for tentative work, the budget, and whether it is billable.
  4. On Allocation, add one row for each person and project pair, with hours for each of the 12 weeks. Person and project are drop-downs fed by the Team and Projects tabs.
  5. On Time off, enter hours off per person per week for vacation, public holidays and conferences.
  6. Each week, paste logged hours from your time tracker into Actuals. It uses the same person, project and week layout as Allocation.

Leave the three teal tabs alone. Capacity, Forecast and Variance are formulas that read everything above, and typing over a cell breaks them. On Allocation, columns O to Q (Total hours, Bill rate, Cost rate) are formulas too, and so is Total hours on Actuals. Rates belong on the Team tab; P and Q only look them up.

The sheet has room for 30 people, 30 projects and 150 allocation rows, which covers most agencies that should still be planning in a spreadsheet.

How to read utilization on the Capacity tab.

Each cell on the Capacity tab is one person's booked hours divided by the hours they have that week after time off. The template colors it in three bands:

  • Under 70% is under-booked: bench time you are paying for.
  • 70 to 100% is healthy.
  • Over 100% means more work is planned than the person has hours for.

If someone is booked in a week they have entirely off, the cell shows 999%; in the sample, that is Sam in week 10. A Whole team row at the bottom does the same sum for everyone.

The sample team shows each band. Marta hits 200% in week 4 because a conference takes 16 of her 40 hours and she is still booked for 48. Nobody plans that on purpose, and this tab is where you catch it.

Jonas works a 32-hour week, so his 24 booked hours read as 75%; enter 40 hours for him and he would look under-booked when he isn't. Tom sits at exactly 100% in 11 of the 12 weeks. The sheet colors that healthy, but it leaves him no slack for a production bug or a sick day.

Utilization counts every booked hour, while billable utilization counts only hours on billable projects, the ones a client pays for. Iris shows 60%, but 16 of her 24 booked hours are on Internal tools, which the Projects tab marks as not billable. Her billable utilization is 8 ÷ 40 = 20%, against the 80% target on her Team row. The template doesn't calculate billable utilization, so add a column for it if you track it.

Watch the Whole team row as well. In the sample it falls from 84% in week 1 to 62% in week 12 as current projects wind down, which tells whoever sells how much room there is to fill.

Capacity tab: six of the sample team, weeks 1 to 8

Each cell is booked hours divided by available hours. Marta's 200% in week 4 comes from a conference nobody planned around, and Iris stays under 70% for all eight weeks.

Wk 1Wk 2Wk 3Wk 4Wk 5Wk 6Wk 7Wk 8
AlexDesign lead80%80%90%90%90%80%60%60%
TomFrontend developer100%100%100%100%100%100%100%100%
MartaBackend developer100%100%120%200%120%120%100%100%
JonasBackend developer75%75%75%75%75%75%75%75%
SamQA engineer60%60%60%60%70%70%80%80%
IrisJunior developer60%60%60%60%60%60%60%60%
  • Under-booked (< 70%)
  • Healthy (70–100%)
  • Overbooked (> 100%)

Sample data in the downloadable template. Utilization = booked hours ÷ (weekly hours − time off).

What the plan is worth: the Forecast and Variance tabs.

Forecast prices the plan. For each project it multiplies every week's booked hours by each person's bill rate, then totals revenue, cost (hours × cost rate), margin and margin % across the 12 weeks. That assumes time and materials, so a fixed-price project needs its own math.

In the sample, Checkout rebuild comes to $132,880 of revenue at a 56% margin. Projects marked not billable earn nothing and still cost money: Internal tools costs $9,696 over the same period.

Tentative work gets a weighted figure too. The Data platform pilot is planned at $34,360 of revenue, and the Projects tab gives it a 60% chance of being signed, so it counts as $20,616 of weighted revenue.

The sheet doesn't compare the forecast with the budget, so do that by eye. Checkout rebuild has a $96,000 budget on the Projects tab, which means the plan books $36,880 more work than the budget allows. Either the budget is stale or the plan is wrong, and you want to know which before the client does.

Variance compares planned with logged hours for each project. It counts only the weeks that have actuals, so a half-finished month doesn't look like underspend. More than 10% over plan turns red and more than 10% under turns yellow. After three weeks of sample actuals, Brand refresh is 20% over (115 hours logged against 96 planned) and the Data platform pilot is 38% under.

Capacity planning formulas for Excel and Google Sheets.

To build your own capacity planning spreadsheet, here are the template's formulas, simplified, plus billable utilization, which it leaves to you. A person or project sits in row 2, column B holds weekly hours, and column C is week 1, so week 4 is column F. Every function here works the same way in Excel and Google Sheets.

What it calculatesFormulaSample result
Plan start=TODAY()-WEEKDAY(TODAY(),3)This week's Monday
Available hours=B2 - SUMIFS('Time off'!C:C, 'Time off'!A:A, A2)Marta, week 4 (C:C becomes F:F): 40 − 16 = 24 hours
Utilization=SUMIFS(Allocation!C:C, Allocation!A:A, A2) / (B2 - SUMIFS('Time off'!C:C, 'Time off'!A:A, A2))Marta, week 4 (C:C becomes F:F): 48 ÷ 24 = 200%
Billable utilization=SUMIFS(Allocation!C:C, Allocation!A:A, A2, Allocation!R:R, "Yes") / (B2 - SUMIFS('Time off'!C:C, 'Time off'!A:A, A2))Iris: 8 ÷ 40 = 20%
Bill rate for a booking=IFERROR(INDEX(Team!E:E, MATCH(A2, Team!A:A, 0)), 0)Marta: $115 an hour
Revenue, one project, one week=SUMPRODUCT((Allocation!B2:B151=A2) * Allocation!C2:C151 * Allocation!P2:P151)Checkout rebuild, week 1: $14,020
Margin %(Revenue - Cost) / RevenueCheckout rebuild: 56%
Weighted revenue (tentative projects)Revenue * Win probabilityData platform pilot: $34,360 × 60% = $20,616
Variance %(Logged - Planned) / PlannedBrand refresh: (115 − 96) ÷ 96 = +20%

In the revenue formula, Allocation column P holds the bill-rate lookup above, so each booking row carries its person's rate. SUMPRODUCT needs fixed ranges such as B2:B151, because a whole column would include the text header. For billable utilization, add Allocation column R as =IFERROR(INDEX(Projects!F:F, MATCH(B2, Projects!A:A, 0)), "No"), which copies each project's Billable flag onto its bookings.

Where a resource management spreadsheet stops working for an agency.

With one planner and fewer than 25 people, these problems are rare. More editors and rate changes make them likelier. Float's agency guide puts the switch at about 30 people; we put it at 25.

A raise rewrites the past. The sheet holds one cost rate per person. Give Marta a raise from $50 to $55 an hour in week 7 and all 496 of her planned hours are recosted at the new rate, including the 272 planned for weeks 1 to 6. That adds $1,360 of cost to weeks you have already closed.

Two editors make two plans. Emailed as an Excel file, the plan becomes two copies and a merge by hand. Google Sheets keeps a single copy, yet two people can still book the same person: a project manager puts Tom on one project while the ops lead books him onto another, and the sheet accepts both until his row turns red.

Time off lives somewhere else. A vacation approved in your HR tool reaches the Time off tab only when someone types it in, and until then Capacity counts hours the person doesn't have.

When someone leaves, the lookups break. Chris, the contractor, is booked through week 8. Delete his row from Team when the contract ends and the bill-rate lookup returns 0. The Forecast then prices his 176 hours on Checkout rebuild at $0, and $21,120 of revenue you already earned disappears.

Nobody approves the hours. Tom logged 44 hours on Checkout rebuild in week 3 against 40 planned. Whether the extra four go on the invoice is a decision the Actuals tab has nowhere to record.

The sheet has a ceiling. It has room for 30 people, 30 projects and 150 allocation rows, because SUMPRODUCT needs fixed ranges. Past that, someone extends every range by hand, and one missed range is a total that is quietly wrong.

Plan and invoice disagree at month end. Forecast prices planned hours and your invoice prices logged ones. Checkout rebuild was planned at 396 hours for the first three weeks and logged 433, just under the 10% line where Variance turns red. The sheet can't tell you how much of the gap was extra work and how much was a write-off.

What Opsium does that a spreadsheet can't.

The template holds the plan. Opsium holds the plan and everything that hangs off it: the people and their records, projects and clients, logged hours and approvals, time off, reports, and the invoices and vendor bills in QuickBooks Online. It is one app, so nobody has to remember which tabs are formulas. The grid shows where the template stops and Opsium carries on.

What the template and Opsium each cover

Both handle the plan itself. The template's gaps start once rates change and hours are logged; Opsium's start with the price and the 25-person minimum.

FeatureOpsiumTemplate
Weekly allocation by person and projectYesYes
Capacity per personYesYes
Tentative work with a probabilityYesYes
Utilization by personYesYes
Capacity and role changes on a dateYesNo
Versioned ratesYesNo
Change history on people and projectsYesPartly
Revenue and cost forecastYesPartly
Profitability from actual hours and invoicesYesNo
Budget against actualsNoNo
Time off requests and approvalsYesNo
People, project and client recordsYesPartly
Logged hours arrive without a pasteYesNo
Timesheet approvalsYesNo
Invoicing and vendor billsYesNo
Cost rates hidden by roleYesNo
Free at any team sizeNoYes

Template: the spreadsheet offered on this page. Opsium: the product as it ships.

How Opsium handles what breaks in the sheet.

Rates are versioned. Every rate in Opsium is a dated record: the organization default, each role and seniority, each person's bill and cost rate, and each project's flat rate or rate card. Marta's raise applies from week 7, and weeks 1 to 6 keep the $50 rate everywhere. Hours are priced at the rate in effect on the day the work was done.

The planner is change-aware. A person's hours per day, role, seniority, department and rates change on a date, past or future, not when someone saves a cell. The planner reads what was in effect each day, so cutting Jonas's hours from next month leaves this month's capacity alone.

Every person and project has a Change History tab: each change, its before and after values, the date it applies from, and whether a user or an integration made it.

Overbooking shows on the board. Each person's utilization is shown day by day as you plan, against that day's capacity, and a booking that would create overtime is flagged in the booking form. Several people edit one plan, so there is no second copy to merge.

Planning ahead has its own statuses. A project can be Tentative, with a probability. A booking can be Confirmed, Unconfirmed or Draft, and the last two carry their own probability. Placeholders stand in for people you have not hired yet, and they are free. You choose which statuses count toward utilization, and the planner's resource utilization report shows each day against total or billable capacity.

Hours arrive without a paste. People track time in Opsium with a timer, or their hours sync in from Jira, Tempo or Clockify. Managers approve each entry with two numbers, hours to invoice the client and hours to pay the person, which means Tom's extra four can be paid and not billed. A sync that would change an approved entry is skipped and flagged.

QuickBooks Online works both ways. Opsium creates the client invoices from approved hours at the rates in effect, and the contractors' vendor bills from the same hours at cost rates. Edits you make in Opsium go back to QuickBooks, and each invoice's status and balance come back.

Reports forecast from the plan. The Report Builder turns bookings into forward capacity, booked hours, probability-weighted pipeline hours, and forecasted revenue and cost by month, client, department or role. Revenue is forecast for projects billed at a flat rate or a project rate card. Looking back, the Profitability report sets actual cost against invoiced revenue and overheads.

People and time off live there too. Each person has a department, role, seniority, manager, membership type (in-house, partner or contractor), location and your own custom fields. Time off has requests, approvals, accrual policies and balances, and it shows on the planner.

Rates stay private. Salaries and cost rates are hidden by the server from anyone without rate permission, so project managers plan without seeing what anyone earns. When Chris's contract ends, you archive him from that date and his past hours keep their rate. Any booking at a zero rate is flagged instead of quietly pricing hours at $0.

Opsium has limits too. Invoices go to QuickBooks Online only, with no Xero, and there is no budget-against-actual view. If those matter more to you, our tool comparisons say where Float, Runn or Resource Guru is the better buy.

What Opsium costs, and why it starts at 25 people.

Opsium costs $12 per person per month billed annually, $15 billed monthly, or $10 on a 2-year term. Placeholders are free.

The minimum is 25 people, and the reason is onboarding. Every plan includes it, with no setup fee: our team maps your people, projects, bookings, rate cards, time entries and history from your spreadsheets and exports, connects your integrations, and trains your team. That is real hands-on time, and for a very small team it doesn't make financial sense for us.

Below 25, a sheet like this one usually still works, so we'd rather point you to it, or to Float or Resource Guru, which have no seat minimum, than sell you seats you won't use.

If the sheet already costs you a day at month end, start the 30-day free trial. It needs no credit card, and you try Opsium on sample data or a project you set up yourself. Importing your sheet is part of onboarding once you subscribe.

What people ask before switching.

Ready to take control of your operations?

Free 30-day trial. Cancel anytime.

Start Saving Time

Sign in to Opsium

Choose the workspace you want to open.

No account yet? Start a free trial