Quarterly Budget Variance

What it extracts

13 extraction fields

Report Overview

The identifying facts of the report - property, type, owning entity, period, source system, and basis - so a reviewer can orient before reading the variances.

Reporting Period

The quarter and year the export covers, parsed from the period header and normalized to a Q<n> YYYY label so every property's report and letter align.

Source Accounting System

Which property-management system produced the export, since each labels the budget, actual, and variance columns differently and that guides how the report is read.

Line-Item Budget Variance

The full GL-line budget-versus-actual detail for both the quarter and year-to-date, with variance and percent variance verified, favorability set by NOI impact, and each line flagged against the materiality rule.

Revenue and NOI Variance Bridge

The line items rolled up into a standard GPR-to-EGI-to-NOI bridge on a budget-versus-actual basis, revenue and expense shown separately, with a footing check that each subtotal ties out.

Material Variance Flags

The short list of variances that clear the materiality threshold, ranked by dollar magnitude - the lines that actually need explanation in the letter.

Variance Drivers and Explanations

For each material variance, the driver category and a grounded explanation, classified timing versus permanent, with a recommended action - flagging where analyst confirmation is still needed.

Reforecast Recommendations

Full-year reforecast guidance for lines whose variance is permanent or a reliable run-rate signal, with the suggested revised budget, the delta, and a confidence level.

Overall Budget Performance

A single-label verdict on the property against budget for the period, based on the NOI variance and whether revenue and expense are moving together or offsetting.

Variance Summary Scorecard

The one-look scorecard - total revenue, operating expense, and NOI actual/budget/variance plus material-line counts - that populates the property's row in the portfolio roll-up.

Investor-Letter Variance Commentary

The drafted variance narrative for the quarterly investor letter - headline NOI-vs-budget, the revenue and expense stories with cited figures, and the outlook - the deliverable the cycle exists to produce.

Data Quality and Validation Flags

The footing, sign, classification, and threshold checks an analyst runs before trusting the report - variance math, revenue/expense-to-NOI footing, favorability signs - each marked Pass, Fail, or Review.

Analyst Notes

A narrative of the classification judgments, undetermined drivers, zero-budget cases, and source-versus-recomputed disagreements, so a reviewer knows where to double-check before the letter goes out.

Where it fits

What it needs

What it produces

Review model

An asset manager or portfolio analyst reviews the material-variance flags, the driver explanations, the reforecast recommendations, and the drafted commentary - confirming any driver marked 'requires analyst input' - before the property's section is merged into the quarterly investor letter.

Who uses it

Volume fit

Grounded in

• CREFC Investor Reporting Package (IRP) - Chart of Accounts and NOI frameworkverified as of 2026-07-22
• Budget variance / favorable-unfavorable and materiality conventions (management-accounting practice)verified as of 2026-07-22

Changelog

• July 2026