Moving a survey or Chartered Engineering practice beyond spreadsheets
Many survey firms and CE practices track jobs in spreadsheets and chat groups. How to move to a proper system in phases without stopping live work.

Key takeaways
- Spreadsheets and chat groups work for a small practice, then fail quietly as claims, consignments and staff grow.
- The warning signs are lost evidence, duplicate data entry, unclear status and reports rebuilt from scratch.
- Move in phases: new jobs first, then active ones, and leave closed files where they are.
- Run the old and new process side by side for a short period, and switch off the spreadsheet only when the team trusts the new system.
Most survey firms and Chartered Engineering practices start the same way. A spreadsheet tracks jobs. A messaging group carries photos. A folder of past reports serves as the template for the next one. It works well when there are two or three people and a manageable number of claims or consignments. Then the practice grows, and the system starts failing in ways nobody notices until something goes wrong.
The warning signs
You have probably outgrown spreadsheets if:
- photos for a claim or consignment are spread across several phones and chat threads
- the same vehicle, policy or item details are typed into the tracker, the report and the email
- nobody can say quickly which survey reports are due this week, or which consignments are still waiting for inspection
- a new staff member needs weeks to learn where everything lives
- reports are built by copying an old one and editing it, and errors carry over
For Motor Surveyors, this matters more since IRDAI’s 2024 timelines put the survey report on a 15-day clock after allocation. For Chartered Engineers at ports, delays add charges while containers wait.
Do not replace everything at once
The safest approach is phased. A practice cannot stop working while it changes systems, so the change has to fit around live work.
Phase 1: new jobs only. Start every new claim or consignment in the new system from an agreed date. The spreadsheet keeps tracking what is already in progress.
Phase 2: active jobs. Once the team is comfortable, move the remaining open jobs across. Do it in a quiet week, not when the backlog peaks.
Phase 3: retire the tracker. When nothing active remains in the spreadsheet, make it read-only and keep it as an archive.
Closed files rarely need migrating. They can stay where they are for reference.
Keep the useful habits
Spreadsheets survive because they are flexible. Before you switch, note what your team actually relies on: a colour code for urgent claims, a column for the insurer’s reference, a note field for the repairer’s promised date. Make sure the new system has a home for each of these, or the team will quietly keep a spreadsheet on the side.
Our guide to mapping your workflow helps you capture these habits before choosing software.
Run both for a short while
For the first few weeks, run the old and new processes side by side on a handful of jobs. Compare the outputs. Check that every photo arrived, every figure matches and every report reads correctly. Switch off the old process only when the team trusts the new one.
Train by role
A field surveyor, an office administrator and a firm owner use the system differently. Train each on the part they use every day, with their own real cases. A short session on actual claims or consignments beats a long tour of every feature.
What good looks like
After the move, a practice owner should be able to see every open job, its status and what it is waiting on, in one place. A surveyor or engineer should capture evidence once and see it flow into the report. And nobody should need to ask in a chat group where a photo went.
Techkrate builds MOVAL for motor survey practices and CARS for Chartered Engineering practices. Both are designed to replace the tracker, the chat group and the copied report with one record per job.
Frequently asked questions
Should we migrate all our old claims or jobs?
Usually not. Closed files can stay in their current archive. Migrate only what is still active, and start every new job in the new system.
How long should we run both systems together?
Long enough to complete a representative set of jobs end to end, often a few weeks. Stop when the new system has handled your normal mix of work without gaps.
What are the signs a practice has outgrown spreadsheets?
The same data typed in several places, confusion over which version is current, photos stored apart from the record, and no reliable view of what is pending.
Who should be trained first?
The people who capture data in the field and the people who review it, trained by role on the steps they actually do.
Regulatory references were checked at the time of writing. Rules change, so confirm against the current official text before relying on them. This article is general information, not legal advice.


