How Do You Build a Consolidated Cash Flow View for Multiple Properties?

Start with the failure mode: why the bank balances lie

The reason you cannot see your portfolio's cash flow is rarely missing data; it is that the data lives in pieces that do not add. A typical six-property portfolio runs eight bank accounts across three corporations. Rent lands in one account, the mortgage comes out of another, a renovation gets paid from whichever company had cash that week, and the owner draws from wherever the balance looks healthy. Every property can look fine in isolation while the group quietly consumes more than it makes.

Profit statements do not rescue you, because rental profit and rental cash are different numbers. A property showing a healthy net income can be cash-negative once mortgage principal and a new roof are paid, and a property showing a paper loss after CCA can be the one funding everything else. Owners who manage from the T2 or from bank balances are steering with two instruments that both point the wrong way.

The consolidated cash flow view exists to answer three questions on one page: which properties generate cash, where that cash goes, and how much the group can commit, to a purchase, a renovation, or a distribution, without borrowing to cover the commitment. Everything in the build serves those three questions.

Move one: standardize the property-level books so the numbers can be added

Consolidation starts with sameness. Every property gets the same chart of accounts, the same revenue and expense categories in the same order, on the same bookkeeping platform, with a property tag on every transaction. If one company's books call it repairs and another's calls it maintenance and a third lumps it into general expense, the combined line means nothing, and every month of history compounds the problem.

How many sets of books you standardize depends on your ownership structure. One corporation holding four properties is one ledger with four tracking classes; four corporations need four ledgers that mirror each other exactly. The structure question itself, and the tax weight each option carries, is a separate decision we cover in whether rentals belong in a corporation, but whatever structure you have, the reporting cure is identical: same accounts, same tags, same monthly close.

Three disciplines make the property-level numbers trustworthy. Tie revenue to the rent roll every month, so vacancies and arrears surface as facts rather than year-end surprises. Pay each property's costs from the corporation that owns it, because costs paid by a sister company create intercompany balances that need their own accounting. And post recurring accruals, property tax and insurance in twelfths rather than as annual lumps, so one month's picture is comparable to the next.

Shared costs need a rule, not a habit. Insurance bought on one policy, a superintendent covering three buildings, bookkeeping fees billed to one company: allocate them on a stated basis, by units, square footage or revenue, and keep the basis constant. Allocation drift is invisible month to month and fatal to year-over-year comparisons.

Move two: eliminate intercompany transactions, or the total is fiction

Adding entities together without eliminations double-counts your own money. If your holding company charges a management fee to each property company, the group total shows the fee as both income and expense; if one corporation rents space to another, combined revenue inflates by rent nobody outside the group ever paid. A consolidated view only tells the truth after every internal flow has been identified and netted out.

The working tool is an intercompany matrix: one schedule listing every balance and every recurring charge between group companies, confirmed equal on both sides at each month-end. Loans between companies, recharged costs, management fees, rent between entities, each gets a row. When the matrix reconciles, eliminations are mechanical. When it does not, the consolidated view is wrong by exactly the amount nobody can explain, and the first fix belongs in the underlying books.

Cash movements deserve one more distinction. A transfer between two of your companies is not group cash flow at all; it changes which pocket holds the money, not how much money there is. The view should show internal transfers in their own section, below the real operating lines, so a month where Corporation A funded Corporation B's shortfall reads as what it was. Groups that let transfers sit inside operating cash flow routinely mistake circulation for generation. The wider discipline of keeping several corporations reportable, filings, balances and paper, is covered in how to report across multiple real estate corporations.

Move three: convert profit to cash, line by line

The conversion is where most homemade views fail, because the items that separate profit from cash are exactly the ones bookkeeping treats quietly. Four of them do most of the damage, and each moves in its own direction.

So the view starts from net operating income per property, rent less operating costs before any financing or depreciation, then deducts full debt service, principal and interest together, to get each property's true surplus. Below the property lines it deducts group overhead, corporate tax instalments, and capital spending, and only then shows distributions. CCA never appears, because it is not cash; it matters enormously for tax, and not at all for this page.

HST needs care proportional to your mix. Commercial properties collect HST on rent, recover it on costs and remit the difference, so their gross cash swings do not reflect real earning; show HST in its own column so the operating lines stay clean. Long-term residential rent is exempt, which means HST paid on costs is simply part of the cost, and there is nothing to strip out. A mixed portfolio carries both patterns at once, one more reason the property tag on every transaction matters.

Financing items complete the conversion. Renewal dates, rate resets and interest-only periods belong on the page, because a property that carries its debt today can fail at renewal pricing. Groups that run this view use it to test exactly that: reprice each mortgage at a stressed rate and watch which property lines go negative.

What the finished page looks like, and the cadence that keeps it honest

The finished product is deliberately small: one page, monthly, properties as rows or columns. For each property, NOI, debt service, and surplus. For the group, overhead, tax, capital spending, distributions, and the closing position, with internal transfers shown separately. A second page carries the forward view: the next twelve months with known lease expiries, planned capital work and mortgage renewals layered in, so the surplus you are counting on is the one after the events you already know about.

Cadence is what turns the artifact into a management tool. Built once for a bank request, the view is stale in a quarter; closed monthly, within a couple of weeks of month-end, it starts answering questions before they become problems, which unit's arrears are compounding, which property's repairs are trending toward a capital decision, whether this year's distributions are being earned or borrowed. Lenders notice the difference immediately: a portfolio that produces a current consolidated cash flow on request reads as managed, and the credit conversation starts from your numbers instead of the lender's reconstruction of them.

Spreadsheets can carry a small portfolio, and plenty of good views live in one. The honest limit is fragility: once entities multiply and eliminations stop being trivial, a spreadsheet maintained by hand starts to drift from the books it summarizes. The durable version pulls from bookkeeping files that already share one chart of accounts, which is why move one was the foundation.

The facts that change the design, and how we build it

Six facts decide what your version of this view needs. The ownership structure, because every additional corporation adds a ledger and an elimination layer. The HST profile, exempt residential, taxable commercial or mixed. The debt stack, since renewal dates and covenant tests dictate the forward page. The capital program, because a portfolio in renovation mode lives or dies on capex timing. Who has to trust the numbers, you alone, or a credit committee. And whether the portfolio is meant to outlive you, because a succession-bound group needs the view a business estate planning CPA in Ontario will eventually rely on to value, divide or fund the estate.

We build and run these views as part of our work for property groups; the full picture of how the accounting, tax and reporting fit together is in accounting and tax planning for real estate investment companies. In an Ongoing Financial Partnership the consolidated cash flow is simply a monthly deliverable: the books close, the matrix reconciles, the page updates, and the same numbers feed the T2s and the lender file. Where an owner just needs the view built once, properly, with the chart of accounts and eliminations set up to last, that is Fractional CFO territory with a written scope, and the discovery call that defines it is free.