A CRE pipeline template that actually works

Most of the 'CRE pipeline templates' you find online are not templates. They are pretty spreadsheets. You download one, open it, and realize that while the columns have nice names, the template does not actually solve the thing that makes CRE pipelines hard. It just gives you a slightly more attractive blank page to start from.

The hard thing about a CRE pipeline is not the columns. It is the shape of a deal. A commercial real estate deal is a tree of objects: the deal itself, the documents attached to it, the tasks that need to happen, the contacts involved, the lender quotes under consideration, and the financial assumptions you are testing. A template that gives you columns without solving for the tree collapses the moment you try to track a second rent roll, a third lender quote, or a fourth DD workstream on the same deal. You cannot represent a tree in a row.

The second hard thing is ownership. A template that says 'assigned to' is not enough. A commercial real estate deal has multiple parallel workstreams happening at the same time. Financial DD has an owner. Physical DD has an owner. Legal DD has an owner. Environmental DD has an owner. Financing has an owner. A template that lets you assign the deal to one person loses the ability to track which workstreams are stuck and which are moving. By the time you find out the environmental consultant has ghosted the project, you are three days from closing.

The third hard thing is state. A deal is not in one state. It is in multiple states at once. A deal can be in financial DD, passed inspections, awaiting final lender approval, and drafting the IC memo all at the same time. A single-column 'stage' dropdown forces the team to pick the one stage that feels most representative, which means the pipeline always under-reports the real work. The best CRE pipelines track each workstream independently and let the overall stage be a derived field.

The fourth hard thing is documents. A pipeline that cannot hold the OM, the rent roll, the T-12, the inspection report, and the lender term sheet is not a pipeline. It is an index into a file system. And if the file system is someone's Google Drive, the pipeline will be out of date the moment someone uploads a new version.

A real template has to solve all four of these problems at once. That is why most real CRE teams eventually stop looking for templates and start looking for software.

The fields a pipeline needs depend on the asset class, the size of the deals, and the structure of the team. That said, there is a durable core that works for most CRE acquisition teams. Start here and add only the fields you know you will use.

Deal identification

Property name, address, asset class, deal source (broker name or off-market lead), and the date the deal was added to the pipeline. These are your baseline. Do not overthink them.

Economics

Asking price, estimated value, target cap rate, unit count (for multifamily), square footage (for industrial, office, retail), and any quick metrics the team cares about during early screening. Keep the list short. A field you do not actually use at the screening stage is a field that will be missing or stale on half the deals.

Stage and workstream status

A primary stage field (sourcing, screened, LOI submitted, under contract, in DD, closing, closed, dead) and individual workstream fields for financial DD, physical DD, legal DD, environmental DD, and financing. Each workstream should have its own status and its own owner, updated by the person doing the work.

Ownership and accountability

The acquisitions lead for the deal, plus owners for each active workstream. Do not collapse multiple owners into one field. A deal owned 'by the team' is owned by no one.

Key dates

LOI submitted, contract executed, DD period end, financing commitment deadline, closing date, and any broker-imposed deadlines. Use real dates, not 'TBD.' If a date is unknown, the value should be blank, not a guess.

Contacts

Broker, seller, seller's counsel, lender(s), property manager, environmental consultant, and any other parties you are working with on the deal. Attach contacts to the deal, not to a separate CRM that drifts out of sync.

Documents

The offering memorandum, the rent roll, the T-12, the inspection report, and any lender quotes, all tied to the deal, all versioned. The pipeline should let you open the latest version of any of these without leaving the deal workspace.

Notes and decisions

A running log of what the team has decided, what they are waiting on, and why they have chosen one lender over another. This is the field that saves you when an analyst leaves and someone new picks up the deal.

MotionCRE is built on the structure described above. Every deal has a workspace with documents, tasks, contacts, financing, and notes. The pipeline is a live view into every workspace, with filters for asset class, stage, workstream status, owner, and date ranges. You do not configure the fields because they are already there.

The primary stage field is augmented by workstream-specific status indicators for financial, physical, legal, and environmental DD plus financing. Each of those workstreams has an owner and updates as the responsible team member does the work. The deal card shows the overall stage alongside a quick visual read on which workstreams are progressing and which are stuck.

Documents uploaded to a deal workspace are versioned automatically, scoped to the deal, and searchable. Contacts are attached to the deal, not stored in a separate CRM. The whole template is live the moment your team logs in.