Commercial Property Budget vs. Actual Reporting: A Monthly Workflow for Landlords

Abstract commercial-property budget-to-actual reporting workflow with architectural model, document marks, and comparison line.

Commercial Property Budget vs. Actual Reporting: A Monthly Workflow for Landlords

A budget-to-actual report is easy to produce and easy to ignore. A few lines are over budget, a few are under, and the month closes with no clear answer to the only question that matters: what needs attention now?

For commercial landlords, that gap creates trouble later. A utility spike may be a billing error, a leak, a rate change, or a vacant-space allocation issue. A repair invoice may be routine maintenance, a capital item, or an expense that needs more support before it is considered for tenant recovery. If those questions sit unresolved, the year-end CAM process becomes a search through old invoices and email threads.

The purpose of a monthly budget-vs.-actual process is not to predict the future perfectly. It is to compare the approved operating plan with recorded general-ledger activity, identify material differences, assign a next step, and keep the support with the property record.

> This is an operational workflow, not accounting, tax, legal, or lease-interpretation advice. Chart-of-accounts treatment, accruals, capital-versus-expense decisions, and tenant-recovery questions depend on the facts, the lease, and applicable requirements. Use qualified accounting, tax, and legal advisers where those decisions are needed.

Start With a Report You Can Reconcile

Build the report at the same level of detail as the approved operating budget. A useful monthly view normally includes each property, the month and year-to-date period, budget, actual GL activity, dollar variance, percentage variance, and a place for an owner and disposition.

Before asking why a line moved, make sure the comparison is sound:

For a portfolio, begin with a property summary and then move to the account detail. The summary directs attention; the account detail explains it. A consistent chart of accounts for NNN landlords makes this comparison much easier because the same categories remain visible from budget through invoice review and later reconciliation.

Set a Materiality Rule Before Looking at the Numbers

Without a materiality rule, a report can create two opposite problems: every small variance gets a comment, or only the most obvious outliers receive attention. Decide in advance which items require review.

A practical rule may combine a dollar threshold, a percentage threshold, and a judgment trigger. For example, a property team might review a variance when it exceeds a designated dollar amount and percentage of budget, while also reviewing any unusual vendor, utility, tax, insurance, repair, or tenant-recovery item regardless of size. The right thresholds depend on the property's scale, budget, and management structure.

The point is consistency. Document the threshold and the exceptions so a new team member can understand why one variance received a full investigation while another was simply noted.

Use a Monthly Close Workflow

The following sequence gives each variance a path from report to resolution.

1. Freeze the source set

After the close cutoff, save the GL detail, accounts-payable register, bank or cash information used by the accounting team, and the budget version. If late entries are expected, mark the report preliminary and log the expected update rather than silently replacing the file.

This creates a record of what the team knew at the time. It also prevents a later adjustment from making an earlier explanation impossible to trace.

2. Run the budget-to-actual report

Compare actual activity with both the monthly and year-to-date budget. Sort by the materiality rule, then group related lines when a single cause affects more than one account. A snow-removal invoice, for example, may affect both a direct contract line and a repair line depending on the established coding approach.

Do not treat a favorable variance as automatically good. It may reflect an unrecorded invoice, delayed work, a miscoded charge, or an expense that will arrive in a later period.

3. Classify the variance before explaining it

Use a small set of repeatable categories. Common operational categories include:

Classification is not the final conclusion. It is a way to make the next question more precise: which document, person, or decision will confirm what happened?

4. Investigate with the supporting record

For each material item, link the report line to the GL detail and then to the relevant support: invoice, contract, work order, utility statement, tax notice, approval, or correspondence. Record a short factual explanation, the evidence reviewed, and anything still unknown.

Avoid explanations such as “over budget—monitor.” A better note identifies the cause and action: “Electricity above budget after a rate change shown on the August statement; property manager to confirm the new rate schedule and update the remaining-month outlook by September 12.”

