A spreadsheet is often the right system for a small business. It is cheap, flexible and everybody knows roughly how to use one. The problem starts when the spreadsheet becomes a database, a to-do list, a customer update tool and the only place one person remembers how the business works.
Keep the spreadsheet while it helps people do the work. Replace it when people spend their time protecting, copying or explaining the spreadsheet.
First: what is a client portal?
A client portal is a private part of a website where each customer signs in to see or do the things relevant to them. Depending on the business, that might include:
- accepting a quote;
- seeing project progress;
- sending files securely;
- answering questions or approving work;
- viewing invoices and paying;
- booking a visit; or
- raising and following a support request.
It does not have to be a huge software product. A useful portal may solve one repeated customer journey very well.
Five signs the spreadsheet has outgrown the job
1. More than one person edits the same process
Names, dates and statuses are overwritten. People make private copies. Nobody knows which row is current. Filters left on by one colleague hide work from another.
2. Staff copy the same information between tools
An enquiry arrives by email, is typed into a spreadsheet, copied into accounts software and then rewritten in a customer update. Re-keying creates delay and mistakes; it is also an obvious place for a supported integration or small internal tool.
3. Customers keep asking for status
If “Where are we up to?” is a frequent email, the information exists but is not reaching the person who needs it. A simple timeline or status page can remove those updates without making the customer chase.
4. The file contains information not everybody should see
One workbook may hold customer contact details, prices, staff notes and sensitive documents. Giving somebody access to the file often gives them access to all of it. A portal can show each user only their own record and keep an audit trail of important actions.
5. Work is missed when one person is away
If a handover depends on the owner explaining colours, initials and unwritten rules, the spreadsheet is no longer just a file. It is an undocumented business system.
When the spreadsheet is still the better answer
Do not commission software just because a spreadsheet looks untidy. Keep it when:
- one or two people use it;
- the process changes every week;
- mistakes are easy to spot and cheap to fix;
- customers do not need direct access;
- there is little sensitive information; and
- a maintained off-the-shelf product already does the job.
A better template, validation rules, a form feeding the sheet, or one automatic reminder may remove most of the pain for far less money.
Map the process before choosing the software
Write one real job from beginning to end. For each step, note:
- who starts it;
- what information they need;
- what decision is made;
- who needs to know next;
- what evidence should be kept; and
- what happens when the normal route fails.
This exposes whether you need a portal, an internal dashboard, a connection between two existing services, or simply a clearer process.
What to build first
Start with the narrow journey that causes the most repeated work. Good first versions include:
- enquiry → quote → approval;
- booking → visit notes → invoice;
- file request → customer upload → approval;
- support request → status → resolution; or
- project stage → customer update → sign-off.
Do not begin with a dashboard full of charts. Begin with the action somebody needs to take next.
Questions to ask before anybody writes code
- Does a maintained product already solve at least 80% of this?
- Which system remains the source of truth?
- What personal data will be stored, and for how long?
- Can each user see only what they should?
- How are backups, updates and security handled?
- Can the data be exported if you leave?
- Who supports it when the business process changes?
The Information Commissioner’s Office says small businesses must use appropriate measures to keep personal data from being lost, altered, destroyed or disclosed to the wrong person. A login screen alone does not answer that. Permissions, retention, audit records and maintenance must be part of the design.
What does a portal cost?
Our focused workflow and communications work starts at £250, an internal tool or integration at £750, and a client portal at £2,000. Larger work begins with a £125 discovery session, credited against the build if you proceed.
Those are starting points, not a claim that every business needs custom software. If a sensible existing service does the job, paying for custom code would be wasteful and we will say so.
Start with the bottleneck
Show us the spreadsheet people work around.
We will map the process, check the maintained products already available, and quote a focused tool only where there is a real gap.
