From one blended number to property-level clarity

The client

A real estate investment fund holding multiple properties, with money moving constantly: acquisitions, distributions, capital calls, and property-level expenses. The portfolio was real and the totals were there. The reporting underneath them was not.

The problem

Financial information lived across systems and spreadsheets that did not reconcile to each other, so what anyone could see depended on which source they happened to open. The fund knew what had been raised and what had been spent. It could not tell how much capital was actually sitting in each asset.

Returns were understood at the fund level only. Without consistent property-level data, comparing one building against another was not possible even in principle, which meant a weak property could be masked by a strong one for a long time before anyone noticed.

Investor capital accounts carried the same uncertainty. Contributions, distributions, and allocations had never been traced end to end, so no balance could be defended without reconstructing it first. For a fund, that is where a reporting problem turns into a decision problem: every allocation becomes a guess.

What we did

Moved the fund onto one system of record

We transitioned the fund’s accounting to QuickBooks and established a centralized, secure reporting portal, so one set of books became the source everyone worked from instead of several that disagreed.

Ran a forensic review of the capital accounts

We reconstructed the capital account history and traced contributions, distributions, and allocations back to source, correcting discrepancies as they surfaced. Each investor’s balance now reflects what actually happened rather than a figure carried forward.

Tagged every transaction to its property

We implemented class tracking so income and expense are isolated per asset. This is the change that made everything else possible: property-level performance became a report rather than a project. Separate books per property would have created reconciliation work and drift, while class tracking keeps one ledger, so the portfolio view and the property view always agree.

Rebuilt the monthly reporting package

We redesigned the monthly reporting so it arrives on a schedule and answers the questions the fund actually asks: performance by asset, capital position by investor, and cash movement across the portfolio.

The result

Investor capital accounts and distributions are reconciled and aligned. Performance is tracked and compared across individual assets, so underperformance surfaces early enough to act on. Monthly reporting arrives consistently and supports both management decisions and investor communications.

The fund did not change what it owned. It changed what it could see, and that is what made the portfolio manageable.