A Living Company Budget — Rolling, GL-Connected, and Reconciled Every Month

Client Snapshot

Industry: Real Estate Development & Construction (multi-entity group) Scope: Company-level operating budgets for the management company and its affiliated entities Deliverable: A 36-month rolling operating budget — chart-of-accounts coded, driver-based, vendor-level granular, and reconciled to the NetSuite general ledger every month

---

The Problem: Budgets That Die in January

Most company budgets share the same fate. They’re built once a year, in a burst of effort, as a static spreadsheet. By February, actual spending has drifted from the plan; by April, nobody updates it; by summer, it’s an artifact — quietly ignored while the business runs on instinct and bank balance checks.

For a development group’s management company, that failure mode is expensive. The operating company carries the group’s payroll, professional fees, marketing, travel, and technology spend — funded by fee income (development fees, asset management fees, construction management fees) that arrives in lumpy, project-driven events rather than smooth monthly revenue. When large fees land months apart, the questions that matter are unforgiving: How long does our cash last? Can we afford the next hire? Which spending is quietly growing? When do we need to raise capital, and how much? A static annual budget can’t answer any of them. Only a living one can.

What We Built: A Budget Wired Into the Books

We designed and built a rolling operating budget that behaves less like a spreadsheet and more like a management system. Its defining features:

A 36-month monthly horizon that blends actuals and forecast

The model runs month by month across three years. As each month closes, actuals flow in and the forecast rolls forward — so leadership is never looking at a stale annual plan, but at a continuously updated view: what has actually happened, and what is expected next, on one timeline. Full-year totals recalculate automatically as actuals replace estimates.

Every line speaks the language of the general ledger

Each budget line carries its chart-of-accounts code from the accounting system. Salaries, 401(k), health care, legal fees, subscriptions, each travel sub-category — every row maps to the exact GL account where the actuals post. This one design decision eliminates the classic budget failure: categories in the plan that don’t match categories in the books, making variance analysis a translation exercise nobody performs. Here, budget and books are the same taxonomy by construction.

Driver-based where it matters most

Payroll — the single largest operating cost — isn’t a guessed number. It’s computed from a linked employee-and-contractor model: every person, every pay cycle, with salaries, bonuses, 401(k) contributions, health care, and payroll taxes flowing into the budget automatically. When headcount plans change, the budget changes with them. Revenue is modeled the same way: fee by fee, project by project, timed to when each development fee, asset management fee, and sales fee is contractually expected — including scheduled step-ups — rather than smeared evenly across the year.

Vendor-level spend granularity

Marketing and capital-raise costs were rebuilt from actual card and vendor transaction data into a vendor-by-vendor view — roughly 170 named vendors, each with its own history and forecast. Future months project forward on trailing run-rates, so recurring costs like software subscriptions, advertising platforms, and event spend forecast themselves from their own behavior. Nothing hides inside a lump-sum “marketing” line; every dollar has a name.

Reconciled to the general ledger — every single month

This is the discipline that keeps the budget alive. At the bottom of the model, the budget’s monthly profit is compared directly against the profit reported by NetSuite. Differences are computed, investigated, and itemized as named reconciling items — timing differences, entries recorded in one place but not yet the other, items flagged for the accountant. The residual unexplained variance is surfaced at the very top of the sheet, in plain sight, until it’s driven to zero. The budget cannot silently drift from reality, because the model itself measures the drift.

Replicated across the group

The same architecture was deployed for each affiliated entity — parallel detailed P&L models feeding group-level summary budgets — so the whole organization plans in one consistent framework, and entity budgets roll up as cleanly as entity actuals do.

How It Changed Decision-Making

Cash and runway became visible, not guessed. With fee income modeled by event and expenses forecast monthly, leadership can see exactly how projected cash flows bridge the gaps between major fee receipts — and how far the runway extends under current plans. Capital-raise timing shifted from a reactive scramble to a planned milestone on a timeline.

Hiring decisions got a price tag in advance. Because payroll is headcount-driven, any proposed hire, raise, or bonus plan can be dropped into the model and its full multi-month cash impact — salary, taxes, benefits — appears instantly across the forecast horizon. The conversation changed from “can we afford this?” to “here is exactly what this costs us through next year.”

Spending creep gets caught in weeks, not year-end. Vendor-level tracking with run-rate forecasting exposes the costs that quietly compound — the subscription that doubled, the platform nobody uses, the category running ahead of plan. Month-by-month comparison against actuals turns cost control from an annual post-mortem into a monthly routine.

Variances get explained, not explained away. The built-in GL reconciliation means every month closes with a known answer to “does our plan match our books, and if not, why?” Bookkeeping gaps are caught early — the model even flags income recorded in the plan that hasn’t yet been booked in the ledger — which keeps both the budget and the accounting honest.

Leadership plans on one version of the truth. Board discussions, capital-raise materials, and internal decisions all draw from the same continuously reconciled model — not from competing spreadsheets with different assumptions.

Why Every Business Should Run on a Budget Like This

None of this is exclusive to real estate. Any business — an agency, a startup, a contractor, a professional practice — faces the same core questions: how long does our cash last, what can we afford, and where is our money actually going? The answer is never a static annual budget. It’s a rolling model with a handful of non-negotiable properties: it must share its account structure with the books, it must be driven by real operational drivers (people, contracts, vendors) rather than plugged numbers, it must roll forward every month as actuals arrive, and it must be reconciled to the general ledger on a fixed cadence so it can never quietly detach from reality.

Building that takes a particular combination of skills: accounting fluency to wire the model into the chart of accounts and reconcile it to the GL, financial modeling craft to make it driver-based and self-updating, and the operational discipline to maintain it month after month. That combination is exactly what we deliver.