Healthpeak Properties Transforms Capital Budgeting with a Custom Quickbase Application

The Client Profile: Healthpeak Properties

Healthpeak Properties, Inc. (NYSE: DOC), headquartered in Denver, CO, is a leading healthcare real estate company that owns, operates, and develops facilities supporting healthcare discovery and delivery. Its portfolio includes outpatient medical and lab properties serving healthcare providers, researchers, patients, and some of the country's most important healthcare and life sciences markets. Healthpeak operates at significant national scale. As of June 30, 2026, the company reported

686 properties across in 42 US states
$27 billion in enterprise gross assets
48 million square feet of outpatient medical and lab real estate,
11,420 senior housing units.

Managing capital decisions across an enterprise of this complexity requires sophisticated systems capable of connecting project data, budgets, forecasts, approvals, and financial reporting. That need for scalable capital planning technology became the foundation of Healthpeak's engagement with Quandary Consulting Group.

The Challenge

Managing Capital Planning Across a Complex Real Estate Portfolio

Capital budgeting in commercial healthcare real estate extends far beyond deciding how much money to spend. Every proposed project carries a complex web of interconnected information, including properties, assets, project categories, forecasts, monthly operational spend, acquisition and disposition activity, capital approvals, financial exports, and project status. Ultimately, all of that information must help finance and real estate teams answer one critical question: Where should we deploy capital, when should we deploy it, and what will the financial impact be?

Healthpeak needed a system capable of bringing those decisions together within a single, structured environment. Its requirements extended well beyond a standard database application. The organization needed an enterprise capital budgeting platform capable of supporting projects from initial planning through budgeting, forecasting, approval, and downstream capital processes, while providing greater visibility into how investment decisions affected properties and the broader portfolio.

The platform also needed to operate within Healthpeak's existing technology ecosystem. Rather than creating another isolated system, the solution needed to exchange information with Healthpeak's existing Capital Portal and Master Data Hub, helping maintain consistent data across systems while reducing the need for disconnected financial planning processes.

At the same time, strong security and governance were essential. Different stakeholders required distinct levels of access based on their responsibilities within the budgeting and capital authorization process, making role-based permissions, data controls, and structured approval workflows fundamental to the solution.

The objective was to create a centralized commercial healthcare real estate capital budgeting system capable of transforming complex property, project, and financial data into a structured, scalable planning process—giving Healthpeak a stronger foundation for evaluating investments, forecasting capital requirements, managing approvals, and making more informed decisions about where and when to deploy capital.

Building an Enterprise Capital Budget

Large commercial real estate portfolios can generate hundreds or even thousands of individual capital planning decisions. A single budget may contain projects spanning different properties, investment priorities, project categories, timelines, forecast methodologies, funding requirements, and approval paths.

Without a centralized system connecting those decisions, finance and operations teams can become trapped in a repetitive cycle of spreadsheets, data uploads, manual corrections, reconciliations, version control issues, and disconnected data transfers. As portfolio and project volumes increase, those manual processes make it increasingly difficult to maintain accurate forecasts, consistent project information, and clear visibility into capital deployment and Healthpeak wanted something fundamentally better.

The organization needed a dynamic capital budgeting environment where users could build and modify budgets as planning decisions evolved. Teams needed the ability to select or remove projects, adjust capital plans, forecast expenditures by month, validate project information, create new projects in bulk, manage project data, and release approved projects into downstream capital workflows.

The process also needed to support the financial side of capital planning. Once budgets and forecasts were established, Healthpeak needed the ability to transform and export financial information into required formats without relying on employees to manually reconstruct data across disconnected systems.

Most importantly, these capabilities could not operate as isolated functions. Healthpeak needed budget creation → project selection → forecasting → data validation → approvals → project release → financial export to operate as parts of one connected capital planning process. By connecting each stage, Healthpeak could create a more scalable approach to healthcare real estate capital budgeting, giving finance and real estate teams greater control over project data, stronger visibility into planned expenditures, and a clearer path from an initial capital request to an approved and actionable investment.

The Solutions

A Custom Quickbase Capital Budgeting Platform

Quandary Consulting Group designed a dedicated Capital Budgeting application in Quickbase rather than embedding the entire budgeting environment inside Healthpeak's existing Capital Portal and that architectural decision was deliberate. Creating a separate budgeting application helped isolate development and testing, support distinct role-based permissions, provide a safer environment for training and pilot activities, and reduce the potential for new budgeting functionality to interfere with live capital authorization processes - but separate didn't mean disconnected.

Quandary designed the new application to synchronize information from Healthpeak's Master Data Hub and Capital Portal while using Quickbase Pipelines to connect project profiles with the existing CAR workflow. The result was an architecture designed around two goals that often conflict:

Separation where Healthpeak needed control
Integration where Healthpeak needed continuity

Creating a Single Source of Truth for Capital Planning

