# How to Manage CapEx Across 50, 100, or 500 Properties **Author:** Banner Team **Published:** September 7, 2026 **Category:** Industry Insights **Read time:** 10 min > Portfolio CapEx breaks when every property runs its own spreadsheet. Here is a scalable operating model for planning, approvals, execution, forecasting, and reporting across 50, 100, or 500 properties. --- To manage CapEx across a large real estate portfolio, standardize the data model first, then the workflow. Every property should use the same project taxonomy, budget structure, approval rules, forecast definitions, and reporting cadence. The goal is not to centralize every decision; it is to make every decision roll up into one comparable portfolio view. ## Why portfolio CapEx gets harder as you scale At ten properties, a strong asset manager can often keep the capital program together through spreadsheets, email, and institutional memory. At 50 or 100 properties, the same process creates inconsistent project names, duplicate files, unclear approvals, stale forecasts, and hours of manual rollup. At 500 properties, those inconsistencies become a control problem. Scale changes the job from tracking projects to designing a capital operating system. ## The seven-layer operating model ### 1. Build one portfolio taxonomy Define the fields every project must share: property, entity, fund, project type, capital category, cost code, priority, owner, start date, target completion, funding source, and approval status. Local teams can add detail, but the portfolio fields should be controlled. This is what makes apples-to-apples reporting possible. ### 2. Separate the plan from the forecast The approved budget answers what leadership authorized. The forecast answers what the team now expects to happen. Do not overwrite one with the other. Preserve original budget, approved revisions, current working budget, commitments, actuals, and forecast-to-complete so variance has a clear meaning. ### 3. Encode delegation of authority Approval rules should be explicit and repeatable. A routine project within budget should not follow the same path as an unplanned seven-figure scope change. Use thresholds for new budgets, contract awards, change orders, and invoices, and preserve who approved what and when. ### 4. Standardize the monthly forecast Each active project needs a current estimate at completion and expected timing of remaining cash. A forecast that only changes at quarter-end is a report, not a management tool. Set a cadence and define who owns updates, which changes require commentary, and which variance thresholds trigger escalation. ### 5. Keep the PMS or ERP synchronized Accounting should not re-key the operating team's version of the project. Align properties, entities, vendors, cost codes, commitments, invoices, and actuals with the financial system of record. Integration matters more as the portfolio grows because reconciliation work scales with transaction volume. ### 6. Report by exception Leadership should not need to inspect 500 properties to find risk. Surface projects with forecast overruns, stalled approvals, aging commitments, late schedules, missing forecasts, or unusual change-order activity. The portfolio view should direct attention, not merely display data. ### 7. Preserve drill-down from portfolio to invoice Every portfolio number should be explainable. A CFO looking at a $4 million variance should be able to move from fund to property to project to commitment or invoice without requesting a new spreadsheet from three teams. ## What changes at 50, 100, and 500 properties? ### Around 50 properties: standardize The priority is eliminating one-off templates and definitions. Establish one project register, one approval model, and one monthly reporting package. You can still tolerate some manual processes if the underlying data is consistent. ### Around 100 properties: automate Manual consolidation becomes expensive. Automate approvals, accounting synchronization, reminders, recurring reporting, and portfolio rollups. Focus on exception management so regional and portfolio leaders spend time on risk rather than data collection. ### Around 500 properties: govern At this scale, data governance and permissions become first-class requirements. Define ownership for master data, approval matrices, integrations, forecast cadence, and reporting definitions. The platform should support multiple regions, funds, entities, asset types, and operating teams without fragmenting the portfolio view. ## The minimum portfolio CapEx dashboard At minimum, leadership should see approved budget, revised budget, committed cost, actual spend, forecast-to-complete, variance to budget, remaining cash by period, project status, and major exceptions. The same measures should be filterable by fund, property, region, asset type, project category, and project owner. ## When spreadsheets stop scaling There is no magic property count. The stronger signals are behavioral: teams maintain parallel trackers; leadership cannot reconcile portfolio totals to the GL; approvals happen outside the project record; forecast updates require a monthly spreadsheet chase; or the same project has different numbers in asset management and accounting. Those are process signals that the operating model has outgrown its tools. ## How Banner supports portfolio-scale CapEx Banner gives owners and operators a portfolio-first system for capital planning, approvals, project execution, cost control, forecasting, and reporting. Teams can move from portfolio to fund to property to project while keeping financial activity synchronized with systems such as Yardi, RealPage, Entrata, and MRI. ## Frequently asked questions ### What is the best way to track CapEx across multiple properties? Use one standardized project and financial data model, connect it to the accounting system, enforce approval and forecasting workflows, and provide portfolio rollups with project-level drill-down. ### Who should own the CapEx forecast? Ownership varies by organization, but the person closest to project execution should update the estimate while asset management and finance govern assumptions, review exceptions, and reconcile the forecast with actuals. --- *Originally published at [withbanner.com/home/blog/manage-capex-across-real-estate-portfolio](https://withbanner.com/home/blog/manage-capex-across-real-estate-portfolio)*