Onboarding a cleared engineer to a new contract takes weeks because it lives in a passworded Excel file
A custom internal tool for a Portsmouth defence or marine-tech firm runs £25,000 to £75,000 over 2 to 5 months, far less than a full ERP (Enterprise Resource Planning). The fastest payback usually comes from replacing the clearance-and-certification spreadsheet that drags cleared-staff onboarding out for weeks. Retool and Airtable get you halfway, then hit a wall on access control and audit trails.
The most expensive object in your business is a spreadsheet. It tracks which staff are cleared, to what level, against which classified projects, plus parts certifications, and it's the reason onboarding an engineer to a new naval subcontract takes weeks. Every change is a manual edit by one person who knows the file, and nobody else dares touch it.
You reach for Airtable or Retool to fix it, and they're genuinely good for the first version. Then you need real access control, a tamper-evident audit trail, and the ability to prove to a prime contractor who saw what and when, and that's where the no-code ceiling appears. The data that governs whether someone can legally work a contract should not live in a shared workbook.
The problems nobody warns you about
- A single passworded spreadsheet maps cleared staff to classified projects, and only one person can safely edit it
- Onboarding a cleared engineer to a new contract takes weeks because every step is a manual lookup and edit
- Parts-certification records sit in the same fragile file with no audit trail a prime would accept
- Retool and Airtable can't enforce the granular access control and tamper-evident logging defence work demands
The case for owning your internal tools
A custom internal tool turns that spreadsheet into a real application with role-based access, a tamper-evident audit trail, and a workflow that walks a new cleared engineer onto a contract in hours instead of weeks. It enforces who can see and change clearance-to-project mappings, and it produces the access history a prime contractor expects without anyone assembling it by hand.
Budgeting a internal tools build in Portsmouth
| Project scope | Typical cost | Timeline |
|---|---|---|
| Single workflow tool (clearance onboarding) | £25k to £40k | 2 to 3 months |
| Plus certification register and audit trail | £40k to £60k | 3 to 4 months |
| Plus approvals, reporting, integrations | £60k to £75k | 4 to 5 months |
What your build should include
Internal Tools services we deliver in Portsmouth
The engagements Portsmouth teams bring us most often: internal dashboards, Retool alternative, workflow automation, back-office software and operations tooling.
Exactly what you get
A focused web application that replaces the clearance-and-certification spreadsheet. It walks a new cleared engineer onto a contract through permissioned gates, enforces who can edit clearance mappings, logs every access in a tamper-evident trail, and keeps parts certifications with expiry alerts. It exports the access evidence a prime contractor asks for without anyone building it by hand, and it connects to your CRM (Customer Relationship Management) and ERP where useful.
How to choose a developer in Portsmouth
Pick a builder who treats access control and audit logging as the core feature, not a checkbox. Ask them to explain, concretely, how they'd stop the wrong person editing a clearance mapping and how they'd prove access history to an auditor. A team that has shipped permissioned internal tools for regulated work will answer fast. One that defaults to Airtable for everything is the wrong fit for clearance data.
- !They suggest Airtable for clearance data. Ask how it enforces tamper-evident access logging
- !They skip the audit trail. Ask how a prime contractor would verify who accessed what
- !No security thinking on hosting. Ask where the clearance data sits and who can reach it
- !They scope every internal need as one mega-tool. Ask why this can't be a focused first build
- !No plan for ownership. Ask who keeps the data accurate after launch
If internal tools is on the roadmap, custom software, wordpress, accounting usually follow within the year. Budget them as one conversation.
Rohan advises mid-market and enterprise teams on ERP, CRM and custom software, and has led delivery on dozens of business-software builds.
Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.
Frequently asked questions
Why not just clean up the spreadsheet?
A tidier spreadsheet is still a shared file with no enforced access control or audit trail, and it still depends on one person. The point of a custom tool is to make the rules the system's job, not a human's.
Can we start with one tool and expand?
Yes, and that's usually the smart path. Start by killing the worst bottleneck, the clearance-onboarding workflow, then add the certification register and approvals once the value is proven.
Is Retool not good enough?
Retool is excellent for internal dashboards over existing data. It struggles when you need granular, enforced access control and tamper-evident logging over sensitive clearance data, which is exactly the requirement here.