echtic
Get a free website plan

One system for records, bookings and stock. Not a pile of spreadsheets.

A bespoke business system puts your customers, diary, stock and staff in one database, so one booking updates all three at once. We built one that holds over 150,000 client records for nine NHS services. Yours can start smaller and grow.

Book a free consultation

Usually 2–3 months · delivered in stages · fixed quote per stage

ONE DATABASERECORDSDIARYSTOCK
  • TypeScript
  • One database
  • Role-based access
  • SSO: SAML 2.0 / OIDC
  • Audit trail
  • Excel / PDF export
  • UK hosting

One booking. Three places, at once.

With spreadsheets, one booking means three edits, often by three people. In a business system it is one action. Watch Thursday at 10:00: the diary, the customer record and the stock change together, in a single database transaction.

Sample data
DiaryRiverside · week of 12 Oct
Week diary. Thursday 15 October at 10:00 is now booked for Leo Hart.
Mon 12Tue 13Wed 14Thu 15Fri 16
09:30A. KhanFreeP. ShahJ. ReidFree
09:45FreeM. AliFreeBreakT. Cole
10:00R. DiazFreeS. EllisL. HartFree
10:15FreeK. OwenFreeFreeN. Price
10:30L. WardFreeBreakFreeA. Khan

Breaks and bank holidays left out

Leo HartCustomer since March 2024 · 07700 900123

History

  • Thu 10:00 · Booked1 × starter kit reserved · by Sam Ellis, just now
  • Mon 5 Oct · Phone callAsked about a Thursday morning
  • 12 Sep · Order delivered1 × refill pack
  • 3 Mar 2024 · Record createdDuplicate found by phone number and merged
StockRiverside store room
  • Starter kit3 available · 1 reserved
    Batch B-2291 · use by Mar 2027 · earliest expiry first
  • Refill pack18 available
    Batch B-2310 · use by Jun 2027
  • Welcome leaflet9 available
    Reorder point 10 · order raised
  • DiaryOnly free slots can be booked, so double bookings cannot happen.
  • Customer recordThe booking lands on the record, with who made it and when.
  • StockThe kit is reserved for that customer, so it cannot be promised twice.

One database transaction · audit trail

Build only the parts you need

Every system is built around how your business works. These are the parts we build most often. Most clients start with two or three and add the rest in later stages.

  • Customer and case records

    One record per customer, with their history, notes, files and consents in one place. New entries are checked for duplicates before they are saved.

    CRM records · full change history · duplicate matching

  • Booking and scheduling

    Staff diaries, rooms and equipment, with slots that respect breaks, closures and bank holidays. Reminders go out by SMS and email, and customers can book online if you want them to.

    Slot rules · bank holidays · SMS and email reminders

  • Stock and orders

    Stock levels for each location, orders with an approval step, batches and use-by dates, and a warning when something needs reordering.

    Stock movements · batch and expiry tracking · approvals

  • Staff, roles and rotas

    Who works where and when, and what each person may see and change. Staff sign in with the Microsoft or Google account they already use.

    RBAC · SSO (SAML 2.0 / OIDC) · rotas

  • Tasks and approvals

    Work arrives as a task with an owner and a due date. Anything that needs a manager’s sign-off waits for the right person, and nothing is lost in an inbox.

    Queues · due dates · approval steps · email and Teams alerts

  • Audit trail and exports

    Every change is recorded with who, what and when, and cannot be edited afterwards. Lists and reports export to Excel, CSV and PDF, or into a template you are sent.

    Change history · Excel / CSV / PDF · official templates

  • One database you own

    Everything sits in one proven, open-source database that is not tied to any vendor. It is backed up, and it is yours to take with you.

    Open source · daily backups · point-in-time recovery

  • Security from the start

    Hosted in the UK, encrypted in transit and at rest, and tested against a recognised checklist before it goes live. We help you write the data protection impact assessment.

    UK region · TLS 1.3 · AES-256 at rest · OWASP ASVS · UK GDPR

