Most management-company owners can tell you their total revenue, but very few can tell you which associations actually make money once the labor and overhead to service them are counted. That gap is structural: the accounting modules in CAM software keep each association's books separate, so the firm's own margin on each contract never appears on a single screen. This template reconstructs it — management fee plus ancillary income, minus the loaded cost to serve, community by community.
What this report answers
The portfolio overview answers the questions an owner runs the business on: what do we bill across every contract, what does it cost us to deliver, and what's left over? The detail page goes one level deeper — it lists every community with its gross margin and surfaces the money-losers, the contracts where cost to serve has crept above the fee you're collecting. A scatter of doors against gross profit instantly separates the small-but-profitable communities from the large-but-thin ones that look impressive on a door count and earn almost nothing.
The metrics that matter
Portfolio gross margin rate is the headline — gross profit as a share of total revenue. Revenue per door is the blended benchmark you carry into every renewal conversation, because it makes a 90-door condo and a 600-door master-planned community comparable. Cost to serve is the number CAM software was never built to produce: it loads manager time, admin, and accounting against a specific contract so a thin fee paired with a high-touch board finally shows up as the loss it is. The unprofitable-communities count is the short list of contracts to reprice or resign first.
Why the data is trapped across the systems
Vantaca, TOPS [ONE], CINC Systems, AppFolio, Buildium and the rest are built around per-association accounting and resident portals — each association is its own ledger, deliberately walled off from the next. That design is correct for fiduciary reporting to a board, but it means the management company's own P&L doesn't exist in the software. To see margin per community you have to roll up management-fee income from one place, ancillary income from another, and labor and overhead from somewhere outside the platform entirely — which is exactly why the standard industry advice is to "use a shared spreadsheet." This template does that roll-up in a model instead of a workbook that goes stale the day you build it.
How to read it
Start with the bottom-15 gross-profit bar and the unprofitable-communities card — those are the contracts bleeding money right now. Then read margin by tier and by region to see whether the losses are concentrated in a pricing band (often the "Lite" tier) or a geography you've over-expanded into. The scatter is where the surprises live: communities sitting low and right are large doors earning thin margin, the textbook repricing or right-sizing candidates.
The sample on this page uses entirely synthetic, anonymized community data — no real associations, owners, or financials.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Management-Fee Revenue | Sum of the monthly management fee across every community — the recurring contract revenue you bill the boards, not the associations' own assessment income. |
| Total Cost to Serve | Sum of the loaded cost to service each contract — manager labor, admin, accounting, and allocated overhead. |
| Total Gross Profit | Management fee plus ancillary revenue minus cost to serve, summed across the portfolio. |
| Portfolio Gross Margin Rate | Gross profit divided by total revenue (management fee plus ancillary) across all communities. |
| Communities Under Management | Count of associations currently under contract — one row per community. |
| Revenue per Door | Total revenue divided by total doors — blended monthly revenue earned per managed door. |
Used by: Management-company owners, presidents, and regional directors
Frequently asked questions
Why can't my CAM software show profit per association?
Vantaca, TOPS, CINC and similar platforms are built around each association's own books — its assessments, its expenses, its reserves — for fiduciary reporting to that board. The management company's margin on the contract (your fee minus what it costs you to serve it) lives outside that per-association ledger, so the software never rolls it up. That's the gap this template fills.
What counts as 'cost to serve' a community?
The loaded cost of delivering the contract: the community manager's allocated time, administrative and accounting support, and a share of overhead. The sample models it as a realistic percentage of each contract's revenue, with a slice of communities deliberately running above their fee so you can see how money-losers appear.
Can I build this on my own portfolio?
Yes. Export your management-fee revenue and a cost or labor allocation per community, and use this as a template. We model it into a Power BI report you open in Power BI Desktop; the sample here uses synthetic data so you can see the finished shape first.
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 →