Healthpeak Properties Transforms Capital Budgeting with a Custom Quickbase Application

The Client Profile: Healthpeak Properties

Industry: Healthcare Real Estate / REIT
Headquarters: Denver, Colorado
Current Enterprise Gross Assets: $27B
Use Case: Enterprise Capital Budgeting & Capital Project Management

Healthpeak Properties, Inc. (NYSE: DOC) 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
42 states, approximately
$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 isn't simply a matter of deciding how much money to spend and every proposed project carries a web of information; properties, assets, project categories, forecasts, monthly operational spend, acquisition and disposition activity, capital approvals, financial exports, project status, and ultimately, the question every finance and real estate team must answer, "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 and their requirements extended well beyond a standard database application. The organization needed an enterprise budgeting environment that could support capital projects from initial planning through budgeting, forecasting, approval, and downstream capital processes; and, the platform also had to coexist with Healthpeak's existing technology ecosystem.

Rather than creating another isolated system, Healthpeak needed its new budgeting application to exchange information with its existing Capital Portal and Master Data Hub, while maintaining strong security and distinct permissions for users involved in budgeting and capital authorization. The objective was to create a centralized capital budgeting platform capable of turning complex property and project data into a structured, scalable financial planning process.

Building an Enterprise Capital Budget

Large real estate portfolios can generate hundreds or thousands of individual capital planning decisions and a single budget can include projects with different properties, priorities, categories, timelines, forecast methodologies, and approval requirements. Without the right system, finance and operations teams can become trapped in a cycle of spreadsheets, uploads, corrections, reconciliations, and manual data transfers and Healthpeak wanted something fundamentally better.

The organization needed users to be able to build budgets dynamically, select and remove projects, adjust planning decisions, forecast monthly expenditures, validate project data, create new projects in bulk, release projects into downstream workflows, and ultimately export financial information into required formats; most importantly, those functions needed to operate as parts of one connected process.

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.