We have built this at scale. It runs nine NHS services.

The platform we built for NHS Stop Smoking Services is a business system like the one on this page: records, bookings, stock and reporting, in one database. We still look after it, and it has been independently penetration tested.

  • Over 150,000client records
  • 500+staff use it
  • Hundredsof appointments a day
  • NineNHS Stop Smoking Services in England

Booking that knows the real diary

Clinics and venues · walk-ins · group sessions · reminders

Hundreds of appointments a day are booked across clinics and venues, around breaks, closures and holidays. Walk-in sessions and group sessions sit in the same diary, reminders go out by text, and anyone who misses an appointment is followed up.

Why it matters to you. If you sell time, empty slots and no-shows are lost money. The diary should do the arithmetic, and tell you how full it was.

One record for each person

Duplicate checks · safe merging · full change history

New referrals are checked against existing records, so the same person is not entered twice. When two records do turn out to be one person, staff merge them safely, all at once or not at all, and the merge stays on the record.

Why it matters to you. Duplicate customers are where spreadsheets go wrong: two histories, two invoices, nobody sure which is right. Stop them at the door and fix the old ones safely.

Stock you can trace

Orders · approvals · batches and expiry · stock checks

Medical products are ordered, approved and sent out from the same system that holds the client record. Every movement is kept, batches and expiry dates are tracked, and regular stock checks explain any difference.

Why it matters to you. If you hold stock, you need to know where every unit went, not just how many are left. Then the count can always be explained, and a recall is a search.

Reporting without retyping

Statutory and funder reporting · live dashboards · Excel and PDF

Statutory and funder reporting is built straight from the records, and managers see live dashboards. One definition sits behind every figure, so the dashboard and the report always agree.

Why it matters to you. Whoever you report to, whether a regulator, a funder or your board, the figures should come from live records, the same way every time, in the format they ask for.

Read the NHS platform case study

Single sign-on · each service sees only its own clients · designed to extend to further lifestyle programmes

Moving off spreadsheets, without a lost week.

Most of the risk in a new system is in the move, not the build. So we plan the move first, and your old spreadsheets stay where they are until the new system has proved itself.

  1. Map

    We list every spreadsheet, form and shared inbox the work lives in today, and match each column to a field in the new system. You approve the map.

    A field map you sign off

  2. Clean

    We find the duplicates, the blanks and the dates written five different ways, and fix them with you, using the same matching rules the system will use.

    A cleaning report

  3. Import

    Records come in by a repeatable script, not by hand, so we can run it again on fresh data as often as we need to.

    Counts that match, row for row

  4. Run side by side

    For an agreed period your team works in the new system while the old spreadsheets stay open for checking.

    Differences found early

  5. Switch over

    A last import on a quiet day, then the spreadsheets are archived. Your staff have had training and a short guide.

    One system, old files archived

Often paired with reporting from the records it holds, a portal for customers to book and pay into it, integrations with your accounts, email and calendars and our security pack.

Business system questions

Something else? hello@echticstudios.com

Why not buy an off-the-shelf system?

Often you should, and we will say so. Bespoke makes sense when your process is what sets you apart, when you are paying for several tools that do not talk to each other, or when a package forces your team into workarounds.

Can you move our data out of spreadsheets?

Yes. We map, clean and import it by script, then run the old and new side by side before you switch over. Nothing is retyped by hand.

Where is our data held?

In a UK data centre, encrypted in transit and at rest, with daily backups. We work as your data processor under UK GDPR and help you complete a data protection impact assessment.

How long does a system take?

Usually two to three months for the first stage, delivered in stages so your team uses the first part sooner. Your quote sets out each stage and its timeline.

How do you price a system?

After a free consultation we send a fixed quote, split into stages. Each stage has its own fixed price, and you can stop after any stage.

Who owns the code and the data?

You do. The code is yours once paid for, and the data sits in a database you can take with you.

Tell us which spreadsheets run your business.

A free consultation, then a fixed quote in stages. We plan the move off spreadsheets before we build anything.