For many management companies, ancillary fees are the most profitable line on the P&L and the least visible. Resale certificates, estoppel and transfer documents, closing packages, fine processing, late fees, ARC review fees, portal convenience fees — they're high-margin, they scale with home sales and homeowner activity, and they're scattered across dozens of association ledgers where no owner can see them in total. This template pulls all seven revenue lines together, per door, so under-monetized communities and revenue lines stop hiding.
What this report answers
The mix page answers the monetization question: how much fee income are we earning, what's the breakdown across the seven lines, and how does it stack up against base management fees? The detail page exposes the gaps — the bottom communities by ancillary per door, the ones where you're leaving resale, estoppel, or fine income uncaptured. Revenue per document order shows whether your resale and estoppel pricing has kept pace, an easy lever that many firms haven't touched in years.
The metrics that matter
Ancillary revenue per door is the benchmark — it makes a small condo and a large HOA comparable and instantly flags the communities earning far less fee income than their peers. Ancillary share of total revenue tells you how diversified the firm is beyond the base management fee, and how exposed it is to home-sale volume. Resale and transfer doc revenue is the closing-driven engine, and revenue per document order is the pricing lever inside it — the single number to revisit when transaction volume is up but income isn't.
Why the data is trapped across the systems
This is the report CAM software fights hardest. Resale and estoppel orders may flow through Vantaca, CINC Systems, or a dedicated document portal; fines and late fees post to each association's ledger; ARC fees sit in Smartwebs or the compliance module; portal convenience fees show up in the payment processor's reporting. Every line is real, but each lives in a different place and posts to a different association's books — so the total fee income across the portfolio, and the per-door comparison that reveals under-monetization, simply doesn't exist in any one system. The industry literature on "how CAM companies turn a profit" keeps pointing to resale and ancillary revenue precisely because owners can't see it. This template assembles it.
How to read it
Read the per-portfolio percent-of-total stacked column first to understand your mix — if resale and estoppel dominate, your fee income rides on home sales and you'll feel every slow market. Then work the bottom-15 ancillary-per-door bar: those are communities where a revenue line is missing or under-priced relative to comparable doors. Compare ancillary share by tier to see whether your higher tiers are actually capturing more fee income or just a higher base fee.
The sample on this page uses entirely synthetic, anonymized revenue data — no real associations, homeowners, or transactions.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Ancillary Revenue | Sum of the seven non-management-fee revenue lines across the portfolio. |
| Resale & Transfer Doc Revenue | Resale-certificate plus estoppel plus transfer-document revenue — the closing-driven fee income. |
| Total Document Orders | Resale, estoppel, and transfer requests fulfilled across the period. |
| Ancillary Revenue per Door | Total ancillary revenue divided by doors — the key monetization benchmark for comparing communities. |
| Ancillary Share of Total Revenue | Ancillary revenue as a share of management fee plus ancillary — how much of the top line comes from fee income. |
| Revenue per Document Order | Resale and transfer doc revenue divided by document orders — the average price realized per document transaction. |
Used by: Owners and presidents focused on monetization
Frequently asked questions
What counts as ancillary revenue for a management company?
Fee income beyond the base management fee: resale certificates, estoppel and transfer documents, closing packages, fine processing, late fees, architectural (ARC) review fees, and portal or payment convenience fees. It's often the firm's highest-margin revenue, which is why it's worth seeing in total and per door rather than buried in each association's ledger.
Why measure ancillary revenue per door?
Per-door normalization makes every community comparable regardless of size, so a community earning far less fee income than its peers stands out as under-monetized — a missing or under-priced revenue line you can fix. Total dollars alone just track size; per door tracks monetization.
Is any of this real financial data?
No. The sample is entirely synthetic and anonymized. To build your own, export each ancillary revenue line by community along with doors and management fee; 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 →