Custom business systems

From Spreadsheets to a System: When Your Business Needs Custom Software

By Jasper Fernandez on , 4 min read

Most small and growing businesses run on spreadsheets, group chats and a notebook or two. That is not a mistake. Spreadsheets are flexible, cheap and everyone already knows how to use them. The trouble starts quietly: a formula gets overwritten, two branches keep two versions of the same file, and month-end becomes a week of checking numbers instead of running the business.

This post is for owners and managers wondering whether it is time to replace a spreadsheet with a proper system, and how to do it without paying for software you do not need.

Five signs you have outgrown your spreadsheets

  1. The same data is typed twice. Attendance goes into one file and gets retyped into the payroll file. Sales go into a notebook, then into a spreadsheet, then into a report. Every retype is a chance for an error.
  2. Only one person really understands the file. If that person is sick or leaves, nobody knows which cells are safe to touch.
  3. Errors are found at month-end, not the day they happen. A missing cash entry or a wrong overtime figure is cheap to fix on Tuesday and expensive to untangle on the 30th.
  4. Everyone can see everything. A shared spreadsheet has no real permissions. Staff who should only enter sales can also read salaries.
  5. Locations cannot see each other's numbers. With two or more branches, the owner ends up collecting screenshots in chat to know how the day went.

If three or more of these sound familiar, the spreadsheet is no longer saving you money. It is costing you time and accuracy.

What a custom business system actually replaces

A custom system is not magic. It takes the rules your team already follows and makes the computer follow them every time. Two examples from my own projects:

  • Attendance to payroll. The Goodly Trading HRIS replaced time sheets and payroll spreadsheets for six companies. Staff clock in at a face-recognition kiosk, and payroll is computed from that attendance, leave and each company's benefit rules. I explain the whole chain in how attendance-based payroll works.
  • Daily sales across branches. The Sales Monitoring System gives a two-branch business one place for daily sales by shift, expenses, payables and cash reconciliation, with admin and viewer logins so each person sees only what they should.

Build or buy?

Off-the-shelf software is the right choice when your process is standard. Accounting, email and simple invoicing are solved problems, and a subscription is usually cheaper than building your own.

Custom software earns its cost when your rules are the product: several companies with different payroll settings under one roof, a cash-handling routine specific to your branches, or per-use fees that grow every month (for example, paying per face scan). In those cases you are either bending a generic tool until it breaks or paying for features you will never use.

How to scope a system without overspending

  1. Start with the most painful workflow. Not the whole business. One process that wastes the most time or causes the most errors.
  2. Write the rules down. How is a late counted? When is overtime approved? What does "paid" mean for a supplier bill? Written rules become the spec, and the spec is what keeps the project on budget. This is the first step in how I work.
  3. List who needs to see what. Owners, managers, encoders and viewers usually need different screens. Permissions are much easier to design up front.
  4. Define "done". For example: "payroll for one full cutoff matches our manual computation line by line."
  5. Plan hosting, backups and updates from day one. A system your business depends on needs a server, HTTPS and tested backups, and updates that do not interrupt staff. I cover that in deploying without logging users out.

The bottom line

Spreadsheets are a great way to start and a risky way to scale. When the same numbers are typed twice, reviewed late and shared with everyone, a small custom system usually pays for itself in saved hours and avoided mistakes.

If you are weighing this up, see what goes into my custom business systems service, or tell me about the workflow you want to fix. I will reply with a plan and a fixed-scope quote.