Commercial Property Cash Flow Forecasting for Small Landlords

A rent roll can look healthy and still leave a landlord short on cash at the wrong time.

That usually happens because the rent roll answers a different question. It shows what should be billed under the leases. A cash flow forecast asks what is likely to land in the bank this month, what must be paid this month, and how much room is left after both. For a small commercial or NNN portfolio, that distinction matters when a tax installment, insurance renewal, vendor invoice, or loan payment arrives before a late-paying tenant catches up.

The goal is not to predict the future perfectly. It is to make the next few months visible enough to act early: follow up on a collection, move a discretionary project, preserve a cash cushion, or explain a timing gap before it becomes a surprise.

Start With Operating Cash, Not Annual NOI

NOI is useful for understanding property performance. A monthly cash forecast is a working operations tool. It is concerned with timing.

For each month, begin with a simple structure:

| Forecast line | What belongs there | | --- | --- | | Opening cash | The cash available at the start of the month for the property or operating account you are reviewing | | Expected collections | Rent and other amounts reasonably expected to be received in that month | | Known cash out | Scheduled operating expenses and other known payments due that month | | Net monthly cash movement | Expected collections less known cash out | | Ending cash | Opening cash plus or minus the month's expected movement |

Keep the forecast focused on cash timing. Do not treat billed rent as collected rent by default. Do not assume a CAM reimbursement will arrive in the same month as the expense it offsets. And do not bury a known annual bill inside an even monthly average just because it makes the sheet look smoother.

If you need the separate operating-performance view, see our guide to NNN net operating income. The forecast should sit beside that view, not replace it.

Build Expected Collections Tenant by Tenant

The collection side of the forecast should come from the lease schedule and the actual collection pattern, not from a single annual rent number divided by 12.

For each tenant, capture the amount due, the usual payment date, and the best current expectation for the month. Include:

• base rent due under the current lease schedule
• scheduled rent escalations that take effect during the forecast window
• percentage rent or other recurring charges only when the timing and amount are reasonably supportable
• CAM, tax, or insurance estimates when they are billed and expected to be collected
• credits, abatements, free-rent periods, or approved concessions that reduce expected cash
• known delinquency, payment plans, or tenant disputes that may delay a collection

A practical forecast distinguishes between contractual due and expected to collect. A tenant that routinely pays five days after the first may still be a reliable collection. A tenant with an open dispute or a broken payment commitment belongs in a more cautious column.

That does not mean writing off the rent. It means avoiding a cash decision based on money that has not arrived. Track the receivable separately and update the forecast when the facts change.

> A forecast becomes useful when it reflects the collection date you can reasonably expect, not the invoice date you wish were true.

Put Lease Dates on the Monthly Calendar

Cash flow problems often start as missed lease dates. A rent escalation may be correct in the abstract but absent from the invoice. A free-rent period may end, but the forecast still assumes the old payment amount. A renewal may be under discussion while the forecast quietly carries the prior rent for another year.

At the start of each forecast cycle, review the next 90 days for:

1. fixed-dollar and percentage rent increases 2. free-rent expirations and other concession end dates 3. lease commencements, move-outs, and renewal decisions 4. CPI or other adjustment notices that need calculation or communication 5. option deadlines and other dates that could change occupancy or rent

The point is not to turn the cash forecast into a lease abstract. It is to pull forward the lease events that change monthly cash. A current commercial lease administration checklist makes this review much easier to repeat.

Schedule Expenses When They Will Be Paid

On the expense side, use known payment timing rather than a generic monthly average. Your forecast should show the invoices and obligations likely to leave cash during the month, including:

• property tax installments
• insurance premiums or financing payments
• utilities and recurring service contracts
• payroll, management, and accounting costs
• planned repairs, make-readies, and approved capital work
• debt service, if you use the forecast to plan total property cash needs

For NNN properties, record recoveries and expenses separately. An expense can be recoverable under a lease and still create a short-term cash need if the vendor must be paid before the tenant is billed or pays. Likewise, a forecast should not assume that every expense is recoverable: caps, exclusions, vacancies, fixed-CAM arrangements, and lease-specific responsibilities can leave part of the cost with the landlord.

When an amount is uncertain, use a clear assumption rather than false precision. For example, list a pending roof repair as a range or mark it as a decision item until you have a bid and a timing commitment. That gives you a chance to see the pressure without pretending the number is settled.

Use a Rolling 13-Week View Alongside Monthly Totals

Monthly totals are enough for many planning conversations, but a rolling 13-week view can reveal a near-term squeeze that a calendar-month report hides. It is especially useful when rents arrive early in the month and major expenses leave late in the prior month, or when several tenants pay on different schedules.

The weekly view does not need every minor transaction. Include the material cash movements that could change a decision:

• expected tenant receipts by likely week
• scheduled tax, insurance, debt, and vendor payments
• approved projects with a deposit or milestone payment
• known delinquent balances and the next collection action
• transfers or owner contributions, if they are actually planned

Use the monthly forecast for the big picture, then use the 13-week view when the timing of cash matters. If occupancy may change, keep the vacancy report nearby so the forecast reflects real leasing status instead of last quarter's assumptions.

Set a Review Cadence That Matches the Portfolio

The first forecast is less important than the habit of updating it. A reasonable cadence for a small commercial portfolio is:

• Weekly: Update collections received, late payments, urgent vendor commitments, and the next four weeks of cash.
• Monthly: Roll the forecast forward, compare expected and actual cash movement, and review scheduled rent changes and major expense dates.
• Quarterly: Revisit vacancy assumptions, service contracts, tax and insurance timing, upcoming capital work, and the cash reserve target.

Keep a short note beside material changes. If expected collections fell because a tenant asked for a payment plan, say so. If cash improved because an insurance invoice moved to next month, record that timing change. Those notes help distinguish a true operating problem from a bill that simply landed earlier or later than expected.

Turn Forecast Gaps Into Decisions

The forecast is not an accounting exercise to file away. It should lead to a decision when the projected ending cash falls below the cushion you need.

Before reacting, ask a few practical questions:

• Is the gap caused by a collection risk, or by the timing of an otherwise expected payment?
• Which expense is fixed and unavoidable, and which cost can be rescheduled without creating a bigger problem?
• Is a tenant reimbursement expected later, and is it actually permitted and supported under the lease?
• Has a planned repair been approved, bid, and scheduled, or is it still an estimate?
• Does the forecast need a collection follow-up, a vendor conversation, an owner decision, or an updated reserve plan?

Do not use a forecast to make lease, tax, accounting, or lending conclusions on its own. The active lease, invoices, bank activity, and advice from the appropriate qualified professional still control when interpretation or compliance is involved.

Make the Forecast Easy to Maintain

A complex workbook that nobody updates is not a forecast. Start with the fields that change cash: tenant, expected receipt date, amount, confidence or collection note, payment due date, expense category, and assumption note.

Then keep the records connected. The rent schedule should reflect current lease dates. Collection expectations should reflect current follow-up. Expense timing should reflect actual vendor and tax calendars. When those inputs live in scattered spreadsheets, email threads, lease PDFs, and accounting notes, the monthly review becomes a reconstruction project.

PigJet helps commercial landlords keep lease dates, rent changes, tenant records, and operating workflows organized in one place. If you want to see how that can support a more reliable monthly cash review for your commercial or NNN portfolio, book a demo at PigJet.