Building a CRM in 60 Days for an Audit: What Is Actually Achievable
An evidence-first decision guide: what fits before a compliance deadline, what waits, the interim controls that hold meanwhile, and how the answer differs on Dynamics 365 and a custom build.
In sixty days you can build one auditable process properly: enforced data capture on the records the auditor will sample, role-based access, an audit trail running from the first live record, and one report the auditor accepts as evidence. You cannot also redesign every process, build every integration or migrate years of history. Scope backwards from the audit evidence requirement to the minimum data model, and run documented interim controls while the build runs. Safe cuts are optional fields, dashboards, low volume automation and history migration. Unsafe ones are auditing switched on late, shared logins, totals people can overtype and a go-live without a tested evidence report, because those produce a worse finding than having no system.
What can realistically be built in sixty days, and what cannot?
The honest line is between the process the auditor will test and everything else the organization would like a CRM to do. A sixty day window is enough to put one process under control on a proper platform. It is not enough to do that and also fix every adjacent process, connect every system and bring the past across, and trying to do all of it is the most reliable way to arrive at the audit with nothing finished.
For normal, deadline-free timelines and phases, our Dynamics 365 consulting page sets out how a single module rollout is usually planned, so that is not repeated here. This page is about what changes when the date is fixed by somebody else.
| Fits in sixty days | Does not fit in sixty days |
|---|---|
| One auditable process, end to end, for the records in audit scope. | A full redesign of sales, service and every adjacent process at the same time. |
| Enforced data capture: the fields the evidence depends on cannot be skipped or left blank. | Every integration to finance, marketing, telephony and document systems. |
| Role-based access matching who is allowed to create, approve and view. | Migration of years of historical records with full relationships and activity history. |
| An audit trail switched on before the first live record is created. | A complete reporting and dashboard suite for management. |
| One report or extract, built to the definition the auditor gave, tested before the audit. | Automation of every low volume or exception path. |
| Written interim controls covering the weeks before go-live. | Organization wide rollout and training beyond the teams in audit scope. |
How do you scope a CRM backwards from the audit evidence requirement?
Start from the end. The first working session is not a requirements workshop, it is a reading of what the auditor or compliance team will ask to see. Every entity, field, role and automation in scope must trace back to a piece of that evidence, and anything that does not trace back waits for phase two. This is the discipline that makes the window achievable, because it converts an open-ended CRM project into a short, testable list.
- Write down the evidence request in the auditor language: which population, which period, which attributes, and what a passing sample looks like.
- For each attribute, name the record and column that will hold it, and who is allowed to set it.
- For each control, name what the system enforces and what a person still does, because the second part needs a procedure, not a feature.
- Derive the minimum data model from that list: usually a small number of tables, not the full standard CRM model.
- Define the evidence report before building the forms, and agree its definition with compliance in writing.
- Put everything else on a dated phase two list, so the business sees it is deferred, not refused.
Which artefacts does an auditor actually want to see?
Auditors test whether a control exists, whether it operated over the period and whether the evidence can be trusted. A CRM helps with all three only if the artefacts below are produced deliberately. Your compliance team and auditor decide what is sufficient; Solzet does not give regulatory advice, and we build to the definition they give.
| Artefact | What it shows | Where it comes from |
|---|---|---|
| Control description | What the process is, who does each step and what the system enforces. | A short written document agreed with compliance, matching the build. |
| Access listing | Who holds which role, and that people who create records cannot also approve them where that separation is required. | Security role and team assignments, exported and reviewed. |
| Audit trail extract | Old value, new value, user and time for changes to the records and columns in scope. | Platform auditing, or an append-only change log in a custom build. |
| The evidence report | The population and attributes the auditor samples, for the period under review. | A saved view, report or extract built to the agreed definition. |
| Interim control log | How the control operated before the system went live. | The documented manual procedure, with a dated sign-off per item. |
| Change record | That the configuration in production is the configuration that was tested. | Solution versions, deployment dates and who approved each release. |
What interim controls hold while the CRM is being built?
The audit period rarely waits for go-live, so the weeks before the system exists need a control of their own. The mistake is an informal workaround that nobody can evidence. The better approach is a deliberately simple manual control, designed so its records can later be loaded into the new system rather than retyped.
- One register, in one controlled location, with column headings copied from the fields the new data model will use.
- Every row carries the record identifier, the date, the person who acted and, where approval applies, a different person who approved.
- Restricted edit access and version history on the register, with a named owner.
- A periodic review signed and dated by someone independent of the people entering rows.
- A written statement of when the interim control ends and how its records move into the CRM.
Which corners are safe to cut, and which create a worse finding?
Cutting scope is the point, but not all cuts are equal. Some only make the system less convenient. Others undermine the evidence itself, and an auditor who finds a system that looks controlled but is not will usually treat that more seriously than an honest manual process.
| Safe to defer | Not safe to cut |
|---|---|
| Optional fields and secondary tabs on forms. | Auditing on the tables and columns in scope, switched on before the first live record, because it does not record the past. |
| Dashboards and management reporting outside the evidence report. | Individual named accounts; shared logins destroy the audit trail. |
| Automation of low volume or exception steps, run manually with a procedure. | Totals and status values people can overtype, where the evidence depends on them. |
| Historical migration: archive the old records read-only and reference them. | Required fields enforced only on a form while imports and integrations bypass them. |
| Integrations that can run as a documented file or manual step for now. | A test of the evidence report against real records before the audit. |
| Rollout to teams outside audit scope. | Separation between a test environment and production, and a record of what was released. |
How does the sixty day answer differ on Dynamics 365?
On Dynamics 365 and Dataverse most of the controls exist in the platform and are configured rather than built, which is what makes a short window plausible. The work goes into designing them correctly for the process, not into writing them. The Dynamics 365 Sales implementation page describes the wider scope when the audited process is a sales process; here the focus is only on what the deadline needs.
- Auditing: Dataverse auditing is enabled at environment, table and column level, with a retention period agreed with compliance. It is not retroactive, so it goes on first.
- Access: security roles, business units and teams model who can create, read, approve and assign; column security profiles protect sensitive fields.
- Enforced capture: business required columns and business rules on forms, plus server side validation where records also arrive through imports, flows or integrations.
- Process: a business process flow or status model for the audited steps, with approvals built in Power Automate that write the approver and time back to the record.
- Evidence: saved views, an exported extract or a report built on the agreed definition.
- Lead times outside the build: licences, environment provisioning, identity and access approvals inside your own organization often take longer to arrange than the configuration.
How does the sixty day answer differ on a custom-built CRM?
We recommend the right solution - whether that's Microsoft Dynamics 365, Power Platform, or a custom-built CRM. Some businesses need the Microsoft ecosystem. Others need full control without licensing. We deliver both.
A custom CRM on React, Node.js, PostgreSQL or .NET starts without controls, so role-based access, an append-only audit log and the evidence report have to be engineered and tested rather than configured. That does not rule it out under a deadline, but it changes the shape: the scope must be narrower, and the controls must be built first rather than last. It is the right answer when the audited process is narrow, Microsoft licensing does not fit the people who must use it, or data must be hosted on your own infrastructure.
- Identity: sign-in through your existing identity provider over OpenID Connect, so there are no local passwords and no shared accounts.
- Audit log: every change to in-scope records written to an append-only table with old value, new value, user and time, which application users cannot edit.
- Access: roles enforced in the API, not only hidden in the interface.
- Evidence: the report built as a tested query against the agreed definition, with its output reproducible for any period.
Should an audit deadline CRM be built on Dynamics 365, Power Platform or a custom platform?
Can afford licensing and want the Microsoft ecosystem
Dynamics 365
Microsoft 365, Teams and Outlook integration, a mature partner ecosystem, Copilot, and apps for sales, service and field operations that are configured rather than built.
Need full control and zero licensing
Custom CRM
A CRM built on React, Node.js, PostgreSQL or .NET that you own outright: your data model, your hosting, no per-user subscription, and features shaped exactly to your process.
Not sure which fits
We help you decide
A short discovery weighs licensing budget, process complexity, integrations and long-term ownership, then recommends one path. We deliver both, so the recommendation has no reason to lean.
What does a sixty day plan look like in practice?
The shape below is indicative, not a promise. Whether it fits your date depends on how quickly decisions come back, how available the people who own the process are, and what your own organization needs for licences and access. We would rather tell you after a short scoping conversation that the date is not realistic than accept it and miss it.
- First stage, evidence and scope: the evidence request read line by line, the minimum data model, the role matrix, the report definition agreed in writing, and the interim control switched on.
- Second stage, controls first: environments, identity and auditing in place before any form is built, so every test record already leaves a trail.
- Third stage, build in short iterations: data model, forms with enforced capture, roles, the audited process and its approvals, demonstrated to the process owners as each part is ready.
- Fourth stage, evidence dry run: the report run against realistic records, checked by compliance against the definition, and corrected before anything else is added.
- Fifth stage, go-live and handover: interim register records loaded or referenced, the control description finalised, and a release record showing what went live and when.
- After the audit: the phase two list, including integrations and history migration, planned at a normal pace.
Who should build it, and what if it is already behind?
If your own team has platform skills, a narrow scope like this is something they may be able to deliver with targeted help, and our guide on when to hire a Dynamics 365 consultant versus doing it yourself sets out where that holds and where it stops. Solzet provides senior Dynamics 365 consultants and developers and custom CRM developers, delivered remotely from Yerevan, Armenia, with 8+ years of CRM experience.
Two related situations have their own guides. If the deadline follows an acquisition and there are two CRMs to report from, read the guide to merging two CRMs with a regulatory deadline, which reports first from a thin layer over both. If a build is already under way and has stalled, the project rescue and takeover service covers stabilising it before the date.
What do people ask us?
Can you implement a CRM in sixty days for a compliance deadline?
For one auditable process, often yes: enforced data capture on the records in audit scope, role-based access, an audit trail running from the first live record and one report the auditor accepts. Not for a full process redesign, every integration and historical data migration at the same time. Whether a specific date is realistic depends on decision speed, process owner availability and your own licence and access lead times, which a short scoping conversation establishes.
What is the minimum viable CRM for an audit?
The smallest data model that holds every attribute the auditor will sample, forms that enforce capture of those attributes, roles that separate who creates from who approves where that matters, auditing enabled on the in-scope tables and columns, and a tested evidence report built to a definition agreed with compliance. Everything that does not trace back to the evidence request belongs on a dated phase two list.
Should we migrate historical data before the audit?
Usually not. Full history migration with relationships and activities is one of the most time consuming parts of any CRM project and rarely what the auditor tests. A common approach is to archive the old records read-only with a clear reference, load only open records the process needs, and migrate history after the audit at a normal pace. Confirm with your compliance team that this fits the evidence request.
Does Dynamics 365 auditing record changes made before it was switched on?
No. Dataverse auditing is enabled at environment, table and column level and records changes only from the moment it is on, with retention set for the environment. That is why auditing must be configured before the first live record is created, and why a late switch-on is one of the corners that is never safe to cut.
What should we do about the weeks before the system is live?
Run a documented interim control: one controlled register with columns matching the new data model, a named person and date on every row, a different approver where separation applies, restricted edit access, a periodic independent review and a written end date. It evidences the control for that period and its records can be loaded into the CRM afterwards.
Is a custom CRM too slow to build under an audit deadline?
Not necessarily, but the scope must be narrower. A custom CRM has no built-in auditing or security model, so identity, role enforcement in the API, an append-only audit log and the evidence report are engineered and tested first. It fits when the audited process is narrow, Microsoft licensing does not suit the users, or hosting must be your own.
Does Solzet tell us what our regulator or auditor requires?
No. Solzet does not give regulatory or legal advice. Your compliance team and auditor define what evidence is sufficient, and we scope and build the CRM process, controls and evidence report to that definition, and flag where a requested shortcut would weaken the evidence.
Where should you go next?
Dynamics 365 consulting and developers
Senior consultants and developers, and how a normal single module implementation is phased.
Dynamics 365 Sales implementation
The full scope when the audited process is part of how your team sells.
Hire a consultant or do it yourself
What a capable internal maker can build, and the walls where expert help is needed.
Custom CRM Development
CRM on React, Node.js, PostgreSQL and .NET for organizations that need full control without Microsoft licensing.
Two CRMs and a regulatory deadline
Reporting first from a thin canonical layer after an acquisition, then consolidating.
Dynamics 365 project rescue and takeover
Stabilising and taking over a build that has stalled before its date.
Which solution is right for your business?
Tell us what you need. A senior consultant replies within one business day with a recommendation - Dynamics 365, Power Platform, or a custom-built CRM - not a sales script.