Skip to main content

SW-02 Internal tools · Worldwide

Business Software Development

Every business has one: a shared spreadsheet that quietly runs a department, with no audit trail, no permissions and a formula nobody understands. We turn it into software your team will actually use.

  • The spreadsheet is the specification, and it is already written
  • Roles designed first, because permissions never retrofit well
  • A non-disableable audit trail, which a spreadsheet cannot have
  • A usable version in front of real users by week three

Reply within 1 working day · we will say if low-code is cheaper

P J DivyaCo-Founder, CTO and CMO

Builds the data model and the screens, then trains the team that has to use them.

A team working from one shared internal tool rather than several versions of a spreadsheet
  • Fixed scopeAgreed in writing
  • 6-10 weeksSingle tool
  • Week 3First real usage
  1. InputHow the team works today
  2. ModelOne source of truth
  3. BuildScreens people will actually use
  4. OutputTraining and a support plan
RegistersTrackersApprovalsDashboardsField appsPortals
RepositoryHanded over
Single tool6 to 10 weeks
RolesDesigned first
Audit trailUneditable

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

  • 01

    More than one editor

    Two people editing means two versions eventually, and no way to tell which change came from whom or when.

    Signal 1
  • 02

    A file called final

    Usually alongside final-v2 and final-revised. Version control by filename is the clearest sign the tool has outgrown the format.

    Signal 2
  • 03

    A load-bearing formula

    One nobody currently employed can explain, doing something the business depends on. Nobody dares touch the cell.

    Signal 3
  • 04

    It disagrees with a system

    Its numbers and the ERP's numbers differ, and neither is obviously wrong. Two sources of truth means no source of truth.

    Signal 4
  • 05

    Losing it would stop work

    If the file were corrupted on Monday, a department would be idle. That is a business continuity exposure sitting in a shared folder.

    Signal 5
  • 06

    Everyone sees everything

    Salaries, margins or customer data visible to anyone with the link, because a spreadsheet has no concept of a role.

    Signal 6

The constraint the design is held to

If the software is slower than the spreadsheet it replaces, it will not be used, so we time the current task first and design against that number rather than a 10% guess. 100% of edits are logged with the actor and the timestamp, and every screen is reachable by a role that is defined before the first field is drawn.

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

Where each option is the right answer
PropertyLow-code platformCustom code
Forms, registers, approvalsYesOverkill
Unusual calculation or business logicHits a ceilingYes
High transaction volumeGets expensive per recordYes
Deep integration with several systemsPossible, awkwardYes
Shares data with an existing suiteYesNeeds building
You want to change it yourself laterYesNeeds a developer

The recommendation costs us money sometimes

A Zoho Creator application on an existing Zoho account can be a fraction of a custom build and shares masters with Books and CRM automatically. We say so when it applies, because the alternative is selling you three years of maintenance you did not need.

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

  • Registers. Asset, document, complaint, visitor, gate-pass and compliance registers, where the value is a searchable history rather than a current list.
  • Trackers. Project, order, dispatch, service-call and recruitment trackers, where the value is knowing what is stuck and with whom.
  • Approval tools. Requests, checks and sign-offs with a real routing rule, which is where a spreadsheet and a WhatsApp group are currently doing the work between them.
  • Dashboards. Numbers pulled from the source rather than rebuilt every Monday morning from a copy of a copy.
  • Field applications. Installed from a browser, working with a poor connection and syncing when it recovers, for staff who are not at a desk.
  • Customer or vendor portals. A place for a counterparty to see their own orders, statements or tickets, which removes a surprising amount of inbound email.

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

What changes when a spreadsheet becomes software
ConcernIn a spreadsheetIn the software
Who can see whatEveryone with the link sees everythingPer role, and scoped to a branch or team
Who changed a figureUnknowableRecorded with the actor and the timestamp
Bad dataAccepted silently, discovered laterRejected at entry, with a reason
ApprovalsA colour, and a WhatsApp messageA routing rule with escalation and a record
Two people at onceA conflicted copyBoth writes land, in order
BackupWhatever the drive doesScheduled, and tested by restoring
  • Where the tool touches the books it inherits the logging control an external audit already tests: an unalterable, timestamped record of each entry and each later change, which is control A.8.15 of ISO/IEC 27001, retained for as long as the record-keeping rules in your own jurisdiction require.
  • Where it holds employee or customer personal data, the General Data Protection Regulation applies wherever those people are in the EU or the UK, and an equivalent regime applies elsewhere. Retention and a deletion path are designed into the schema.

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

  1. Step 1: Time the current task

    Minutes per record, as it is done today. That number becomes the design constraint: if the software is slower, it will not be used, whatever else it offers.

    Week 1
  2. Step 2: Read the sheet as the specification

    Columns are fields, formulas are rules, coloured cells are statuses nobody wrote down. The most accurate requirements document in the business is already written.

    Week 1
  3. Step 3: Design the roles

    Who sees, edits and approves, and whether a person is scoped to their own branch. Permissions retrofit badly, so they come before features.

    Week 2
  4. Step 4: Real users in week three

    Not a demonstration to a sponsor. The actual team, doing actual work on a staging URL, which surfaces more in an hour than another month of design would.

    Week 3
  5. Step 5: Migrate and run both briefly

    Data migrated after cleansing, with the spreadsheet kept read-only for a short parallel period so nobody feels stranded.

    Weeks 6 to 10