At the center of the solution was a structured Quickbase data model connecting capital projects with their underlying budgeting and forecasting information. Instead of treating budgets as static documents, Quandary designed the application to treat them as living collections of project-level financial decisions. Users could work with centralized project profiles containing the operational and financial information required throughout the budgeting process.

The result was a more structured capital planning lifecycle with one connected data foundation and that foundation allowed Healthpeak to connect: Property Data → Capital Project → Budget → Forecast → Validation → Approval → CAR Workflow

A Custom Budget Builder Turns Capital Planning Into an Interactive Workflow

One of the most sophisticated components of the project was the Budget Builder. Healthpeak's requirements went beyond what a standard Quickbase dashboard could efficiently support. Users needed dynamic filtering, real-time summary updates, the ability to remove selected projects, and the ability to modify project-level decisions directly from the interface.

Quandary therefore designed the Budget Builder as a fully custom Quickbase Code Page. Rather than forcing users to move between disconnected forms and reports, the Budget Builder created an interactive workspace for assembling and refining capital budgets. Users could filter available information, review the projects included in a budget, remove projects, and update key planning selections without abandoning the budgeting interface. Capital planning became less about manipulating static files and more about interacting directly with live portfolio data.

Dynamic Project Selection Makes Budget Creation Faster

Building the budget was only half the challenge and users also needed an efficient way to decide which projects belonged in it. Quandary created a custom Add Projects interface designed around dynamic filtering and multi-project selection. Users could narrow a large project population using relevant criteria, identify the projects that belonged in a particular budget, select multiple projects, and add them together. A similar custom interface supported project release workflows and these interfaces replaced repetitive record-by-record processing with multi-record actions designed for enterprise-scale capital planning.

Project Forecasting Connects Budgets With Monthly Capital Spend

A capital budget becomes truly useful when leadership can see not just how much the organization expects to spend, but when it expects to spend it. Healthpeak's solution therefore incorporated project-level forecasting directly into the Project Profile, the system supported three forecasting approaches:

Straight-line forecasting
Custom dollar forecasting
Custom percentage forecasting

Forecast information was entered through embedded Quickbase grid-edit reports, allowing users to work with monthly financial information efficiently while keeping forecasts connected to the underlying capital project and that created a stronger connection between approved project budgets and anticipated monthly capital deployment.

Automated Validation Improves Capital Budget Data Quality

Enterprise budgeting becomes unreliable when bad data reaches the final budget. Quandary incorporated validation throughout the application to identify incomplete or inconsistent information before it could quietly move downstream. Required fields used native Quickbase validation where appropriate, while additional business rules compared project-level information against summarized forecasting data.

For example, monthly forecast amounts could be reconciled against the associated project budget, allowing users to identify discrepancies requiring correction and instead of relying entirely on finance teams to discover inconsistencies during final reconciliation, validation became part of the workflow itself.

Bulk Project Uploads With Real-Time Error Detection

Bulk data imports are often where otherwise well-designed enterprise systems break down. A spreadsheet containing dozens or hundreds of new projects can include missing fields, incorrect values, formatting inconsistencies, or data that doesn't meet business rules and importing those errors first and fixing them later creates unnecessary cleanup. Quandary designed Healthpeak's bulk upload process differently. Users could upload a project file through a custom Quickbase Code Page. While the page remained open, the system validated the file and displayed its contents in an editable table.

Rows containing validation issues could be identified before the projects were created.
Users could then correct errors directly within the interface.
Only after the inputs passed validation could the projects be submitted.

For larger project imports, users retained the ability to cancel the transaction, correct the original Excel file, and return later and the platform also maintained the upload template within Quickbase, creating a consistent reference point for future imports.

Automated Budget Exports Connect Planning With Financial Systems

A capital budgeting platform can't become another data silo. Once Healthpeak finalized a budget, the information needed to move into the formats required by downstream financial processes and Quandary developed a custom Budget Export workflow that allowed users to generate Excel files directly from the Quickbase application. Users could initiate the export from the Budget View, select the appropriate output, and generate an .xlsx file from the same interface.

The application supported Healthpeak's required MRI and B+F export formats, using predetermined mapping and query logic to structure the output appropriately. Important budget information such as segment, budget, and version could automatically populate based on the selected budget, reducing repetitive manual entry. The system also retained a historical copy of generated budget exports within Quickbase, which created a cleaner bridge between operational capital planning and downstream financial processes.

Connecting Capital Budgets With Healthpeak's Existing Capital Portal

A major architectural requirement was ensuring that budgeting did not become isolated from Healthpeak's existing capital authorization process. Quandary designed synchronization between the new Budget Application and Healthpeak's existing Capital Portal. Quickbase Sync brought required information from the Master Data Hub and Capital Portal into the budgeting environment on recurring schedules, meanwhile, Quickbase Pipelines managed the relationship between Project Profiles and CAR forms.

