Management companies grow by winning boards, but almost none run that effort like a pipeline — because CAM software has no CRM for the customers who hire the management company. Growth lives on a spreadsheet and in a business-development director's head. This template makes the proposal pipeline visible: referrals, board RFPs, developer handovers, and competitor switches moving through the stages to a win or a loss, with weighted pipeline value and the doors and revenue actually booked.
What this report answers
The pipeline page answers the growth question: how many doors and how much revenue are in play, where are opportunities stalling in the funnel, and what's our win rate on the proposals we actually decide? The detail page answers where the wins come from — opportunity volume and revenue by lead source — so business development can double down on the channels that convert. Doors won here pairs with doors lost in the retention report to show whether the portfolio is actually growing.
The metrics that matter
Proposal win rate is the headline — won divided by decided, ignoring still-open deals so it isn't flattered by a stuffed top of funnel. Weighted pipeline revenue is the forward number: each open opportunity's annual fee scaled by its stage probability, the realistic expectation of new revenue. New annual revenue won and doors won are the bookings that, set against churn, reveal net growth. Lead source ties it all to where growth actually originates.
Why the data is trapped across the systems
This is the one report whose data barely exists in CAM software at all. Vantaca, CINC Systems, AppFolio, and Enumerate / CiraConnect onboard a community only after it's won — they have no concept of a prospect, a proposal stage, or a win rate, because they're operational platforms, not sales tools. So the entire pipeline lives in spreadsheets, email threads, and the BD director's memory, with no standing view of weighted value or stage conversion. When a referral stalls, nobody notices until it's gone cold. This template gives growth the pipeline structure the operational software was never going to provide.
How to read it
Read the stage funnel to find the leak — a sharp drop between proposal and finalist points to a pricing or fit problem, while a drop between finalist and won points to a closing problem. Weighted pipeline revenue is your forecast; compare it to the new-revenue target to see whether the top of funnel is full enough. Use the lead-source views to decide where business development spends its time, and set doors won against the retention report's doors lost to confirm the portfolio is growing net of churn.
The sample on this page uses entirely synthetic, anonymized pipeline data — no real prospects, boards, or proposals.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Pipeline Doors | Doors across active (open) opportunities not yet won or lost. |
| Opportunities Won | Count of new community contracts signed this period. |
| Proposal Win Rate | Won divided by decided (won plus lost), excluding still-open opportunities. |
| Weighted Pipeline Revenue | Annual fee times stage probability for open opportunities — probability-weighted expected new revenue. |
| New Annual Revenue Won | Annual fee on the opportunities signed this period — booked new recurring revenue. |
| Doors Won | New portfolio doors booked this period; pairs with the retention report's doors lost for net door movement. |
Used by: Owners and business-development directors
Frequently asked questions
What is a good proposal win rate in HOA management?
Win rate depends heavily on lead source — referrals and developer handovers typically close far higher than cold competitive RFPs — so the useful read is win rate by source rather than a single portfolio number. The template computes win rate on decided opportunities only (won plus lost) so a pile of open deals doesn't inflate it, and breaks it out by lead source.
How does weighted pipeline revenue work?
Each open opportunity's annual fee is multiplied by a probability tied to the furthest stage it has reached — a finalist counts for more than an early lead. Summing those gives a realistic expected-revenue forecast that doesn't treat a long-shot lead the same as a near-certain win. Won and lost opportunities drop out of the weighted figure.
Is this real pipeline data?
No. The sample is entirely synthetic and anonymized. To build your own, export your opportunities with their doors, annual fee, lead source, furthest stage, and won/lost status; we model it into a Power BI report you open in Power BI Desktop.
Build this report on your own data
Clone this HOA management template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →