Article #562 Why It is Crucial to Associate CRM Date with Project Management Information Systems (PMIS) Data for Real Estate Development Projects?

Regardless of the CRM solution selected by a real estate developer, there will be always a requirement to associate the captured CRM data with the data captured in a Project Management Information System (PMIS) like PMWeb. This is essential for Real estate developers who need to look at several factors in order to understand the success of their development project. Sales numbers and inventory sold, types of interactions that led to a sale, the marketing efforts that contributed the most leads, and the most successful campaigns by the agents are all important functions that a CRM can provide. Nevertheless, a PMIS is where all the other information associated with real estate development are managed and captured. Failing to associate those two data sources could result in incomplete and misleading information that might negatively impact the validity of decisions made by the real estate developer.

A real estate developer usually uses CRM solutions to facilitate the relationship between their sales agents and potential buyers, and even helps track the most successful marketing campaigns and sources. Nevertheless, many CRM solutions might lack some of the critical functionalities that are required by real estate developers. For example, those would include managing all sales and long and short-term lease contract agreements for which many of those contract agreements need to go through a formal process before they are approved. The payment terms of those contract agreements could be associated with project schedule milestone dates.

In addition, there could be need to have details on the status of real estate assets inventory for a single project development or across the complete real estate development projects’ portfolio. When reporting on the assets inventory, there might be a requirement to group, sort, compare and filter the generated information by certain data fields like asset size, price, buyer or occupant and others. This information is also important for identifying purchase patterns and sales trends to provide a real-time single version of the truth of the whole projects’ portfolio as well as for a single project status of sales revenue tracking and performance breakdowns.

The CRM and PMIS data will be used to create the real-time single version of the truth reports that each real estate developer requires. For example, a report could be created for each real estate development asset for which it also includes a visual for the project’s Building Information Modelling (BIM) model. The BIM model and associated data will be exported in a format that can be read, used and visualized in MS Power BI using the “3DBI” visual developed by KG-DEV ( The BIM visual will be used to display the properties that were sold or closed, under negotiation and available.

562 1

In addition, another report can be created to capture the details of all development projects that the real estate developer might have. The report will include a map visual like the one available from “Icon Map” ( the enable viewing the boundaries of each project. The report will be configured to enable the reader to drilldown to each real estate development report displayed above.

562 2

The data associated with the sales or revenue of all those assets will be managed using PMWeb Revenue Contract module. The level of details for the income contracts will depend on each real estate developer requirement. For example, there could be a single revenue contract for each project for which it will detail all available assets in the project for which each asset will be shown as a single line item. Nevertheless, if the real estate developer wants full details on each asset, then a separate revenue contract will be created for inventory stock item. Those contracts will itemize the payment plan and link each payment installment with the relevant project schedule milestone activity as well as the financial period that the payment is scheduled to be made.

Each sales agreement will be attached with all supportive documents such as flat layout, signed sales agreement among others that will be uploaded and stored on PMWeb document management repository. In addition, links to other PMWeb records can be also added.

A workflow will be assigned to the sales agreement or revenue contract agreement to ensure that they had been formally reviewed and approved by the assigned team members including those involved in delivering the project. The workflow will identify the tasks to be performed and in what sequence, responsibility assigned to each task, duration of each task and the actions that can be taken by the assigned team member. In addition, the workflow could embed conditions to enforce the approval authority levels assigned with property sale price, property type among others.

When a business process transaction is initiated, the workflow tab available on the relevant template will capture the planned review and approve workflow tasks for each transaction as well as the actual history of those review and approval tasks. The captured workflow data will include the actual action data and time, done by who, action taken, comments made and whether team input was requested.

PMWeb Word module will be used to create the sales agreement templates so they can be generated using the data captured in contract module. The content of those agreement templates can be copied from the current agreement templates used by the property developer. PMWeb provides the option to generate the sales agreement in MS Word or PDF file format. The wet-signed agreement, needs to be scanned, uploaded and stored in its designated document management system folder. The scanned agreement will be also attached to the relevant contract record. Those agreements can be in English, Arabic or any other desired language.

The sales contract also has the option to capture and manage changes to the sales agreement should this be needed, issued payment invoices for the payment plan and details of actual payments received against those invoices. This will enable the real estate developer to have a real-time, single version of the truth on the approved sale agreements.

562 8

The income data captured in the revenue contracts along with the cost data captured in the commitment contracts and other related business processes managed using PMWeb will enable the real estate developer to also have a real-time single version of the truth of each real estate development as well as the complete real estate development projects’ portfolio.

For example, the reader of the Revenue and Income Recognition report can select a specific project or period to have details of the current values of all financial figures that will impact the real estate developer bottom line. The report can be also designed to enable drilling down to the cost management transaction that for required data field. The report can be also designed to display the location of each real estate development project.

562 9

About the Authorfounder

Bassam Samman, PMP, PSP, EVP, GPM is a Senior Project Management Consultant with 40-year service record providing project management, project controls services and project management information system to over than 200 projects with a total value in excess of US $100 Billion. Those projects included Commercial, Residential, Education and Healthcare Buildings and Infrastructure, Entertainment, Hospitality and shopping malls, Oil and Gas Plants and Refineries, Telecommunication and Information Technology projects. He is thoroughly experienced in complete project management including project management control systems, computerized project control software, claims analysis/prevention, risk analysis/management (contingency planning), design, supervision, training and business development.

Bassam is a frequent speaker in topics relating to Project Management, Strategic Project Management and Project Management Personal Skills. Over the past 40 years he has lectured at more than 350 events and courses at different locations in the Middle East, North Africa, Europe and South America. He has written more than 550 articles on project management and project management information systems that were featured in international and regional magazines and newspapers. He is a co-founder of the Project Management Institute- Arabian Gulf Chapter (PMI-AGC) and has served on its board of directors for more than 6 years. He is a certified Project Management Professional (PMP) from the Project Management Institute (PMI), a certified Planning and Scheduling Professional (PSP) and Earned Value Professional (EVP) from the Association for the Advancement of Cost Engineering (AACE) and Green Project Management (GPM).

Bassam holds a Masters in Engineering Administration (Construction Management) with Faculty Commendation, George Washington University, Washington, D.C., USA, Bachelor in Civil Engineering – Kuwait University, Kuwait and has attended many executive management programs at Harvard Business School, Boston, USA and London Business School, London, UK.


Contact us