When a project reached the appropriate stage, information could move between the systems while associated CAR information could flow back to the correct project record and that created a more seamless lifecycle: Project Planning → Budgeting → Forecasting → Release → Capital Authorization → Project Management

Role-Based Security Protects Sensitive Financial Workflows

Capital budgets contain sensitive information and require carefully controlled access. The architecture of a dedicated budgeting application gave Healthpeak greater flexibility to separate budgeting permissions from permissions associated with the existing CAR process. Users could receive access appropriate to their role without forcing Healthpeak to compromise permissions elsewhere in its capital management ecosystem and that made security part of the application's architecture rather than an afterthought.

Dashboards Give Teams Immediate Visibility Into Capital Budgets

The system also incorporated Quickbase dashboards and reporting to give users a centralized view of current budgets and projects. Instead of searching through individual records or spreadsheets, teams could access structured views and apply native Quickbase filters to analyze the information relevant to them. Budget status, project information, forecasting data, and downstream workflow activity could now live within the same connected operating environment and that shift was significant for Healthpeak, taking them from just managing files to actually managing capital data.

The Results

A Connected Capital Planning Infrastructure

Healthpeak's custom Quickbase solution transformed capital budgeting from a collection of individual processes into a connected enterprise workflow; budget creation, project selection, forecasting, validation, bulk project creation, financial exports, reporting, and downstream capital authorization could now operate against a shared data foundation. The result was a capital budgeting infrastructure designed to deliver greater consistency, stronger data quality, faster decision-making, and significantly less dependence on manual financial administration.

Centralized Capital Budget Management

Healthpeak gained a dedicated system for managing capital budgets and their associated projects. Rather than allowing critical budgeting information to become fragmented across files and processes, the Quickbase application provided a structured environment where project and budget information could remain connected throughout the planning lifecycle.

Faster Budget Creation and Revision

The custom Budget Builder gave teams a more efficient way to assemble and refine capital budgets. Dynamic filters, multi-project selection, project removal, and inline updates reduced the friction associated with creating and revising large budgets and instead of rebuilding spreadsheets whenever priorities changed, teams could work directly with centralized project information.

Stronger Forecast Accuracy

Project-level monthly forecasting created greater visibility into expected capital deployment. Straight-line, custom-dollar, and custom-percentage forecasting gave users flexibility while maintaining a consistent data structure and validation helped identify situations where forecast totals and project budgets did not reconcile, improving the integrity of financial planning information before it moved downstream.

Cleaner Data Before It Enters the System

The custom bulk upload experience introduced validation before project creation. Instead of allowing bad records to enter Quickbase and creating cleanup work afterward, users could identify and correct issues before submission, that improved data quality at the point of entry.

Streamlined Financial System Exports

Custom MRI and B+F export workflows reduced the manual effort required to transform budgeting data into downstream financial formats and users could now generate standardized Excel outputs directly from the Budget Application while maintaining historical copies for reference.

Connected Budgeting and Capital Authorization

Quickbase Pipelines and synchronization prevented the new Budget Application from becoming another disconnected platform. Project and CAR information could now move between Healthpeak's budgeting and capital authorization environments, supporting continuity from planning through execution.

Better Security and Governance

Separating the Budget Application from the existing Capital Portal allowed Healthpeak to establish permissions appropriate to the budgeting process without disrupting roles associated with other capital workflows. The architecture also created safer conditions for testing, training, and pilot activities before production deployment.

Built for Enterprise Scale

Most importantly, the application wasn't designed around one budget cycle and as a result this created a reusable infrastructure for ongoing capital planning and project budgeting. As properties, projects, forecasts, and capital priorities change, the underlying platform can continue supporting the process without forcing Healthpeak back into fragmented manual workflows.

From Capital Budgeting to Capital Intelligence

For an enterprise real estate organization, the challenge isn't simply collecting capital requests, the challenge is transforming thousands of pieces of project and financial information into decisions leadership can trust.

Healthpeak needed more than another budgeting spreadsheet, they needed an operating system for capital planning. Quandary Consulting Group combined Quickbase application development, custom interfaces, workflow automation, data validation, financial export automation, system synchronization, and Quickbase Pipelines to create a connected environment for managing the capital budgeting lifecycle.

The resulting architecture connected what had traditionally been separate activities:

Projects became budgets.
Budgets became forecasts.
Forecasts became validated financial plans.
Approved projects moved into capital authorization.
And capital data remained connected throughout the process.

For Healthpeak, that meant a more scalable way to manage complex capital decisions across a major healthcare real estate portfolio and for other healthcare REITs, commercial real estate companies, property management organizations, and enterprise finance teams, the project demonstrates something larger, Quickbase can become far more than a project database. With the right architecture, it can become the operational layer connecting capital planning, budgeting, forecasting, financial systems, and project execution.