Internal tools and client portals: replace the spreadsheet

Every business starts on a spreadsheet, and the spreadsheet is usually right for longer than people think. It becomes a leak at the point where more than one person edits it, where clients need to see part of it, or where a mistake in it costs a job.

An internal tool is the spreadsheet with rules: who can change what, what happens when a stage changes, and a view for each person who needs one. A client portal is the part of it that clients are allowed to see.

The leak

The business runs on a spreadsheet three people edit and one person understands. Jobs fall between columns, clients email for status, and the only report is a Friday night of copy-and-paste.

The number it moves

Admin hours a week, and status-check emails per job.

Signs the spreadsheet has become the leak

Two versions of it exist and nobody is sure which is current.
Someone spends an afternoon a week turning it into a report.
Clients ask for information that is in it, by email, repeatedly.
A job was missed because a row was filtered out.

What we build

A job trackerEvery job with its stage, owner, files, deadline and money. The spreadsheet, with rules.
Views per roleThe crew sees today's jobs. The office sees what is waiting on a client. You see the week.
Automatic hand-offsA stage change sends the next person their task and the client a status update.
A client portalQuotes, approvals, invoices, files and reorders behind one login.
The dashboard tileJobs in progress, overdue, and waiting on someone, live.

How we keep it small

Internal tools fail when they try to do everything. We build on Airtable, Notion or a small database with a simple interface, start with the one process that hurts most, and add the next only after the first has replaced its spreadsheet. You own the data and can export it at any time.

Questions, answered.

Can we keep using the spreadsheet for a while?

Yes. Many builds start by connecting to the existing sheet and replacing it one tab at a time.

Is a portal worth it for a small client list?

If clients email for status or reorder by phone, yes. Twenty clients who each send three fewer emails a job is a lot of afternoons back.

What about a mobile app?

Portals and tools are built to work well on a phone in the browser. A store app only makes sense when customers use it weekly, like a gym.

Related guides, and the work they come from.

Find your biggest leak

Free, 30 minutes, and you keep the findings.

Book a leak audit