Cube vs. Mosaic for a Solar EPC's Project Pipeline Forecast
A commercial solar or energy EPC contractor plans around a pipeline of projects moving through development, procurement, and construction stages, each with its own equipment lead time, permitting timeline, and percentage-of-completion revenue schedule once construction starts. A forecast that only looks at signed contracts misses the projects still moving through permitting that will convert to revenue two or three quarters out.
Here's a step-by-step approach to building that forecast, and where Cube and Mosaic each fit into it.
Vendors Covered in this Article
Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.
How do you build a stage-weighted pipeline, not a signed-contract list?
Every project in development, from initial proposal through signed contract to notice to proceed, carries a different probability of actually reaching construction. Apply a stage-based conversion rate to each project's expected value rather than treating every pipeline entry as equally likely to close, so your forecast reflects the real uncertainty in projects still working through permitting or financing. Recalculate those conversion rates periodically against your own actual close history rather than setting them once and leaving them fixed, since a rate that was accurate a year ago may no longer reflect your current sales process or the markets you're bidding into.
Step two: separate equipment lead time from construction timeline
Panels, inverters, and switchgear often have to be ordered months before a project's construction start date, which means a delay in permitting doesn't necessarily delay the equipment order, and a delay in equipment delivery doesn't necessarily delay permitting. Model these as separate tracks feeding into the same project timeline rather than one combined project duration, so a bottleneck in either one shows up clearly instead of getting averaged away. A procurement delay on a single large order can quietly push back several projects at once if your model doesn't track which projects share a common equipment order.
Step three: pick Cube if your project accountant already models this in Excel
If your team already builds stage-weighted pipeline forecasts and separates equipment lead time from construction schedule in a spreadsheet, Cube's approach of syncing that model against your project management and procurement data keeps the logic where it's understood, without asking anyone to rebuild it inside a new interface.
Step four: pick Mosaic if you need one dashboard across a growing project count
Once you're running enough concurrent projects that tracking each one's stage, equipment status, and percentage-of-completion revenue in a single spreadsheet gets unwieldy, a dashboard rolling all of that into one view can help. Confirm in a demo that Mosaic's revenue recognition matches percentage-of-completion accounting rather than a simpler milestone or subscription-style model, since EPC revenue recognition has real nuance a generic template can miss.
How do you stress-test the forecast against a permitting delay?
Permitting timelines are the single least predictable variable in most solar and energy projects, varying by jurisdiction in ways that are hard to model precisely. Run the pipeline forecast at a baseline permitting timeline and a delayed case for your jurisdictions with historically slower approval processes, so a stretch of permitting delays across a few projects doesn't blow a hole in your revenue plan without warning. Keep the delayed case updated with your own recent experience by jurisdiction rather than a generic assumption applied uniformly across every market you operate in.
Step six: bring in Jirav once project and crew headcount need to scale together
Jirav's driver-based forecasting is useful once you're planning to grow project volume and need the model to show how many additional installation crews, project managers, and procurement staff that growth actually requires, rather than assuming existing headcount can absorb an expanding pipeline. That tie between project volume and staffing capacity is often the real constraint on how fast an EPC contractor can actually grow, more so than sales pipeline alone.
Step seven: separate interconnection risk from construction risk
A project can finish construction on time and still sit waiting on utility interconnection approval before it can actually be energized and revenue fully recognized, and interconnection timelines are frequently outside your control and outside the EPC contract's own schedule. Track interconnection status as its own forecast variable separate from construction completion, so a queue backlog at the utility doesn't quietly delay revenue recognition in a way your model never anticipated.
Step eight: confirm either platform can handle change orders on an active project
Scope changes during construction, a site condition that requires additional engineering, a customer-requested equipment change, are common enough on solar and energy projects that your forecast needs a clean way to update a project's expected revenue and cost mid-build. Confirm in a demo how change orders flow through either Cube's spreadsheet model or Mosaic's dashboard, since a tool that makes this a manual override rather than a structured update will drift out of sync with reality on your most complex projects.
Check these points in a demo before you choose:
- Ask how a change order updates a project's expected revenue and cost in Cube's spreadsheet model versus Mosaic's dashboard.
- Confirm the platform's revenue recognition follows percentage-of-completion accounting rather than a simpler milestone or subscription-style method.
- Check that stage-based conversion probabilities can be applied to each project in the pipeline.
- Verify that interconnection status can be tracked as its own variable, separate from construction completion.
- Run a delayed permitting case alongside the baseline to see whether the forecast still holds.
What Good Looks Like
A well-run EPC contractor forecasts revenue off a stage-weighted pipeline that reflects real conversion probability by project stage, with equipment lead time and construction timeline tracked as separate variables.
Building The Capability (5-Stage Skill Ladder)
How to Get Started
Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.
Cube fits a contractor whose stage-weighted pipeline logic already works in a spreadsheet and mainly wants project and procurement data synced in automatically.
Mosaic is worth a demo once tracking every project's stage and revenue in a spreadsheet gets unwieldy, provided its revenue recognition actually matches percentage-of-completion accounting.
Jirav suits a contractor planning to grow project volume and wanting installation crew and project manager staffing tied explicitly to that growth.
Frequently Asked Questions
Should a project in the permitting stage be included in the revenue forecast at all?
Yes, but weighted by its stage-based conversion probability, not at full expected value. Excluding pipeline projects entirely understates future revenue, while including them at full value overstates near-term certainty; a weighted approach reflects the real range of outcomes.
How far in advance should equipment be ordered relative to construction start?
That depends on current lead times for your specific equipment and suppliers, which shift with market conditions. Track your own historical lead times by equipment type rather than relying on a fixed rule, since lead times for panels, inverters, and switchgear don't always move together.
Do Cube or Mosaic track permitting status directly?
No, permitting and project management status typically live in a separate project management system. Both forecasting tools can incorporate that stage data once it exists somewhere, but neither one tracks permitting or interconnection approval on its own.
About the numbers
This guide doesn't quote a sourced benchmark. Figures in it are estimates or general guidance, so check them against your own numbers.
Related Guides
409A Valuation for a Solar or Energy EPC Contractor
Project-level tax equity, development pipeline, and module price swings all shape a solar EPC's 409A differently than a typical contractor. Here's how.
FloQast vs. AuditBoard for Commercial Solar EPC Contractors
Milestone billing, performance guarantees, and tax credit documentation drive an EPC contractor's close. Compare FloQast and AuditBoard for each.
A Worked Example: Financing a Commercial Solar EPC's O&M Revenue
A worked look at where Pipe and Capchase do and don't fit a commercial solar or energy EPC business, split between project and O&M revenue.
BILL vs Tipalti for Commercial Solar and Energy EPC Firms
Following one solar project's payables shows where BILL and Tipalti fit equipment, subcontractor and permitting payments in EPC.
A Solar EPC's Sales Tax Question, Worked Through One Project
Walk a commercial solar EPC project through equipment exemptions, real property treatment and multi-state registration before picking a compliance tool.
Payroll for Solar and Energy EPC Crews on Federal Projects
How a solar or energy EPC contractor handles Davis-Bacon prevailing wage and traveling crews across state project sites, and where Gusto and Rippling diverge.