Our dispatch sheet had eleven tabs and one person who understood it. Now four people use the tool and the sheet is read-only history, which was the whole point.

Plant managerFood processing company

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

We build for the people who will use it daily, and one of them sits in every review. That is why the screens survive contact with the team.

  • P J Divya

    Co-Founder, CTO and CMO

    Designs the data model, builds the screens, connects them to what you already run, and writes the support plan.

  • Chetan Ravi

    Founder and CEO

    Studies how the team works today, agrees one source of truth, and owns the rollout and the training.

  • Harith, Compliance Expert at ProTax

    Harith

    Compliance Expert

    Checks the reports and records the system must produce to stand up in a filing or an audit.

  • Harsh Jain, Legal Expert at ProTax

    Harsh Jain

    Legal Expert

    Assigns ownership of the code and data, and reviews the terms of every third-party service it calls.

10 Related

What else replaces a spreadsheet

Sometimes the right answer is not a new tool at all, and these are the two alternatives worth checking first.

  • Working hours

    Our day runs on UTC+5:30. The overlap window with your team is written into the scope rather than assumed, and everything outside it runs asynchronously.

  • How we communicate

    One written update a day on the channel you already use, a standing weekly call inside the overlap window, and a named person to escalate to. Nothing important is agreed only on a call.

  • Who you contract with

    ProTax Consultancy, the company behind ProTax, named in the agreement with its registration number. The governing law and the forum are agreed before you sign, not after a dispute.

  • Currency and payment

    Invoiced in your currency or in ours, your choice, and settled by bank transfer. Milestones are tied to deliverables you can see, never to elapsed time.

  • What you own

    Copyright in everything built for you is assigned on final payment: source code, design files, prompts, configuration and documentation. Third-party licences are listed by name so nothing is a surprise later.

  • Where data sits

    You choose the region your data is stored and processed in, and the answer is written down before the build starts, with who at ProTax can reach it and for how long.

Offset from our working day standard time

  • London-5:30
  • Dubai-1:30
  • Singapore+2:30
  • Sydney+4:30
  • New York-10:30
  • San Francisco-13:30

ProTax is a brand of ProTax Consultancy. The contracting entity, the governing law and the invoicing currency are all named in the proposal before you sign anything.

09 Questions

What else replaces a spreadsheet

Spreadsheet risk
The exposure created when a business-critical process runs in a shared spreadsheet: no audit trail, no permissions, no validation.
Role-based access control
Written RBAC: deciding who may see, edit and approve which records, including scoping a view to a branch or team.
Single source of truth
One system treated as authoritative for a class of data, so a disagreement between reports has one place to be resolved.
Progressive web application
Written PWA: an application installed from the browser that works with a poor connection and syncs when it recovers.
Low-code platform
A configurable application platform such as Zoho Creator, genuinely cheaper than custom code for forms, registers and approvals.
Field validation
Rejecting bad data at entry with a reason, instead of accepting it silently and discovering it in a report months later.
GDPR
The EU and UK data protection regime. Article 83 sets administrative fines of up to €20 million or 4% of worldwide annual turnover, whichever is higher, which is why consent, retention and access control are build decisions here rather than paperwork.

09 Questions

What else replaces a spreadsheet

Building the internal tools a business runs on: the register, the tracker, the planner and the approval sheet that started in Excel and now quietly holds a department together. It differs from custom software development mainly in scope and audience, since the users are your own staff.

Next step

Send us the spreadsheet, formulas and all.

We will come back with what it would take to turn it into software with proper roles and an audit trail, and an honest view on whether a low-code platform would do it for less.

Read by P J Divya, our CTO, not a form queue. Reply usually within one working day, in your time zone.

FROM THE PROTAX LIBRARY

Recent Articles & Guides

Practical reading on business records, tax filings and the decisions that come with running a company.

Newsletter

Stay ahead on compliance, tax & business updates

Get selected business and compliance updates by email. Once a month, no spam.

  • 100% privacy
  • 1 email / month
  • Unsubscribe anytime
Contact ProTax
Chosen by individuals and businesses

Get Help With Your Business

Tell us what you need help with. Our team will review your enquiry and explain the next steps.

Free Consultation No Obligations Expert Advice
FREE Consultation No obligation, no lock-in

Talk To ProTax

Share Your Business Requirement

Instant Response 100% Confidential Expert Advice
FREE Consultation No obligation, no lock-in

Request a Free Quote

Share Your Business Requirement

Instant Response 100% Confidential Expert Advice
Replace the spreadsheet that runs a department Roles audit trail