When the item involves a lease, operating-expense recovery, or classification judgment, route it to the qualified person who can advise on that question. The monthly report can flag the item without deciding what a lease permits.

5. Assign one owner and one due date

A variance is not resolved because it has a narrative. Give every open material item a single accountable owner, a due date, and a defined next action. That may be obtaining a corrected invoice, confirming a service scope, asking the accountant about coding, obtaining management approval, or obtaining professional advice.

Keep the owner field distinct from the person who wrote the comment. A controller may prepare the report while a property manager owns vendor follow-up and an asset manager owns a budget or operating decision.

6. Decide the disposition

At the end of review, label each material item with a status such as closed, monitoring, correction pending, approval pending, or reforecast candidate. Retain the final note with the evidence and date.

A reforecast can be useful when conditions truly changed, but it should sit beside—not replace—the approved budget. Keeping both makes it possible to see the original plan, the actual result, and the current outlook without rewriting history.

7. Carry unresolved items forward

Open items should appear on the next month's close list until they are closed. Carry forward the owner, due date, prior explanation, and linked support. This is where a monthly process becomes a control: the team can see whether the same variance is repeating, growing, or stuck.

A Simple Variance Log

Your log can be short. The important thing is that it connects the report to action.

| Field | What to record | | --- | --- | | Property and account | The property, GL account, and reporting period | | Budget / actual / variance | Current-month and year-to-date comparison | | Category | Timing, usage, rate, scope, coding, or one-time/project | | Explanation | A factual description of the apparent cause | | Support | Links or references to GL detail, invoice, contract, work order, or correspondence | | Owner and due date | One accountable person and the next deadline | | Status | Closed, monitoring, correction pending, approval pending, or reforecast candidate |

Store the log with the month-end package rather than in an isolated spreadsheet. The record should be easy to find when an owner asks why expenses changed, when a vendor dispute arises, or when the team prepares for an annual reconciliation.

Keep Four Similar Processes Separate

These activities inform one another, but they serve different purposes.

| Process | Primary question | Typical cadence | | --- | --- | --- | | Monthly budget to actual | Did recorded operating activity differ from the approved plan, and what action is needed? | Monthly close | | Annual CAM estimate setup | What operating-expense estimate and collection schedule should be set for the upcoming period under the applicable leases? | Annual budget cycle and lease-driven updates | | Owner reporting | What concise, decision-useful view should ownership receive about operations, variances, cash, and open items? | Monthly or as agreed | | Cash forecasting | When will cash be received and paid, and what liquidity is expected? | Rolling weekly or monthly |

Do not use the monthly GL report as a substitute for the annual estimate process. CAM estimate setup depends on lease terms, recoverability, exclusions, caps, timing, and other property-specific facts. Likewise, a favorable accrual-basis variance does not necessarily mean cash is available; receivable timing, debt service, reserves, and scheduled payments belong in cash forecasting.

For the annual close and support trail, see PigJet’s CAM reconciliation calendar for NNN landlords. For the wider cadence around lease records, deadlines, and recurring operating work, use this NNN lease administration checklist.

Make the Report Useful to Ownership

Owners rarely need every GL line in the first page of a report. They need a concise view of what changed, why it changed, what decision is needed, and what remains open. A practical owner summary can include total operating variance, the handful of material drivers, year-to-date trend, actions underway, decision requests, and risks to the current outlook.

Keep detailed support behind the summary. That allows a conversation about the business while preserving a path back to the invoice, GL line, and documented follow-up.

Build the Habit Before Year-End

The most valuable part of the workflow is the discipline of closing open loops each month. When the team consistently preserves the baseline, investigates material differences, assigns ownership, and retains support, year-end work starts with a file of resolved decisions instead of a year of unexplained numbers.

PigJet helps commercial landlords keep property budgets, operational records, documents, and follow-up work organized around the property. See how PigJet supports commercial property operations when you are ready to replace scattered close spreadsheets with a clearer workflow.