A commercial portfolio cash forecast is only useful when the owner can trace its lines to current property records. Rent, recoveries, invoices, approved work, vendor commitments, and upcoming lease events can sit in different reports. The review task is to connect them before changing the forecast.
This is an operating review, not investment or accounting advice. The owner needs a dated view of what is known, what is expected, what is committed, and what still requires a decision.
Set the forecast period and property list
Name the buildings, bank or reporting period, opening cash position, and forecast dates. Keep each property visible before rolling the portfolio into one total. A portfolio number can hide one building’s vacancy, recovery delay, large invoice, or approved project.
Coastline’s guide to cash flow management connects income timing, expenses, reserves, and owner decisions. Use the guide as a framework for the records to assemble, then tie each line to the source report that supports it.
Reconcile expected income
Start with scheduled rent, known changes, delinquency, collections, recoveries, credits, deposits, and lease events that affect timing. Show the source period and explain material variance from the prior forecast. A recovery that is calculated but not billed or collected belongs in a visible status column, not in the same bucket as cash received.
For each tenant or property exception, identify the next action, responsible person, and review date. The goal is a forecast that tells the owner which income is supported, which is expected, and which is waiting on a record or decision.
Reconcile invoices and commitments
List open payables, recurring contracts, approved repairs, capital work, tenant improvements, taxes or insurance invoices, and known vendor commitments. Match material items to an invoice, proposal, contract, approval, or project record. Separate approved from scheduled, incurred from paid, and estimated from documented.
Coastline’s commercial owner scorecard calls for reconciled invoices, variance notes, lease obligations, cash needs, and decision support. Those fields let an owner see why the forecast changed instead of treating a new total as an unexplained answer.
Keep a short assumptions register beside the forecast. Record the source date, amount or timing assumption, person who supplied it, and date it must be refreshed. Mark whether the item is confirmed, expected, estimated, or pending. That is enough context for an owner to challenge one line without discarding the whole forecast.
When a material variance appears, explain the movement in plain language and link to the record that changed. A late collection, approved project, revised invoice, or lease event should be visible as the reason for the change.
Present decisions and review dates
End the forecast with a short decision register: item, property, amount or timing effect, supporting record, decision owner, due date, and next review. Link large work or recovery questions to the underlying record. If an assumption is unverified, label it pending and show how it affects the range of expected cash.
Use the same structure each period so the owner can compare changes. The value is a reliable record of movement and open decisions, not false precision.
If rent, recoveries, invoices, approved work, and commitments are difficult to connect across your commercial portfolio, Request a Property Management Performance Review.




