Cube vs. Mosaic for CAM Reconciliation Across Properties

The management company earns fee revenue and incurs its own overhead, staff, software, insurance, while each managed property has its own income, expenses, and CAM pool that belongs to the property owner, not the management company. A forecast that blends these two together will misstate the management company's actual margin, since property-level revenue passing through isn't the management company's revenue at all.

Get this separation right before building anything else, since every other step in the forecast depends on knowing which numbers belong to the management company and which belong to the properties it serves. A property management company that skips this step often ends up presenting a much larger revenue figure than it actually earns, simply because gross property income was never stripped out of the company's own top line.

Common area maintenance charges are typically billed to tenants as estimates throughout the year, then reconciled against actual expenses at year-end, with tenants owing more or getting a refund depending on how the estimate compared to reality. A forecast that ignores this annual true-up will show a misleading expense pattern, since the reconciliation often creates a real swing in cash and in what's owed between the property and its tenants.

Track CAM estimates against actual expenses throughout the year rather than waiting until year-end to discover a large variance, so a true-up doesn't arrive as a surprise to either the property owner or the tenants being billed each year. A property whose CAM estimates consistently run well below actual expenses needs its estimating methodology revisited, not just another large true-up bill.

Run CAM as a repeating annual cycle like this:

1. Bill CAM to tenants as estimates throughout the year, based on the expected common area expenses for each property.
2. Track actual common area expenses against those estimates as the year goes on, not only at year-end.
3. At year-end, compare estimates with actuals to see whether each tenant owes more or receives a refund.
4. Keep each property's CAM pool separate from the management company's own books and fee revenue.
5. Plan for the swing the true-up creates so it does not surprise property owners or tenants.

If your team already tracks management fee revenue by property and reconciles CAM pools in a spreadsheet, Cube's approach of syncing that spreadsheet against your property management software keeps the logic where it's understood, with less manual export from each property's accounting each month.

This tends to be the lower-friction path when the per-property fee formulas already work correctly and the real pain point is simply pulling fresh numbers from each property's accounting system every month rather than rebuilding the calculation logic itself.

Once you're managing enough properties that rolling up management fee revenue and CAM status into one view becomes a real time cost in a spreadsheet, a dashboard consolidating that automatically can help ownership see the picture across the whole portfolio. Confirm in a demo that Mosaic can keep each property's CAM pool and fee calculation separate rather than blending them into one company-wide figure.

A portfolio-wide dashboard is most valuable once the property count is large enough that a single owner or asset manager genuinely can't hold every property's status in their head, which is a different threshold for every management company depending on how hands-on ownership wants to stay.

If your management company also advises on or participates in property acquisitions or refinancing, the current cost of debt directly affects deal underwriting; with the 10-year Treasury yield near 4.44%¹, build financing assumptions off the current rate environment rather than a rate from when a prior deal closed, since stale rate assumptions can make an acquisition look more attractive on paper than the actual financing available today would support.

Jirav's driver-based approach is useful when you're planning to add properties to the portfolio and want the model to show how many additional property managers and maintenance staff that growth actually requires, rather than assuming existing staff can absorb new properties without a corresponding increase in headcount.

A management company that adds properties faster than it adds staff tends to see service quality slip at existing properties first, since overstretched property managers naturally prioritize the newest or most demanding accounts, and that erosion often shows up in the numbers well before an owner complaint makes it obvious.