Forecast billable capacity
The Forecast view looks four weeks ahead and estimates how much of your team’s upcoming capacity will be billable, so a revenue gap shows up before the hours are lost, not after.
Open the forecast
Section titled “Open the forecast”-
Select Timesheet in the sidebar and switch to the Capacity Planner tab.
-
In the view toggle at the top right, select Forecast (next to Weekly and Monthly).
You get a summary card for the next four weeks, a projected billable mix percentage, and a per-person table. Each week’s cell shows two numbers: the person’s capacity on top, and the estimated billable hours below it.
How the estimate works
Section titled “How the estimate works”The forecast is intentionally simple:
- Capacity comes from the availability you set per person, per week, in the Capacity Planner’s Weekly view. Future weeks you have not filled in yet have no capacity to forecast.
- Billable estimate assumes each person’s billable share for the coming weeks matches their actual mix from last week. Someone who logged 60% of last week’s hours to billable projects is projected at 60% of each forward week’s capacity.
- People with no history yet are projected at fully billable.
What to do with it
Section titled “What to do with it”Two patterns make the forecast actionable:
- Projected billable mix dropping over the four weeks usually means upcoming vacation weeks or a project rolling off. Line up the next engagement, or expect the dip in revenue.
- One person’s billable estimate near zero while their capacity is full means last week they worked almost entirely on internal projects. If that is not intentional, rebalance their assignments now, while the weeks are still ahead of you.
Whether a project counts as billable is controlled by the project’s Billable flag; reclassifying a project changes both this forecast and the billable utilization views.
Best practices
Section titled “Best practices”- Use Forecast in weekly capacity planning, not for hard commitments. It’s an extrapolation, not a promise. Combine with project plans and sales pipeline to commit deliverable hours.
- Populate forward availability before reading the forecast. Empty future-week capacity = empty forecast cells. Set known vacations, conferences, and leave first.
- Read trends, not absolute numbers. A billable mix dropping from 75% to 60% over four weeks is more actionable than the absolute 60%. Trend = signal; single number = noise.
- Compare Forecast to bookings pipeline. Forecast says “65% billable next week.” Pipeline says “you’ll book project X next week.” The two together inform staffing decisions.
- Don’t try to forecast past 4 weeks. Beyond the 4-week window, last week’s mix is too stale to be useful. The view’s deliberate limit is a feature, not a bug.
Troubleshooting / common pitfalls
Section titled “Troubleshooting / common pitfalls”- Forecast cells are empty. Future-week capacity isn’t set. Go to Weekly view and populate availability first.
- Billable estimate looks too high or low. Last week’s mix is what’s used. A single unusual week (all internal, post-vacation) skews the estimate. The next week’s actuals replace it.
- A new hire shows 100% billable. No history = full billable assumed. The estimate corrects after their first week.
- Mix is 0% for everyone. No projects are marked Billable, or no hours were logged to billable projects last week. Check the Billable flag on projects and the prior week’s logged hours.
- The Forecast tab is missing. Pro+ + Owner/Admin/PM role required.
How this combines with other features
Section titled “How this combines with other features”- Forecast + Pipeline. Sales pipeline tells you what’s expected next; Forecast tells you what capacity you have to deliver it. Mismatches signal hiring or staffing actions.
- Forecast + Billable flag. A project’s Billable flag drives whether last week’s hours count as billable. Reclassifying mid-week changes the forecast on the next refresh. See Mark projects billable or internal.
- Forecast + Capacity Planner. Forecast builds on the Weekly view’s availability. Without availability, no forecast. See Plan team capacity.
- Forecast + Revenue at Risk. Forecast is forward-looking; Revenue at Risk is current. Both feed the same revenue conversation. See Track revenue at risk.
Coming from another tool
Section titled “Coming from another tool”| Tool | Mapping |
|---|---|
| Microsoft Project Online Forecast | Direct concept |
| Float | Float’s “schedule” view ≈ Forecast |
| Resource Guru | Direct |
| Smartsheet Resource Management | Direct |
| Custom spreadsheet | Onplana automates the math |
Why does the forecast differ from what actually happens? It extrapolates one week of history. A person who had an unusual week (all internal work, or a holiday) carries that mix forward until the next week’s actuals replace it.
Can I forecast further than four weeks? Not in this view. Four weeks keeps the extrapolation honest; beyond that, last week’s mix stops being a useful predictor.
Why can’t my team members see the forecast? The Capacity Planner tab, including Forecast, is limited to Owners, Admins, and Portfolio Managers.
Can I adjust the prior-week window the forecast uses? Not today — the forecast uses exactly last week. The single- week window is the algorithm’s simplifying assumption.
Does the forecast take exceptions into account? Yes, via the Capacity Planner’s availability. Exception weeks have zero capacity; the forecast row shows zero.
Can I export the forecast? Not from this view today. Use Reports for forward-looking billable utilization in tabular form.
Related
Section titled “Related”- Plan team capacity — set availability the forecast reads
- Track revenue at risk — current revenue risk
- Mark projects billable or internal — what counts as billable
Was this helpful?
Thanks for your feedback!