Ask a managing broker where the firm’s client information lives and the first answer is usually “in the CRM”. Ask a few follow-up questions and the real answer emerges. Some of it is in the CRM. Some is in a shared spreadsheet that one coordinator maintains. Some is in agents’ personal inboxes and phones. Listing data comes from a board feed. Commission data lives in accounting. Lease dates for a landlord client are in a folder of PDFs.
None of this is unusual. It is how most firms grow. But it means that any plan to improve reporting, adopt a new CRM or use analytical tools rests on an assumption that is usually wrong: that the firm knows what information it has and where it is.
This article sets out a self-audit you can run in a few working sessions. It does not need special software. It produces a clear map of where information lives, how reliable it is, and what to fix first.
Why an audit comes first
Firms often start with a tool. They buy a new CRM or a dashboard product and then try to fill it. The result is a new system that holds a partial copy of the firm’s information, alongside all the old places that still hold the rest.
An audit reverses the order. It asks what information the firm depends on, where each piece lives today, and which places should become the source of truth. Tools are chosen afterwards, to fit.
It also has a privacy benefit. Under PIPEDA and provincial privacy laws, a firm is accountable for the personal information it holds. You cannot protect, correct or delete information you do not know you have.
The audit in five steps
Step 1: List the decisions and questions that matter
Start with use, not storage. Write down the ten to fifteen questions leadership, agents and staff need answered regularly. For example:
- Which clients have we not contacted in the past quarter?
- What is in our pipeline, by stage, today?
- Which listings expire in the next 60 days?
- Which tenants in our landlord clients’ buildings have leases ending within a year?
- Where did last quarter’s qualified opportunities come from?
- What commission is expected to close next month?
These questions define what information matters. Anything not needed to answer them is lower priority.
Step 2: Inventory every place information lives
Now list every location where business information is stored. Be thorough and honest. Interview a few agents and the people who do administration, not just leadership. Typical entries:
- CRM or contact database
- Shared spreadsheets, and the private ones people mention when asked directly
- Email inboxes, shared and personal
- Phones: contacts, text messages, messaging apps
- Board or listing feeds, and any listing management tool
- Transaction management system
- Accounting and commission software
- Shared drives and document folders
- Website forms and their notification emails
- Advertising platform accounts
- Calendars
- Paper files
For each location, record it in a simple table:
| Location | What it holds | Who maintains it | Who can access it | How current it is | Contains personal information? |
|---|---|---|---|---|---|
| Example: “Pipeline tracker” spreadsheet | Open deals, stages, estimated commission | Office coordinator, weekly | All agents, by shared link | Updated weekly, sometimes missed | Yes: client names and phone numbers |
The “who can access it” column often produces the most surprising answers. Shared links tend to stay open long after the people they were shared with have left.
Step 3: Map each question to its sources
Go back to the list of questions from step 1. For each one, write down which locations you would need to consult to answer it today, and how long it would take.
This is where the real cost becomes visible. A question like “which clients have we not contacted in a quarter” may need the CRM, three agents’ inboxes and a spreadsheet, and still give an incomplete answer. A question that takes a person half a day to answer is a question that, in practice, gets answered rarely or not at all.
Step 4: Rate each source for reliability
For each location that feeds an important question, rate it on four simple dimensions. A three-point scale is enough: good, partial, poor.
- Completeness. Does it hold all the records it should, or only some?
- Accuracy. When you check a sample of records against reality, how many are right?
- Timeliness. Is it updated when things happen, or in batches, or when someone remembers?
- Structure. Is the information in consistent fields, or in free text and attachments?
To rate accuracy honestly, take a small sample, perhaps twenty records, and check each one. Is the phone number right? Is the deal stage current? Is the contact still at that company? A sample check takes an hour and is far more reliable than anyone’s impression.
Step 5: Choose the source of truth for each type of information
For each type of information, decide which single place should be authoritative. For example:
| Information | Source of truth | Others become |
|---|---|---|
| Contacts and relationships | CRM | Read-only or retired |
| Active listings | Listing feed, synchronized into CRM | Mirrors |
| Pipeline and stages | CRM | Retired spreadsheet |
| Commission and payments | Accounting | Source for reporting, not edited elsewhere |
| Lease terms for landlord clients | CRM property and lease records, with documents attached | Folder of PDFs kept as archive |
The rule is simple: each fact is entered and maintained in one place. Everywhere else either reads from that place or stops holding the fact.
What you will usually find
Every firm is different, but certain patterns come up often.
- Inboxes hold the relationship history. The CRM has names and numbers, but the context of the relationship is in email threads only one agent can see.
- The pipeline lives in a spreadsheet. The CRM has deals, but the spreadsheet is what the weekly meeting actually uses.
- Website inquiries arrive as email. The form sends a notification and nothing else, so source and timing are lost.
- Departed agents’ data is in limbo. Their contacts and notes are in personal accounts the firm cannot reach, or in accounts the firm should have closed.
- Lease and listing dates are in documents. The dates that drive renewals and expiries are buried in PDFs rather than in fields that can trigger a reminder.
None of these is a failure of individuals. Each is the natural result of people doing their jobs with the tools at hand.
Turning the audit into a plan
The audit gives you a list of gaps. Prioritize them by two factors: how important the question they affect is, and how hard they are to fix.
- Fix the leaks first. Website forms that only send email, and shared links open to people who have left, are usually quick to fix and carry real risk.
- Move one high-value process into its source of truth. Often this is the pipeline. Retire the spreadsheet by making the CRM the place the weekly meeting reads from.
- Bring critical dates into structured fields. Lease expiries, listing expiries, conditional deadlines. Once they are fields, they can drive reminders and reports.
- Set a rule for agent communications. Decide which client communications must be logged in the CRM, and make logging easy, for example by connecting email.
- Repeat the sample check in three months. Measure whether accuracy has improved.
Where to start
- Write down the ten questions your firm most needs answered regularly.
- Spend one session listing every place information lives, including the private spreadsheets.
- For your three most important questions, map which sources you need and how long an answer takes.
- Run a twenty-record accuracy check on your CRM.
- Pick one source of truth to establish this quarter, and retire the copy it replaces.
Multiunit starts every business intelligence engagement with this kind of discovery, before any building. If you would like a second pair of eyes on your audit, use the Contact page.
This article is general information, not legal, financial or brokerage advice. Examples and figures are illustrative unless a source is given.