The challenge
For many small and medium construction businesses, the CRM is a spreadsheet. It works up to a point. But as the volume of enquiries, live jobs, and subcontractor relationships grows, spreadsheets start to create problems: data gets duplicated, follow-up falls through gaps, and no one has a clear view of where things stand without asking someone directly.
This was the situation facing a Cheshire-based commercial fit-out contractor when they approached us. They were managing all contact data, quote tracking, and job progress across a mix of spreadsheets and email threads, with no single place to see pipeline value, outstanding quotes, or the status of a live job.
The goal was to give them a CRM that reflected how a construction business actually works, without unnecessary complexity or a lengthy onboarding process. If your business is still running on spreadsheets, our piece on what spreadsheet tracking actually costs makes the case for moving on in plain terms.
What SME Software Help delivered
A practical CRM setup built around the way a commercial contractor manages relationships, quotes, and jobs, not a generic out-of-the-box configuration.
- Contact and company records structured to reflect the contractor’s network: clients, architects, project managers, and subcontractors stored with the right context.
- A quote and tender pipeline to track opportunities from initial enquiry through to award or decline, with clear stages and owner assignment.
- A separate job pipeline to manage live projects independently from the sales process, giving visibility of active work without cluttering the opportunity view.
- Custom fields capturing the information that matters in construction: project type, site location, contract value, and decision-maker details.
- Tags to support filtering and reporting across contact types and project categories.
- A data migration from existing spreadsheets into the CRM, with deduplication and a consistent record structure from day one.
Why do quotes and tenders need separate pipelines?
Direct quotes and formal tenders convert at rates far enough apart that averaging them together produces a number describing neither. A fit-out quote to a repeat client can close in a fortnight. A tender for a main contractor sits against a submission deadline, goes quiet for six weeks, and is decided by people this contractor never speaks to.
Run both through one pipeline and every forecast is wrong in the same direction. The tender volume inflates the pipeline value while the direct work carries the actual conversion, so nobody can tell whether a slow month is a quoting problem or just tender timing. Separating them was the first structural decision on this project, and the one that made the reporting usable.
Before and after the engagement
Our approach
Before configuring anything, we spent time mapping the real workflow. This shaped every decision that followed.
How we built the CRM
Discovery and workflow mapping
Documented the key stages in the quoting and delivery process, the contact types managed, and the information the team needed to retrieve quickly. Construction businesses have specific needs around procurement routes, contract values, and multi-contact relationships that need to be understood before configuration begins.
CRM data model
Configured Capsule CRM with contact and company records structured to reflect the contractor's actual network. Custom fields were added for project type, site location, estimated and awarded contract value, procurement route, and key decision-maker details.
Quote and tender pipeline
Built a pipeline tracking the quote and tender process from initial enquiry through site visit, quote submission, and follow-up to award or decline. Stages were defined with the team to match their actual process, not a generic template.
Live job pipeline
Implemented a separate pipeline for live jobs, tracking from contract award through to practical completion and final account. This gave the team visibility of active project workload and upcoming milestones without requiring a separate project management tool.
Data migration from spreadsheets
Migrated existing contact and job data from spreadsheets into the CRM with deduplication and a consistent record structure applied from day one. Getting the migration right at the start prevented months of cleaning up inconsistent records later.
Living with two pipelines day to day
In daily use the split pays off in what each person stops seeing. Whoever is quoting opens a board of outstanding quotes with no live job noise on it, and whoever is running site work sees active jobs without historical tender clutter underneath.
When quotes go quiet and follow-up slips, a clear pipeline stage is the trigger, but the follow-up process itself still needs to be consistent. Our guide to quote follow-up automation covers the practical steps for making that work reliably.
Results and impact
- One central system for all contact, company, and job data, replacing a mix of spreadsheets and email threads.
- Clear pipeline visibility across outstanding quotes and live jobs, with stage-by-stage tracking and owner assignment.
- Faster follow-up on submitted quotes through structured pipeline stages and task reminders.
- Reduced admin overhead with contact history, job details, and communications accessible in one place.
- A consistent data structure that supports reporting on pipeline value, win rate, and project workload.
Key takeaways for commercial contractors and construction businesses
- A CRM built for generic sales processes won’t reflect how construction businesses work. Pipelines, stages, and fields need to match the real workflow before adoption will stick.
- Separating the quoting pipeline from the job delivery pipeline is worth the extra setup time. The two processes have different owners, timescales, and information needs.
- Custom fields earn their place in construction CRM. Project type, contract value, and procurement route aren’t optional extras. They’re the basis for filtering and reporting.
- Data migration from spreadsheets isn’t glamorous, but getting it right at the start prevents months of cleaning up inconsistent records later.
- Subcontractors, architects, and quantity surveyors belong in the CRM alongside clients. Relationship history doesn’t stay useful if it only covers one contact type.
Still tracking jobs in spreadsheets?
If your quoting and job tracking still relies on spreadsheets, or your team can’t see pipeline and workload without asking around, we can design and implement a CRM setup that reflects the way your business actually runs.
Achieving similar results on other platforms
The approach above isn’t specific to Capsule CRM. The same principles apply across most platforms: define the data model first, build pipelines that reflect your real process, and migrate cleanly from whatever came before.
HubSpot
HubSpot supports multiple pipelines and custom properties natively. For a construction business, you can configure separate deal pipelines for quoting and job tracking, use custom properties for project-specific fields, and use the Companies object to hold the full relationship picture across contacts and jobs. (HubSpot CRM)
Zoho Bigin
Bigin is a lightweight, affordable option well suited to smaller contractors who need clear pipeline visibility without a full CRM platform. Multiple pipelines are supported, and custom fields can be added to reflect construction-specific data. (Zoho Bigin)
Whatever platform you choose, the most reliable approach is to define your stages, fields, and contact structure before configuration begins. Retrofitting a data model onto a live CRM is considerably harder than getting it right at the start.